SYSTEMS AND METHODS FOR IMPLEMENTING MANY OBJECT TO OBJECT RELATIONSHIPS IN A MULTI-TENANT ENVIRONMENT
First Claim
Patent Images
1. A method of storing relationship information for an information object in a database system, comprising:
- receiving an information object to store in a portion of a database accessible to a tenant of a plurality of tenants having access to a plurality of other portions of the database, the plurality of portions comprising a single table of the database (“
main table”
), the information object relating to at least one other information object by relationship information identifying the other information object in the database; and
storing the relationship information to an index table (“
index table”
) enabling locating information objects related to the information object received without searching the main table, once the information object is stored in the main table.
1 Assignment
0 Petitions
Accused Products
Abstract
Systems and methods for storing relationship information for an information object in a database system. Methods and mechanisms for storing relationship information for information objects enable database systems to store and retrieve data objects having an arbitrary number of relationships with one another. This ability to store and retrieve data objects by relationship(s) enables more efficient searching of database objects and removal of constraints on the number of relationships that would otherwise exist when objects are stored in a database.
-
Citations
20 Claims
-
1. A method of storing relationship information for an information object in a database system, comprising:
-
receiving an information object to store in a portion of a database accessible to a tenant of a plurality of tenants having access to a plurality of other portions of the database, the plurality of portions comprising a single table of the database (“
main table”
), the information object relating to at least one other information object by relationship information identifying the other information object in the database; andstoring the relationship information to an index table (“
index table”
) enabling locating information objects related to the information object received without searching the main table, once the information object is stored in the main table. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A machine-readable medium carrying one or more sequences of instructions for storing relationship information for an information object in a database system, which instructions, when executed by one or more processors, cause the one or more processors to carry out the steps of:
-
receiving an information object to store in a portion of a database accessible to a tenant of a plurality of tenants having access to a plurality of other portions of the database, the plurality of portions comprising a single table of the database (“
main table”
), the information object relating to at least one other information object by relationship information identifying the other information object in the database; andstoring the relationship information to an index table (“
index table”
) enabling locating information objects related to the information object received without searching the main table, once the information object is stored in the main table. - View Dependent Claims (11, 12, 13, 14, 15, 16, 17, 18)
-
-
19. An apparatus for storing relationship information for an information object in a database system, the apparatus comprising:
-
a processor; and one or more stored sequences of instructions which, when executed by the processor, cause the processor to carry out the steps of; receiving an information object to store in a portion of a database accessible to a tenant of a plurality of tenants having access to a plurality of other portions of the database, the plurality of portions comprising a single table of the database (“
main table”
), the information object relating to at least one other information object by relationship information identifying the other information object in the database; andstoring the relationship information to an index table (“
index table”
) enabling locating information objects related to the information object received without searching the main table, once the information object is stored in the main table.
-
-
20. A method for transmitting code for storing relationship information for an information object in a database system on a transmission medium, the method comprising:
-
transmitting code for receiving an information object to store in a portion of a database accessible to a tenant of a plurality of tenants having access to a plurality of other portions of the database, the plurality of portions comprising a single table of the database (“
main table”
), the information object relating to at least one other information object by relationship information identifying the other information object in the database; andtransmitting code for storing the relationship information to an index table (“
index table”
) enabling locating information objects related to the information object received without searching the main table, once the information object is stored in the main table.
-
Specification