Abstract: In accordance with methods and systems consistent with the present invention, an improved object-relational mapping tool is provided that generates source code containing classes which preserve both changes to the database schema as well as customizations to a preexisting version of the classes. This functionality alleviates the programmer from having to recreate their changes to the classes when the database changes, thus saving significant development time over conventional systems.

Abstract: In accordance with methods and systems consistent with the present invention, an improved object-relational mapping tool is provided that generates source code containing classes which preserve both changes to the database schema as well as customizations to a preexisting version of the classes. This functionality alleviates the programmer from having to recreate their changes to the classes when the database changes, thus saving significant development time over conventional systems.

Abstract: An improved object-database mapping tool is provided that generates indexes in a database corresponding to classes in an object-oriented application. Initially, the mapping tool maps each class in an object-oriented application to a table in a database. A user, for example, selects one or more fields to be indexed from one or more classes. The tool determines if the selected fields correspond to the columns in more than one table in the database. If the selected fields correspond to a plurality of tables in the database then the mapping tool generates a plurality of indexes. Alternatively, if the fields correspond to one table in the database then the mapping tool generates a single index.

Abstract: Mapping rules for use in mapping data between a relational model and an object model. A user interface permits a programmer or other person to enter the mapping rules, and a mapping tool converts data between the relational model and the object model according to the mapping rules.

Abstract: A graphical user interface on a computer system is provided for displaying objects in 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.

Abstract: A user interface permits a programmer or other person to manage lock groups for classes. The programmer enters information through the user interface to define new lock groups, update defined lock groups, and delete lock groups. The programmer manages the lock groups in the classes, and an optional mapping tool maps the defined lock groups when converting data between an object model and a relational model.

Abstract: A process receives an object-based query and creates a logical tree that contains nodes representing operations that are required for the query to be completed. Operations that can be performed by an RDBMS are transmitted to the RDBMS as an SQL query. The RDBMS executes the SQL query and returns data to the process. The process places the data into appropriate fields of one or more objects, and stores the resulting objects in a memory, such as an object cache. The process executes the remaining node operations (that could not be performed by the RDBMS) in conjunction with the objects stored in the object cache, and forwards the results to a user program.

Abstract: An improved object-database mapping tool is provided that stores a series of stored procedures associated with a database and an object-oriented application. The tool accesses stored procedures associated with classes corresponding to an object-oriented application. The tool determines a sequence of the stored procedures based on relationships between the classes. The tool loads the stored procedures based upon the sequence. In another aspect of the present invention, the tool uses several steps to sequence the stored procedures. The tool categorizes the stored procedures based on the classes the stored procedures correspond to in the object-oriented application. The tool loads the stored procedures corresponding to classes having relationships to other classes. The tool loads the stored procedures corresponding to classes categorized as superclasses. The tool also loads the stored procedures corresponding to classes categorized as subclasses.

Abstract: A method and system for database concurrency control is provided that allows lock groups to contain columns of different tables and allows an individual column of a table to be in more than one lock group. While using optimistic concurrency control for monitoring multiple transactions modifying the same database, it allows the concurrent access of a single table when the individual columns of the table are accessed by separate users or applications. This, in turn, reduces the delay of waiting for a table to be free for access and decreases the delay of rolling back transactions that are concurrently accessing a table. The reduction of these delays increases the overall data processing efficiency for the system.

Abstract: The invention relates to a method of configuring a set of object values in a computer. At least one object value of the set of object values is user-chosen from a number of object values. Each object has at least one possible object value. Each object value is determined or undetermined. Each of the determined object values is assigned to a value. Some or all of these object values is included in the set of object values. The object values are constrained by a rule base defining a number of relationships between the objects or the object values. The method uses at least one interruptable algorithm adapted to deduce knowledge about the undetermined object values. This knowledge indicates whether a user selection of a part of or all of the individual undetermined object values are possible or not. The algorithm(s) includes at least one readout point.

Abstract: This invention relates to a method of configuring a set of objects in a computer, each object having at least one possible value, each value being determined or undetermined, and at least one of said object values being accessible to a user for assigning at least one value to be determined or undetermined, said values being constrained by a rule base defining a number of relationships between the values. The undetermined object values are searched in order to find at least one first subset of values, said first subset and a subset of determined values defining at least one first possible configuration of object values satisfying the rule base if said first subset exists, said search being initiated when at least one value of an object is changed or said search being initiated upon a user request.

Abstract: An object-relational mapping tool that can process views is provided. In processing views, the object-relational mapping tool identifies the dependency relationship between the various views and tables and allows the programmer to customize the mapping that will occur by selectively determining which tables and views get mapped. This customization allows the mapping tool to map an individual table or view or to map (1) all tables and views, (2) all tables only, and (3) tables and views for which there are no dependencies. Also, the mapping tool allows the programmer to view and set the updatability of a particular view or table.