US20010007104A1 - Method and apparatus for coupling object state and behavior in a database management system - Google Patents
Method and apparatus for coupling object state and behavior in a database management system Download PDFInfo
- Publication number
- US20010007104A1 US20010007104A1 US09/757,388 US75738801A US2001007104A1 US 20010007104 A1 US20010007104 A1 US 20010007104A1 US 75738801 A US75738801 A US 75738801A US 2001007104 A1 US2001007104 A1 US 2001007104A1
- Authority
- US
- United States
- Prior art keywords
- dbms
- state
- behavior
- relations
- computer
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Abandoned
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/289—Object oriented databases
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99932—Access augmentation or optimizing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99944—Object-oriented database structure
Definitions
- This invention relates the coupling of state and behavior of an object in a DBMS and in application programs that access the DBMS.
- DBMSs Database Management Systems
- An object-oriented environment a software application uses a module or entity referred to as an object.
- An object is comprised of both state and behavior.
- An object's state is determined by the set of values an object carries for a set of properties or variables.
- a property can be an attribute of the object or a relation between the object and one or more other objects.
- Behavior is defined by the set of operations that can be performed with the object. Each operation is implemented in a routine that is referred to as a method.
- An object can include a plurality of methods.
- An operation is performed by invoking one of the object's methods.
- a method invocation usually occurs as a result of a message sent to an object by another object.
- the message identifies the method, or operation, that is to be performed.
- the message may contain a plurality of properties or arguments that are used by the method.
- a DBMS only manages an object's state.
- an application needs an object, it can only retrieve the object's state from the DBMS.
- the object's method(s) must be retrieved from another source such as a class library, for example.
- An attribute of an object can be set in a variety of ways.
- One way is by retrieving information stored in a database management system (DBMS) into a property of the object.
- DBMS database management system
- a relational DBMS stores information in a table or relation.
- a table consists of a set of rows and columns.
- a column defines a field in a row.
- a row is collection of fields that represents one instance or record of data.
- the following provides an example of an Employee table for storing employee information: First Middle Last Name Name Name EmployeeID Salary Manager Level Peter Thomas Smith 345789 $50,000 804356 P4
- the Employee table contains a single row (a table can contain multiple rows, however) that is comprised of seven columns or fields (i.e., First Name, Middle Name, Last Name, EmployeeID, Salary, Manager, and Level).
- the data stored in the Employee table can be retrieved and used by an application.
- a data manipulation language (DML) is used to formulate a query to retrieve the data. For example, a query can be used to retrieve the row of the Employee table illustrated above.
- DML data manipulation language
- the DBMS uses tables to store schema data, or metadata.
- Metadata contains information that describes the structure of the data stored in the DBMS. For example, metadata identifies the tables contained in the DBMS and the columns in each table. Metadata is defined using a data definition language (DDL).
- DDL data definition language
- the metadata may include a Tables relation to define each table in the DBMS.
- the following provides an example of the Tables relation that contains a record for the Employee table: Name Number of Columns Employee 7
- the Tables relation contains a record for each table in the DBMS.
- Each record contains two columns: Name and Number of Columns.
- the Name field identifies the name of a table and the Number of Columns field defines the number of columns in the table defined by the record.
- the metadata may contain a columnName table that identifies all of the columns defined in a table in the DBMS.
- the following provides an example of an entry in the columnName table for the First Name column in the Employee table: Name Table Name Column No. Column Type Length First Name Employee 1 char 20
- Each column in a table has a record in the columnName table.
- Each record in the columnName table has fields that further define the associated column.
- the columnName table may include Name, Table Name, Column No., Column Type and Length columns or fields.
- the columnName table contains a record that defines the First Name column as the first column in the Employee table and having a length of twenty characters.
- a relational DBMS uses stored procedures implemented in a special language (e.g., Oracle's PL/SQL) that execute safely in the database server environment and that can be invoked using queries.
- a special language e.g., Oracle's PL/SQL
- the stored procedures that run in a relational DBMS environment do not provide mechanisms to dynamically distribute the procedures to clients so that they can execute at the client.
- the logic implemented by a stored procedure in the DBMS must be duplicated at the client. This duplication requires additional development costs. Further, any modifications or upgrades must be ported to each storage site thereby duplicating development efforts and increasing costs.
- an object-oriented DBMS stores an object's state on disk.
- An OODBMS typically uses a library implementation to retrieve an object.
- An OODBMS stores an object's state on disk and maps it into programming language objects. The state is mapped into the object such that the state can be retrieved from the DBMS and stored in the object's attributes when the object is instantiated.
- the object's class is defined in a compiled library that includes the object's behavior.
- the library is linked into the program from compiled libraries (typically written in C++) and used at run time to define the object's behavior.
- FIG. 2 provides an illustration of object retrieval using an OODBMS.
- DBMS 200 consists of schema 202 and data 206 .
- DBMS 200 is an OODBMS.
- Schema 202 comprises the metadata that defines the structure for data 206 .
- Data 206 contains application data such as that stored in the Employee table illustrated above.
- DBMS 200 does not store both state and behavior information such that the behavior can be retrieved into a client environment.
- DBMS 200 may encode behavior as stored procedures that execute in the DBMS engine.
- DBMS 200 stores only state information that can be retrieved into the client environment.
- Object 208 includes both state and behavior. However, because DBMS 200 does not store both state and behavior, the state and behavior of object 208 must be retrieved from different sources. DBMS 200 contains state information for object 208 . The state information for object 208 is stored in data 206 . Library 204 contains the behavior of object 208 as well as a class definition for object 208 . When object 208 is instantiated, an instance of its class as defined in library 204 is created. The state of object 208 is then set by retrieving the state information stored in data 206 into properties of object 208 .
- DBMS 200 uses a DML to maintain the information stored in data 206 .
- DML can be used to express select, update, insert and delete operations on tables in a DBMS.
- the DML primarily used by DBMS's is Structured Query Language (SQL). SQL is used to perform operations on data 206 .
- SQL Structured Query Language
- SQL3 A new version of SQL referred to as “SQL3” is currently being defined by the ANSI X3H2 “SQL3” Committee that provides “object-relational” extensions to the existing SQL language.
- the SQL3 implementations are designed to store object attributes and metadata describing the object types in the database. However, these implementations do not provide the ability to couple behavior with state such that a retrieval operation can yield both state and behavior from the same source using the same operation.
- a method and apparatus for coupling object state and behavior in a DBMS is provided such that an object's class definition, behavior information, and state information are included in and managed by the DBMS.
- An object is replicated by retrieving the object's class definition, state information, and behavior information from the DBMS.
- an object can be stored in the DBMS by storing its class definition along with its state and behavior information in the DBMS.
- the behavior information stored in the DBMS can be used within and without the DBMS server environment.
- Behavior information is preferably defined using a programming language that is secure, portable, and interoperable.
- the security characteristic ensures the integrity of the behavior implemented by the language. Portability and interoperability allow the behavior to be ported to any computing environment without modification.
- An example of such a language is Java.
- Other languages that may be used include PL/SQL and SQL/PSM.
- JAVA extensions that compile to JAVA source or JAVA byte codes are candidate languages.
- a schema coupled to a DBMS server is used to store class and behavior definitions for an object.
- a state portion of the DBMS stores a state definition for the object.
- a client process having a mechanism for initiating behavior i.e., a behavior initiator
- the mechanism is a language interpreter or a just-in-time (JIT) compiler, for example.
- JIT just-in-time
- An object manager can be used to manage object references, determine when behavior is out-of-date, and determine when updates are propagated to the DBMS.
- a client can be local or remote to the DBMS server.
- a client can be connected to the DBMS server via a local area network (LAN).
- the client can be linked to the server via the Internet or World Wide Web. That is, the invention can be used to distribute an object's state and behavior to a client via the Internet or World Wide Web (WWW).
- WWW World Wide Web
- a client can use the Internet or WWW to transmit a request to invoke a method of an object stored in the DBMS server environment.
- FIG. 1 provides an example of a general purpose computer to be used in accordance with embodiments of the present invention.
- FIG. 2 provides an illustration of object retrieval using a DBMS.
- FIG. 3 provides an example of object retrieval according to one embodiment of the present invention.
- FIG. 4 provides an example of retrieval relations having state and behavior information according to one embodiment of the present invention.
- FIGS. 5 A- 5 B provide a process flow using a relational DBMS according to one embodiment of the present invention.
- the present invention can be implemented on a general purpose computer such as illustrated in FIG. 1.
- a keyboard 110 and mouse 111 are coupled to a bi-directional system bus 118 .
- the keyboard and mouse are for introducing user input to the computer system and communicating that user input to CPU 113 .
- the computer system of FIG. 1 also includes a video memory 114 , main memory 115 and mass storage 112 , all coupled to bi-directional system bus 118 along with keyboard 110 , mouse 111 and CPU 113 .
- the mass storage 112 may include both fixed and removable media, such as magnetic, optical or magnetic optical storage systems or any other available mass storage technology.
- Bus 118 may contain, for example, 32 address lines for addressing video memory 114 or main memory 115 .
- the system bus 118 also includes, for example, a 32-bit DATA bus for transferring DATA between and among the components, such as CPU 113 , main memory 115 , video memory 114 and mass storage 112 .
- a 32-bit DATA bus for transferring DATA between and among the components, such as CPU 113 , main memory 115 , video memory 114 and mass storage 112 .
- multiplex DATA/address lines may be used instead of separate DATA and address lines.
- the CPU 113 is a 32-bit microprocessor manufactured by Motorola, such as the 680 ⁇ 0 processor, a 80 ⁇ 86 microprocessor manufactured by Intel, or a SPARC microprocessor. However, any other suitable microprocessor or microcomputer may be utilized.
- Main memory 115 is comprised of dynamic random access memory (DRAM).
- Video memory 114 is a dual-ported video random access memory. One port of the video memory 114 is coupled to video amplifier 116 .
- the video amplifier 116 is used to drive the cathode ray tube (CRT) raster monitor 117 .
- Video amplifier 116 is well known in the art and may be implemented by any suitable means. This circuitry converts pixel DATA stored in video memory 114 to a raster signal suitable for use by monitor 117 .
- Monitor 117 is a type of monitor suitable for displaying graphic images.
- DBMS server may not necessarily have a monitor, keyboard and mouse.
- the present invention may be implemented in any type of computer system or programming or processing environment.
- a general purpose computer system such as the one described executes the processes and process flows described herein, it is configured to couple object state and behavior in a DBMS.
- An object's state and behavior is tightly coupled thereby providing a current and complete object definition that can be retrieved from the same source. Further, an object's definition is stored in one logical database (e.g., one or more databases) thereby minimizing retrieval and maintenance operations. In the preferred embodiment, an object's definition is stored as data in the DBMS. That is, both the state and behavior of an object are stored reliably in the DBMS. A modification to an object's state and behavior can be made to one logical database within a single transaction. Further, when an object is replicated (in a client process, for example), both its state and behavior definition can be retrieved from a single location (i.e., the DBMS).
- FIG. 3 provides an example of object retrieval according to one embodiment of the present invention.
- DBMS server 300 includes object definition 314 .
- Object definition 314 includes behavior 304 and state 306 .
- Client process 310 is executing and generates request 312 .
- Request 312 can be a request for object 308 , for example.
- DBMS server 300 accesses object definition 314 to retrieve object 308 .
- Object definition 314 includes state and behavior information that is used to satisfy request 312 .
- Behavior 304 and state 306 can be stored in any manner used by DBMS server 300 .
- behavior 304 is stored as part of the schema, or metadata, along with a object class definition for object 308 .
- DBMS server 300 retrieves object state 326 from state 306 and behavior 324 from behavior 314 and returns object 308 .
- object request 312 from client process 310 is satisfied from a single logical source. There is no need for client process 310 to access a separate class library to retrieve the behavior and class definition for object 308 .
- the storage technique used to retain state 306 and behavior 314 depends on the type of DBMS.
- behavior 304 and state 306 can be stored in one table or multiple, related tables.
- FIG. 4 provides an example of relations having state and behavior information according to one embodiment of the present invention.
- DBMS server 402 includes schema 400 and data 406 .
- Schema 400 defines the structure of the DBMS.
- Schema 400 further includes relation 404 .
- Relation 404 is illustrated as a single table. However, relation 404 can consist of multiple tables.
- Relation 404 contains an object class definition and behavior for objects 414 - 416 .
- An object class definition typically consists of a type and attribute declarations.
- Relation 404 further includes the methods associated with the object class definition.
- relation 404 defines an Employee object class and behavior 410 for the Employee object.
- behavior 410 consists of the promote, giveRaise, transfer, fire and getManager methods.
- DBMS server 402 further includes data 406 .
- Data 406 stores state information to populate attributes of an instance of the Employee object class.
- Data 406 includes Employee table 412 that contains state information 408 that can be used to populate attributes of the Employee object.
- State 408 contains employee attribute information such as: First Name, Middle Name, Last Name, Employee ID, Salary, Manager, and Level.
- DBMS server 402 retrieves the state information 408 from Employee table 412 .
- a single table is used to retain state information. However, it should be apparent that multiple tables can be used to store state information.
- State 408 and behavior 410 are coupled together to create an Employee object instance from the Employee object definition.
- Examples, of Employee object instances are objects 414 and 416 .
- Object 414 is created in response to a request generated by client process 424 .
- Object 416 is generated in response to a request by client process 426 .
- Client processes 424 and 426 reside in client environment 422 .
- Client environment 422 can consist of multiple systems.
- Client processes 424 and 426 can reside on the same or different systems.
- client processes 424 and 426 reside on different systems, each would access a separate class library to retrieve a behavior definition for objects 414 and 416 , respectively. It is necessary when using this prior art approach to attempt to synchronize the object definitions stored at each site.
- client processes 424 and 426 can access the same location to retrieve state and behavior information using the present invention. Thus, synchronization of state and behavior information is ensured using the present invention.
- the present invention facilitates the passing of objects in a distributed object environment such as NEO.
- NEO is a development environment and runtime system for developing and deploying distributed objects on a Common Object Request Broker Architecture (CORBA) infrastructure.
- CORBA Common Object Request Broker Architecture
- an object can be replicated and passed by retrieving the object definition (i.e., state and behavior) from DBMS server 402 .
- Behavior 410 can be of any form capable of being stored in the DBMS.
- behavior 410 is implemented such that it is secure, portable and interoperable.
- DBMS administrators are reluctant to allow user-written code to execute within the DBMS engine unless it is “safe”. Similar considerations apply to application programs that download code from a server to be executed on the client (e.g., a web browser).
- a secure implementation reduces the potential for viruses that might compromise the DBMS server or the client environment.
- a portable implementation permits behavior 410 to run in any standard computing environment and platform without modification. Being interoperable, behavior 410 can be stored in a form that can be sent directly to another computing environment without translation.
- Java provides the ability to translate a source definition into a series of bytes referred to as byte codes that can run in any standard computing environment without any translation.
- Java provides a source checking mechanism that disables execution if the source of the code is not known.
- PL/SQL or ANSI SQL/PSM can be used as the source for defining behavior 410 .
- the PL/SQL and ANSI SQL/PSM source is then compiled into Java byte codes. It should be apparent that any language that preferably includes the characteristics of security, portability and interoperability can be used to implement behavior 410 .
- a mechanism must be provided for invoking the methods applied to a retrieved object on the client. That is, for example, a mechanism must be provided for invoking behavior 410 of object 414 on client process 424 . This can be achieved by providing an interpreter or a just in time (JIT) compiler on client 424 to execute behavior 410 . When object 414 receives a message to invoke the giveRaise behavior of behavior 410 , an interpreter or JIT compiler is used to execute the giveRaise behavior. The mechanism for invoking or initiating the behavior can be bundled with or separate from the operating system.
- An object cache mechanism is preferably used in both the client and server environments (e.g., client environment 422 and DBMS server 402 , respectively).
- An object manager maintains the references to other objects and determines when updates are propagated to the DBMS.
- the particular object cache mechanism that is used is dependent on the client programming language as well as the method implementation language.
- An embedded SQL preprocessor could be used to assist in making the method implementation language suitable for expressing methods that follow object references and that affect other objects.
- An object manager can further determine when behavior is out-of-date. For example, a time stamp can be used that identifies when an object's behavior that is stored at the DBMS server was last changed. Every time an object is retrieved from the DBMS server, the time stamp can be examined to determine whether the version of the behavior that is stored in the client is out-of-date, for example. If so, the changes can be propagated to the client.
- a time stamp can be used that identifies when an object's behavior that is stored at the DBMS server was last changed. Every time an object is retrieved from the DBMS server, the time stamp can be examined to determine whether the version of the behavior that is stored in the client is out-of-date, for example. If so, the changes can be propagated to the client.
- the present invention can be implemented using a relational DBMS.
- a relational DBMS can be implemented in other environments.
- an object-oriented DBMS can be used.
- FIGS. 5 A- 5 B provide a process flow using a relational DBMS according to one embodiment of the present invention.
- a schema, or metadata, and data relations are created in the relational DBMS.
- an executable form of object behavior is created. For example, source code that defines a method of an object is compiled to create an executable form. The source code is, for example, written in the Java programming language. Java byte codes are generated from the Java source.
- the object state is stored in data relations of the relational DBMS.
- a class definition and behavior associated with an object are stored in the DBMS' schema relations.
- a determination is made whether the DBMS server has received a request for the object. If a request is not identified, the DBMS server can perform whatever other processing is needed.
- processing continues step 512 to process the object request.
- the object's state is retrieved from the DBMS' data relation(s).
- step 514 i.e., “have behavior?”
- a determination is made whether the behavior for that class of object has already been retrieved. If not, processing continues at step 516 wherein the object behavior and class definition are retrieved from the schema relation(s).
- step 518 After the retrieval operation is performed at step 516 , or if it is determined that the object's behavior has already been retrieved, processing continues at step 518 .
- the new object instance having both state and behavior is provided to the requester, or client.
- the object is thereby activated in the client environment. For example, the state and behavior are copied into executable address space (e.g., a client process) to allow execution of the object's behavior on the object's state.
- executable address space e.g., a client process
- the object instance retrieved from the DBMS server includes properties initialized with state information stored in the DBMS.
- the object instance includes behavior or methods that can be invoked on the client.
- a method of the object is invoked using a behavior interpreter or JIT compiler, for example.
- FIGS. 5 A- 5 B describe an embodiment whereby an object is activated at a client.
- the invention can also be used to activate an object within the DBMS server.
- FIGS. 5 A- 5 B can modified to illustrate the activation of an object's state and behavior in the DBMS server environment.
- Steps 502 - 508 function in the manner described above.
- an object's state and behavior can be created and stored in the DBMS server environment regardless of whether the object is to be activated in the client or the DBMS environment.
- a determination is made whether a request is being made for activation of an object in the DBMS server environment.
- the object emp is retrieved and the behavior emp.getManager is invoked to obtain the manager object in the DBMS server.
- the DBMS server determines that the emp object is to be retrieved as a result of the client request, for example, processing continues at step 512 .
- the object state (e.g., for the emp object) is retrieved from the data relations stored at the DBMS server.
- an object's behavior could have previously been retrieved from the DBMS. If not, however, the object's behavior is retrieved at step 516 .
- the object (with its state and behavior) is activated in the DBMS server environment (e.g., copied to executable address space in the DBMS server environment).
- the method, or behavior (e.g., getManager) is invoked in the DBMS server environment.
- the object is activated in the DBMS server environment or the client environment, the object (state and behavior) is retrieved from the same source, the DBMS server. There is no need to store an object's state and behavior differently (or in a different location) depending on the environment in which it is activated.
- an object's state and behavior can be retrieved from one store (e.g., the DBMS server) using the present invention. State and behavior can therefore be retrieved in a single step, or transaction. Retrieval can be performed using one or more select statements in a single transaction, for example. That is, a single transaction can be used to retrieve the state and the behavior stored in the DBMS server.
- a transaction is a mechanism used in a DBMS environment whereby a sequence of database operations can be packaged together and performed as a unit.
- a transaction is said to have the properties of atomicity, consistency, isolation and durability (or ACID).
- the atomicity property ensures that all or none of the work comprising a transaction is performed. Without the atomicity property, a portion of the work contained in a transaction could be performed without performing the other.
- isolation The notion that each transaction is considered to be independent of another transaction is referred to as isolation. That is, that two concurrent transactions do not effect each other other than to the extent that they would effect each other if they were not operating concurrently.
- a transaction that has been committed and is resistant to a system crash is said to be durable.
- the consistency property is implied by the existence of the other properties and in the existence of the isolation property in particular.
- the transactional approach can also be used to manipulate an object stored in the DBMS server environment.
- the transactional approach can be used to update an object's definition (e.g., class definition, state, and/or behavior).
- An update transaction can include one or more update SQL statements to store modifications to an object (e.g., modifications to the class definition, state, and/or behavior) in the relations.
- An object can be inserted and deleted using insert and delete (respectively) statements.
- the operations can be performed as a unit, or transaction.
- the ACID properties are preserved when manipulating an object using the invention since object manipulations can be performed in the DBMS server using a single transaction. Further, when an object is manipulated from the DBMS server, the ACID properties can be enforced using the invention. Thus, the invention provides object manipulations that are more reliable and consistent than the multi-step library approach.
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A method and apparatus for coupling object state and behavior in a DBMS is provided such that an object's class definition, behavior information, and state information are included in the DBMS. An object is instantiated using an object class definition, state information, and behavior information from the DBMS. In addition, an object can be stored in the DBMS by storing its class definition along with its state and behavior information in the DBMS. The behavior information stored in the DBMS can be used within and without the DBMS environment.
Description
- 1. Field of the Invention
- This invention relates the coupling of state and behavior of an object in a DBMS and in application programs that access the DBMS.
- 2. Background Art
- Existing Database Management Systems (DBMSs) cannot guarantee full coupling of an object's state and behavior in the client environment. In an object-oriented environment, a software application uses a module or entity referred to as an object. An object is comprised of both state and behavior. An object's state is determined by the set of values an object carries for a set of properties or variables. A property can be an attribute of the object or a relation between the object and one or more other objects.
- Behavior is defined by the set of operations that can be performed with the object. Each operation is implemented in a routine that is referred to as a method. An object can include a plurality of methods. An operation is performed by invoking one of the object's methods. A method invocation usually occurs as a result of a message sent to an object by another object. The message identifies the method, or operation, that is to be performed. In addition, the message may contain a plurality of properties or arguments that are used by the method.
- In the prior art, a DBMS only manages an object's state. Thus, for example, when an application needs an object, it can only retrieve the object's state from the DBMS. The object's method(s) must be retrieved from another source such as a class library, for example.
- In addition, the introduction of user-written code in a DBMS engine can compromise the integrity of the engine and is therefore not recommended. To ensure the integrity of the DBMS, a separate implementation of the same object method used by a client is stored in the DBMS server environment. The implementation stored in the DBMS is referred to as a stored procedure. Stored procedure languages are not object-oriented programming languages. A stored procedure is not locally invokable in a client's environment and the DBMS does not use the client's object method. Thus, in the prior art, the same logic is duplicated for different environments. This results in increased development and maintenance costs, and the possibility of serious inconsistencies in object behavior.
- As more fully described below, prior art capabilities do not include an ability to store a complete object definition that can be accessed in both a DBMS server and client environment. Object definitions used in these two different environments are effectively stored in separate locations resulting in synchronization issues. In addition, each client application must incorporate all the class libraries that contain any needed functionality. The use of polymorphism (e.g., the ability to refer to different things having different forms) is greatly restricted. Thus, there is added complexity in the management of each client application. This results in additional development and maintenance costs as well as the possibility for inconsistencies.
- An attribute of an object can be set in a variety of ways. One way is by retrieving information stored in a database management system (DBMS) into a property of the object. A relational DBMS stores information in a table or relation. A table consists of a set of rows and columns. A column defines a field in a row. A row is collection of fields that represents one instance or record of data. The following provides an example of an Employee table for storing employee information:
First Middle Last Name Name Name EmployeeID Salary Manager Level Peter Thomas Smith 345789 $50,000 804356 P4 - In this example, the Employee table contains a single row (a table can contain multiple rows, however) that is comprised of seven columns or fields (i.e., First Name, Middle Name, Last Name, EmployeeID, Salary, Manager, and Level). The data stored in the Employee table can be retrieved and used by an application. A data manipulation language (DML) is used to formulate a query to retrieve the data. For example, a query can be used to retrieve the row of the Employee table illustrated above.
- In addition to storing application data, the DBMS uses tables to store schema data, or metadata. Metadata contains information that describes the structure of the data stored in the DBMS. For example, metadata identifies the tables contained in the DBMS and the columns in each table. Metadata is defined using a data definition language (DDL).
- The metadata may include a Tables relation to define each table in the DBMS. The following provides an example of the Tables relation that contains a record for the Employee table:
Name Number of Columns Employee 7 - In the above example, the Tables relation contains a record for each table in the DBMS. Each record contains two columns: Name and Number of Columns. The Name field identifies the name of a table and the Number of Columns field defines the number of columns in the table defined by the record.
- To further illustrate, the metadata may contain a columnName table that identifies all of the columns defined in a table in the DBMS. The following provides an example of an entry in the columnName table for the First Name column in the Employee table:
Name Table Name Column No. Column Type Length First Name Employee 1 char 20 - Each column in a table has a record in the columnName table. Each record in the columnName table has fields that further define the associated column. For example, the columnName table may include Name, Table Name, Column No., Column Type and Length columns or fields. In the above example, the columnName table contains a record that defines the First Name column as the first column in the Employee table and having a length of twenty characters.
- To implement logic, a relational DBMS uses stored procedures implemented in a special language (e.g., Oracle's PL/SQL) that execute safely in the database server environment and that can be invoked using queries. However, the stored procedures that run in a relational DBMS environment do not provide mechanisms to dynamically distribute the procedures to clients so that they can execute at the client. Thus, the logic implemented by a stored procedure in the DBMS must be duplicated at the client. This duplication requires additional development costs. Further, any modifications or upgrades must be ported to each storage site thereby duplicating development efforts and increasing costs.
- Like relational DBMS's, an object-oriented DBMS (OODBMS) stores an object's state on disk. An OODBMS typically uses a library implementation to retrieve an object. An OODBMS stores an object's state on disk and maps it into programming language objects. The state is mapped into the object such that the state can be retrieved from the DBMS and stored in the object's attributes when the object is instantiated. The object's class is defined in a compiled library that includes the object's behavior. The library is linked into the program from compiled libraries (typically written in C++) and used at run time to define the object's behavior. It is up to the database designer to distribute the class libraries to the client systems and keep these libraries up-to-date with the methods and objects stored in the database, if any. A database designer must distribute the class libraries to client systems and ensure that they remain current and synchronized across multiple sites with the state definition contained in the DBMS.
- FIG. 2 provides an illustration of object retrieval using an OODBMS.
DBMS 200 consists ofschema 202 anddata 206.DBMS 200 is an OODBMS.Schema 202 comprises the metadata that defines the structure fordata 206.Data 206 contains application data such as that stored in the Employee table illustrated above.DBMS 200 does not store both state and behavior information such that the behavior can be retrieved into a client environment.DBMS 200 may encode behavior as stored procedures that execute in the DBMS engine.DBMS 200 stores only state information that can be retrieved into the client environment. -
Object 208 includes both state and behavior. However, becauseDBMS 200 does not store both state and behavior, the state and behavior ofobject 208 must be retrieved from different sources.DBMS 200 contains state information forobject 208. The state information forobject 208 is stored indata 206.Library 204 contains the behavior ofobject 208 as well as a class definition forobject 208. Whenobject 208 is instantiated, an instance of its class as defined inlibrary 204 is created. The state ofobject 208 is then set by retrieving the state information stored indata 206 into properties ofobject 208. - It is not possible to couple both state and behavior information for an object retrieved into a client from a relational DBMS. This results in the need to obtain an object's definition by accessing multiple sources. The DBMS server and its clients access separate sources to obtain behavior information. This raises synchronization and consistency issues between the DBMS server and the client. The synchronization issue is magnified when multiple clients are accessing different class libraries for the same class definition.
- Referring to FIG. 2,
DBMS 200 uses a DML to maintain the information stored indata 206. For example, SQL can be used to express select, update, insert and delete operations on tables in a DBMS. The DML primarily used by DBMS's is Structured Query Language (SQL). SQL is used to perform operations ondata 206. - A new version of SQL referred to as “SQL3” is currently being defined by the ANSI X3H2 “SQL3” Committee that provides “object-relational” extensions to the existing SQL language. The SQL3 implementations are designed to store object attributes and metadata describing the object types in the database. However, these implementations do not provide the ability to couple behavior with state such that a retrieval operation can yield both state and behavior from the same source using the same operation.
- A method and apparatus for coupling object state and behavior in a DBMS is provided such that an object's class definition, behavior information, and state information are included in and managed by the DBMS. An object is replicated by retrieving the object's class definition, state information, and behavior information from the DBMS. In addition to retrieval, an object can be stored in the DBMS by storing its class definition along with its state and behavior information in the DBMS. The behavior information stored in the DBMS can be used within and without the DBMS server environment.
- Behavior information is preferably defined using a programming language that is secure, portable, and interoperable. The security characteristic ensures the integrity of the behavior implemented by the language. Portability and interoperability allow the behavior to be ported to any computing environment without modification. An example of such a language is Java. Other languages that may be used include PL/SQL and SQL/PSM. In addition, JAVA extensions that compile to JAVA source or JAVA byte codes are candidate languages.
- A schema coupled to a DBMS server is used to store class and behavior definitions for an object. A state portion of the DBMS stores a state definition for the object. A client process having a mechanism for initiating behavior (i.e., a behavior initiator) accesses the DBMS server to obtain an object having both state and behavior. Once retrieved, the mechanism is used to invoke the object's behavior. The mechanism is a language interpreter or a just-in-time (JIT) compiler, for example. An object manager can be used to manage object references, determine when behavior is out-of-date, and determine when updates are propagated to the DBMS.
- A client can be local or remote to the DBMS server. For example, a client can be connected to the DBMS server via a local area network (LAN). In addition, the client can be linked to the server via the Internet or World Wide Web. That is, the invention can be used to distribute an object's state and behavior to a client via the Internet or World Wide Web (WWW). In addition, a client can use the Internet or WWW to transmit a request to invoke a method of an object stored in the DBMS server environment.
- FIG. 1 provides an example of a general purpose computer to be used in accordance with embodiments of the present invention.
- FIG. 2 provides an illustration of object retrieval using a DBMS.
- FIG. 3 provides an example of object retrieval according to one embodiment of the present invention.
- FIG. 4 provides an example of retrieval relations having state and behavior information according to one embodiment of the present invention.
- FIGS.5A-5B provide a process flow using a relational DBMS according to one embodiment of the present invention.
- A method and apparatus for coupling object state and behavior in a DBMS is described. In the following description, numerous specific details are set forth in order to provide a more thorough description of the present invention. It will be apparent, however, to one skilled in the art, that the present invention may be practiced without these specific details. In other instances, well-known features have not been described in detail so as not to obscure the invention.
- The present invention can be implemented on a general purpose computer such as illustrated in FIG. 1. A
keyboard 110 andmouse 111 are coupled to abi-directional system bus 118. The keyboard and mouse are for introducing user input to the computer system and communicating that user input toCPU 113. The computer system of FIG. 1 also includes avideo memory 114,main memory 115 andmass storage 112, all coupled tobi-directional system bus 118 along withkeyboard 110,mouse 111 andCPU 113. Themass storage 112 may include both fixed and removable media, such as magnetic, optical or magnetic optical storage systems or any other available mass storage technology.Bus 118 may contain, for example, 32 address lines for addressingvideo memory 114 ormain memory 115. Thesystem bus 118 also includes, for example, a 32-bit DATA bus for transferring DATA between and among the components, such asCPU 113,main memory 115,video memory 114 andmass storage 112. Alternatively, multiplex DATA/address lines may be used instead of separate DATA and address lines. - In the preferred embodiment of this invention, the
CPU 113 is a 32-bit microprocessor manufactured by Motorola, such as the 680×0 processor, a 80×86 microprocessor manufactured by Intel, or a SPARC microprocessor. However, any other suitable microprocessor or microcomputer may be utilized.Main memory 115 is comprised of dynamic random access memory (DRAM).Video memory 114 is a dual-ported video random access memory. One port of thevideo memory 114 is coupled tovideo amplifier 116. Thevideo amplifier 116 is used to drive the cathode ray tube (CRT)raster monitor 117.Video amplifier 116 is well known in the art and may be implemented by any suitable means. This circuitry converts pixel DATA stored invideo memory 114 to a raster signal suitable for use bymonitor 117.Monitor 117 is a type of monitor suitable for displaying graphic images. - The computer system described above is for purposes of example only. For example, a DBMS server may not necessarily have a monitor, keyboard and mouse. The present invention may be implemented in any type of computer system or programming or processing environment. When a general purpose computer system such as the one described executes the processes and process flows described herein, it is configured to couple object state and behavior in a DBMS.
- An object's state and behavior is tightly coupled thereby providing a current and complete object definition that can be retrieved from the same source. Further, an object's definition is stored in one logical database (e.g., one or more databases) thereby minimizing retrieval and maintenance operations. In the preferred embodiment, an object's definition is stored as data in the DBMS. That is, both the state and behavior of an object are stored reliably in the DBMS. A modification to an object's state and behavior can be made to one logical database within a single transaction. Further, when an object is replicated (in a client process, for example), both its state and behavior definition can be retrieved from a single location (i.e., the DBMS). FIG. 3 provides an example of object retrieval according to one embodiment of the present invention.
-
DBMS server 300 includes object definition 314. Object definition 314 includesbehavior 304 and state 306.Client process 310 is executing and generatesrequest 312. Request 312 can be a request forobject 308, for example. Whenobject request 312 is received byDBMS server 300,DBMS server 300 accesses object definition 314 to retrieveobject 308. - Object definition314 includes state and behavior information that is used to satisfy
request 312.Behavior 304 and state 306 can be stored in any manner used byDBMS server 300. Preferably,behavior 304 is stored as part of the schema, or metadata, along with a object class definition forobject 308.DBMS server 300 retrieves objectstate 326 from state 306 andbehavior 324 from behavior 314 and returns object 308. Thus,object request 312 fromclient process 310 is satisfied from a single logical source. There is no need forclient process 310 to access a separate class library to retrieve the behavior and class definition forobject 308. - The storage technique used to retain state306 and behavior 314 depends on the type of DBMS. For example, in a relational DBMS,
behavior 304 and state 306 can be stored in one table or multiple, related tables. FIG. 4 provides an example of relations having state and behavior information according to one embodiment of the present invention. -
DBMS server 402 includesschema 400 anddata 406.Schema 400 defines the structure of the DBMS.Schema 400 further includesrelation 404.Relation 404 is illustrated as a single table. However,relation 404 can consist of multiple tables.Relation 404 contains an object class definition and behavior for objects 414-416. An object class definition typically consists of a type and attribute declarations.Relation 404 further includes the methods associated with the object class definition. For example,relation 404 defines an Employee object class andbehavior 410 for the Employee object. In this example,behavior 410 consists of the promote, giveRaise, transfer, fire and getManager methods. -
DBMS server 402 further includesdata 406.Data 406 stores state information to populate attributes of an instance of the Employee object class.Data 406 includes Employee table 412 that containsstate information 408 that can be used to populate attributes of the Employee object.State 408 contains employee attribute information such as: First Name, Middle Name, Last Name, Employee ID, Salary, Manager, and Level.DBMS server 402 retrieves thestate information 408 from Employee table 412. In this example, a single table is used to retain state information. However, it should be apparent that multiple tables can be used to store state information. -
State 408 andbehavior 410 are coupled together to create an Employee object instance from the Employee object definition. Examples, of Employee object instances areobjects Object 414 is created in response to a request generated byclient process 424.Object 416 is generated in response to a request byclient process 426. Client processes 424 and 426 reside inclient environment 422. -
Client environment 422 can consist of multiple systems. Client processes 424 and 426 can reside on the same or different systems. In the prior art, it would be necessary to either store a class library at each system inclient environment 422, or to allow access to a shared library via a file server. In the latter case, the library is outside the DMBS' control. In the former case, client processes 424 and 426 reside on different systems, each would access a separate class library to retrieve a behavior definition forobjects - Further, the present invention facilitates the passing of objects in a distributed object environment such as NEO. NEO is a development environment and runtime system for developing and deploying distributed objects on a Common Object Request Broker Architecture (CORBA) infrastructure. There are two distinct ways to pass around objects stored in a database: (1) by reference (e.g., CORBA objRefs), or (2) via object replication. Using the present invention, an object can be replicated and passed by retrieving the object definition (i.e., state and behavior) from
DBMS server 402. -
Behavior 410 can be of any form capable of being stored in the DBMS. Preferablybehavior 410 is implemented such that it is secure, portable and interoperable. DBMS administrators are reluctant to allow user-written code to execute within the DBMS engine unless it is “safe”. Similar considerations apply to application programs that download code from a server to be executed on the client (e.g., a web browser). A secure implementation reduces the potential for viruses that might compromise the DBMS server or the client environment. - A portable implementation permits
behavior 410 to run in any standard computing environment and platform without modification. Being interoperable,behavior 410 can be stored in a form that can be sent directly to another computing environment without translation. - An implementation having the characteristics of security, portability and interoperability can be achieved using a programming language such as Java. Java provides the ability to translate a source definition into a series of bytes referred to as byte codes that can run in any standard computing environment without any translation. In addition, Java provides a source checking mechanism that disables execution if the source of the code is not known.
- Alternatively, another language such as PL/SQL or ANSI SQL/PSM can be used as the source for defining
behavior 410. The PL/SQL and ANSI SQL/PSM source is then compiled into Java byte codes. It should be apparent that any language that preferably includes the characteristics of security, portability and interoperability can be used to implementbehavior 410. - A mechanism must be provided for invoking the methods applied to a retrieved object on the client. That is, for example, a mechanism must be provided for invoking
behavior 410 ofobject 414 onclient process 424. This can be achieved by providing an interpreter or a just in time (JIT) compiler onclient 424 to executebehavior 410. Whenobject 414 receives a message to invoke the giveRaise behavior ofbehavior 410, an interpreter or JIT compiler is used to execute the giveRaise behavior. The mechanism for invoking or initiating the behavior can be bundled with or separate from the operating system. - An object cache mechanism, or object manager, is preferably used in both the client and server environments (e.g.,
client environment 422 andDBMS server 402, respectively). An object manager maintains the references to other objects and determines when updates are propagated to the DBMS. The particular object cache mechanism that is used is dependent on the client programming language as well as the method implementation language. An embedded SQL preprocessor could be used to assist in making the method implementation language suitable for expressing methods that follow object references and that affect other objects. - An object manager can further determine when behavior is out-of-date. For example, a time stamp can be used that identifies when an object's behavior that is stored at the DBMS server was last changed. Every time an object is retrieved from the DBMS server, the time stamp can be examined to determine whether the version of the behavior that is stored in the client is out-of-date, for example. If so, the changes can be propagated to the client.
- As previously illustrated, the present invention can be implemented using a relational DBMS. However, it should be apparent to one skilled in the art that the present invention can be implemented in other environments. For example, an object-oriented DBMS can be used.
- FIGS.5A-5B provide a process flow using a relational DBMS according to one embodiment of the present invention. At
step 502, a schema, or metadata, and data relations are created in the relational DBMS. Atstep 504, an executable form of object behavior is created. For example, source code that defines a method of an object is compiled to create an executable form. The source code is, for example, written in the Java programming language. Java byte codes are generated from the Java source. - At
step 506, the object state is stored in data relations of the relational DBMS. Atstep 508, a class definition and behavior associated with an object are stored in the DBMS' schema relations. At step 510 (i.e., “object request received?”), a determination is made whether the DBMS server has received a request for the object. If a request is not identified, the DBMS server can perform whatever other processing is needed. - When a request is received, processing continues
step 512 to process the object request. Atstep 512, the object's state is retrieved from the DBMS' data relation(s). At step 514 (i.e., “have behavior?”), a determination is made whether the behavior for that class of object has already been retrieved. If not, processing continues atstep 516 wherein the object behavior and class definition are retrieved from the schema relation(s). After the retrieval operation is performed atstep 516, or if it is determined that the object's behavior has already been retrieved, processing continues atstep 518. The new object instance having both state and behavior is provided to the requester, or client. The object is thereby activated in the client environment. For example, the state and behavior are copied into executable address space (e.g., a client process) to allow execution of the object's behavior on the object's state. - The object instance retrieved from the DBMS server includes properties initialized with state information stored in the DBMS. In addition, the object instance includes behavior or methods that can be invoked on the client. At
step 520, a method of the object is invoked using a behavior interpreter or JIT compiler, for example. - FIGS.5A-5B describe an embodiment whereby an object is activated at a client. The invention can also be used to activate an object within the DBMS server. FIGS. 5A-5B can modified to illustrate the activation of an object's state and behavior in the DBMS server environment.
- Steps502-508 function in the manner described above. Thus, an object's state and behavior can be created and stored in the DBMS server environment regardless of whether the object is to be activated in the client or the DBMS environment. At step 510 (i.e., object request received?”), a determination is made whether a request is being made for activation of an object in the DBMS server environment. For example, a client wishing to activate an object in the DBMS server can transmit a query to the DBMS server such as the following SQL-3 query:
SELECT emp.getManager FROM Employee emp WHERE emp.employeeID = ′764982′ - In the above example, the object emp is retrieved and the behavior emp.getManager is invoked to obtain the manager object in the DBMS server. When the DBMS server determines that the emp object is to be retrieved as a result of the client request, for example, processing continues at
step 512. Atstep 512, the object state (e.g., for the emp object) is retrieved from the data relations stored at the DBMS server. As discussed above, an object's behavior could have previously been retrieved from the DBMS. If not, however, the object's behavior is retrieved atstep 516. Atstep 518, the object (with its state and behavior) is activated in the DBMS server environment (e.g., copied to executable address space in the DBMS server environment). Atstep 520, the method, or behavior, (e.g., getManager) is invoked in the DBMS server environment. - Whether the object is activated in the DBMS server environment or the client environment, the object (state and behavior) is retrieved from the same source, the DBMS server. There is no need to store an object's state and behavior differently (or in a different location) depending on the environment in which it is activated.
- Previously, at least two separate and distinct steps were required to retrieve an object's state and behavior. In a library environment such as that used in existing object-oriented environments, the state is retrieved from the DBMS and the behavior is retrieved from a file system.
- As discussed above, an object's state and behavior can be retrieved from one store (e.g., the DBMS server) using the present invention. State and behavior can therefore be retrieved in a single step, or transaction. Retrieval can be performed using one or more select statements in a single transaction, for example. That is, a single transaction can be used to retrieve the state and the behavior stored in the DBMS server. A transaction is a mechanism used in a DBMS environment whereby a sequence of database operations can be packaged together and performed as a unit.
- A transaction is said to have the properties of atomicity, consistency, isolation and durability (or ACID). The atomicity property ensures that all or none of the work comprising a transaction is performed. Without the atomicity property, a portion of the work contained in a transaction could be performed without performing the other. The notion that each transaction is considered to be independent of another transaction is referred to as isolation. That is, that two concurrent transactions do not effect each other other than to the extent that they would effect each other if they were not operating concurrently. A transaction that has been committed and is resistant to a system crash is said to be durable. The consistency property is implied by the existence of the other properties and in the existence of the isolation property in particular.
- In addition to object retrieval, the transactional approach can also be used to manipulate an object stored in the DBMS server environment. For example, the transactional approach can be used to update an object's definition (e.g., class definition, state, and/or behavior). An update transaction can include one or more update SQL statements to store modifications to an object (e.g., modifications to the class definition, state, and/or behavior) in the relations. An object can be inserted and deleted using insert and delete (respectively) statements. The operations can be performed as a unit, or transaction.
- The ACID properties are preserved when manipulating an object using the invention since object manipulations can be performed in the DBMS server using a single transaction. Further, when an object is manipulated from the DBMS server, the ACID properties can be enforced using the invention. Thus, the invention provides object manipulations that are more reliable and consistent than the multi-step library approach.
- Thus, a method and apparatus for coupling object state and behavior in a DBMS has been described in conjunction with one or more specific embodiments. The invention is defined by the claims and their full scope of equivalents.
Claims (39)
1. A method of coupling an object's method and state stored in a Database Management System (DBMS) having one or more relations that store schema and data, said method comprising the steps of:
storing in said one or more relations in said DBMS a class definition for an object;
storing in said one or more relations in said DBMS a method of said object; and
storing in said one or more relations in said DBMS a state of said object.
2. The method of further comprising the step of:
claim 1
activating said object using said method and said state in response to a request for said object.
3. The method of wherein said step of activating is performed in a client environment.
claim 2
4. The method of wherein said step of activating is performed in a DBMS server environment.
claim 2
5. The method of wherein said step of activating further comprises the steps of:
claim 2
retrieving from said one or more relations said class definition, said method and said state of said object; and
copying said object's class definition, said method and said state into an executable address space.
6. The method of wherein said method is in the form of an executable module.
claim 1
7. The method of wherein said executable module is in the form of Java byte codes.
claim 6
8. The method of further comprising the step of:
claim 1
invoking said object.
9. The method of wherein said step of invoking occurs within said DBMS.
claim 8
10. The method of wherein said step of invoking occurs in a client process.
claim 8
11. The method of wherein said class definition and method are stored as part of a schema of said DBMS.
claim 1
12. The method of wherein said state is stored in a data portion of said DBMS.
claim 1
13. An article of manufacture comprising:
a computer usable medium having computer readable program code embodied therein for coupling an object's method and state stored in a Database Management System (DBMS) having one or more relations that store schema and data, said article of manufacture comprising:
computer readable program code configured to cause a computer to store in said one or more relations in said DBMS a class definition for an object;
computer readable program code configured to cause a computer to store in said one or more relations in said DBMS a method of said object; and
computer readable program code configured to cause a computer to store in said one or more relations in said DBMS a state of said object.
14. The article of manufacture of further comprising:
claim 13
computer readable program code configured to cause a computer to activate said object using said method and said state in response to a request for said object.
15. The article of manufacture of wherein said program code configured to cause said computer to activate is performed in a client environment.
claim 15
16. The article of manufacture of wherein said program code configured to cause said computer to activate is performed in said DBMS.
claim 13
17. The article of manufacture of wherein said program code configured to cause a computer to activate further comprises:
claim 16
computer readable program code configured to cause a computer to retrieve from said one or more relations said class definition, said method and said state of said object; and
computer readable program code configured to cause a computer to store in said DBMS said class definition and said method;
computer readable program code configured to cause a computer to copy said object's class definition, said method and said state into an executable address space.
18. The article of manufacture of wherein said method is in the form of an executable module.
claim 13
19. The article of manufacture of wherein said executable module is in the form of Java byte codes.
claim 18
20. The article of manufacture of further comprising:
claim 13
computer readable program code configured to cause a computer to invoke said object.
21. The article of manufacture of wherein said program code configured to cause a computer to invoke occurs within said DBMS.
claim 20
22. The article of manufacture of wherein said program code configured to cause a computer to invoke occurs in an application process.
claim 20
23. The article of manufacture of wherein said class definition and method are stored as part of a schema of said DBMS.
claim 13
24. The article of manufacture of wherein said state is stored in a data portion of said DBMS.
claim 13
25. The article of manufacture of wherein the computer usable medium is a computer network.
claim 13
26. A object coupling apparatus comprising:
a DBMS server;
a schema of said DBMS server having a class definition and behavior definition of an object;
a state portion of said DBMS server having a state definition for said object.
27. The apparatus of further including:
claim 26
a client coupled to said DBMS server.
28. The apparatus of further including:
claim 27
a behavior initiator coupled to said client.
29. The apparatus of wherein said behavior initiator is a interpreter.
claim 28
30. The apparatus of wherein said behavior initiator is a “just-in-time” compiler.
claim 28
31. The apparatus of further including an object manager coupled to said DBMS server and said client.
claim 27
32. A method of manipulating an object said object including state and behavior stored in one or more relations in a DBMS comprising the steps of:
performing one or more DBMS operations on said object.
33. The method of wherein said one or more DBMS operations comprise an insert operation, said step of performing further comprises the steps of:
claim 32
inserting in said one or more relations in said DBMS a class definition for said object;
inserting in said one or more relations in said DBMS state of said object; and
inserting in said one or more relations in said DBMS behavior of said object.
34. The method of wherein said one or more DBMS operations comprise an update operation, said step of performing further comprises the steps of:
claim 32
creating a modified object;
replacing said object with said modified object in said one or more relations in said DBMS.
35. The method of wherein said step of storing comprises the step of executing a plurality of update statements.
claim 34
36. The method of wherein said one or more DBMS operations comprise a delete operation, said step of performing further comprises the step of performing a plurality of delete statements to remove said object from said one or more relations.
claim 32
37. The method of wherein said one or more operations are performed as a unit.
claim 32
38. The method of wherein said one or more DBMS operations comprise a retrieve operation, said step of performing further comprising the steps of:
claim 32
retrieving from said one or more relations in said DBMS a class definition for said object;
retrieving from said one or more relations in said DBMS state of said object; and
retrieving from said one or more relations in said DBMS behavior of said object.
39. The method of wherein said steps of retrieving are performed using select statements.
claim 38
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US09/757,388 US20010007104A1 (en) | 1996-09-26 | 2001-01-08 | Method and apparatus for coupling object state and behavior in a database management system |
Applications Claiming Priority (3)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US08/720,227 US5907847A (en) | 1996-09-26 | 1996-09-26 | Method and apparatus for coupling object state and behavior in a database management system |
US09/267,714 US6173290B1 (en) | 1996-09-26 | 1999-03-11 | Method and apparatus for coupling object state and behavior in a database management system |
US09/757,388 US20010007104A1 (en) | 1996-09-26 | 2001-01-08 | Method and apparatus for coupling object state and behavior in a database management system |
Related Parent Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US09/267,714 Continuation US6173290B1 (en) | 1996-09-26 | 1999-03-11 | Method and apparatus for coupling object state and behavior in a database management system |
Publications (1)
Publication Number | Publication Date |
---|---|
US20010007104A1 true US20010007104A1 (en) | 2001-07-05 |
Family
ID=24893176
Family Applications (3)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US08/720,227 Expired - Lifetime US5907847A (en) | 1996-09-26 | 1996-09-26 | Method and apparatus for coupling object state and behavior in a database management system |
US09/267,714 Expired - Lifetime US6173290B1 (en) | 1996-09-26 | 1999-03-11 | Method and apparatus for coupling object state and behavior in a database management system |
US09/757,388 Abandoned US20010007104A1 (en) | 1996-09-26 | 2001-01-08 | Method and apparatus for coupling object state and behavior in a database management system |
Family Applications Before (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US08/720,227 Expired - Lifetime US5907847A (en) | 1996-09-26 | 1996-09-26 | Method and apparatus for coupling object state and behavior in a database management system |
US09/267,714 Expired - Lifetime US6173290B1 (en) | 1996-09-26 | 1999-03-11 | Method and apparatus for coupling object state and behavior in a database management system |
Country Status (3)
Country | Link |
---|---|
US (3) | US5907847A (en) |
EP (1) | EP0833259A3 (en) |
JP (1) | JPH113267A (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20060106864A1 (en) * | 2004-11-12 | 2006-05-18 | International Business Machines Corporation | System, computer program product and method of narrowing an enterprise Java bean (EJB) object reference to a home implementation class name |
US20060218122A1 (en) * | 2002-05-13 | 2006-09-28 | Quasm Corporation | Search and presentation engine |
US20100185601A1 (en) * | 2009-01-09 | 2010-07-22 | Phibbs Paul H | Techniques for database rule ordering and processing |
US9165078B2 (en) | 2013-03-14 | 2015-10-20 | International Business Machines Corporation | Row-based data filtering at a database level |
Families Citing this family (35)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4876295A (en) * | 1987-03-11 | 1989-10-24 | The Dow Chemical Company | Flexible thermoplastic epoxy resin and coatings prepared therefrom |
US5907847A (en) * | 1996-09-26 | 1999-05-25 | Sun Microsystems, Inc. | Method and apparatus for coupling object state and behavior in a database management system |
US5991802A (en) * | 1996-11-27 | 1999-11-23 | Microsoft Corporation | Method and system for invoking methods of objects over the internet |
GB2334353B (en) * | 1998-02-12 | 2002-08-07 | Ibm | An apparatus,method and computer program product for client/server computing with the ability to select which servers are capable of creating transaction stat |
US6105035A (en) * | 1998-02-17 | 2000-08-15 | Lucent Technologies, Inc. | Method by which notions and constructs of an object oriented programming language can be implemented using a structured query language (SQL) |
GB2335518A (en) * | 1998-03-18 | 1999-09-22 | Ibm | Triggering event causes creation of Coordinator transaction state object |
US6745203B1 (en) * | 1998-05-15 | 2004-06-01 | E.Piphany, Inc. | User interface for a distributed messaging framework |
US6636900B2 (en) * | 1998-06-29 | 2003-10-21 | Sun Microsystems, Inc. | Method and apparatus for executing distributed objects over a network |
US6304879B1 (en) | 1998-11-25 | 2001-10-16 | Microsoft Corporation | Dynamic data cache for object-oriented computing environments |
US6795968B1 (en) | 1998-11-25 | 2004-09-21 | Microsoft Corporation | Dynamic object behavior for object-oriented-computing environments |
WO2000031628A1 (en) * | 1998-11-25 | 2000-06-02 | Microsoft Corporation | Dynamic data cache for object-oriented computing environments |
US6714926B1 (en) * | 1999-02-02 | 2004-03-30 | Amazon.Com, Inc. | Use of browser cookies to store structured data |
US6473769B1 (en) | 1999-03-31 | 2002-10-29 | Microsoft Corporation | Property linking in object-oriented computing environments |
AU6361800A (en) * | 1999-07-23 | 2001-02-13 | Concorde Solutions Inc. | Computer programming object externalization |
US7019740B2 (en) | 2000-03-31 | 2006-03-28 | British Telecommunications Public Limited Company | Resource creation method and tool |
AU2001239425A1 (en) * | 2000-03-31 | 2001-10-15 | British Telecommunications Public Limited Company | Resource modelling |
US6842892B1 (en) | 2000-05-15 | 2005-01-11 | Sun Microsystems, Inc. | Automatic generation of an optimized API |
AU2000254357A1 (en) * | 2000-05-31 | 2001-12-11 | Infomakers Sweden Ab | A just-in-time information control and operator system |
US6898783B1 (en) * | 2000-08-03 | 2005-05-24 | International Business Machines Corporation | Object oriented based methodology for modeling business functionality for enabling implementation in a web based environment |
US7171455B1 (en) | 2000-08-22 | 2007-01-30 | International Business Machines Corporation | Object oriented based, business class methodology for generating quasi-static web pages at periodic intervals |
US6684388B1 (en) | 2000-08-22 | 2004-01-27 | International Business Machines Corporation | Method for generating platform independent, language specific computer code |
US6853994B1 (en) | 2000-08-30 | 2005-02-08 | International Business Machines Corporation | Object oriented based, business class methodology for performing data metric analysis |
US20030212987A1 (en) * | 2001-02-28 | 2003-11-13 | Demuth Steven J. | Client container for building EJB-hosted java applications |
US6728735B1 (en) * | 2001-03-12 | 2004-04-27 | Network Appliance, Inc. | Restartable dump that produces a consistent filesystem on tapes |
JP2005502937A (en) * | 2001-05-15 | 2005-01-27 | サイコジェニックス・インコーポレーテッド | System and method for monitoring behavioral information engineering |
US6915287B1 (en) * | 2001-12-13 | 2005-07-05 | Novell, Inc. | System, method and computer program product for migrating data from one database to another database |
US7080352B2 (en) * | 2002-01-30 | 2006-07-18 | Dloo, Incorporated | Method and system for creating programs using code having coupled syntactic and semantic relationships |
US7043721B2 (en) * | 2002-03-18 | 2006-05-09 | International Business Machines Corporation | Initial object capacity determination |
KR100654447B1 (en) * | 2004-12-15 | 2006-12-06 | 삼성전자주식회사 | Method and system for sharing and transacting contents in local area |
US7437080B2 (en) * | 2005-02-03 | 2008-10-14 | Stratalight Communications, Inc. | Optical transmission system having optimized filter wavelength offsets |
US8676746B2 (en) * | 2008-01-03 | 2014-03-18 | Microsoft Corporation | Database management system risk assessment |
US8150866B2 (en) | 2008-01-07 | 2012-04-03 | Semmle Limited | Creating concise and re-useable queries over complex data |
US9560130B2 (en) | 2010-09-30 | 2017-01-31 | Microsoft Technology Licensing, Llc | Presenting availability statuses of synchronized objects |
US8719777B2 (en) * | 2010-11-22 | 2014-05-06 | Sap Ag | Object, for object-oriented programming, with state-dependent behaviors |
US10437564B1 (en) | 2016-09-16 | 2019-10-08 | Software Tree, LLC | Object mapping and conversion system |
Family Cites Families (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
GB2253500A (en) * | 1990-08-23 | 1992-09-09 | Data General Corp | Object oriented-data bases |
US5291583A (en) * | 1990-12-14 | 1994-03-01 | Racal-Datacom, Inc. | Automatic storage of persistent ASN.1 objects in a relational schema |
US5295256A (en) * | 1990-12-14 | 1994-03-15 | Racal-Datacom, Inc. | Automatic storage of persistent objects in a relational schema |
US5566330A (en) * | 1991-08-20 | 1996-10-15 | Powersoft Corporation | Method for forming a reusable and modifiable database interface object |
DE69327448T2 (en) * | 1992-12-21 | 2004-03-04 | Sun Microsystems, Inc., Mountain View | Method and device for subtasks in a distributed processing system |
US5644764A (en) * | 1995-01-31 | 1997-07-01 | Unisys Corporation | Method for supporting object modeling in a repository |
US5790861A (en) * | 1995-07-07 | 1998-08-04 | Sun Microsystems, Inc. | Method and apparatus for generating executable code from object-oriented C++ source code |
US5907847A (en) * | 1996-09-26 | 1999-05-25 | Sun Microsystems, Inc. | Method and apparatus for coupling object state and behavior in a database management system |
-
1996
- 1996-09-26 US US08/720,227 patent/US5907847A/en not_active Expired - Lifetime
-
1997
- 1997-09-22 EP EP97307386A patent/EP0833259A3/en not_active Withdrawn
- 1997-09-26 JP JP9261530A patent/JPH113267A/en active Pending
-
1999
- 1999-03-11 US US09/267,714 patent/US6173290B1/en not_active Expired - Lifetime
-
2001
- 2001-01-08 US US09/757,388 patent/US20010007104A1/en not_active Abandoned
Cited By (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20060218122A1 (en) * | 2002-05-13 | 2006-09-28 | Quasm Corporation | Search and presentation engine |
US7680777B2 (en) * | 2002-05-13 | 2010-03-16 | Timothy Poston | Search and presentation engine |
US20100198815A1 (en) * | 2002-05-13 | 2010-08-05 | Timothy Poston | Search and presentation engine |
US8438180B2 (en) | 2002-05-13 | 2013-05-07 | Timothy Poston | Search and presentation engine |
US9690824B2 (en) | 2002-05-13 | 2017-06-27 | Q-Sensei Corp. | Methods and systems for searching a database of objects |
US10515087B2 (en) | 2002-05-13 | 2019-12-24 | Q-Sensei Corp. | Methods and systems for searching a database of objects |
US20060106864A1 (en) * | 2004-11-12 | 2006-05-18 | International Business Machines Corporation | System, computer program product and method of narrowing an enterprise Java bean (EJB) object reference to a home implementation class name |
US20100185601A1 (en) * | 2009-01-09 | 2010-07-22 | Phibbs Paul H | Techniques for database rule ordering and processing |
US8386472B2 (en) * | 2009-01-09 | 2013-02-26 | Teradata Us, Inc. | Techniques for database rule ordering and processing |
US9165078B2 (en) | 2013-03-14 | 2015-10-20 | International Business Machines Corporation | Row-based data filtering at a database level |
US9665603B2 (en) | 2013-03-14 | 2017-05-30 | International Business Machines Corporation | Row-based data filtering at a database level |
US10783198B2 (en) | 2013-03-14 | 2020-09-22 | International Business Machines Corporation | Row-based data filtering at a database level |
Also Published As
Publication number | Publication date |
---|---|
US5907847A (en) | 1999-05-25 |
JPH113267A (en) | 1999-01-06 |
EP0833259A3 (en) | 1998-04-15 |
EP0833259A2 (en) | 1998-04-01 |
US6173290B1 (en) | 2001-01-09 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US5907847A (en) | Method and apparatus for coupling object state and behavior in a database management system | |
US5542078A (en) | Object oriented data store integration environment for integration of object oriented databases and non-object oriented data facilities | |
US6240413B1 (en) | Fine-grained consistency mechanism for optimistic concurrency control using lock groups | |
US5926819A (en) | In-line triggers | |
US6374256B1 (en) | Method and apparatus for creating indexes in a relational database corresponding to classes in an object-oriented application | |
US6477540B1 (en) | Method and apparatus for using Java as a stored procedure language and as an embedded language on a client | |
US8032488B2 (en) | System using virtual replicated tables in a cluster database management system | |
US6243710B1 (en) | Methods and apparatus for efficiently splitting query execution across client and server in an object-relational mapping | |
US6192370B1 (en) | Method and system for rapid memory-resident processing of transactional data | |
US5581758A (en) | Computer program product for object specification, generation, and management in a distributed database | |
US5448727A (en) | Domain based partitioning and reclustering of relations in object-oriented relational database management systems | |
US7386568B2 (en) | Techniques for partial rewrite of XPath queries in a relational database | |
US6338056B1 (en) | Relational database extender that supports user-defined index types and user-defined search | |
EP1042721B1 (en) | Integrating both modifications to an object model and modifications to a database into source code by an object-relational mapping tool | |
US6014674A (en) | Method for maintaining log compatibility in database systems | |
US6813617B2 (en) | Dynamic generation of optimizer hints | |
US7555506B2 (en) | Partial deserialization of complex type objects | |
US7464073B2 (en) | Application of queries against incomplete schemas | |
US20030167277A1 (en) | Application program interface for network software platform | |
US7702649B1 (en) | Object-relational mapping system and method for generic relationships | |
Part | Database management systems | |
EP1040432B1 (en) | Method and apparatus for loading stored procedures in a database corresponding to object-oriented data dependencies | |
US20080040369A1 (en) | Using XML for flexible replication of complex types | |
Horowitz | An introduction to object-oriented databases and database systems | |
Bruni et al. | LOBs with DB2 for z/OS: Stronger and Faster |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
STCB | Information on status: application discontinuation |
Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION |