Recurring Revenue Authors: Yeshim Deniz, Elizabeth White, Xenia von Wedel, Liz McMillan, Carmen Gonzalez

Related Topics: @CloudExpo, Recurring Revenue

@CloudExpo: Article

Database.com versus Oracle

Five features for Database.com to get more enterprise friendly in the cloud

Cloud Database as a Platform from Salesforce
Cloud Computing adoption definitely  gets a boost with yet another offering of Database as a Service (DaaS) with the Database.com offering from Salesforce. This will  compliment  the Relational Cloud Offering from Microsoft SQLAzure and Amazon RDS.

With SQLAzure being a 100% Microsoft centric cloud solution and Amazon RDS built on MySQL, naturally the salesforce  cloud database will be looked as an viable alternative for  cloud consumers who wanted to implement a Oracle Like solution  as a DaaS.

So potentially Database.com will be looked upon as an alternative to a ‘In Premise' Oracle to a equivalent on Cloud.

In that context  we would like to  highlight on the following features that will be needed in ‘Database.com'  , potentially once available  the ‘Database.com'  could be a serious competitor to Oracle.

What is ‘Database.com'

  • Database.com is a stand-alone service available via its SOAP and REST APIs to any language on any platform or device.
  • Features include user management, row-level security, triggers, stored procedures, authentication and APIs, all in an easily scalable cloud infrastructure.
  • The product's relational data capabilities include tables, relationships, support for a variety of field types, triggers and stored procedures, a query language and enterprise search.

The initial reading of the technical documents is promising, and provides alternative and choice for the database needs  on the Cloud, however the availability of following features makes it every more ‘enterprise' class and a worthy alternative to Oracle.

1. High Performance Load: The biggest trust on Cloud is the  ability  to   fasten the ‘time to market' for the consumers. Which means that we should be able to  move large amounts of data from ‘On Premise' legacy applications  into ‘database.com', this is only going to be feasible with a high performance  direct path load much like ‘Sql*Loader'  does in Oracle. There is a data loader available with  Force.com but  Direct Path high performance needs should be addressed.

2. Intra Tenant Partitioning : All database.com  data is physically partitioned by Tenant ID. In a multi tenant model  like ‘SalesForce' this is very useful, as it aims at partition pruning at the tenant level.  However in real world  for larger enterprise tenants , we needed to ensure partitioning of data  within a tenant using appropriate range or hash techniques.

3. Tuning Control : While most of the modern databases including Oracle  touts self-tuning capabilities such as ADDM, AWR,  it is also highly desired to give developers the control to tune the application by understanding the query execution plans.  ‘database.com'  provides a  cost based optimizer  using optimizer statistics at tenant level. There are features like ‘MT_FALLBACK_INDEXES' which provides  alternative query optimization at the developer control. However more features to identify  long running queries and tune them  will make it more competitive.

4. Binary Large Objects (BLOB)  & Unstructured Data Types: ‘database.com'  supports  standard structured data types like text, number, date and date/time , sequences, formula ,Boolean etc. ‘Database.com' supports the declaration of fields as a character large objects (CLOBs)to permit the storage of long texts up to 32,000 characters. However  enterprise data model requires  other unstructured data types like BLOB (Binary Large Objects) to storage images, multi media documents and also XML document data types.

5. Security: Enterprise databases like Oracle have heaped on features on  Security  over the period. We also find  several good features with ‘database.com' at this time.

  • Single Sign On / Federated authentication
  • Database profiles for common security settings
  • History Tracking & Auditing Features

However Oracle has features like VPD (Virtual Private Database), Roles, VIEWS, Advanced Security, Fine Grained Auditing which goes further into providing enterprise class security features. Implementing them into ‘database.com' will  improve its security credentials.

With SQL Azure taking up the  Cloud  incarnation of enterprise SQL Server databases and Amazon RDS taking up the  cloud incarnation of  MySQL databases, ‘database.com' DBaaS platform  gives a  scaled down alternative for Oracle at this time.

Implementation of some of the above features will improve its chances  as a true enterprise database cloud platform, especially for Oracle customers.

There could be some workarounds already available, but we needed to go through further documentation and reference implementations of this platform as  a  database as a service.

Remember, already being  a cloud database some of the time consuming activities of traditional databases are already covered in the  ‘database.com' like,

  • Auto backups without RMAN
  • Elasticity without complex setup like RAC (Real Application Clusters)
  • Availability without complex setup like Data Guard or Stand By databases.

More Stories By Srinivasan Sundara Rajan

Highly passionate about utilizing Digital Technologies to enable next generation enterprise. Believes in enterprise transformation through the Natives (Cloud Native & Mobile Native).

@ThingsExpo Stories
Michael Maximilien, better known as max or Dr. Max, is a computer scientist with IBM. At IBM Research Triangle Park, he was a principal engineer for the worldwide industry point-of-sale standard: JavaPOS. At IBM Research, some highlights include pioneering research on semantic Web services, mashups, and cloud computing, and platform-as-a-service. He joined the IBM Cloud Labs in 2014 and works closely with Pivotal Inc., to help make the Cloud Found the best PaaS.
Everything run by electricity will eventually be connected to the Internet. Get ahead of the Internet of Things revolution. In his session at @ThingsExpo, Akvelon expert and IoT industry leader Sergey Grebnov provided an educational dive into the world of managing your home, workplace and all the devices they contain with the power of machine-based AI and intelligent Bot services for a completely streamlined experience.
Cloud-enabled transformation has evolved from cost saving measure to business innovation strategy -- one that combines the cloud with cognitive capabilities to drive market disruption. Learn how you can achieve the insight and agility you need to gain a competitive advantage. Industry-acclaimed CTO and cloud expert, Shankar Kalyana presents. Only the most exceptional IBMers are appointed with the rare distinction of IBM Fellow, the highest technical honor in the company. Shankar has also receive...
Business professionals no longer wonder if they'll migrate to the cloud; it's now a matter of when. The cloud environment has proved to be a major force in transitioning to an agile business model that enables quick decisions and fast implementation that solidify customer relationships. And when the cloud is combined with the power of cognitive computing, it drives innovation and transformation that achieves astounding competitive advantage.
Personalization has long been the holy grail of marketing. Simply stated, communicate the most relevant offer to the right person and you will increase sales. To achieve this, you must understand the individual. Consequently, digital marketers developed many ways to gather and leverage customer information to deliver targeted experiences. In his session at @ThingsExpo, Lou Casal, Founder and Principal Consultant at Practicala, discussed how the Internet of Things (IoT) has accelerated our abilit...
In his session at Cloud Expo, Alan Winters, U.S. Head of Business Development at MobiDev, presented a success story of an entrepreneur who has both suffered through and benefited from offshore development across multiple businesses: The smart choice, or how to select the right offshore development partner Warning signs, or how to minimize chances of making the wrong choice Collaboration, or how to establish the most effective work processes Budget control, or how to maximize project result...
To get the most out of their data, successful companies are not focusing on queries and data lakes, they are actively integrating analytics into their operations with a data-first application development approach. Real-time adjustments to improve revenues, reduce costs, or mitigate risk rely on applications that minimize latency on a variety of data sources. In his session at @BigDataExpo, Jack Norris, Senior Vice President, Data and Applications at MapR Technologies, reviewed best practices to ...
Data is the fuel that drives the machine learning algorithmic engines and ultimately provides the business value. In his session at Cloud Expo, Ed Featherston, a director and senior enterprise architect at Collaborative Consulting, discussed the key considerations around quality, volume, timeliness, and pedigree that must be dealt with in order to properly fuel that engine.
"Akvelon is a software development company and we also provide consultancy services to folks who are looking to scale or accelerate their engineering roadmaps," explained Jeremiah Mothersell, Marketing Manager at Akvelon, in this SYS-CON.tv interview at 21st Cloud Expo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
In his keynote at 19th Cloud Expo, Sheng Liang, co-founder and CEO of Rancher Labs, discussed the technological advances and new business opportunities created by the rapid adoption of containers. With the success of Amazon Web Services (AWS) and various open source technologies used to build private clouds, cloud computing has become an essential component of IT strategy. However, users continue to face challenges in implementing clouds, as older technologies evolve and newer ones like Docker c...
Two weeks ago (November 3-5), I attended the Cloud Expo Silicon Valley as a speaker, where I presented on the security and privacy due diligence requirements for cloud solutions. Cloud security is a topical issue for every CIO, CISO, and technology buyer. Decision-makers are always looking for insights on how to mitigate the security risks of implementing and using cloud solutions. Based on the presentation topics covered at the conference, as well as the general discussions heard between sessio...
To Really Work for Enterprises, MultiCloud Adoption Requires Far Better and Inclusive Cloud Monitoring and Cost Management … But How? Overwhelmingly, even as enterprises have adopted cloud computing and are expanding to multi-cloud computing, IT leaders remain concerned about how to monitor, manage and control costs across hybrid and multi-cloud deployments. It’s clear that traditional IT monitoring and management approaches, designed after all for on-premises data centers, are falling short in ...
Organizations planning enterprise data center consolidation and modernization projects are faced with a challenging, costly reality. Requirements to deploy modern, cloud-native applications simultaneously with traditional client/server applications are almost impossible to achieve with hardware-centric enterprise infrastructure. Compute and network infrastructure are fast moving down a software-defined path, but storage has been a laggard. Until now.
DXWorldEXPO LLC announced today that the upcoming DXWorldEXPO | CloudEXPO New York event will feature 10 companies from Poland to participate at the "Poland Digital Transformation Pavilion" on November 12-13, 2018.
Digital Transformation is much more than a buzzword. The radical shift to digital mechanisms for almost every process is evident across all industries and verticals. This is often especially true in financial services, where the legacy environment is many times unable to keep up with the rapidly shifting demands of the consumer. The constant pressure to provide complete, omnichannel delivery of customer-facing solutions to meet both regulatory and customer demands is putting enormous pressure on...
The best way to leverage your CloudEXPO | DXWorldEXPO presence as a sponsor and exhibitor is to plan your news announcements around our events. The press covering CloudEXPO | DXWorldEXPO will have access to these releases and will amplify your news announcements. More than two dozen Cloud companies either set deals at our shows or have announced their mergers and acquisitions at CloudEXPO. Product announcements during our show provide your company with the most reach through our targeted audienc...
In an era of historic innovation fueled by unprecedented access to data and technology, the low cost and risk of entering new markets has leveled the playing field for business. Today, any ambitious innovator can easily introduce a new application or product that can reinvent business models and transform the client experience. In their Day 2 Keynote at 19th Cloud Expo, Mercer Rowe, IBM Vice President of Strategic Alliances, and Raejeanne Skillern, Intel Vice President of Data Center Group and ...
More and more brands have jumped on the IoT bandwagon. We have an excess of wearables – activity trackers, smartwatches, smart glasses and sneakers, and more that track seemingly endless datapoints. However, most consumers have no idea what “IoT” means. Creating more wearables that track data shouldn't be the aim of brands; delivering meaningful, tangible relevance to their users should be. We're in a period in which the IoT pendulum is still swinging. Initially, it swung toward "smart for smart...
DXWorldEXPO LLC announced today that All in Mobile, a mobile app development company from Poland, will exhibit at the 22nd International CloudEXPO | DXWorldEXPO. All In Mobile is a mobile app development company from Poland. Since 2014, they maintain passion for developing mobile applications for enterprises and startups worldwide.
@DevOpsSummit at Cloud Expo, taking place November 12-13 in New York City, NY, is co-located with 22nd international CloudEXPO | first international DXWorldEXPO and will feature technical sessions from a rock star conference faculty and the leading industry players in the world.