Semantic modeling platform

• US 10,152,556 B1
• Filed: 04/16/2015
• Issued: 12/11/2018
• Est. Priority Date: 04/16/2015
• Status: Active Grant

• Current Assignee: JP Morgan Chase Bank, N.A. (JP Morgan Chase & Co)
• Original Assignee: JP Morgan Chase Bank, N.A. (JP Morgan Chase & Co)
• Inventors: Carlos, Edgardo S.
• Primary Examiner(s): Brown, Sheree N
• Application Number:
  US14/688,536
• Time in Patent Office: 1,335 Days
• Field of Search: 707794
• CPC Class Codes: G06F 16/213 with details for schema evolution support
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/86 Mapping to a database
• CPC Class Codes: H04L 67/02 based on web technology, e.g. hypertext transfer protocol [HTTP]

Abstract

A semantic modeling platform is disclosed for creating and modifying data objects to better accommodate data in databases and/or web services. The platform creates an ontology based on the data and compares it to the ontology of the data object, such as a database table or web services instance. Based on the comparison the platform modifies the ontology, which is used to create or modify the data object.

Claims

1. A semantic modeling platform comprising a memory with programmed instructions stored thereon and one or more processors configured to execute the stored programmed instructions to:

scan one or more databases to determine when at least one of the one or more databases is ready to update;

receive an indication for updating at least one of the one or more databases to accommodate data, when the determination indicates that the at least one of the one or more databases is ready to update;

parse a first ontology associated with at least one table in the at least one of the one or more databases;

create a second ontology that describes the data is accommodated;

map the parsed first ontology on to the created second ontology;

analyze the mapping of the first ontology on to the created second ontology;

determine one or more differences between the first and the second ontologies based on the analyzing;

recommend one or more changes to the second ontology based on the determined one or more differences between the first and the second ontologies; and

update the created second ontology based on the recommended one or more changes to the second ontology.

2. The semantic modeling platform of claim 1, wherein the-executable code when executed by the one or more processors further causes the one or more processors to:

export the updated ontology to a data modeler that modifies the at least one table in the database or creates a new table in the database.

3. The semantic modeling platform of claim 2, wherein the-executable code when executed by the one or more processors further causes the one or more processors to:

map the parsed first ontology on to the created second ontology based on a plurality of relational criteria.

4. The semantic modeling platform of claim 3, wherein the-executable code when executed by the one or more processors further causes the one or more processors to:

recommend one or more changes to the parsed first ontology based on the determined one or more differences between the first and the second ontologies.

5. The semantic modeling platform of claim 1, wherein the executable code when executed by the one or more processors further causes the one or more processors to:

receive an input indicating one or more web services are updated to accommodate data;

parse a first ontology associated with at least one of the one or more web services;

create a second ontology that describes the data based on the first XSD file;

map the parsed first ontology on to the created second ontology;

determine one or more differences between the first and the second ontologies;

update the created second ontology based on the determined differences between the first and the second ontologies; and

export the updated ontology to a data modeler that creates and utilizes a second XSD file to modify the one or more web services or create a new web service.

6. The semantic modeling platform of claim 1, wherein the executable code when executed by the one or more processors further causes the one or more processors to:

receive an indication to update one or more web services to accommodate data;

import a first XSD file associated with the data;

parse a third ontology associated with at least one web services instance;

create a fourth ontology that describes the data based on the first XSD file;

map the parsed third ontology on to the created fourth ontology;

determine one or more differences between the third and the fourth ontologies;

update the created fourth ontology based on the determined differences between the third and the fourth ontologies; and

export the updated ontology to a data modeler that creates and utilizes a second XSD file to modify the web services instance or creates a web services instance.

7. A method for updating an ontology in a database, the method comprising:

scanning, by a semantic modeling platform, one or more databases to determine when at least one of the one or more databases is ready to update;

receiving, by the semantic modeling platform, an indication for updating at least one of the one or more databases to accommodate data, when the determination indicates that the at least one of the one or more databases is ready to update;

parsing, by the semantic modeling platform, a first ontology associated with at least one table in the at least one of the one or more databases;

creating, by the semantic modeling platform, a second ontology that describes the data to is accommodated;

mapping, by the semantic modeling platform, the parsed first ontology on to the created second ontology;

analyzing, by the semantic modeling platform, the mapping of the first ontology on to the created second ontology;

determining, by the semantic modeling platform, one or more differences between the first and the second ontologies based on the analyzing;

recommending, by the semantic modeling platform, one or more changes to the second ontology based on the determined one or more differences between the first and the second ontologies; and

updating, by the semantic modeling platform, the created second ontology based on the recommended one or more changes to the second ontology.

8. The method of claim 7, further comprising:

exporting, by the semantic modeling platform, the updated ontology to a data modeler that modifies the at least one table in the database or creates a new table in the database.

9. The method of claim 8, further comprising:

mapping, by the semantic modeling platform, the parsed first ontology on to the created second ontology is based on a plurality of relational criteria.

10. The method of claim 9, further comprising:

recommending, by the semantic modeling platform, one or more changes to the parsed first ontology based on the determined one or more differences between the first and the second ontologies.

11. The method of claim 7, further comprising:

receiving, by the semantic modeling platform, an input indicating one or more web services are updated to accommodate data;

parsing, by the semantic modeling platform, a first ontology associated with at least one of the one or more web services;

creating, by the semantic modeling platform, a second ontology that describes the data based on the first XSD file;

mapping, by the semantic modeling platform, the parsed first ontology on to the created second ontology;

determining, by the semantic modeling platform, one or more differences between the first and the second ontologies;

updating, by the semantic modeling platform, the created second ontology based on the determined differences between the first and the second ontologies; and

exporting, by the semantic modeling platform, the updated ontology to a data modeler that creates and utilizes a second XSD file to modify the one or more web services or create a new web service.

12. The method of claim 7, further comprising:

receiving, by the semantic modeling platform, an indication to update one or more web services to accommodate data;

importing, by the semantic modeling platform, a first XSD file associated with the data;

parsing, by the semantic modeling platform, a third ontology associated with at least one web services instance;

creating, by the semantic modeling platform, a fourth ontology that describes the data based on the first XSD file;

mapping, by the semantic modeling platform, the parsed third ontology on to the created fourth ontology;

determining, by the semantic modeling platform, one or more differences between the third and the fourth ontologies;

updating, by the semantic modeling platform, the created fourth ontology based on the determined differences between the third and the fourth ontologies; and

exporting, by the semantic modeling platform, the updated ontology to a data modeler that creates and utilizes a second XSD file to modify the web services instance or creates a web services instance.

13. A non-transitory machine readable medium having stored thereon instructions for updating an ontology in a database comprising executable code which when executed by one or more processors, causes the one or more processors to:

scan one or more databases to determine when at least one of the one or more databases is ready to update;

receive an indication for updating at least one of the one or more databases to accommodate data, when the determination indicates that the at least one of the one or more databases is ready to update;

parse a first ontology associated with at least one table in the at least one of the one or more databases;

create a second ontology that describes the data to is accommodated;

map the parsed first ontology on to the created second ontology;

analyzing the mapping of the first ontology on to the created second ontology;

determine one or more differences between the first and the second ontologies based on the analyzing;

recommend one or more changes to the second ontology based on the determined one or more differences between the first and the second ontologies; and

update the created second ontology based on the recommended one or more changes to the second ontology.

14. The non-transitory machine readable medium of claim 13, wherein the executable code when executed by the processors further causes the one or more processors to:

export the updated ontology to a data modeler that modifies the at least one table in the database or creates a new table in the database.

15. The non-transitory machine readable medium of claim 14, wherein the executable code when executed by the processors further causes the one or more processors to:

map the parsed first ontology on to the created second ontology based on a plurality of relational criteria.

16. The non-transitory machine readable medium of claim 15, wherein the executable code when executed by the processors further causes the one or more processors to:

recommend one or more changes to the parsed first ontology based on the determined one or more differences between the first and the second ontologies.

17. The non-transitory machine readable medium of claim 13, wherein the executable code when executed by the processors further causes the one or more processors to:

receive an input indicating one or more web services are updated to accommodate data;

parse a first ontology associated with at least one of the one or more web services;

create a second ontology that describes the data based on the first XSD file;

map the parsed first ontology on to the created second ontology;

determine one or more differences between the first and the second ontologies;

update the created second ontology based on the determined differences between the first and the second ontologies; and

export the updated ontology to a data modeler that creates and utilizes a second XSD file to modify the one or more web services or create a new web service.

18. The non-transitory machine readable medium of claim 13, wherein the executable code when executed by the processors further causes the one or more processors to:

receive an indication to update one or more web services to accommodate data;

import a first XSD file associated with the data;

parse a third ontology associated with at least one web services instance;

create a fourth ontology that describes the data based on the first XSD file;

map the parsed third ontology on to the created fourth ontology;

determine one or more differences between the third and the fourth ontologies;

update the created fourth ontology based on the determined differences between the third and the fourth ontologies; and

export the updated ontology to a data modeler that creates and utilizes a second XSD file to modify the web services instance or creates a web services instance.