Data processing: database and file management or data structures – Database design – Database and data structure management
Reexamination Certificate
2004-10-14
2011-11-08
Leroux, Etienne (Department: 2161)
Data processing: database and file management or data structures
Database design
Database and data structure management
C707S769000, C705S050000
Reexamination Certificate
active
08055683
ABSTRACT:
A method, system and article of manufacture for managing relationships between database tables and, more particularly, for identifying and accurately describing relationships between tables in a database. One embodiment provides a method for identifying relationships between tables in a database. The method comprises receiving user input selecting a plurality of tables from the database. The plurality of tables is organized into a logical island defining a logical unit related to a particular logical entity. The method further comprises receiving user input identifying, for each of the plurality of tables, a table column containing information that identifies the particular logical entity in the table, whereby the identified table columns of different tables define logical relationships between the different tables in the logical island. On the basis of the identified table columns, relations specifications are created which describe the logical relationships between the different tables in the logical island.
REFERENCES:
patent: 5253362 (1993-10-01), Nolan et al.
patent: 5734887 (1998-03-01), Kingberg et al.
patent: 6460043 (2002-10-01), Tabbara et al.
patent: 6553368 (2003-04-01), Martin et al.
patent: 6601058 (2003-07-01), Forster et al.
patent: 6601065 (2003-07-01), Nelson et al.
patent: 6725227 (2004-04-01), Li
patent: 6768986 (2004-07-01), Cras et al.
patent: 6803927 (2004-10-01), Sahoo
patent: 6820076 (2004-11-01), Bailey et al.
patent: 6928431 (2005-08-01), Dettinger et al.
patent: 6954748 (2005-10-01), Dettinger et al.
patent: 6996558 (2006-02-01), Dettinger et al.
patent: 7024425 (2006-04-01), Krishnaprasad et al.
patent: 7096229 (2006-08-01), Dettinger et al.
patent: 7146376 (2006-12-01), Dettinger et al.
patent: 2002/0065854 (2002-05-01), Pressly
patent: 2003/0216939 (2003-11-01), Bito et al.
Patent U.S. Appl. No. 10/083,075, “Application Portability and Extensibility Through Database Schema and Query Abstraction”, filed Feb. 26, 2002.
Llama, “Search Your Database”, Jan. 18, 2002, Codewalkers, pp. 1-4.
Meng, Weiyi, et al, “A Theory of Translation From Relational Queries to Hierarchical Queries”, Apr. 1995, IEEE, pp. 228-245.
Brodhun Mark A.
Dettinger Richard D.
Glowacki Janice R.
Kolz Daniel P.
International Business Machines - Corporation
Leroux Etienne
Patterson & Sheridan LLP
Rahman Mohammad
LandOfFree
Management of relationships between database tables does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Management of relationships between database tables, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Management of relationships between database tables will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4293678