Method and system for representing and accessing object-oriented data in a relational database system
AssigneeOracle International Corporation
InventorsUppili Srinivasan, Harpinder Madan, Sanjay Jain
Life of this patent
Estimating the term…
Abstract
A method and system for representing objects in a relational database is provided. In one aspect, the invention provides a method and system for storing directory information objects in a relational database management system. In addition, a method and system for generating a statement in a database query language to search or manipulate objects or entries that are stored in a relational database is disclosed. An aspect of the invention is directed to a method and system that can automatically generate a SQL statement for an LDAP search filter.
Claims27
A system for representing data in a relational database comprising:
- a database table comprising a plurality of rows;
- data stored in a first row of said database table;
- metadata stored in a second row of said database table, said metadata describing said data stored in stored in said first row, wherein said metadata comprises definition data for an attribute type or definition data for an object class;
- and
- a plurality of identifiers, each identifier associated with a row to indicate whether data or metadata metadata is stored in said row.
A method for representing data in a relational database comprising:
- storing data in a first row of a database table;
- storing metadata in a second row of said database table, said metadata describing said data stored in said first row, wherein said metadata comprises definition data for an attribute type or definition data for an object class;
- and
- identifying each row of said database table as a data row or a metadata row.
A method for representing data in a relational database comprising:
- storing a class and one or more attributes of said class in a database table, wherein said database table comprises a plurality of rows;
- and
- storing metadata describing all of said one or more attributes of said class in said database table, said metadata comprising definition data for said one or more attributes of said class, wherein an attribute and metadata describing said attribute are stored in different rows of said database table.
A computer program product that includes a computer-readable medium having a sequence of instructions which, when executed by a processor, causes the processor to execute a process for representing data in a relational database, the process compressing:
- storing data in a first row of a database table;
- storing metadata in a second row of said database table, said metadata describing said data stored in said first row, wherein said metadata comprises definition data for an attribute type or definition data for an object class;
- and
- identifying each row of said database table as a data row or a metadata row.
A computer program product that includes a computer-readable medium having a sequence of instructions which, when executed by a processor, causes the processor to execute a process for representing data in a relational database, the process comprising:
- storing a class and one or more attributes of said class in a database table, wherein said database table comprises a plurality of rows;
- and
- storing metadata describing all of said one or more attributes of said class in said database table, said metadata comprising definition data for said one or more attributes of said class, wherein an attribute and metadata describing said attribute are stored in different rows of said database table.
A system for representing data in a relational database, comprising:
- means for storing a class and one or more attributes of said class in a database table, wherein said database table comprises a plurality of rows;
- and
- means for storing metadata describing all of said one or more attributes of said class in said database table, said metadata comprising definition data for said one or more attributes of said class, wherein an attribute and metadata describing said attribute are stored in different rows of said database table.
Dependencies are inferred from the claim text.