Externalizing very large objects in a relational database client/server environment
First Claim
1. A method for executing a query to retrieve data from a database, the database comprising data having at least one standard data type and data having at least one non-standard data type and being stored on a data storage device connected to a server computer, the method comprising the steps of:
- at the server computer, retrieving data having a standard data type, a small non-standard data type, and a large non-standard data type from the database;
generating an answer set comprising data having the standard data types, the small non-standard data types, and a placeholder, wherein the placeholder represents data having the large non-standard data types;
transmitting the generated answer set comprising at least the placeholder to a client computer; and
after transmitting the generated answer se transmitting data having the large non-standard data type represented by the placeholder in the answer set to the client computer.
1 Assignment
0 Petitions
Accused Products
Abstract
The present invention discloses a method, apparatus, and article of manufacture for transmitting data having non-standard data types between computers. A query is executed to retrieve data from a database. The database comprises data having standard data types and data having non-standard data types and is stored on a data storage device connected to a server computer. At the server computer, data having standard data types, small non-standard data types, and large non-standard data types is retrieved. An answer set is generated that comprises data having standard data types, small non-standard data types, and one or more placeholders representing data having the large non-standard data types. The generated answer set is transmitted to a client computer. After transmitting the generated answer set, data represented by each placeholder in the answer set is transmitted to the client computer.
-
Citations
33 Claims
-
1. A method for executing a query to retrieve data from a database, the database comprising data having at least one standard data type and data having at least one non-standard data type and being stored on a data storage device connected to a server computer, the method comprising the steps of:
-
at the server computer, retrieving data having a standard data type, a small non-standard data type, and a large non-standard data type from the database;
generating an answer set comprising data having the standard data types, the small non-standard data types, and a placeholder, wherein the placeholder represents data having the large non-standard data types;
transmitting the generated answer set comprising at least the placeholder to a client computer; and
after transmitting the generated answer se transmitting data having the large non-standard data type represented by the placeholder in the answer set to the client computer. - View Dependent Claims (2, 4, 5, 6, 7)
receiving data from an application residing on the client computer; and
inputting the received data into the database.
-
-
3. The method of clam 1, wherein the small non-standard data types are less than or equal to 32 k bytes and the large non-standard data types are greater than 32 k bytes.
-
8. An apparatus for executing a query to retrieve data from a database, comprising:
-
a server computer having a data storage device connected thereto, wherein the data storage device stores a database and wherein the database comprises data having at least one standard data type and data having at least one non-standard data type;
one or more computer programs, performed by the server computer, for, at the server computer, retrieving data having a standard data type, a small non-standard data type, and a large non-standard data type from the database, generating an answer set comprising data having the standard data type, data having the small non-standard data type, and a placeholder representing data having a large non-standard data type, transmitting the generated answer set comprising at least the placeholder to a client computer, and, after transmitting the generated answer set, transmitting data represented by the placeholder in the answer set to the client computer. - View Dependent Claims (9, 10, 11, 12, 13, 14)
-
-
15. An article of manufacture comprising a computer program carrier readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing a query to retrieve data from a database, the database comprising data having at least one standard data type and data having at least one non-standard data type and being stored on a data storage device connected to a server computer, the method comprising the steps of:
-
at the server computer, retrieving data having a standard data type, a small non-standard data type, and a large non-standard data type from the database;
generating an answer set comprising data having the standard data type, the small non-standard data type, and a placeholder representing data having the large non-standard data type;
transmitting the generated answer set comprising at least the placeholder to a client computer; and
after transmitting the generated answer set, transmitting data having the large non-standard data type represented by the placeholder in the answer set to the client computer. - View Dependent Claims (16, 17, 18, 19, 20, 21)
receiving data from an application residing on the client computer; and
inputting the received data into the database.
-
-
22. A method for executing a query to retrieve data from a database, the database comprising data having at least one non-standard data type and being stored on a data storage device connected to a server computer, the method comprising the steps of:
-
at the server computer, retrieving data having a small non-standard data type and a large non-standard data type from the database;
generating an answer set comprising data having the small non-standard data types and a placeholder, wherein the placeholder represents data having the large non-standard data types;
transmitting the generated answer set comprising at least the placeholder to a client computer; and
after transmitting the generated answer set, transmitting data having the large non-standard data type represented by the placeholder in the answer set to the client computer. - View Dependent Claims (23, 24, 25)
-
-
26. An apparatus for executing a query retrieve data from a database, comprising:
-
a server computer having a data storage device connected thereto, wherein the data storage device stores a database and wherein the database comprises data having at least one standard data type and data having at least one non-standard data type;
one or more computer programs, performed by the server computer, for, at the server computer, retrieving data having a small non-standard data type and a large non-standard data type from the database, generating an answer set comprising data having the small non-standard data types and a placeholder, wherein the placeholder represents data having the large non-standard data types, transmitting the generated answer set comprising at least the placeholder to a client computer, and after transmitting the generated answer set, transmitting data having the large non-standard data type represented by the placeholder in the answer set to the client computer. - View Dependent Claims (27, 28, 29)
-
-
30. An article of manufacture comprising a computer program carrier readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing a query to retrieve data from a database, the database comprising data having at least one standard data type and data having at least one non-standard data type and being stored on a data storage device connected to a server computer, the method comprising the steps of:
-
at the server computer, retrieving data having a small non-standard data type and a large non-standard data type from the database;
generating an answer set comprising data having the small non-standard data types and a placeholder, wherein the placeholder represents data having the large non-standard data types;
transmitting the generated answer set comprising at least the placeholder to a client computer; and
after transmitting the generated answer set, transmitting data having the large non-standard data type represented by the placeholder in the answer set to the client computer. - View Dependent Claims (31, 32, 33)
-
Specification