by Vincent S
As businesses continue to become more reliant on the integration of new communications technologies and services, it has become more difficult to ensure that all the technologies use similar platforms. Databases are no longer only stored on in-house servers. Many company databases are stored on a combination of in-house servers and public cloud computing servers for data storage. With this in mind, one can see the challenge in keeping all the databases homogeneous enough in format in order to keep the rules of referential integrity. For many years software developers have attempted to solve this problem by creating databases that do not use SQL. In October 2011, Oracle announced the release of their own database that lacks the use of SQL. The obvious advantage of this type of database is that it does not matter on what platform or operating system the database was created on. Advocates of this method of database agree that large quantities of unstructured and unformatted data become much easier to deal with.
This article relates to what we have talked about in class this week in sense that it introduces a new kind of data model. However, the no SQL model is different from anything we mentioned in class. Using software that lacks use of SQL allows for customizable behavior that does not restrict data to a row and column format. This concept has the additional advantage of faster processing among a string of low-end servers which can help keep costs way down. The most obvious disadvantage is the lack of an ability to merge tables once they are complete. This makes achieving referential integrity almost impossible once too much heterogeneous data is entered into the same database.
I find it extremely interesting that the field of CIS is so dynamic in nature. Just as we are learning about data models in class, new software that uses a new model is being implemented in the industry. Newcomers in the industry must always be ready to learn new methods and protocols as quickly as they are created.
Metz, Cade. (2011, October 03). wired.com. Retrieved on January 15,2010 from http://www.wired.com/wiredenterprise/2011/10/oracle-nosql-database/