Abstract: The present invention relates to a system and methodology to facilitate the automated creation of an XML object model which overlays a standard relational database to allow both saving and retrieval of data via hierarchical XML objects from within the actual database server itself. The Automated Database Object Model (ADOM) process generates a set of log tables, triggers, stored procedures, functions, and views for all objects as determined by a database schema interrogation process. The result is a select query for every hierarchical object in the database, and a single point of entry stored procedure for all inserts, updates, and deletes. A managed application programming interface (API) is also provided to automatically generate a class object library in the application layer which matches the automated database object model, thus abstracting the application developer from directly managing the underlying database structure.
Type:
Grant
Filed:
August 3, 2016
Date of Patent:
December 22, 2020
Assignee:
Intelligence Designs, LLC
Inventors:
Larry Arrington, Stephen Smith, Paul Flomer