Standard database queries within standard request-response protocols
AssigneeMicrosoft Corporation
InventorsLisa M. Lippert, Joel M. Soderberg, Saveen V. Reddy
Life of this patent
Estimating the term…
Abstract
Standard database queries within standard request-response protocols is disclosed. A database query according to a predetermined query language such as SQL is first wrapped according to a predetermined markup language such as XML. The query is then also wrapped according to a predetermined transport protocol such as HTTP. The resulting twice-wrapped database query can then be submitted from a client to a server over a TCP/IP-compliant network, such as the Internet, for example.
Claims31
In a network system that includes a querying computer system and a query processing computer system that are configured to communicate via a transport protocol, and that are both configured to process a markup language, a method for the querying computer system to submit a database query in a format that may be processed by the query processing computer system, the method comprising:
- an act of accessing a database query that is structured according to a query language;
- an act of wrapping the database query according to a markup language to indicate the start and stop of the database query, and to identify the database query as being a database query;
- an act of further wrapping the wrapped database query according to the transport protocol;
- and
- an act of outputting the further wrapped database query.
A computer program product for use in a network system that includes a querying computer system and a query processing computer system that are configured to communicate via a transport protocol, and that are both configured to process a markup language, the computer program product for implementing a method for the querying computer system to submit a database query in a format that may be processed by the query processing computer system, the computer program product comprising one or more machine-readable media having machine-executable instructions stored thereon that, when executed by a processor, perform the following acts:
- causing a database query to be accessed, the database query being structured according to a query language;
- wrapping the database query according to a markup language to indicate the start and stop of the database query, and to identify the database query as being a database query;
- further wrapping the wrapped database query according to the transport protocol;
- and
- causing the database query to be submitted from the querying computer system to the query processing computer system over a network.
A computer program product for use in a network system that includes a querying computer system and a query processing computer system that are configured to communicate via a transport protocol, and that are both configured to process a markup language, the computer program product for implementing a method for the query processing computer system to respond to a database query in a format that may be processed by the querying computer system, the computer program product comprising one or more machine-readable media having instructions stored thereon that, when executed by a processor, perform the following acts:
- generating a database response to a database query that is structured according to a query language;
- wrapping the database response according to the markup language to indicate the start and stop of the database response, and to identify the database response as being a database response;
- further wrapping the wrapped database response according to the transport protocol;
- and
- causing the database response to be submitted from the query processing computer system to the querying computer system over the network.
A computerized system comprising:
- a querying computer system configured to send a database query that is structured according to a query language, and that is wrapped according to a markup language to indicate the start and stop of the database query and to identify the database query as being a database query, and that is wrapped according to a transport protocol;
- and
- a query processing computer system configured to receive the database query and generate and send a database response thereto according to the query language, the database response being wrapped according to the markup language and according to the transport protocol.
Dependencies are inferred from the claim text.