Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
1999-07-15
2001-05-29
Alam, Hosain T. (Department: 2172)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000, C707S793000, C707S793000, C707S793000, C709S241000, C709S241000, C345S440000
Reexamination Certificate
active
06240422
ABSTRACT:
BACKGROUND OF THE INVENTION
1. Field of the Invention
The present invention is directed to a system for mapping objects and their associations to and from a relational database and, more particularly, to a system that uses a reflection layer, mapping files, overflow tables and buffered database input/output to provide flexibility and performance improvements in high volume transaction situations.
2. Description of the Related Art
A recurring problem in object development is how to insert or retrieve an object from a relational database table without hard-coding the object's structure and the database function calls. Objects can contain basic types as attributes (for example dates, strings, etc.) which map directly to the database, but they can also contain other objects, pointers to objects and lists, which may need mapping to multiple tables. Complex inheritance structures complicate the mapping issues. Hard-coding a solution, as seen in many systems, results in difficult to maintain and unwieldy database interfaces. What is needed is an object to relational database mapping infrastructure.
Another problem is how to store objects that are contained within lists in a parent object. A possible approach is to store the list object in a separate table and associated to the parent object using foreign key relationship. This approach does not provide the performance necessary for high volume data processing since for each object containing an object list, a second table needs to be accessed. Another possible approach is to store the list objects within the parent object's storage table. This results in having to provide columns to store all possible entries. This results in large storage tables within many of the columns remaining empty when the lists are not full. What is needed is a system which will allow storage of an optimum number of list entries within the parent object's table. The optimum number has to be determined on a case by case basis and solely depends on the business scenario. For example, a scenario where 96% of all customers of a telecommunication company are estimated to have one or two accounts, the remaining 4% have an average of 6 accounts. In this scenario, two might be the optimal number to provide fast access for 96% of the customer retrievals and not to allocate storage for more accounts that are not used by 96% of the customers in the database.
SUMMARY OF THE INVENTION
It is an object of the present invention to provide a system that maps objects and their associations to and from a relational database.
It is another object of the present invention to provide mapping files that allow configuration of all object attributes and methods at run time.
It is also an object of the present invention to provide an overflow mechanism used to enhance the speed of access.
It is also an object of the present invention to buffer data between the objects and the database to improve efficiency.
It is also an object of the present invention to utilize a reflection layer to interact with the business objects.
The above objects can be attained by a system that uses an infrastructure to map objects and their associations to and from a relational database. The mapping is facilitated by metadata or scripts in the form of mapping files which describe how an object corresponds to a table in the database. To facilitate speed and efficiency overflow tables are provided in the database when an object is associated with more than a predetermined number of other objects. A reflection layer is provided that allows particular attributes and methods of the objects to be resolved at run time. Mapped data is also buffered during the operation of transferring data to and from the database.
These together with other objects and advantages which will be subsequently apparent, reside in the details of construction and operation as more fully hereinafter described and claimed, reference being had to the accompanying drawings forming a part hereof, wherein like numerals refer to like parts throughout.
REFERENCES:
patent: 5291583 (1994-03-01), Bapat
patent: 5295256 (1994-03-01), Bapat
patent: 5426780 (1995-06-01), Gerull et al.
patent: 5448727 (1995-09-01), Annevelink
patent: 5504885 (1996-04-01), Alashqur
patent: 5729739 (1998-03-01), Cantin et al.
patent: 5809505 (1998-09-01), Lo et al.
patent: 5873093 (1999-02-01), Williamson et al.
patent: 5937409 (1999-08-01), Wetherbee
patent: 6038566 (2000-03-01), Tsai
patent: 6108664 (2000-08-01), Nori et al.
patent: 6154748 (2000-11-01), Gupta et al.
Fu, Mei-Mei et al., “A Concurrent Programming Environment for Memory-Mapped Persistent Object Systems,” Proceedings of the Seventeenth Annual International Conference on Computer Software and Applications, 1993, COMPSAC '93., Nov. 1-5, 1993, pp. 291-329.*
Millard, Bruce et al., “Run-Time Support and Storage Management for Memory-Mapped Persistent Objects,” Proceedings of the 13th International Conference on Distributed Computing Systems, May 25-28, 1993, pp. 508-515.*
International Search Report, International Appl. No. PCT/US99/16765, International Filing Date Jul. 26, 1999, 4 pgs.
Charly Kleissner, “Enterprise Objects™ Framework A Second Generation Object-Relational Enabler”, Association of Computing Machinery, 1995, pp. 445-459.
Bryan Boreham, “What's My Line?”, Effective C++, XP-000856296, Application Development Advisor, 1998, pp. 66, 68-69.
Rene Brun et al., “ROOT-An object oriented data analysis framework”, Nucleatr Instruments and Methods in Physics Research, 1997, pp. 81-86.
Atkins Stephan
Baldwin James
Hohmann Andreas
Schmetz Frank
Alam Hosain T.
Alam Shahid
American Management Systems, Inc.
LandOfFree
Object to relational database mapping infrastructure in a... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Object to relational database mapping infrastructure in a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Object to relational database mapping infrastructure in a... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-2528163