Relationship-based inherited attributes system
First Claim
1. A process for combining relationship-based inherited attributes in a computer environment, comprising the steps of:
- providing a table-driven relational database system, comprising an inheritance table and a relationship table,wherein said inheritance table comprises;
an inherited ID field;
an assigned object ID; and
a sequence number field, wherein said sequence number indicates the order of inheritance of the object in a hierarchy;
wherein said relationship table comprises;
a relationship ID field, wherein said relationship ID uniquely identifies said relationship;
a role; and
an assigned object ID field; and
wherein a table-driven relational database server queries said inheritance table and said relationship table and uses a link to link said inheritance table with said relationship table via a common element of a field of each table and obtains all linked objects that are associated with said link,wherein said linked objects are used to control a determinative business rule and access rule and wherein said sequence ID indicates a priority for said role,wherein a user writes at least one of said determinative business rule and said access rule having at least one configurable parameter.
10 Assignments
0 Petitions
Accused Products
Abstract
A relationship-based inherited attributes system provides an Inheritance Table where each object in the table has an Inherited Object ID. Each ID is listed with all of the ID'"'"'s that the object inherits from with sequence number that indicates the order of the inheritance in the hierarchy. A Relationship Table is provided and contains a Relationship ID, a Role, and an Assigned Object ID. To find up all of the objects participating in a certain relationship, the server looks for all the rows that have a particular relationship ID in the relationship table. The invention provides an Assignment Table where the server obtains a value by correlating the list of objects obtained from the Inheritance and Relationship tables. The value may need to be processed further and is passed to a JavaScript routine named in the table. The server refers to an Attribute Voter Table when multiple values result and conflicts arise because of this situation. The Attribute Voter Table contains Attribute ID, Role, and Sequence Number fields where the Sequence Number indicates the Role'"'"'s priority. An Attribute Definition Table is provided to resolve multiple set of roles obtained from the Attribute Voter Table down to one value or set of values. A Resolution Strategy is used to resolve conflicts that arise when the server SQL query returns a such a list of items.
43 Citations
36 Claims
-
1. A process for combining relationship-based inherited attributes in a computer environment, comprising the steps of:
-
providing a table-driven relational database system, comprising an inheritance table and a relationship table, wherein said inheritance table comprises; an inherited ID field; an assigned object ID; and a sequence number field, wherein said sequence number indicates the order of inheritance of the object in a hierarchy; wherein said relationship table comprises; a relationship ID field, wherein said relationship ID uniquely identifies said relationship; a role; and an assigned object ID field; and wherein a table-driven relational database server queries said inheritance table and said relationship table and uses a link to link said inheritance table with said relationship table via a common element of a field of each table and obtains all linked objects that are associated with said link, wherein said linked objects are used to control a determinative business rule and access rule and wherein said sequence ID indicates a priority for said role, wherein a user writes at least one of said determinative business rule and said access rule having at least one configurable parameter. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
15. An apparatus for accessing relationship-based inherited attributes in a computer environment, comprising:
-
a table-driven relational database system, comprising an inheritance table and a relationship table, wherein said inheritance table comprises; an inherited ID field; an assigned object ID; and a sequence number field, wherein said sequence number indicates the order of inheritance of the object in a hierarchy; wherein said relationship table comprises; a relationship ID field; a role; and an assigned object ID field; and wherein a table-driven relational database server queries said inheritance table and said relationship table and establishes a link between said inheritance table and said relationship table via a common element of a field of each table and obtains all linked objects that are associated with said link and wherein said sequence ID indicates a priority for said role, wherein said linked objects are used to control a determinative business rule and access rule, wherein said determinative business rule comprises use in e-commerce. - View Dependent Claims (16, 17, 18, 19, 20, 21, 22, 23, 24, 25)
-
-
26. A program storage medium readable by a computer, tangibly embodying a program of instructions executable by the computer to perform method steps that combine relationship-based inherited attributes in a computer environment, comprising the steps of:
-
providing a table-driven relational database system, comprising an inheritance table and a relationship table; wherein said inheritance table comprises; an inherited ID field; an assigned object ID; and a sequence number field, wherein said sequence number indicates the order of inheritance of the object in a hierarchy; wherein said relationship table comprises; a relationship ID field; a role; and an assigned object ID field; and wherein a table-driven relational database server queries said inheritance table and said relationship table and establishes a link between said inheritance table and said relationship table via a common element of a field of each table and obtains all linked objects that are associated with said link and wherein said sequence ID indicates a priority for said role, wherein said linked objects are used to control a determinative business rule used in e-commerce and access rule used in e-commerce. - View Dependent Claims (27, 28, 29, 30, 31, 32, 33, 34, 35)
-
-
36. A method that combines relationship-based inherited attributes in a computer environment, comprising the steps of:
-
providing a table-driven relational database system, comprising an inheritance table and a relationship table, wherein said inheritance table comprises; an inherited ID field; an assigned object ID; and a sequence number field, wherein said sequence number indicates the order of inheritance of the object in a hierarchy; and wherein said relationship table comprises; a relationship ID field; and an assigned object ID field; querying said inheritance table and said relationship table by means of a table-driven relational database server; establishing a link between said inheritance table and said relationship table via a common element of a field of each table; and obtaining linked objects that are associated with said link; and controlling determinative business rules and access rules in e-commerce using said linked objects.
-
Specification