Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1998-06-29
2001-08-21
Homere, Jean R. (Department: 2177)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C345S215000, C345S215000
Reexamination Certificate
active
06279008
ABSTRACT:
BACKGROUND OF THE INVENTION
1. Field of the Invention
This invention generally relates to database systems for computers and more particularly, to an integrated graphical user interface method and apparatus for mapping between objects and databases.
2. Description of the Related Art
Object-database mapping tools assist in integrating tables in a database with corresponding classes in an object-oriented application. Conventional object-database mapping tools receive class definitions from an object-oriented application and automatically generate code, typically stored in a database schema, to create tables and other structures for the database. The tables and structures in the database are used to hold data corresponding to objects generated by an object-oriented application.
There are numerous challenges to improve the techniques for integrating object-oriented applications and databases using these object-database mapping tools. In particular, these techniques need to account for the different organization of data in an object-oriented application compared with the organization of data in a database.
In an object-oriented application the skeleton of an object is a class. The class may have a number of fields used to store values or parameters typically used by object instances of the class. The class may also include specific methods which define how objects instantiated from each class will interact with each other and hold certain information in each of the corresponding fields. A hierarchical class structure provides an organized framework for creating objects and their relationships.
In contrast, databases have features that object-oriented applications do not possess. The database typically organizes data using one or more tables having multiple rows and columns. A data relationship is defined by the manner in which data is stored in the various rows and columns of the tables. A single table or multiple tables can be used to hold every row or record of data. A primary key includes one or more columns in a table that uniquely identifies each row of data. If multiple tables are used to store a data, a foreign key associates rows of data in one table with another table.
Unfortunately, conventional object-database mapping tools do not provide sophisticated techniques for integrating object-oriented applications and databases. Generally, the user must resort to multiple object-oriented development tools, database tools, and object-database mapping tools to integrate these two disparate systems. The numerous tools required to integrate such systems can be expensive and often will not work together smoothly.
Existing object-database mapping tools also make it difficult for the user to test and refine the integration of object-oriented applications and databases. For example, conventional object-database mapping tools do not allow a user to make a round-trip between a database and an object oriented application. That is, the user can not generate a database from a object-oriented application, modify the database, and then regenerate a portion of the object-oriented application. This prevents a user from quickly testing such an integrated system using various design scenarios. Furthermore, conventional user interfaces for performing such features are not properly designed to support these more sophisticated techniques for integrating object-oriented applications and databases.
Based on the above limitations found in conventional database and object-oriented systems, it is desirable to provide improved tools for integrating objects and databases.
SUMMARY OF THE INVENTION
In accordance with methods and systems consistent with the present invention, a graphical user interface on a computer system is provided that facilitates integrating objects from an object-oriented application and data stored in tables of a database. The graphical user interface displays a class view corresponding to one or more classes in the object-oriented application that in turn corresponds to tables in the database and displays a table view having one or more tables in a database corresponding to classes in the object-oriented application. In addition, the graphical user interface also displays a combination table-and-class view having database elements from the database adjacent to the object-oriented elements from the object-oriented application.
REFERENCES:
patent: 5291583 (1994-03-01), Bapat
patent: 5596746 (1997-01-01), Shen et al.
patent: 5717924 (1998-02-01), Kawai
patent: 5857197 (1999-01-01), Mullins
patent: 5878411 (1999-03-01), Burroughs et al.
patent: 5907846 (1999-05-01), Berner et al.
patent: 5937409 (1999-08-01), Wetherbee
patent: 5983020 (1999-11-01), Sweeney et al.
patent: 6003040 (1999-12-01), Mital et al.
patent: 6009428 (1999-12-01), Kleewein et al.
patent: 6101502 (2000-08-01), Heubner et al.
patent: 6108664 (2000-08-01), Nori et al.
patent: 6141660 (2000-10-01), Bach et al.
patent: 6175837 (2001-01-01), Sharma et al.
patent: WO 95/04960 (1995-02-01), None
patent: WO 95/03586 (1995-02-01), None
patent: WO 97/03406 (1997-01-01), None
T. Lindholm and F. Yellin, “The Java Virtual Machine Specification” Second Edition, Apr. 1999, pp. 1-473.
“Customizable Four Pane Layout for Database Table Definition,” Dec. 1992, pp. 268-269.
H. Bank, “OQL,” Sep. 15, 1997 (Rev. 0.11), pp. 1-7.
“Applications in Java and Extended Java,” Sep. 28, 1998, pp. 1-21.
“Sun Simplifies Database Programming with Java Blend,” Aug. 21, 1997, pp. 1-3.
S. Wang, “Improvement of Concurrency Control Within Object-Oriented Database Systems,” Apr. 5, 1990, IEEE, pp. 68-70.
S. Heiler and S. Zdonik, “Object Views: Extending the Vision,” 1990 IEEE, pp. 86-93.
D. Agrawal, A. Bernstein, P. Gupta, and S. Sengupta, “Distributed Multi-Version Optimistic Concurrency Control for Relational Database,” Mar. 1986, pp. 416-421.
X. Qian and L. Raschid, “Query Interoperation Among Object-Oriented and Relational Databases,” Mar. 6, 1995, IEEE, pp. 271-278.
S. Gantimahapatruni and G. Karabatis, “Enforcing Data Dependencies in Cooperative Information Systems,” May 12, 1993, IEEE, pp. 332-341.
IBM Technical Disclosure Bulletin, vol. 38, No. 01, Jan. 1995, Fast and Secure Stored Procedures for a Client/Server DBMS, pp. 79-82.
A. Alashqur and C. Thompson, “O-R Gateway: A System for Connecting C++ Application Programs and Relational Databases,” Aug. 10, 1992, pp. 151-169.
R. Ahad and T. Cheng, Hewlett-Packard Journal 44 (1993) Jun., No. 3, “HP OpenODB: An Object-Oriented Database Management System for Commercial Applications,” pp. 20-30.
TOPLink, “The Industry Standard for Persistence Product, A White Paper: The Object People”, 1997.
IBM Technical Disclosure Bulletin, vol. 37, No. 08, Aug. 1994, “Automatically Revising Function Prototypes in C and C++ Implementations of System Object Model Classes,” pp. 363-365.
C. Kleissner, “Enterprise Objects Framework, A Second Generation Object-Relational Enabler,” Jun. 1995, pp. 455-459.
“The Enterprise Objects Framework,” Jul. 1994, pp. 1-12.
SQL Tutorial: Introduction to Structured Query Language, Version 3.63 (May 1998), URL http://w3.one.net/~jhoffman/sqltut.htm#Compound Conditions.
The JDBC Database Access API (Apr. 1998), URL http://java.sun.com/products/jdbc.
O'Brien, Stephen K., “Turbo Pascal 5.5: The Complete Reference”, Osborne/McGraw-Hill (1989), pp. 500-522.
Gosling, Joy, and Steele, “The Java™ Language Specification”, Addison-Wesley (1996).
Hamilton, Cattell, and Fisher, “JDBC Database Access with Java™”, Addison-Wesley (1997).
R.G.G. Cattell et al., “Object Database Standard: ODMG 2.0”, Morgan Kaufman Publishers, Inc. (1997).
Campione, Mary and Kathy Walrath, “The Java™ Tutorial”, Addison-Wesley (1996).
Learmont Timothy R.
Ng Tony Chun Tung
Sharma Rahul
Finnegan Henderson Farabow Garrett & Dunner L.L.P.
Homere Jean R.
Sun Microsystems Inc.
LandOfFree
Integrated graphical user interface method and apparatus for... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Integrated graphical user interface method and apparatus for..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Integrated graphical user interface method and apparatus for... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2483034