Systems and methods for deriving database semantic information using artificial intelligence
An artificially intelligent method includes the steps of monitoring, by a processor, information sources to identify primary semantic information; capturing, by the processor, the primary semantic information; reformatting, by the processor, the primary semantic information according to a predetermined format; analyzing, by the processor, the primary semantic information to establish secondary semantic information; and establishing, by the processor, ontologies from the primary, secondary, and additional secondary semantic information.
1. A method performed by a processor during runtime of a database, comprising:
monitoring information sources that regulate how variables in database tables are affected to find a foreign key constraint and using the foreign key constraint to identify primary semantic information;
extracting the primary semantic information;
analyzing the primary semantic information to establish secondary semantic information, wherein the secondary semantic information is not directly presented in the information sources;
extracting the secondary semantic information; and
establishing, by the processor, ontologies from the primary semantic information and the secondary semantic information.
2. The method according to claim 1 , wherein extracting the primary semantic information includes extracting the primary semantic information from runtime behaviors of a database, the runtime behaviors including reading data, wilting data, deleting data, moving data and duplicating data.
3. The method according to claim 1 , wherein analyzing includes inferring, by the processor, crosslinking relationships from the primary semantic information, wherein the crosslinking relationships are not directly presented in the information sources.
4. The method according to claim 1 , wherein the information sources include an embedded SQL statement in an application program.
5. The method according to claim 1 , wherein the information sources include a JDBC or ODBC query.
6. The method according to claim 1 , wherein the information sources include a trigger expression.
7. The method according to claim 1 , further including editing, by the processor, the ontologies.
8. A computer program product, comprising:
a non-transitory computer-readable medium comprising instructions which, when executed by a processor, cause the processor to perform the steps of:
monitoring information sources that regulate how variables in database tables are affected to find a foreign key constraint and using the foreign key constraint to identify primary semantic information;
extracting the primary semantic information and reformatting the primary semantic information to a predetermined format;
analyzing the primary semantic information to establish secondary semantic information, wherein the secondary semantic information is not directly presented in the information sources;
extracting the secondary semantic information and reformatting the second semantic information to the predetermined format;
and
establishing, by the processor, ontologies from the primary semantic information and the secondary semantic information.
9. The computer program product of claim 8 , wherein the information sources include a query execution plan.
10. The computer program product of claim 8 , wherein the information sources include a stored procedure instruction.
11. The computer program product of claim 8 , wherein the information sources include an embedded SQL statement in an application program.
12. The computer program product of claim 8 , wherein the information sources include a JDBC or ODBC query.
13. The computer program product of claim 8 , wherein the information sources include a trigger expression.
14. The computer program product of claim 8 , wherein the steps further include editing, by the processor, the ontologies.
15. An apparatus, comprising:
a memory; and
a processor coupled to the memory, the processor being configured to perform the steps of:
monitoring information sources that regulate how variables in database tables are affected to find a foreign key constraint and using the foreign key constraint to identify primary semantic information;
extracting the primary semantic information and reformatting the primary semantic information to a predetermined format;
analyzing the primary semantic information to establish secondary semantic information, wherein the secondary semantic information is not directly presented in the information sources;
extracting the secondary semantic information and reformatting the secondary semantic information to the predetermined format;
and
establishing, by the processor, ontologies from the primary semantic information and the secondary semantic information.
16. The apparatus of claim 15 , wherein the information sources include a query execution plan.
17. The apparatus of claim 15 , wherein the information sources include a stored procedure instruction.
18. The apparatus of claim 15 , wherein the information sources include an embedded SQL statement in an application program.
19. The apparatus of claim 15 , wherein the information sources include a JDBC or ODBC query.
20. The method of claim 1 , wherein the primary semantic information and the secondary semantic information are reformatted to a predetermined format.