SYSTEMS AND METHODS FOR RELATIONAL NODE-BASED GRAPH DATABASE
A method, performed by one or more processors, for generating a database, includes: generating a first primary key in a node table for a first entity; generating a second primary key in the node table for a first attribute associated with the first entity; generating a third primary key in the node table for first data associated with the first attribute of the first entity; storing the first data in an attribute table, using the first primary key for the first entity in the node table as a primary key for the first data in the attribute table; and generating a triple with the first primary key as a subject, the second primary key as a predicate, and the third primary key as an object.
1 . A method, performed by one or more processors, for generating a database, the method comprising:
generating a first key in a node table having a single column for a first domain, wherein the first domain is included in one or more of a first graph or a second graph;
generating a second key in the node table for a first attribute in a domain table associated with the first domain;
generating a third in the node table for first data associated with the first attribute of the first domain;
storing the first data in an attribute table, using the first key for the first domain in the node table as a primary key for the first data in the attribute table; and
generating a triple with the first key as a subject, the second as a predicate, and the third key as an object.
2 . The method of claim 1 , further comprising:
generating a fourth key for a second attribute associated with the first domain, wherein the second attribute is different from the first attribute.
3 . The method of claim 1 , further comprising:
storing the first the second key, and the third in a single subgraph of the database.
4 . The method of claim 3 , further comprising:
storing the triple in a subgraph of the database.
5 . The method of claim 1 , further comprising:
authenticating an identity of the first domain using the triple.
6 . The method of claim 1 , further comprising:
generating a confidence level for the first data of the first attribute associated with the first domain.
7 . The method of claim 1 , further comprising:
exporting the triple to an external data structure.
8 . A system comprising:
one or more data storage devices that store instructions for generating a database; and
one or more processors configured to execute the instructions to perform a method including:
generating a first key in a node table having a single column for a first domain, wherein the first domain is included in one or more of a first graph or a second graph;
generating a second key in the node table for a first attribute in a domain table associated with the first domain;
generating a third key in the node table for first data associated with the first attribute of the first domain;
storing the first data in an attribute table, using the first key for the first domain in the node table as a primary key for the first data in the attribute table; and
generating a triple with the first key as a subject, the second primary key as a predicate, and the third primary key as an object.
9 . The system of claim 8 , wherein the method further includes:
generating a fourth for a second attribute associated with the first domain, wherein the second attribute is different from the first attribute.
10 . The system of claim 8 , wherein the method further includes:
storing the first key, the second key, and the third key, in a single subgraph of the database.
11 . The system of claim 10 , wherein the method further includes:
storing in separate subgraphs the triple of the first key, the second key, and the third key.
12 . The system of claim 8 , wherein the method further includes:
authenticating an identity of the first domain using the triple.
13 . The system of claim 8 , wherein the method further includes:
generating a confidence level for the first data of the first attribute associated with the first domain.
14 . The system of claim 8 , wherein the method further includes:
exporting the triple to an external data structure.
15 . A non-transitory computer readable medium including a database comprising:
a first node for a first domain in a node table having a single column, wherein the first node includes a first key for the first domain included in one or more of a first graph or a second graph;
a second node for a first attribute in a domain table, wherein the first attribute is associated with the first domain, wherein the second node includes the first for the first domain and first data associated with the first attribute, and wherein the first attribute is associated with a second key and the first data is associated with a third key; and
a first edge defined by the first key as a subject, the second as a predicate, and the third key as an object.
16 . The database of claim 15 , wherein the first node and the second node are stored in a first subgraph of the database.
17 . The database of claim 16 , wherein an association between the first node and the first domain are stored in a second subgraph of the database.
18 . The database of claim 15 , wherein the database further includes:
a third node for a second domain, wherein the third node includes a fourth key for the second domain;
a fourth node for a second attribute associated with the second domain, wherein the fourth node includes the fourth key for the second domain and second data associated with the second attribute, and wherein the second attribute is associated with a fifth key and the second data is associated with a sixth key; and
a second edge defined by the fourth key as a subject, the fifth key as a predicate, and the sixth key as an object.
19 . The database of claim 18 , wherein the database further includes:
the first edge and the second edge stored in a subgraph of the database.
20 . The database of claim 15 , wherein the first data is constrained in the database.