Query derived communication mechanism for communication between relational databases and object-based computing environments and systems

Abstract

Techniques for providing communication mechanisms between object-based and relational database systems are disclosed. A communication mechanism (e.g., a Web service) can be effectively derived from one or more query statements (e.g., SQL statements) based on a mapping to the objects of the object-based system. The communication mechanism can be generated in a Top-Down or Contract-First approach based on definitions and / or metadata needed to effectively construct the communication mechanism.

Description

CROSS REFERENCE TO RELATED APPLICATIONS[0001]This application takes priority of the U.S. Provisional Patent Application No. 61,619,893, entitled “QUERY DERIVED WEB SERVICES,” by John J. Smith and Mike G. Coutts, filed on Sep. 26, 2011, which is hereby incorporated herein by reference in its entirety and for all purposes.BACKGROUND[0002]Data can be an abstract term. In the context of computing environments and systems, data can be generally encompassing of all forms of information that can be stored in a computer readable medium (e.g., memory, hard disk). Data, and in particular, one or more instances of data can also be referred to as data object(s), especially in the context of object-based approaches to computing, where a data object can, for example, be an actual instance of data, a class, type, or form data, and so on.[0003]However, the term database can refer to a collection of data and / or data structures typically stored in a digital form. Data can be stored in a database for ...

AI Technical Summary

Benefits of technology

The patent describes a mechanism for integrating object-based and database systems using queries. A Web service can be created from these queries by generating a mapping of the database fields to programming languages. This mapping can be used to create various components needed for the web service. The invention simplifies the process of creating complex integrations between different systems and makes it easier to develop and maintain.

Problems solved by technology

Generally, database systems are much more complex than the example noted above.

Today, databases can be very complex.

Generally, databases and DBMS that manage them can be very large and extremely complex partly in order to support an ever increasing need to store data and analyze data.

Images