The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Mar. 18, 1997
Filed:
Jun. 07, 1995
John A Malatesta, Alamo, CA (US);
Richard A Bergquist, Danville, CA (US);
Peoplesoft, Inc., Walnut Creek, CA (US);
Abstract
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.