Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1998-04-01
2002-04-02
Alam, Hosain T. (Department: 2172)
Data processing: database and file management or data structures
Database design
Data structure types
C717S152000
Reexamination Certificate
active
06366917
ABSTRACT:
FIELD OF THE INVENTION
The present invention pertains to the field of database generation, maintenance and modification. More particularly, the present invention relates to a method of modifying database object structures in accordance with changes made to metadata objects describing the database objects.
BACKGROUND OF THE INVENTION
Relational databases are advantageous in that the duplication of information or data within a relational database is limited by defining relationships between data records (or rows) in a number of data objects. Accordingly, the updating of the actual data within the database is simplified as the occurrence of the duplicate data items within the database is minimized. However, the modification of the structure (as opposed to the database data) of a populated database, for example by the modification of data formats, types or lengths or by the addition of columns to a table within the database, is nonetheless problematic, and typically requires the intervention of a database expert. For example, a particular data item (e.g., an amount) may be defined to have a particular format that requires modification (e.g., from the 999.9999 format to the 99999.99 format). As such a data item may be referenced by a number of the dependent tables and procedures within a database, such a modification to a populated database structure typically requires a database expert to make corresponding modifications to all dependent tables and procedures. The location, identification and modification of such dependent objects (e.g., table, procedure and view objects) must manually be performed, and is thus time consuming and inefficient. Further, the modification task is made difficult by the presence of data within such dependent objects. The problem is exasperated when massive databases are employed in complex systems, such as Enterprise Resource Planning (ERP) systems.
SUMMARY OF THE INVENTION
According to the invention, there is provided a method of modifying a database structure. Metadata, which describes the database structure, is modified. The database structure is then automatically modified to conform to the modified metadata.
Other features of the present invention will be apparent from the accompanying drawings and from the detailed description that follows.
REFERENCES:
patent: 4627019 (1986-12-01), Ng
patent: 4742467 (1988-05-01), Messerich et al.
patent: 4774661 (1988-09-01), Kumpati
patent: 4791561 (1988-12-01), Huber
patent: 4805099 (1989-02-01), Huber
patent: 4819160 (1989-04-01), Tanka et al.
patent: 4833597 (1989-05-01), Wakayama et al.
patent: 4979109 (1990-12-01), Tanaka et al.
patent: 5185887 (1993-02-01), Takahashi et al.
patent: 5341498 (1994-08-01), Connor et al.
patent: 5455945 (1995-10-01), VanderDrift
patent: 5806075 (1998-09-01), Jain et al.
patent: 5862325 (1999-01-01), Reed et al.
patent: 5899998 (1999-05-01), McGauley et al.
patent: 5920725 (1999-07-01), Ma et al.
patent: 6018742 (2000-01-01), Hebert, III
patent: 6151624 (2000-11-01), Teare et al.
patent: 6185584 (2001-02-01), Paik et al.
C. A. Schneider, “Table Update Serialization Technique”,IBM Technique Disclosure Bulletin, vol. 21, No. 3, Aug. 1978, pp. 1158-1162.
Frank W. Allen, Mary E. S. Loomis and Michael V. Mannino, “The Integrated Dictionary/Directory System”, ACMComputing Surveys, vol. 14, No. 2, Jun. 1982, pp. 245-286.
Batchelor, Dimmick and Rees, “Automatic Data Base Dictionary Creation and Maintenance During Program Creation or Modification”,IBM Technical Disclosure Bulletin, vol. 26, No .5, Oct. 1983, pp. 2466-2475.
Alam Hosain T.
Blakely , Sokoloff, Taylor & Zafman LLP
Fleurantin Jean Bolte
WebPutty, Inc.
LandOfFree
Method of modifying a populated database structure by... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Method of modifying a populated database structure by..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method of modifying a populated database structure by... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2918864