Responding to data requests related to constrained natural language vocabulary terms

Patent metadata

Field	Value
Publication number	US-10372697-B2
Application number	US-201414576956-A
Country	US
Kind code	B2
Filing date	Dec 19, 2014
Priority date	Dec 19, 2014
Publication date	Aug 6, 2019
Grant date	Aug 6, 2019

Abstract

One or more processors generate a data source table. The data source table is specific for a particular constrained natural language (cNL) vocabulary term from a cNL vocabulary dictionary. The data source table includes a location reference to multiple predetermined data sources that contain data related to the particular cNL vocabulary term, where at least two of the multiple predetermined data sources are disparate types of data sources as compared to each other. The data source table also includes a location reference to a materialized view of data from each of the multiple data sources, where the materialized view of data is data that is related to the particular cNL vocabulary term. One or more processors receive a request for data related to the particular cNL vocabulary term from a requester, and then retrieve data from multiple materialized views from the data source table to the requester.

First claim

What is claimed is:

1. A computer system comprising one or more processors, one or more computer readable memories, and one or more computer readable non-transitory storage mediums, and program instructions stored on at least one of the one or more computer readable non-transitory storage mediums for execution by at least one of the one or more processors via at least one of the one or more computer readable memories, the stored program instructions executed to perform a method comprising:
storing a constrained natural language (cNL) vocabulary dictionary, wherein the cNL vocabulary dictionary contains multiple cNL vocabulary terms;
storing a data source table on a data source server, wherein the data source table is specific for a particular cNL vocabulary term from the cNL vocabulary dictionary, wherein the data source table comprises location references to locations of multiple data sources that contain data related to the particular cNL vocabulary term, wherein at least two of the multiple data sources are disparate types of data sources as compared to each other, wherein the data source table comprises location references to materialized views of data from each of the multiple data sources, wherein a materialized view of data is data that describes information that is related to the particular cNL vocabulary term, and wherein the data source table is populated with a materialized view refresh policy for each said materialized view of data from each of the multiple data sources;
receiving a request for data related to the particular cNL vocabulary term from a requester;
retrieving data from multiple materialized views from the data source table;
returning data from the multiple materialized views from the data source table to the requester;
detecting a physical condition of the data source server, wherein the physical condition comprises a change in altitude of a physical location of the data source server beyond a certain level, and wherein the physical condition comprises a change in a geographic physical location of the data source server from a first geographic location to a second geographic location; and
triggering a refresh of one or more materialized views of data by one or more materialized view refresh policies based on the detected physical condition of the data source server.

2. The system of claim 1 , wherein the data source table is populated with a materialized view refresh policy for each said materialized view of data from each of the multiple data sources, and wherein each said materialized view of data is associated with a different materialized view refresh policy.

3. The system of claim 1 , wherein the data source table is populated with a materialized view refresh policy for each said materialized view of data from each of the multiple data sources, and wherein the method further comprises:
detecting a communication session between the data source modifying device and a data source server that supports one or more of the data sources;
detecting a keystroke entry in the data source modifying device;
determining that the data source modifying device has accessed one or more of the data sources based on the communication session detected by the network interface device and the keystroke entry detected by the keystroke detector device; and
triggering a refresh of one or more materialized views of data by one or more materialized view refresh policies, wherein the refresh is triggered by the data source modifying device accessing said one or more of the data sources.

4. The system of claim 1 , wherein the data source table is populated with a materialized view refresh policy for each said materialized view of data from each of the multiple data sources, and wherein the method further comprises:
identifying a server type of the data source server; and
matching and implementing the materialized view refresh policy according to the server type of the data source server.

5. A computer program product for responding to data requests by a computer system, the computer program product comprising a computer readable storage medium having program code embodied therewith, wherein the computer readable storage medium is not a transitory signal per se, and wherein the program code is readable and executable by a processor to perform a method comprising:
creating a constrained natural language (cNL) vocabulary dictionary, wherein the cNL vocabulary dictionary contains multiple cNL vocabulary terms;
generating and storing a data source table on a data source server, wherein the data source table is specific for a particular cNL vocabulary term from the cNL vocabulary dictionary, wherein the data source table comprises location references to locations of multiple data sources that contain data related to the particular cNL vocabulary term, wherein at least two of the multiple predetermined data sources are disparate types of data sources as compared to each other, wherein the data source table comprises location references to materialized views of data from each of the multiple data sources, wherein a materialized view of data is data that describes information that is related to the particular cNL vocabulary term, and wherein the data source table is populated with a materialized view refresh policy for each said materialized view of data from each of the multiple data sources;
receiving a request for data related to the particular cNL vocabulary term from a requester;
retrieving data from multiple materialized views from the data source table;
returning data from the multiple materialized views from the data source table to the requester;
detecting a physical condition of the data source server, wherein the physical condition comprises a change in altitude of a physical location of the data source server beyond a certain level, and wherein the physical condition comprises a change in a geographic physical location of the data source server from a first geographic location to a second geographic location; and
triggering a refresh of one or more materialized views of data by one or more materialized view refresh policies based on the detected physical condition of the data source server.

6. The computer program product of claim 5 , wherein the method further comprises:
populating the data source table with a materialized view refresh policy for each said materialized view of data from each of the multiple data sources; and
updating the materialized view of data from each of the multiple data sources according to the materialized view refresh policy.

7. The computer program product of claim 5 , wherein the method further comprises:
populating the data source table with a materialized view refresh policy for each said materialized view of data from each of the multiple data sources;
detecting a communication session between a data source modifying device and a data source server that supports one or more of the data sources;
detecting a keystroke entry in the data source modifying device;
determining that the data source modifying device has accessed one or more of the data sources based on the communication session detected by the network interface device and the keystroke entry detected by the keystroke detector device;
triggering a refresh of one or more materialized views of data by one or more materialized view refresh policies, wherein the refresh is triggered by the data source modifying device accessing one or more of the data sources.

8. The computer program product of claim 5 , wherein the method further comprises:
populating the data source table with a materialized view refresh policy for each said materialized view of data from each of the multiple data sources; and
triggering a refresh of one or more materialize

Assignees

• IBM

Inventors

• Ashtiani Behrooz
• Guo Yuanyuan
• Khatibi Mitra
• Lau Diana
• Ng Joanna W

Classifications

• G06F16/24522 Primary

  Translation of natural language queries to structured queries · CPC title

• G06F16/3344

  using natural language analysis · CPC title

• G06F16/338

  Presentation of query results · CPC title

• G06F16/2282 Primary

  Tablespace storage structures; Management thereof · CPC title