System and process for providing improved database interfacing using query objects

Claim 3

A system according to claim 1, wherein the request further comprises a parametized request, the query processor accessing the data source via the parametized request.

Claim 4

A system according to claim 1, further comprising an error handler handling errors encountered by the connection manager and the query processor, each such error sending a pre-determined error indication to the client.

Claim 5

A process according to claim 1, wherein the query processor handles transactions subsequent to performing at least one such encapsulated data manipulation.

Claim 6

A system according to claim 4, wherein the query processor handles transactions by caling a single statement transaction implemented in the query language.

Claim 7

A system according to claim 4, wherein the query processor handles transactions by calling an explicit transaction operation implemented in the query language.

Claim 8

A system according to claim 4, wherein the query processor handles transactions by invoking a transaction manager which interfaces with the query object via the interface.

Claim 9

A system according to claim 1, wherein the query processor processes a plurality of threads, each such thread controlling at least one such encapsulated data manipulation on the data source.

Claim 10

A system according to claim 1, wherein the query processor maps the request from the client to an intermediate data format.

Claim 11

A system according to claim 1, wherein the query processor maps the resultant set of the data into an intermediate data format.

Claim 12

A system according to claim 1, wherein the data source operates in a distributed processing environment comprising a plurality of the query objects.

Claim 13

A process for providing improved interfacing to a data source, the data source comprising a schema describing organization of the data within the data source and a interface defined in a query language, the process comprising: providing a query object having encapsulated therein a set of data manipulations implemented in the query language, each such encapsulated data manipulation conforming to the schema of the data source; handling a connection via the interface between the query object and the data source using a connection manager encapsulated within the query object; performing at least one such encapsulated data manipulation on the data source in response to a request from a client using a query processor encapsulated within the query object; and processing a resultant set of the data received in response to the at least one such data manipulation form the data source using a results processor encapsulated within the query object; and providing the resultant set of the data as pre-determined data types to the client using the results processor encapsulated within the query object.

Claim 14

A process for providing improved interfacing to a data source, the data source comprising a schema describing organization of the data within the data source and a interface defined in a query language, the process comprising: providing a query object having encapsulated therein a set of data manipulations implemented in the query language, each such encapsulated data manipulation conforming to the schema of the data source; handling a connection via the interface between the query object and the data source using a connection manager encapsulated within the query object; performing at least one such encapsulated data manipulation on the data source in response to a request from a client using a query processor encapsulated within the query object; and processing a resultant set of the data received in response to the at least one such data manipulation form the data source using a results processor encapsulated within the query object; and providing the resultant set of the data as pre-determined data types to the client using the results processor encapsulated within the query object.

Claim 15

A process according to claim 12, wherein the request further comprises a parametized request, the step of performing at least one such encapsulated data manipulation further comprising the step of accessing the data source via the parametized request.

Claim 16

A process according to claim 12, further comprising the step of handling errors encountered during the steps of handling a connection and performing at least one such encapsulated data manipulation, each such error sending a pre-determined error indication to the client.

Claim 17

A process according to claim 12, further comprising the step of handling transactions subsequent to the step of performing at least one such encapsulated data manipulation.

Claim 18

A process according to claim 15, wherein the step of handling transactions further comprises the step of calling a single statement transaction implemented in the query language.

Claim 19

A process according to claim 15, wherein the step of handling transactions further comprises the step of calling an explicit transaction operation implemented in the query language.

Claim 20

A process according to claim 17, wherein the explicit transaction operation further comprises the step of performing at least one of a commit statement and a rollback statement.

Claim 21

A process according to claim 15, wherein the step of handling transactions further comprises the step of invoking a transaction manager which interfaces with the query object via the interface.

Claim 22

A process according to claim 12, further comprising the step of processing a plurality of threads, each such thread controlling at least one such encapsulated data manipulation on the data source.

Claim 23

A process according to claim 12, further comprising the step of mapping the request from the client to an intermediate data format.

Claim 24

A process according to claim 21, wherein the intermediate data format comprises an interface definition language, the process further comprising the step of converting the request from the client into the interface definition language.

Claim 25

A process according to claim 12, further comprising the step of mapping the resultant set of the data into an intermediate data format.

Claim 26

A process according to claim 23, wherein the intermediate data format comprises the query language of the data source, the process further comprising the step of converting the resultant set of the data into the query language.

Claim 27

A process according to claim 12, wherein the data source operates in a distributed processing environment comprising a plurality of the query objects.

Claim 28

A computer program product embodied on a computer-readable medium for providing improved interfacing to a data source, the data source comprising a schema describing organization of the data within the data source and a interface defined in a query language, the computer program product comprising: code for providing a query object having encapsulated therein a set of data manipulations implemented in the query language, each such encapsulated data manipulation conforming to the schema of the data source; code for handling a connection via the interface between the query object and the data source using a connection manager encapsulated within the query object; code for performing at least one such encapsulated data manipulation on the data source in response to a request from a client using a query processor encapsulated within the query object; and code for processing a resultant set of the data received in response to the at least one such data manipulation form the data source using a results processor encapsulated within the query object; and code for providing the resultant set of the data as pre-determined data types to the client using the results processor encapsulated within the query obiect.

Claim 29

A computer program product embodied on a computer-readable medium for providing improved interfacing to a data source, the data source comprising a schema describing organization of the data within the data source and a interface defined in a query language, the computer program product comprising: code for providing a query object having encapsulated therein a set of data manipulations implemented in the query language, each such encapsulated data manipulation conforming to the schema of the data source; code for handling a connection via the interface between the query object and the data source using a connection manager encapsulated within the query object; code for performing at least one such encapsulated data manipulation on the data source in response to a request from a client using a query processor encapsulated within the query object; and code for processing a resultant set of the data received in response to the at least one such data manipulation form the data source using a results processor encapsulated within the query object; and code for providing the resultant set of the data as pre-determined data types to the client using the results processor encapsulated within the query obiect.

Claim 30

A computer program according to claim 26, wherein the request further comprises a parametized request, the code for performing at least one such encapsulated data manipulation further comprising code for accessing the data source via the parametized request.

Claim 31

A computer program according to claim 26, further comprising code for handling errors encountered during handling a connection and performing at least one such encapsulated data manipulation, each such error sending a pre-determined error indication to the client.

Claim 32

A computer program according to claim 26, further comprising code for handling transactions subsequent to the code for performing at least one such encapsulated data manipulation.

Claim 33

A computer program according to claim 26, further comprising code for processing a plurality of threads, each such thread controlling at least one such encapsulated data manipulation on the data source.

Claim 34

A computer program according to claim 26, further comprising code for mapping the request from the client to an intermediate data format.

Claim 35

A computer program according to claim 31, wherein the intermediate data format comprises an interface definition language, the computer-readable medium further comprising code for converting the request from the client into the interface definition language.

Claim 36

A computer program according to claim 26, further comprising code for mapping the resultant set of the data into an intermediate data format.

Claim 37

A computer program according to claim 33, wherein the intermediate data format comprises the query language of the data source, the computer-readable medium further comprising code for converting the resultant set of the data into the query language.

Claim 38

A computer data signal embodied in a carrier wave for providing improved interfacing to a data source, the data source comprising a schema describing organization of the data within the data source and a interface defined in a query language, the computer data signal comprising: code for providing a query object having encapsulated therein a set of data manipulations implemented in the query language, each such encapsulated data manipulation conforming to the schema of the data source; code for handling a connection via the interface between the query object and the data source using a connection manager encapsulated within the query object; code for performing at least one such encapsulated data manipulation on the data source in response to a request from a client using a query processor encapsulated within the query object; and code for processing a resultant set of the data received in response to the at least one such data manipulation form the data source using a results processor encapsulated within the query object; and code for providing the resultant set of the data as pre-determined data types to the client using the results processor encapsulated within the query object.

Claim 39

A computer data signal embodied in a carrier wave for providing improved interfacing to a data source, the data source comprising a schema describing organization of the data within the data source and a interface defined in a query language, the computer data signal comprising: code for providing a query object having encapsulated therein a set of data manipulations implemented in the query language, each such encapsulated data manipulation conforming to the schema of the data source; code for handling a connection via the interface between the query object and the data source using a connection manager encapsulated within the query object; code for performing at least one such encapsulated data manipulation on the data source in response to a request from a client using a query processor encapsulated within the query object; and code for processing a resultant set of the data received in response to the at least one such data manipulation form the data source using a results processor encapsulated within the query object; and code for providing the resultant set of the data as pre-determined data types to the client using the results processor encapsulated within the query object.