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.

What is claimed is: 
     
         1 . A computer-implemented method for at least facilitating generation of a communication mechanism for communicating with a relational database over a network by one or more object-based applications of one or more object-based programming languages, the computer-implemented method comprising:
 obtaining one or more database queries of the relational database in a database query language;   generating, at least partly based on the one or more database queries, relational-query-to-object data that at least maps one or more database components associated with the one or more database queries to one or more object-based components of the one or more object-based programming languages, thereby allowing a query-based communication mechanism to be generated, at least partly based on the one or more database queries, that allows the one or more object-based applications of the one or more object-based programming languages to communicate via the query-based communication mechanism with the relational database over the network.   
     
     
         2 . The computer-implemented method of  claim 1 , wherein the computer-implemented method further comprises:
 generating at least part of the communication mechanism based on the relational-query-to-object data.   
     
     
         3 . The computer-implemented method of  claim 1 , wherein the generated communication mechanism includes one or more services provided over the network. 
     
     
         4 . The computer-implemented method of  claim 3 ,
 wherein the one or more services are provided as a Web service over the Internet, and   wherein the one or more object-based programming languages are one or more object oriented programming languages.   
     
     
         5 . The computer-implemented method of  claim 1 , wherein the relational-query-to-object data further includes:
 a mapping of the one or more database fields associated with the one or more queries to one or more data types of at least one of the one or more object-based programming languages.   
     
     
         6 . The computer-implemented method of  claim 5 , wherein at least part of the mapping is provided in an extensible markup language. 
     
     
         7 . The computer-implemented method of  claim 1 , wherein the relational-query-to-object data further includes one or more resulting objects corresponding to the result of the execution of one or more database queries. 
     
     
         8 . The computer-implemented method of  claim 5 , wherein the computer-implemented method further comprises:
 generating, based on the mapping, one or more service definitions for the one or more services provided over the network.   
     
     
         9 . The method of  claim 5 , wherein the computer-implemented method further comprises:
 generating, based on the one or more service definitions, a skeleton server.   
     
     
         10 . The computer-implemented method of  claim 5 , wherein the computer-implemented method further comprises:
 generating, based on the mapping, an abstract interface for accessing the database service and a database service class that can that effectively connect the abstract interface to the one or more services.   
     
     
         11 . The computer-implemented method of  claim 5 ,
 wherein the relational-query-to-object data further includes:
 one or more resultant objects of the one or more object-based programming languages obtained at least partly based on the one or more database queries; and 
   wherein the computer-implemented method further comprises:
 executing the one or more database queries which are provided in the database query language to obtain one or more results; 
 generating, at least partly based on the mapping of the one or more database fields, the one or more resultant objects which correspond to the one or more results of the execution of the one or more database queries. 
   
     
     
         12 . The computer-implemented method of  claim 3 , wherein the generating of the communication mechanism that includes one or more services provided over the network comprises one or more the following:
 generating one or more service definitions for the one or more services;   generating schema or metadata for the one or more services;   generating an abstract interface for accessing the database system;   generating abstract and/schema objects;   a server skeleton for a server of the one or more services;   one or more database service classes;   a client proxy for a client or a server of the one or more services;   configuration data for connecting the database to the one or more services;   
     
     
         13 . The computer-implemented method of  claim 3 , wherein the computer-implemented method further comprises: modifying based on user input one or more components of the following based on user input. 
     
     
         14 . The computer-implemented method of  claim 13 , wherein the modifying comprises:
 displaying the one or more components on the display; and   allowing editing of the one or more components on the display.   
     
     
         15 . A system including one or more processors or processing cores operable to:
 obtain one or more database queries of a relational database in a database query language;   generate, at least partly based on the one or more database queries, relational-query-to-object data that at least maps one or more database components associated with the one or more database queries to one or more object-based components of one or more object-based programming languages, thereby allowing a query-based communication mechanism to be generated, at least partly based on the one or more database queries, that allows one or more object-based applications of the one or more object-based programming languages to communicate via the query-based communication mechanism with the relational database over the network.   
     
     
         16 . A non-transitory computer readable medium storing at least executable computer code for at least facilitating generation of a communication mechanism for communicating with a relational database over a network by one or more object-based applications of one or more object-based programming languages, wherein the executable computer code includes:
 executable computer code obtaining one or more database queries of the relational database in a database query language;   executable computer code for generating, at least partly based on the one or more database queries, relational-query-to-object data that at least maps one or more database components associated with the one or more database queries to one or more object-based components of the one or more object-based programming languages, thereby allowing a query-based communication mechanism to be generated, at least partly based on the one or more database queries, that allows the one or more object-based applications of the one or more object-based programming languages to communicate via the query-based communication mechanism with the relational database over the network.