Auto-generation of table neighborhoods
First Claim
1. A database management system for managing data in a database, comprising:
- a database designer for creating a database diagram of tables in the database, wherein said database designer automatically displays a selected database table and related database tables having a selected level of relation with the selected database table.
2 Assignments
0 Petitions
Accused Products
Abstract
A system for automatically generating table neighborhoods comprises a database designer which automatically generates a database diagram for a selected table. The database designer automatically compiles a set of tables having the desired relation to a selected table. The desired level of relation may be several levels removed from the selected table, in which case, the database designer searches multiple levels for tables to be included in the database diagram. Thereafter, the database designer gathers format data for the selected table and the set of tables having the desired relation to the selected table. Finally, the database designer displays the selected table, the tables in the set of tables having the desired relation to the selected table, and the relationships between these tables.
49 Citations
21 Claims
-
1. A database management system for managing data in a database, comprising:
- a database designer for creating a database diagram of tables in the database, wherein said database designer automatically displays a selected database table and related database tables having a selected level of relation with the selected database table.
- View Dependent Claims (2, 3)
-
4. A database management system for managing data in a database, comprising:
- computer-executable instructions for searching a database for tables having a relationship to the selected table;
computer-executable instructions for formatting data related to the selected table and each table having a relationship to the selected table; and
computer-executable instruction for automatically displaying the selected table and each table having a relationship to the selected table.
- computer-executable instructions for searching a database for tables having a relationship to the selected table;
-
5. A database management system for managing data in a database, comprising:
- computer-executable instruction for compiling a set of related tables having a relationship to a selected table;
computer-executable instruction for retrieving format data about the selected table and each table in the set of related tables; and
computer-executable instruction for automatically displaying the selected table, each table in the set of related tables, and relationships between the selected table and each table in the list of related tables.
- computer-executable instruction for compiling a set of related tables having a relationship to a selected table;
-
6. A method for creating a database diagram for a selected table, comprising the following steps:
- searching a database for tables having a relationship to the selected table;
retrieving format data related to the selected table and each table having a relationship to the selected table;
automatically displaying the selected table, each table having a relationship to the selected table, and relationships between the selected table and each table having a relationship to the selected table. - View Dependent Claims (7, 8, 9)
- searching a database for tables having a relationship to the selected table;
-
10. A method for creating a database diagram for a selected table, comprising the following steps:
-
compiling a set of related tables having a relationship to the selected table;
retrieving format data about the selected table and each table in the set of related tables; and
automatically displaying the selected table, each table in the set of related tables, and relationships between the selected table and each table in the set of related tables. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17, 18)
-
-
19. A method for creating a database diagram for a plurality of selected tables, comprising the following steps:
-
searching a database for tables having a relationship to at least one of the plurality of selected tables;
retrieving format data for each of the plurality of selected tables and each table having a relationship to at least one of the plurality of selected tables; and
automatically displaying each of the plurality of selected tables, each table having a relationship to at least one of the plurality of selected tables, and relationships between the plurality of selected tables and each table having a relationship to at least one of the plurality of selected tables. - View Dependent Claims (20, 21)
-
Specification