(Cat? OR feline) AND NOT dog?
Cat? W/5 behavior
(Cat? OR feline) AND traits
Cat AND charact*

This guide provides a more detailed description of the syntax that is supported along with examples.

This search box also supports the look-up of an IP.com Digital Signature (also referred to as Fingerprint); enter the 72-, 48-, or 32-character code to retrieve details of the associated file or submission.

Concept Search - What can I type?

For a concept search, you can enter phrases, sentences, or full paragraphs in English. For example, copy and paste the abstract of a patent application or paragraphs from an article.

Concept search eliminates the need for complex Boolean syntax to inform retrieval. Our Semantic Gist engine uses advanced cognitive semantic analysis to extract the meaning of data. This reduces the chances of missing valuable information, that may result from traditional keyword searching.

Accessing Relational Data From A RDBMS From A NoSQL API

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.

Country

Undisclosed

Language

English (United States)

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...