Peoplesoft, Inc.

John A Malatesta

Richard A Bergquist

The present invention provides the ability to alter data definitions in a Database Management System (DBMS). The present invention provides the ability to maintain DBMS and application catalogs. Alterations can be made to the an application catalog, and the changes propagated to the DBMS catalog based on the differences between like information in the application and DBMS catalogs as identified by the present invention. The present invention provides the ability to test for data loss. That is, the present invention examines the requested alteration and the data that will be affected by the alteration to determine whether or not the alteration will result in the loss of data. If loss of data is possible, alerts can be generated to determine whether or not to proceed with the alterations. The present invention provides two techniques to perform-the alterations depending on the ability of the DBMS to perform an alter on the original table without using an intermediate table (i.e., a native alter), or performing the alterations using an intermediate table for a DBMS with limited native alter capabilities.

Method for migrating application data definition catalog changes to the

The present invention provides the ability to alter data definitions in a Database Management System (DBMS). The present invention provides the ability to maintain DBMS and application catalogs. Alterations can be made to the an application catalog, and the changes propagated to the DBMS catalog based on the differences between like information in the application and DBMS catalogs as identified by the present invention. The present invention provides the ability to test for data loss. That is, the present invention examines the requested alteration and the data that will be affected by the alteration to determine whether or not the alteration will result in the loss of data. If loss of data is possible, alerts can be generated to determine whether or not to proceed with the alterations. The present invention provides two techniques to perform the alterations depending on the ability of the DBMS to perform an alter on the original table without using an intermediate table (i.e., a native alter), or performing the alterations using an intermediate table for a DBMS with limited native alter capabilities.

System for migrating application data definition catalog changes to the

The present invention provides the ability to internationalize a database application by providing a capability to create and maintain related international records. Data items can be stored in a base language with accompanying related copies of the data items represented in multiple languages and/or currencies. Application users can specify a preferred language. When data items are retrieved from a database, and when the user's language preference is not the same as the base language, language-dependent data items are retrieved from the related language records. When a related language record does not exist, or the preferred language is equal to the base language, the data items are retrieved from the base language records. Delete, Insert and Update operations can be performed on base language records, related language records or both.

Growing community of inventors

Alamo, CA, United States of America

John A Malatesta