Welcome!

@CloudExpo Authors: Yeshim Deniz, Carmen Gonzalez, Kevin Jackson, AppNeta Blog, Pat Romanski

Related Topics: @CloudExpo, Microservices Expo

@CloudExpo: Article

Top Five Cloud Databases

SQL Azure, Amazon RDS and others....

Cloud Storage is an important aspect  of a successful Cloud Migration.  Hence any migration of enterprise applications to Cloud  either Private or Public,  would require a stronger database platform in support.

Again the database needs will differ according to the  Cloud  Service Model.

SaaS
In this service model Cloud Consumer may not worry about the underlying database as its implementation is  hidden, however the Cloud Provider needs to worry about the appropriate choice of Cloud Database to meet the agreed QoS  of the Software Service. Probably as a consumer of Google Gmail  you may not be worried about the underlying database platform.

IaaS
As  IaaS  Providers needs to  have a catalog of database servers, it could be   more of existing  popular database servers  being  served over the cloud platform. For example Amazon EC2 provides a catalog of major databases including :

  • IBM DB2
  • IBM Informix Dynamic Server
  • Oracle Database 11g
  • MYSQL Enterprise

PaaS
In this model, as a cloud application development consumer your interest in the proper database support in support of cloud enablement matters most. For example better the features served by the PaaS platform Cloud database more the chances the application is highly scalable on Cloud.

Some of the databases  that come under the PaaS category where the database features have been exclusively tailored  for Cloud are listed  below.

1. SQL AZURE
Microsoft SQL Azure is a multitenant cloud-based relational database built on the SQL Server engine.  SQL Azure offers the same Tabular Data Stream (TDS) interface for communicating with the database that is used to access any on premise SQL Server database. As a result, with SQL Azure, developers can use the same tools and libraries they use to build client applications for SQL Server.

Pros:

  • A true cloud database with much of the administrative activities taken care by the platform and scalable

Cons:

  • While touts to be just another version of Sql Server but there are differences in functionalities
  • Space limitations to be addressed in future versions

2. Amazon RDS

Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up,

operate, and scale a relational database in the cloud. It gives you access to the full capabilities of a MySQL 5.1 database running on your own Amazon RDS database instance.

Pros:

  • While RDS in itself a PaaS platform, it can be bundled as part of EC2 IaaS offering to make it flexible for the customers.

Cons:

  • But for the features like ‘Read Replica' the Scalability options are yet to mature
  • Tools like App Fabric ( Of Azure Platform) to migrate the existing data and applications need to evolve

3. Google BigQuery

BigQuery is a web service for querying large datasets. It supports very fast execution of select-and-aggregate queries on tables with billions of records. It is a  PaaS  based database service, which is scalable and support SQL like syntax.

Pros:

  • While most of the cloud databases have size issues, You can execute queries over billions of rows of data.
  • It is compatible with the Google Storage as the persistent mechanism

Cons:

  • While it supports SQL like syntax for querying it is still unstructured and non relational and enterprise applications may not utilize this design for storing their data, BigQuery does not currently support joins.
  • New learning curve unlike SQL Azure or Amazon RDS which utilizes existing database interfaces

4. Amazon Simple DB

Amazon SimpleDB is a highly available, scalable, and flexible non-relational data store that offloads the work of database administration. Developers simply store and query data items via web services requests, and Amazon SimpleDB does the rest. It avoids complex database design and administration but rather keeps the data access really simple.

Pros:

  • Good choice for low end needs and is in line with rest of Amazon AWS strategy
  • Cost effective and flexible

Cons:

  • All Amazon SimpleDB information is stored in domains. Domains are similar to tables that contain similar data. You can execute queries against a domain, but cannot execute joins between domains. So not conducive for enterprise class database design needs which involves heavy normalization of tables (Domains)
  • Locking and Performance tuning options are limited

5. Other Big Enterprise Databases In IaaS Or ‘Cloud In a Box' Mode

Oracle 11g : While Oracle is yet to release some thing equivalent to SQL Azure, however Oracle 11g is available as part of the cloud platform and  Cloud Appliances, which makes it a  candidate for the Cloud databases.

  • Oracle Exadata Cloud Appliance : The Oracle Exadata Database Machine is the only database machine that provides extreme performance for both data warehousing and online transaction processing (OLTP) applications, making it the ideal platform for consolidating onto grids or private clouds.
  • Amazon EC2 : Amazon EC2 enables partners and customers to build and customize Amazon Machine Images (AMIs) with software based on needs. In that context oracle 11g is available as one of the AMI options.

DB2 : While DB2 is yet to release some thing equivalent to SQL Azure, however DB2 11g is available as part of the cloud platform and  Cloud Appliances, which makes it a  candidate for the Cloud databases.

  • Websphere Cloudburst Appliance : WebSphere CloudBurst V2.0 includes support for a virtual image that contains DB2 9.7 Data Server for WebSphere CloudBurst Appliance. A 90-day trial of the DB2 V9.7 Enterprise Data Server for WebSphere CloudBurst virtual image is pre-loaded in the WebSphere CloudBurst V2.0 catalog .
  • Amazon EC2 : Amazon EC2 enables partners and customers to build and customize Amazon Machine Images (AMIs) with software based on needs. In that context IBM DB2 is available as one of the AMI options.

Pros:

  • No need to elaborate on how good these enterprise class proven databases

Cons:

  • While the appliances meant for private cloud have a price tag associated, enterprise databases as part of EC2 IaaS platform still requires administration and other maintenance typical of these enterprise 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).

@CloudExpo Stories
@DevOpsSummit has been named the ‘Top DevOps Influencer' by iTrend. iTred processes millions of conversations, tweets, interactions, news articles, press releases, blog posts - and extract meaning form them and analyzes mobile and desktop software platforms used to communicate, various metadata (such as geo location), and automation tools. In overall placement, @DevOpsSummit ranked as the number one ‘DevOps Influencer' followed by @CloudExpo at third, and @MicroservicesE at 24th.
The explosion of new web/cloud/IoT-based applications and the data they generate are transforming our world right before our eyes. In this rush to adopt these new technologies, organizations are often ignoring fundamental questions concerning who owns the data and failing to ask for permission to conduct invasive surveillance of their customers. Organizations that are not transparent about how their systems gather data telemetry without offering shared data ownership risk product rejection, regu...
SYS-CON Events announced today that SoftLayer, an IBM Company, has been named “Gold Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2016, at the Javits Center in New York, New York. SoftLayer, an IBM Company, provides cloud infrastructure as a service from a growing number of data centers and network points of presence around the world. SoftLayer’s customers range from Web startups to global enterprises.
SYS-CON Events announced today that Juniper Networks (NYSE: JNPR), an industry leader in automated, scalable and secure networks, will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Juniper Networks challenges the status quo with products, solutions and services that transform the economics of networking. The company co-innovates with customers and partners to deliver automated, scalable and secure network...
As pervasive as cloud technology is -- and as persuasive as the arguments are for using it -- the cloud has its limits. Some companies will always have security concerns about storing data in the cloud and certain high-transaction applications will always be better suited for on-premises storage. Those statements were among the bottom-line takeaways delivered at Cloud Expo this week, a three day, bi-annual event focused on cloud technologies, adoption and associated challenges.
Multiple data types are pouring into IoT deployments. Data is coming in small packages as well as enormous files and data streams of many sizes. Widespread use of mobile devices adds to the total. In this power panel at @ThingsExpo, moderated by Conference Chair Roger Strukhoff, panelists will look at the tools and environments that are being put to use in IoT deployments, as well as the team skills a modern enterprise IT shop needs to keep things running, get a handle on all this data, and deli...
Quickly find the root cause of complex database problems slowing down your applications. Up to 88% of all application performance issues are related to the database. DPA’s unique response time analysis shows you exactly what needs fixing - in four clicks or less. Optimize performance anywhere. Database Performance Analyzer monitors on-premises, on VMware®, and in the Cloud, including Amazon® AWS and Azure™ virtual machines.
SYS-CON Events announced today that Grape Up will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct. 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Grape Up is a software company specializing in cloud native application development and professional services related to Cloud Foundry PaaS. With five expert teams that operate in various sectors of the market across the U.S. and Europe, Grape Up works with a variety of customers from emergi...
20th Cloud Expo, taking place June 6-8, 2017, at the Javits Center in New York City, NY, will feature technical sessions from a rock star conference faculty and the leading industry players in the world. Cloud computing is now being embraced by a majority of enterprises of all sizes. Yesterday's debate about public vs. private has transformed into the reality of hybrid cloud: a recent survey shows that 74% of enterprises have a hybrid cloud strategy.
SYS-CON Events announced today that Super Micro Computer, Inc., a global leader in compute, storage and networking technologies, will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Supermicro (NASDAQ: SMCI), the leading innovator in high-performance, high-efficiency server technology, is a premier provider of advanced server Building Block Solutions® for Data Center, Cloud Computing, Enterprise IT, Hadoop/...
Amazon has gradually rolled out parts of its IoT offerings in the last year, but these are just the tip of the iceberg. In addition to optimizing their back-end AWS offerings, Amazon is laying the ground work to be a major force in IoT – especially in the connected home and office. Amazon is extending its reach by building on its dominant Cloud IoT platform, its Dash Button strategy, recently announced Replenishment Services, the Echo/Alexa voice recognition control platform, the 6-7 strategic...
Bert Loomis was a visionary. This general session will highlight how Bert Loomis and people like him inspire us to build great things with small inventions. In their general session at 19th Cloud Expo, Harold Hannon, Architect at IBM Bluemix, and Michael O'Neill, Strategic Business Development at Nvidia, discussed the accelerating pace of AI development and how IBM Cloud and NVIDIA are partnering to bring AI capabilities to "every day," on-demand. They also reviewed two "free infrastructure" pr...
Judith Hurwitz is president and CEO of Hurwitz & Associates, a Needham, Mass., research and consulting firm focused on emerging technology, including big data, cognitive computing and governance. She is co-author of the book Cognitive Computing and Big Data Analytics, published in 2015. Her Cloud Expo session, "What Is the Business Imperative for Cognitive Computing?" is scheduled for Wednesday, June 8, at 8:40 a.m. In it, she puts cognitive computing into perspective with its value to the busin...
Blockchain is a shared, secure record of exchange that establishes trust, accountability and transparency across supply chain networks. Supported by the Linux Foundation's open source, open-standards based Hyperledger Project, Blockchain has the potential to improve regulatory compliance, reduce cost and time for product recall as well as advance trade. Are you curious about Blockchain and how it can provide you with new opportunities for innovation and growth? In her session at 20th Cloud Exp...
SYS-CON Events announced today that Hitachi, the leading provider the Internet of Things and Digital Transformation, will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Hitachi Data Systems, a wholly owned subsidiary of Hitachi, Ltd., offers an integrated portfolio of services and solutions that enable digital transformation through enhanced data management, governance, mobility and analytics. We help globa...
Cognitive Computing is becoming the foundation for a new generation of solutions that have the potential to transform business. Unlike traditional approaches to building solutions, a cognitive computing approach allows the data to help determine the way applications are designed. This contrasts with conventional software development that begins with defining logic based on the current way a business operates. In her session at 18th Cloud Expo, Judith S. Hurwitz, President and CEO of Hurwitz & ...
Financial Technology has become a topic of intense interest throughout the cloud developer and enterprise IT communities. Accordingly, attendees at the upcoming 20th Cloud Expo at the Javits Center in New York, June 6-8, 2017, will find fresh new content in a new track called FinTech.
SYS-CON Events announced today that Interoute, owner-operator of one of Europe's largest networks and a global cloud services platform, has been named “Bronze Sponsor” of SYS-CON's 20th Cloud Expo, which will take place on June 6-8, 2017 at the Javits Center in New York, New York. Interoute is the owner-operator of one of Europe's largest networks and a global cloud services platform which encompasses 12 data centers, 14 virtual data centers and 31 colocation centers, with connections to 195 add...
In recent years, containers have taken the world by storm. Companies of all sizes and industries have realized the massive benefits of containers, such as unprecedented mobility, higher hardware utilization, and increased flexibility and agility; however, many containers today are non-persistent. Containers without persistence miss out on many benefits, and in many cases simply pass the responsibility of persistence onto other infrastructure, adding additional complexity.
@DevOpsSummit at Cloud taking place June 6-8, 2017, at Javits Center, New York City, is co-located with the 20th International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is no time to wait for long developm...