SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

New Databases

By Steve Jones,

Amazon.comFor almost all of my technical career I've worked with two types of databases: flat files and relational database systems (RDBMS). I investigated object databases at one point in time, but they were so much of a niche, and the programming requirements greater than we wanted to deal with that we decided to stick with SQL Server at that company.

However there are some new types of databases being implemented in the world. Amazon's SimpleDB is mentioned in the article along with a few others that seem to be built to supplement a traditional RDBMS and provide some nice advantages in a distributed environment. For example, SimpleDB seems to be good for lookup data for remote systems, which could be web sites, mobile phones, or some other far flung technology that doesn't need to meet the ACID requirements necessary for transactional systems. Terracotta allows offloading of some transactional elements, preventing the need for so many round trips to the database.

As we build and implement these new types of technology, I think that we can end up with some very powerful applications. However we can also easily end up with a mess if developers and others are assuming that ACID concepts will still apply and that all changes will be visible to all clients in near real time. They might appear to do that in testing, but as usage scales, latency and other types of volume issues will come into play.

As DBAs, we should continue to learn more about these new types of databases or database technologies that might supplement our current RDBMS. Only with the knowledge of how these technologies work will we be able to offer valuable input into the architecture of our applications.

That input will definitely be needed to ensure that data integrity and quality can be ensured.

Steve Jones

The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there.

You can also follow Steve Jones on Twitter:

Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

Total article views: 204 | Views in the last 30 days: 1
Related Articles

SQL Server Podcasts

Photo credit: Digitalnative About a year ago, I came across an online deal for a car stereo system ...


System databases

System databases


Podcast Announcements

Podcast Feeds


DLP Technology

Steve Jones isn't talking about his new television, but rather a new technology dealing with data an...


SQL and the other technologies

Next table shows how SQL stands with the other technologies. The data is taken from StackOverflow.Da...