发明名称 Automatic enforcement of relationships in a database schema
摘要 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.
申请公布号 US9053133(B2) 申请公布日期 2015.06.09
申请号 US201313875928 申请日期 2013.05.02
申请人 Infoblox Inc. 发明人 Bailey Stuart M.;Gutti Srinath;Pulleyn Ivan W.
分类号 G06F7/00;G06F17/30 主分类号 G06F7/00
代理机构 Van Pelt, Yi & James LLP 代理人 Van Pelt, Yi & James LLP
主权项 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;in the event the reference type for the host structure is of the first reference type, it is not necessary for the parent structure to exist for the host structure to exist, and it is not necessary for a child structure of the host structure to exist for the host structure to exist; andin the event the reference type for the host structure is of the second reference type: receiving a request to insert a host into a database for which the database schema has been defined, wherein the host is an instance of the child structure and the host refers to an instance of a parent structure;determining whether the instance of the parent structure exists in the database, wherein the instance of the parent structure is a Domain Name System (DNS) zone of a network; andin the event that the instance of the parent structure does not exist in the database, disallowing insertion of the instance of the child structure into the database, wherein the insert of the host is disallowed if the DNS zone does not exist.
地址 Santa Clara CA US