Data pattern for storing information, including associated version and audit information for use in data management
Information is stored in a data pattern. The data pattern includes an identity table, a version table that includes at least one reference to the identity table, and an audit table that includes at least one reference to the version table. The identity table stores information identifying the information. The version table stores version information identifying one or more versions of the information identified in the identity table. The audit table stores audit information identifying when each of the one or more versions of the information was modified. The audit table may also store effectiveness information identifying when each of the one or more versions of the information is in effect.
1. A method comprising:
receiving a request to perform a first data management function on a set of information, wherein
the set of information describes an entity;
in response to the receiving the request to perform the first data management function, performing the request, wherein
the performing the request comprises
accessing a data pattern, wherein
the set of information is stored in the data pattern,
the performing the request modifies the data pattern, and
the performing the request does not modify any portion of the set of information;
subsequent to the accessing the data pattern, receiving a request to create an audit trail for the entity; and
in response to the receiving the request to create the audit trail, creating the audit trail, wherein
the creating the audit trail comprises accessing the data pattern.
2. The method of claim 1 , wherein
the first data management function is one of
an undo command,
a redo command, or
a soft delete command.
3. The method of claim 1 , wherein
the data pattern comprises
an identity table,
a version table comprising at least one reference to the identity table, and
an audit table comprising at least one reference to the version table,
the identity table stores information identifying the set of information,
the version table stores version information identifying one or more versions of the set of information, and
the audit table stores audit information identifying when each of the one or more versions of the set of information was modified.
4. The method of claim 3 , wherein
the set of information is a set of reference information,
the set of reference information is referenced by transactional information, and
the audit table also stores effectiveness information identifying when each of the one or more versions of the set of information is effective.
5. The method of claim 1 , wherein
the data pattern comprises an audit table storing audit information,
the accessing the data pattern comprises dynamically creating an audit trail based upon the audit information, in response to receipt of the request, and
the method further comprises
updating the audit information in response to a modification of the set of information, wherein
the updating the audit information is performed prior to receiving any request for an audit trail.
6. The method of claim 5 , wherein the updating the audit information comprises:
updating at most two rows of the audit table, wherein
the modification of the set of information modifies more than two attributes of the set of information.
7. A non-transitory computer readable storage medium comprising program instructions executable to:
receive a request to perform a first data management function on a set of information, wherein
the set of information is configured to describe an entity;
perform the request in response to receipt of the request to perform the first data management function, wherein
the program instructions executable to perform the request comprise
program instructions executable to
access a data pattern,
the data pattern is configured to store the set of information,
the performance of the request modifies the data pattern, and
the performance of the request does not modify any portion of the set of information;
receive a request to create an audit trail for the entity subsequent to accessing the data pattern; and
create the audit trail in response to receipt of the request to create the audit trail, wherein
the program instructions executable to create the audit trail comprise program instructions executable to
access the data pattern.
8. The non-transitory computer readable storage medium of claim 7 , wherein
the first data management function is one of
an undo command,
a redo command, or
a soft delete command.
9. The non-transitory computer readable storage medium of claim 7 , wherein
the data pattern comprises
an identity table,
a version table comprising at least one reference to the identity table, and
an audit table comprising at least one reference to the version table,
the identity table is configured to store information identifying the set of information,
the version table is configured to store version information identifying one or more versions of the set of information, and
the audit table is configured to store audit information identifying when each of the one or more versions of the set of information was modified.
10. The non-transitory computer readable storage medium of claim 9 , wherein
the set of information is a set of reference information,
the set of reference information is referenced by transactional information, and
the audit table also stores effectiveness information identifying when each of the one or more versions of the set of information is effective.
11. The non-transitory computer readable storage medium of claim 7 , wherein
the data pattern comprises
an audit table configured to store audit information,
the program instructions executable to access the data pattern comprise program instructions executable to
dynamically create an audit trail based upon the audit information, in response to receipt of the request, and
the program instructions are further executable to
update the audit information in response to a modification of the set of information, wherein
the program instructions further executable to update the audit information are configured to be executed prior to receipt of any request for an audit trail.
12. The non-transitory computer readable storage medium of claim 11 , wherein
the program instructions further executable to update the audit information comprise program instructions executable to
update at most two rows of the audit table, wherein
the modification of the set of information modifies more than two attributes of the set of information.
13. A system comprising:
one or more processors; and
a memory storing program instructions, executable by the one or more processors and configured to
receive a request to perform a first data management function on a set of information, wherein
the set of information is configured to describe an entity,
perform the request, in response to receipt of the request to perform the first data management function, wherein
the program instructions configured to perform the request comprise program instructions configured to access a data pattern,
the set of information is stored in the data pattern,
the performance of the request modifies the data pattern, and
the performance of the request does not modify any portion of the set of information;
receive a request to create an audit trail for the entity subsequent to accessing the data pattern; and
create the audit trail in response to receipt of the request to create the audit trail, wherein
the program instructions configured to create the audit trail comprise program instructions configured to access the data pattern.
14. The system of claim 13 , wherein
the first data management function is one of
an undo command,
a redo command, or
a soft delete command.
15. The system of claim 13 , wherein
the data pattern comprises
an identity table,
a version table comprising at least one reference to the identity table, and
an audit table comprising at least one reference to the version table,
the identity table is configured to store information identifying the set of information,
the version table is configured to store version information identifying one or more versions of the set of information, and
the audit table is configured to store audit information identifying when each of the one or more versions of the set of information was modified.
16. The system of claim 15 , wherein
the set of information is a set of reference information,
the set of reference information is referenced by transactional information, and
the audit table also stores effectiveness information identifying when each of the one or more versions of the set of information is effective.
17. The system of claim 13 , wherein
the data pattern comprises
an audit table configured to store audit information,
the program instructions configured to access the data pattern comprise program instructions configured to
dynamically create an audit trail based upon the audit information, in response to receipt of the request, and
the program instructions are further configured to
update the audit information in response to a modification of the set of information, wherein
the program instructions further configured to update the audit information are configured to be executed prior to receipt of any request for an audit trail.
18. The system of claim 17 , wherein
the program instructions further configured to update the audit information comprise program instructions configured to
update at most two rows of the audit table, wherein
the modification of the set of information modifies more than two attributes of the set of information.