公开(公告)号：US08812539B2

公开(公告)日：2014-08-19

申请号：US13453628

申请日：2012-04-23

申请人： Zack Milousheff ,  Mark Hutchins

发明人： Zack Milousheff ,  Mark Hutchins

IPC分类号： G06F17/30

CPC分类号： G06F17/30371

摘要： Methods and apparatus for ensuring uniqueness of database object attributes are disclosed. An example computer-implemented method includes receiving a request to insert, update or delete a versioned database object having a first identifier (ID) in a main database table. The method further includes determining, based on the request, whether to fire an insert trigger, a delete trigger or an update trigger for the main database table. In the event an insert trigger is fired, the method includes performing, in a secondary database table, a record insertion process. In the event a delete trigger is fired, the method includes performing, in the secondary database table, a record deletion process. In the event an update trigger is fired, the method includes performing, in the secondary database table, at least one of the record insertion process for a post-update versioned database object and the record deletion process for a pre-update versioned database object.

摘要翻译： 公开了确保数据库对象属性的唯一性的方法和装置。 计算机实现的示例包括接收在主数据库表中插入，更新或删除具有第一标识符（ID）的版本化数据库对象的请求。 该方法还包括基于该请求来确定是否触发主数据库表的插入触发器，删除触发器或更新触发器。 在触发插入触发的情况下，该方法包括在次数据库表中执行记录插入过程。 如果触发了删除触发器，则该方法包括在次数据库表中执行记录删除处理。 在触发更新触发器的情况下，该方法包括在次数据库表中执行用于更新后版本化数据库对象的记录插入过程和用于更新前版本化数据库对象的记录删除处理中的至少一个。

公开(公告)号：US20130262403A1

公开(公告)日：2013-10-03

申请号：US13453628

申请日：2012-04-23

申请人： Zack Milousheff ,  Mark Hutchins

发明人： Zack Milousheff ,  Mark Hutchins

IPC分类号： G06F17/30

CPC分类号： G06F17/30371

摘要： Methods and apparatus for ensuring uniqueness of database object attributes are disclosed. An example computer-implemented method includes receiving a request to insert, update or delete a versioned database object having a first identifier (ID) in a main database table. The method further includes determining, based on the request, whether to fire an insert trigger, a delete trigger or an update trigger for the main database table. In the event an insert trigger is fired, the method includes performing, in a secondary database table, a record insertion process. In the event a delete trigger is fired, the method includes performing, in the secondary database table, a record deletion process. In the event an update trigger is fired, the method includes performing, in the secondary database table, at least one of the record insertion process for a post-update versioned database object and the record deletion process for a pre-update versioned database object.

摘要翻译： 公开了确保数据库对象属性的唯一性的方法和装置。 计算机实现的示例包括接收在主数据库表中插入，更新或删除具有第一标识符（ID）的版本化数据库对象的请求。 该方法还包括基于该请求来确定是否触发主数据库表的插入触发器，删除触发器或更新触发器。 在触发插入触发的情况下，该方法包括在次数据库表中执行记录插入过程。 如果触发了删除触发器，则该方法包括在次数据库表中执行记录删除处理。 在触发更新触发器的情况下，该方法包括在次数据库表中执行用于更新后版本化数据库对象的记录插入过程和用于更新前版本化数据库对象的记录删除处理中的至少一个。

公开(公告)号：US20120254254A1

公开(公告)日：2012-10-04

申请号：US13074983

申请日：2011-03-29

申请人： Zack Milousheff

发明人： Zack Milousheff

IPC分类号： G06F17/30

CPC分类号： G06F17/30589 ,  G06F17/30958

摘要： Disclosed are methods and systems to provide for using database triggers to maintain a relational persistence of the transitive closure and path structure of an object hierarchy in the form of an object hierarchy bridge table. In one embodiment, database triggers fire when objects or relationships are added or deleted from the hierarchy. Based on the additions and deletions, a delta can be calculated and applied to an object hierarchy bridge table and the graph transitive closure and path structure can be dynamically built and maintained as corresponding changes to the graph occur. Later, more efficient access and retrieval of a graph transitive closure and path structure can be retrieved without necessarily having to perform recursion to calculate the graph transitive closure and path at request time.

摘要翻译： 公开的是提供使用数据库触发器以对象层次结构桥表的形式维护对象分层结构的传递闭包和路径结构的关系持久性的方法和系统。 在一个实施例中，当从层次结构中添加或删除对象或关系时，数据库触发器触发。 基于添加和删除，可以计算增量并应用于对象层次结构桥表，并且图形传递闭包和路径结构可以动态构建和维护，因为图形的相应更改发生。 之后，可以检索图形传递闭包和路径结构的更有效的访问和检索，而无需执行递归以在请求时计算图形传递闭包和路径。

公开(公告)号：US08667027B2

公开(公告)日：2014-03-04

申请号：US13074983

申请日：2011-03-29

申请人： Zack Milousheff

发明人： Zack Milousheff

IPC分类号： G06F17/00

CPC分类号： G06F17/30589 ,  G06F17/30958

摘要： Disclosed are methods and systems to provide for using database triggers to maintain a relational persistence of the transitive closure and path structure of an object hierarchy in the form of an object hierarchy bridge table. In one embodiment, database triggers fire when objects or relationships are added or deleted from the hierarchy. Based on the additions and deletions, a delta can be calculated and applied to an object hierarchy bridge table and the graph transitive closure and path structure can be dynamically built and maintained as corresponding changes to the graph occur. Later, more efficient access and retrieval of a graph transitive closure and path structure can be retrieved without necessarily having to perform recursion to calculate the graph transitive closure and path at request time.

摘要翻译： 公开的是提供使用数据库触发器以对象层次结构桥表的形式维护对象分层结构的传递闭包和路径结构的关系持久性的方法和系统。 在一个实施例中，当从层次结构中添加或删除对象或关系时，数据库触发器触发。 基于添加和删除，可以计算增量并应用于对象层次结构桥表，并且图形传递闭包和路径结构可以动态构建和维护，因为图形的相应更改发生。 之后，可以检索图形传递闭包和路径结构的更有效的访问和检索，而无需执行递归以在请求时计算图形传递闭包和路径。