International Business Machines Corporation

Thomas S Lee

Mayank Vipin Shah

Gerald Edward Kozina

Lynda Arnold Hansen

Philip Lester Flowers

Tawei Hu

Shirley S Wang

Donald Edward Benson

Thomas G Burket

Chris Myunghoon Lee

Seifu Ali

Chenhuei J Chiang

Roland Seiffert

Donald Allan Weil

Mandy L Wang

Daniel H Wood

Steven Soria, Jr

Stefan Raimund Orban

A method, system, and storage medium for providing versioning of data by associating a version number having a value with a data item, establishing a table for storing a most recent version of the data item, establishing a second table for storing all versions of the data item other than the most recent version, storing the current version of the data item in the first table, storing all other versions of the data item in the second table, and determining the version of said database data item based on the version number and storage location of the database data item.

Implementing versioning support for data using a two-table approach that maximizes database efficiency

A method and system for supporting multivalue attributes in a database system is disclosed. The method and system includes defining an index class by designating a plurality of attributes associated with the index class, wherein the plurality of attributes includes single value attributes and at least one multivalue attribute, generating an attribute value table for the index class for storing attribute values for the single value attributes, and generating a multiple value table for each of the at least one multivalue attributes for storing attribute values for the at least one multivalue attributes. By generating the multiple value table for the multivalue attribute, each row in the multiple value table corresponds to a single value of the multivalue attribute of the index class. Accordingly, an index scan can be performed to retrieve or update data corresponding to the associated multivalue attribute. Thus, data management becomes more efficient and less costly.

Method and system for supporting multivalue attributes in a database system

A technique for manipulating objects at a computer is described. The technique includes receiving one or more requests to manipulate an object, wherein each request is received from a different thread. Each request to manipulate an object generates a copy of the object and a unique identifier for each copy of the object. A request to manipulate a copy of an object is distinguished from other requests to manipulate other copies of the object using the unique identifier. Additionally, a technique for accessing objects at a computer is described. The technique includes receiving a request from a client process for an object which is stored in an object server. A library server process is allocated to handle the object request. Transfer of the requested object is initiated. Thereafter, the library server process that was allocated to the object request is released.

Data processing system

A method and system for supporting multivalue attributes in a database system is disclosed. The method and system includes defining an index class by designating a plurality of attributes associated with the index class, wherein the plurality of attributes includes single value attributes and at least one multivalue attribute, generating an attribute value table for the index class for storing attribute values for the single value attributes, and generating a multiple value table for each of the at least one multivalue attributes for storing attribute values for the at least one mulitvalue attributes.

A method, apparatus, and article of manufacture for executing a command in a computer to retrieve data from a data store connected to the computer. A request to identify a workbasket in which an item resides is received. Initially, it is determined whether the item resides in a workbasket. When it is determined that the item resides in a workbasket, a workbasket identification is returned.

Determining a workbasket identification for an item in a data store

A method, apparatus, and article of manufacture for generating an item identification number within a computer. An item identification number is associated with an item stored in a database connected to the computer. In accordance with the present invention, a unique seed value is created, wherein the unique seed value comprises a computer-dependent timestamp and one or more unique identifiers. A unique item identification number is produced by inputting the unique seed value into a random number generator.

Technique for creating a unique item identification number in a multi-threaded/multi-process environment

The present invention is directed to a method and system for storing and managing objects, such as binary large objects (blobs) in a digital library system which includes a plurality of clients, an object server for storing an object, a cache server for storing an copy of the object, and a centralized server for storing information identifying the object as being stored in the object server and associating one or more of the clients with the cache server, in which one of the clients, as a requesting client, requests retrieval of an object, a copy of the requested object is sent from the cache server to the requesting client if the object is stored in said cache server, and a copy of said object is sent from the object server to said requesting client if the object is not stored in the cache server; and a copy of the requested object is sent from the object server to the cache server after the object server sends the object to the client, in which the object sent to the client is made available to the client regardless of whether sending of the copy of the object to the cache server is completed.

Distributed storage management system having a cache server and method

The present invention is directed to a method and system for storing and managing objects, such as binary large objects (blobs) in a digital library system which includes a plurality of clients, an object server for storing an object, a cache server for storing a copy of the object, and a centralized server for storing information identifying the object as being stored in the object server and associating one or more of the clients with the cache server, in which one of the clients, as a requesting client, requests retrieval of an object, a copy of the requested object is sent from the cache server to the requesting client if the object is stored in said cache server, and a copy of said object is sent from the object server to said requesting client if the object is not stored in the cache server; and a copy of the requested object is sent from the object server to the cache server after the object server sends the object to the client, in which the object sent to the client is made available to the client regardless of whether sending of the copy of the object to the cache server is completed.

The invention relates to directing one or more object-based search engines to an object store, which stores information archived according to parametric classifiers. In order for the object-based search engine to access the objects, a special index class, in the form of a SQL table is created. The index class comprises attributes of a part number, an object identification number, an item identifier, a search state attribute, and a search engine identifier, an object being assigned a corresponding value for each attribute and each object being uniquely identified by the item identifier attribute. The search engine is activated depending on the type of data object to be indexed, in accordance with the search state attribute the catalog table. A computer readable medium is provided with program code to implement the above integration.

Growing community of inventors

San Jose, CA, United States of America

Thomas S Lee