After announcing the technology at its OpenWorld conference last month, Oracle has launched its much anticipated NoSQL database.
The Oracle NoSQL Database can now be downloaded from the Oracle Technology Network. The software will also be a key component the Oracle Big Data Appliance, due to be shipped in the first three months of 2012.
[ Also on InfoWorld: NoSQL is eclipsing the old-time RDBMS. | IT users report that NoSQL offers speed, scalability, and flexibility. | Learn the basics of big data technologies. | Let InfoWorld's Data Explosion interactive iGuide help you manage today's explosion of the data you need to analyze and manage. ]
The database, based on the Berkeley DB database, would be of interest to "customers who are acquiring massive amounts of data who are unsure about the schema, who want more fluid capture of the data," said Marie-Anne Neimat, vice president of database development at Oracle.
Such a database may be useful for storing information such as data from service logs, sensors, and meters as well as from social networks and personal information for e-commerce sites, the company claimed. A database of this sort would also be a good fit for large organizations that are already using Oracle databases, noted analyst Curt Monash of Monash Research. In many cases a relational database is not the best choice for tasks such as tracking Web interactions. "NoSQL in general deserves a place in Oracle shops, so it makes sense for Oracle to try to co-opt it," he wrote in a blog posting.
NoSQL can also be used to handle non-essential data storage duties, taking some of the burden off of more structured relational databases. Monash pointed to a recent database failure experienced by JPMorgan Chase. Because the company stored both time-sensitive financial transactional data and non-essential user information on the same database, financial transactions were slowed by an influx of large number of users checking into the Web site after a crash. Keeping the user data on a separate, possibly NoSQL, database for the user data might have eliminated this problem.
The database is based the Java version of Berkeley DB, an open source database developed by the University of California Berkeley that is widely used in embedded systems. The database uses a simple key-value data model, meaning that a program can fetch the needed piece of data by providing the appropriate key, or a numeric identifier.