Data information framework
A data information framework collects related data sharing characteristics (e.g., personal information, others) revealed by associated purpose information, and reports on that data. The location of the data is not restricted, and can be collected from various locations (e.g. different databases on different computer systems). An engine implements data creation defining links between different stored data structures (e.g., tables) using specific fields. A plurality of tables may be grouped into a smaller number of table clusters to facilitate constructing the data model. The model may be evaluated, enhanced, and/or corrected (e.g., by a user). The model may include fields reflecting the purpose information for the stored data, said fields accessible by the engine during data handling processes. The data model may include descriptions providing data storage location. Purpose information may be mapped to table fields. Field descriptions may be based upon purpose information, with some field values having intelligible text.
1. A computer-implemented method comprising:
an engine communicating with a database containing a plurality of tables;
the engine referencing a first table field to create a data model including links between certain of the plurality of tables comprising a first table and a second table, wherein the first table and the second table are part of a first system;
the engine determining a second link between the first table and a third table of a second system, the second link defined by a remote function call;
the engine grouping the certain of the plurality of tables into a plurality of table clusters based upon the links;
the engine selectively assigning purpose information relevant to a regulation, to fewer than the plurality of table clusters including the first table field to create a purpose model;
the engine receiving a query relating to the purpose information;
the engine generating a query response by recursively traversing the certain of the plurality of tables to match the purpose information; and
the engine delivering the query response for display at an interface comprising a hierarchical XML file.
2. A method as in claim 1 wherein the engine generates the query response by referencing the purpose information to render the first table field into a text description.
3. A method as in claim 1 wherein the links are defined by the certain of the plurality of tables belonging to a database object type.
4. A method as in claim 1 wherein the purpose information denotes private data.
5. A method as in claim 1 wherein the database comprises an in-memory database.
6. A method as in claim 1 wherein the engine comprises an in-memory database engine.
7. A computer-implemented method comprising:
an engine communicating with a database containing a plurality of tables;
the engine referencing a first table field to create a data model including links between certain of the plurality of tables comprising a first table and a second table that are part of a first system;
the engine determining a second link between the first table and a third table of a second system;
the engine grouping the certain of the plurality of tables into a plurality of table clusters based upon the links;
the engine selectively assigning purpose information relevant to a regulation, to fewer than the plurality of table clusters including the first table field to create a purpose model;
the engine receiving a query relating to the purpose information;
the engine generating a query response by recursively traversing the certain of the plurality of tables to match the purpose information, and referencing the purpose information to render the first table field into a text description; and
the engine delivering the query response for display at an interface comprising a hierarchical XML file.
8. A method as in claim 7 wherein the second link is defined by a remote function call.
9. A method as in claim 7 wherein the links are defined by the certain of the plurality of tables belonging to a database object type.
10. A method as in claim 7 further comprising the engine storing the purpose information in an in-memory database, wherein the engine comprises an in-memory database engine.
11. A method as in claim 10 wherein the engine creates a helper table in the in-memory database to store the purpose information, and creates a link to the helper table.
12. A computer system comprising:
a processor;
an in-memory database engine; and
a software program, executable on said computer system, the software program configured to cause the in-memory database engine to:
communicate with an in-memory database containing a plurality of tables;
reference a first table field to create a data model including links between certain of the plurality of tables comprising a first table and a second table, wherein the first table and the second table are part of a first system;
determine a second link between the first table and a third table of a second system, the second link defined by a remote function call;
group the certain of the plurality of tables into a plurality of table clusters based upon the links;
selectively assign purpose information relevant to a regulation, to fewer than the plurality of table clusters including the first table field to create a purpose model;
receive a query relating to the purpose information;
generate a query response by recursively traversing the certain of the plurality of tables to match the purpose information; and
deliver the query response for display at an interface comprising a hierarchical XML file.
13. A computer system as in claim 12 wherein the software program is further configured to cause the in-memory database engine to generate the query response by referencing the purpose information to render the first table field into a text description.
14. A computer system as in claim 12 wherein the links are defined by the certain of the plurality of tables belonging to a database object type.