AUTOMATIC ENFORCEMENT OF RELATIONSHIPS IN A DATABASE SCHEMA
First Claim
Patent Images
1. A method of enforcing a database relationship, comprising:
- specifying using a markup language within a database schema a host structure and a reference type for the host structure that indicates an association between the host structure and a parent structure to which the host structure refers and specifies the relationship between the host structure and the parent structure, wherein the reference type is specified using the markup language and selected from at least a first reference type and a second reference type;
automatically generating code using a processor that enforces the relationship between the host structure and the parent structure based on the reference type specified in the database schema; and
enforcing the relationship using the automatically generated code using the processor, including;
determining whether the reference type for the host structure is of the first reference type or the second reference type; and
in the event the reference type for the host structure is of the first reference type, ensuring that an instance of the parent structure cannot be deleted when an instance of the host structure exists.
6 Assignments
0 Petitions
Accused Products
Abstract
A technique for enforcing a database relationship is disclosed. The technique includes specifying within a database schema a reference type that associates two structures and specifies the relationship between the two structures, and automatically generating code that checks the relationship between the two structures based on the specified reference in the database schema.
-
Citations
20 Claims
-
1. A method of enforcing a database relationship, comprising:
-
specifying using a markup language within a database schema a host structure and a reference type for the host structure that indicates an association between the host structure and a parent structure to which the host structure refers and specifies the relationship between the host structure and the parent structure, wherein the reference type is specified using the markup language and selected from at least a first reference type and a second reference type; automatically generating code using a processor that enforces the relationship between the host structure and the parent structure based on the reference type specified in the database schema; and enforcing the relationship using the automatically generated code using the processor, including; determining whether the reference type for the host structure is of the first reference type or the second reference type; and in the event the reference type for the host structure is of the first reference type, ensuring that an instance of the parent structure cannot be deleted when an instance of the host structure exists. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18)
-
-
19. A system for enforcing a database relationship, comprising:
-
a processor configured to; specify using a markup language within a database schema a host structure and a reference type for the host structure that indicates an association between the host structure and a parent structure to which the host structure refers and specifies the relationship between the host structure and the parent structure, wherein the reference type is specified using the markup language and selected from at least a first reference type and a second reference type; automatically generate code that enforces the relationship between the host structure and the parent structure based on the reference type specified in the database schema; and enforce the relationship using the automatically generated code, including; determine whether the reference type for the host structure is of the first reference type or the second reference type; and in the event the reference type for the host structure is of the first reference type, ensure that an instance of the parent structure cannot be deleted when an instance of the host structure exists; and a memory that is coupled with the processor, wherein the memory provides the processor with instructions.
-
-
20. A computer program product for enforcing a database relationship, the computer program product being embodied in a non-transitory computer readable storage medium and comprising computer instructions executable to:
-
specifying using a markup language within a database schema a host structure and a reference type for the host structure that indicates an association between the host structure and a parent structure to which the host structure refers and specifies the relationship between the host structure and the parent structure, wherein the reference type is specified using the markup language and selected from at least a first reference type and a second reference type; automatically generating code that enforces the relationship between the host structure and the parent structure based on the reference type specified in the database schema; enforcing the relationship using the automatically generated code, including; determining whether the reference type for the host structure is of the first reference type or the second reference type; and in the event the reference type for the host structure is of the first reference type, ensuring that an instance of the parent structure cannot be deleted when an instance of the host structure exists.
-
Specification