Oracle released NoSQL

The Oracle company issued the new database announced a month ago – NoSQL. The software product from Oracle can be loaded from the Oracle Technology Network resource now. This software will be one of key solution components of Oracle Big Data Appliance which deliveries should begin during the first quarter 2012.

NoSQL is created on the basis of the Berkeley DB database. It will be interesting to "the customers buying large volumes of data and who did not decide on the scheme DB, wishing more dynamic data processing", Marie-Anne Neimat, the vice president of Oracle for development of databases told. Thus the company responds to the growing number of the databases created for the last few years and tries to leave from typical architecture of SQL for implementation of more flexible scaling and speed regulation characteristics.

The company announced that the new DB can be useful to storage of such data as information of magazines of registration of events, sensors and metering devices, social networks and personal data of users of e-commerce sites. Databases of this kind also well are suitable for the large organizations which are already using Oracle databases, the analyst of Monash Research company Curt Monash noted. Often a relational database - not the best choice for such tasks as registration of activity on the Internet. "Generally, NoSQL will take the deserved place in a product line of Oracle so it makes sense to try to co-opt the companies it", - he wrote in the blog.

NoSQL can be also used for accomplishment of less important problems of information storage, having undertaken a part of loading from more structured relational databases. Monash reminded of recent failure of the database which faced JPMorgan Chase. As the company stored data of financial transactions and less essential user data in one DB, service of financial transactions was slowed down by inflow of a large number of the users checking after accident the data via the website. Storage of user data in a separate DB - NoSQL is probable, would help to avoid this problem.

At the heart of the DBMS NoSQL Java version database on the basis of the open code Berkeley DB, Berkeley (California) which is widely used in the built-in systems developed by the University. The database uses a simple data model "key value". It means that the program can receive a necessary fragment of data, transferring a necessary key or the numerical identifier. Though NoSQL does not allow to make thinly structured requests what are possible in relational SQL - the database, she does not demand the tough main scheme so the companies can add new columns and new data types which can be received and processed, told Neymat.

The software allows IT administrators to vary the speed of reaction and time necessary for achievement of coordination or a status when a part of data is completely saved. The database has capability of almost linear scaling, i.e. the capacity of a DB can be increased evenly, in process of adding of servers in a cluster. Oracle itself created a cluster from 300 nodes from this DB though, by words Neymat, theoretically, does not exist restrictions for cluster size.

The company is going to offer a free DB of NoSQL and also its commercial version which will be expanded additional opportunities. Oracle promises that installation will be carefully smoothly running, and for the paid editorial offices DB the company will offer a full support.