Speculation has been operating rampant that Oracle may present its own NoSQL information at the OpenWorld conference, to be applied next week in San Francisco. When Oracle thus far has been fast about the arise of the NoSQL information campaign over the past some years, its programmers have been at operate devising ways to bring NoSQL-like speed and flexibility to its MySQL open-source database.
For OpenWorld, Oracle has planned a number of seances and presentments committed to something called the Oracle NoSQL Database. The function that the company has finish thus far to equip MySQL with NonSQL practicality might supply a clue as to the nature of this latest offering. Oracle's operate has focussed on combining the responsiveness of NoSQL systems with the full range of options of SQL-based systems such as Oracle's own.
Oracle's potential secret weapon for revving SQL to NoSQL speeds? The Memcached caching tech, which Facebook and many other serv so soon apply. The company is appearing at at least 2 ways of mixing Memecached with its open-source MySQL information. NoSQL information have been usually praised for the speed at which they can serve and ingest information, when equated to the operation of tralatitious SQL systems such as Oracle's. still, they lack a usual port for language for operating with data, something that SQL provides.
Also, adverse NoSQL, SQL additionally gives a set of properties, predicted ACID (particle, substance, closing off, strength) that mathematically insures that ceremony admonition administering is handled faithfully. In an annual in May with the IDG News Service, Tomas Ulin, Oracle animality admiral of MySQL engineering, showed a action to accompany the NoSQL-like dispatch of attainable to SQL-founded MySQL. "We feel identical able we can admixture SQL and NoSQL," he said. "If you acquire actually high-scalability operation aliment for actually ballocks of your app, you can allocation the dataset" above both NoSQL and SQL ports.
The key to Oracle's attempt is the utilize of Memcached, which Internet-established service providers,Facebook being the biggest, have long expended to quickly serve MySQL data to their users. Memcached creates a hash table of commonly accessed database items that is stored in a server's working memory for quick access, by way of an API (application programming interface).
Memcached would supply a natural non-SQL interface for MySQL, Ulin said. Memcached "is heavy utilized in the Web world. It is something [webmasters] so soon have established on their systems, and they recognize how to utilize. So we felt that would be a better way to provide NoSQL access," Ulin said.