Browse Prior Art Database

Accessing Relational Data From A RDBMS From A NoSQL API

IP.com Disclosure Number: IPCOM000235450D
Publication Date: 2014-Feb-28
Document File: 5 page(s) / 122K

Publishing Venue

The IP.com Prior Art Database

Abstract

A method and system is disclosed for accessing relational data from a Relational Database Management System (RDBMS) from a No Structured Query Language (NoSQL) Application Programming Interface (API). The method and system allows database application developers and administrators to access data stored in a traditional relational database using Javascript Object Notation (JSON) syntax that is commonly used with NoSQL databases.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 39% of the total text.

Page 01 of 5

Accessing Relational Data From A RDBMS From A NoSQL API


Disclosed is a method and system for accessing relational data from a Relational

Database Management System (RDBMS) from a No Structured Query Language (NoSQL) Application Programming Interface (API). The method and system allows database application developers and administrators to access data stored in a traditional relational database using Javascript Object Notation (JSON) syntax that is commonly used with NoSQL databases.

In accordance with the method and system, a middleware is integrated into the client to translate the application's database access API to use either JSON or SQL (relational) data transparently. Alternately, a separate layer between the client and a database server may also be used. This middleware peeks into database to see which of the tables are JSON (NoSQL) tables and which are not and converts the four primary operations of the MongoDB NoSQL JSON access language to equivalent SQL operations as part of execution of an operation on the database.

The method and system includes a database listener component to connect these applications to a relational database. The database listener component performs mapping from the NoSQL JSON syntax to the equivalent SQL syntax. Additionally, applications written for MongoDB style NoSQL JSON database access is created and commands are sent to the database using native syntax and drivers. The database performs the requested operations and prepares the results.

An SQL style SELECT operation is used to query data from a relational table. The equivalent MongoDB style NoSQL find() or findOne() operation can also be used to access this same data when the database accessing layer is modified to convert the SELECT operation to the equivalent find() operation. Additionally, an SQL style INSERT operation is used to insert data into a relational table. The equivalent MongoDB style NoSQL insert() operation can also be used to insert this same data

when the database accessing layer is modified to convert the INSERT operation to the equivalent insert() operation. This same pattern can be extended to UPDATE and DELETE operations.

A NoSQL JSON style database query is illustrated in Fig. 1.

Figure 1

1


Page 02 of 5

Fig. 1 illustrates a representative JSON MongoDB style query looking for the customers living in the state of California. The query is written using a standard JSON style syntax and, when executed against the depicted database, examines each document in the customer collection looking at the "state" field for values of "CA". Documents matching this criterion are selected for return.

A SQL RDBMS query is illustrated in Fig. 2.

Figure 2

Fig. 2 illustrates a representative SQL query also looking for partners living in the state of California. The query is written in the SQL language and, when executed against the

depicted database, examines each row in the partners table, looking at the "state" column for values matching "C...