# US 2008/0306920 A1 · Byte-code representations of actual data to reduce network traffic in database transactions

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2008/0306920 A1
- Document ID: US20080306920A1
- Status: Published application
- Kind: A1
- Application number: 12/181,090
- Filed: 2008-07-28
- Published: 2008-12-11
- Earliest claimed: 2003-03-13
- Assignees: International Business Machines Corporation
- Inventors: John M. Santosuosso
- Web page: https://patentgrep.com/patent/US20080306920A1

## CPC

- G06F 16/24561: {Intermediate data storage techniques for performance improvement}
- Y10S 707/99931: Database or file accessing
- Y10S 707/99932: Access augmentation or optimizing
- Y10S 707/99933: Query processing, i.e. searching
- Y10S 707/99945: Object-oriented database structure processing
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- Y10S: TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS

## Abstract

Methods, articles of manufacture, and systems for reducing network traffic for database transactions between a requesting client and a database server are provided. For some embodiments, the client may access statistical information regarding the data, such as that commonly contained in indexes (e.g., encoded vector indexes), conventionally generated for use by a query optimizer. For some embodiments, based on the statistical information regarding the data, the client may request that the server send small byte-code representations of data from the database, rather than the actual data. The small byte-code representations may be significantly smaller than the actual represented data, thus reducing network traffic between the client and server. The client may then retrieve the actual represented data from a corresponding data representation record.

## Claims

### Claim 1

A tangible computer readable storage medium containing a program which, when executed by a client, performs operations for accessing data from a data source comprising:
obtaining information regarding one or more distinct data values stored in a field of the data source, the information including at least a byte size of the field;
requesting, based at least partially on the byte size of the field, that a server of the data source send representations of the distinct values rather than actual distinct values, in response to queries for data from the field;
sending, to the data source, a query for data from the field;
receiving, in response to the query, a representation of one of the distinct values rather than the actual distinct value; and
retrieving the actual distinct value from a data object, stored on the client, containing the actual distinct value.

### Claim 2 (depends on 1)

The tangible computer readable storage medium of claim 1, wherein the operations further comprise receiving, from the server, the data object containing the actual requested data.

### Claim 3

A tangible computer readable storage medium containing a program which, when executed by a server, performs operations for sending data to a client comprising:
receiving, from the client, a request for data from one or more fields of a database served by the server;
determining whether a representation has been generated for the requested data;
if not, generating the representation;
in response to the request, sending a representation of the requested data to the client, rather than the actual requested data, wherein the representation has a smaller byte size than the actual requested data; and
sending to the client a data object containing the representation and the actual requested data.
