International Business Machines Corporation

Servicenow, Inc.

Donald Allan Weil

Joel Frank Farber

David R Schwartz

Bryan Frederick Smith

Teresa Lynn Leamon

Gerald Edward Kozina

Thomas S Lee

Mayank Vipin Shah

Lynda Arnold Hansen

Chenhuei J Chiang

Steven Soria, Jr

The invention relates to a method and apparatus for recording and maintaining stored information system object relationship information. Information contained within a stored information system (including system catalogs, referential constraints, triggers, table hierarchies, column references, indexes, stored program packages, system catalogs, stored procedures, stored queries, log/trace files of dynamically executed code, etc.) are searched to identify dependency relationships between objects. This object relationship information is stored and maintained in an information base. Information within the information based may be organized based upon subsets of objects that support a common application, service, or capability. Object relationship data is used to facilitate stored information system administration activities such as generating/restoring from archives, physically/logically segmenting data objects, replicating data objects; optimizing the distribution of data in distributed data system; and estimating operational capacity.

Method and apparatus for recording and managing data object relationship data

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

Growing community of inventors

San Jose, CA, United States of America

Donald Allan Weil