Methods and systems for a compliance framework database schema
View Patent ↗Generating a compliance framework. The compliance framework facilitates an organization's compliance with multiple authority documents by providing efficient methodologies and refinements to existing technologies, such as providing hierarchical fidelity to the original authority document; separating auditable citations from their context (e.g., prepositions and or informational citations); asset focused citations; SNED and Live values, among others.
1 . A memory storing a data structure accessible by one or more processors of a data processing system that performs database operations based, at least in part, on the data structure, the data structure comprising:
a record for a citation among multiple citations within multiple authority documents, each record comprising:
an editorial status of the record, wherein the editorial status is calculated, by the one or more processors, based on a comparison between a first checksum value of fields in a current release of the record and a second checksum value of fields in a previous release of the record, to indicate a status selected from a set including a same status, a new status, an edited status, and a deprecated status, and wherein:
if the first checksum value equals the second checksum value, the status is selected to be the same status,
if the second checksum value does not exist, the status is selected to be the new status,
if the first checksum value does not match the second checksum value, the status is selected to be the edited status, and
if a predefined digit of the first checksum value differs from a predefined digit of the second checksum value in a predefined manner, the status is selected to be the deprecated status; and
an indication of a control connected to the citation based on calculation using the one or more processors.
2 . The memory of claim 1 , wherein the predefined digit of the first checksum is the first digit of the first checksum and the predefined digit of the second checksum is the first digit of the second checksum.
3 . The memory of claim 1 , wherein if the status is selected to be the deprecated status, the record includes a deprecated-by field with a value identifying a surviving record.
4 . The memory of claim 1 , wherein the record further comprises information identifying the record in a hierarchy in accordance with the multiple of citations.
5 . The memory of claim 4 , wherein the information includes a parent record identifier and a sort value.
6 . The memory of claim 5 , wherein the parent record identifier indicates the citation's position in the hierarchy relative to at least an ancestor citation in the hierarchy.
7 . The memory of claim 5 , wherein the sort value indicates the citation's position in the hierarchy relative to a set of siblings in the hierarchy.
8 . The memory of claim 1 , wherein the control connected to the citation is generated based on a noun-verb pair for the citation.
9 . One or more instances of non-transitory computer-readable media collectively storing a data structure accessible by one or more processors of a computing system that performs database operations based, at least in part, on the data structure, the data structure comprising:
a record for a citation among multiple citations within multiple authority documents, each record comprising:
an editorial status of the record, wherein the editorial status is calculated, by the one or more processors, based on a comparison between a first checksum value of fields in a current release of the record and a second checksum value of fields in a previous release of the record, to indicate a status selected from a set including a same status, a new status, an edited status, and a deprecated status, and wherein:
if the first checksum value equals the second checksum value, the status is selected to be the same status,
if the second checksum value does not exist, the status is selected to be the new status,
if the first checksum value does not match the second checksum value, the status is selected to be the edited status, and
if a predefined digit of the first checksum value differs from a predefined digit of the second checksum value in a predefined manner, the status is selected to be the deprecated status; and
an indication of a control connected to the citation based on calculation using the one or more processors.
10 . The one or more instances of non-transitory computer-readable media of claim 9 , wherein the predefined digit of the first checksum is the first digit of the first checksum and the predefined digit of the second checksum is the first digit of the second checksum.
11 . The one or more instances of non-transitory computer-readable media of claim 9 , wherein if the status is selected to be the deprecated status, the record includes a deprecated-by field with a value identifying a surviving record.
12 . The one or more instances of non-transitory computer-readable media of claim 9 , wherein the record further comprises information identifying the record in a hierarchy in accordance with the multiple of citations.
13 . The one or more instances of non-transitory computer-readable media of claim 12 , wherein the information includes a parent record identifier and a sort value.
14 . The one or more instances of non-transitory computer-readable media of claim 13 , wherein the parent record identifier indicates the citation's position in the hierarchy relative to at least an ancestor citation in the hierarchy.
15 . The one or more instances of non-transitory computer-readable media of claim 13 , wherein the sort value indicates the citation's position in the hierarchy relative to a set of siblings in the hierarchy.
16 . The one or more instances of non-transitory computer-readable media of claim 9 , wherein the control connected to the citation is generated based on a noun-verb pair for the citation.
17 . A system comprising memory that stores content accessible by one or more processors to perform database operations, the content comprising:
a record for a citation among multiple citations within multiple authority documents, each record comprising:
an editorial status of the record, wherein the editorial status is calculated, by the one or more processors, based on a comparison between a first checksum value of fields in a current release of the record and a second checksum value of fields in a previous release of the record, to indicate a status selected from a set including a same status, a new status, an edited status, and a deprecated status, and wherein:
if the first checksum value equals the second checksum value, the status is selected to be the same status,
if the second checksum value does not exist, the status is selected to be the new status,
if the first checksum value does not match the second checksum value, the status is selected to be the edited status, and
if a predefined digit of the first checksum value differs from a predefined digit of the second checksum value in a predefined manner, the status is selected to be the deprecated status; and
an indication of a control connected to the citation based on calculation using the one or more processors.
18 . The system of claim 17 , wherein the predefined digit of the first checksum is the first digit of the first checksum and the predefined digit of the second checksum is the first digit of the second checksum.
19 . The system of claim 17 , wherein if the status is selected to be the deprecated status, the record includes a deprecated-by field with a value identifying a surviving record.
20 . The system of claim 17 , wherein the record further comprises information identifying the record in a hierarchy in accordance with the multiple of citations.
21 . The system of claim 20 , wherein the information includes a parent record identifier and a sort value.
22 . The system of claim 21 , wherein the parent record identifier indicates the citation's position in the hierarchy relative to at least an ancestor citation in the hierarchy.
23 . The system of claim 21 , wherein the sort value indicates the citation's position in the hierarchy relative to a set of siblings in the hierarchy.
24 . The system of claim 17 , wherein the control connected to the citation is generated based on a noun-verb pair for the citation.