Systems and methods for advanced enterprise data storage and retrieval
View Patent ↗A computer system is provided and is programmed to: (1) store, in a first database, knowledge base data sets for each of a plurality of datasets, wherein each knowledge base data set includes at least data relating to the use of the associated dataset and a link to a separate database storing the corresponding dataset; (2) receive, at the first database from a user computer device, a request for knowledge base data for a first dataset; (3) instruct the user computer device to display the knowledge base data for the first dataset; (4) receive a request for access to the first dataset, wherein the request for access includes one or more database operations to be performed on the first dataset; (5) access the first dataset; and/or (6) execute the one or more database operations on the first dataset to provide results to the user computer device.
1 . A computer system comprising at least one processor in communication with at least one memory device, wherein the at least one processor is programmed to:
generate knowledge base data for each of a plurality of pre-defined structured datasets, wherein the knowledge base data includes metadata describing a respective pre-defined structured dataset, the metadata including data associated with a previous access instance of the respective pre-defined structured dataset and a link to a separate database storing the respective pre-defined structured dataset;
store, in a first database, the knowledge base data for each of the plurality of pre-defined structured datasets,
receive, at the first database from a user computer device, a request for knowledge base data for a first pre-defined structured dataset;
instruct the user computer device to display the knowledge base data for the first pre-defined structured dataset, including an indicator of the previous access instance of the first pre-defined structured dataset;
receive, from the user computer device, a request for access to the first pre-defined structured dataset, wherein the request for access includes one or more database operations to be performed on the first pre-defined structured dataset;
access, via a first database server, the first pre-defined structured dataset; and
execute the one or more database operations on the first pre-defined structured dataset to provide results to the user computer device.
2 . The computer system of claim 1 , wherein the knowledge base data also includes a plurality of overview information for the respective pre-defined structured dataset, and wherein the at least one processor is further programmed to instruct the user computer device to display the plurality of overview information for the first enterprise dataset.
3 . The computer system of claim 1 , wherein the knowledge base data also includes a schema defining a format of the respective pre-defined structured dataset, and wherein the at least one processor is further programmed to instruct the user computer device to display the schema for the first pre-defined structured dataset.
4 . The computer system of claim 1 , wherein the knowledge base data also includes a list of users registered with the computer system who have accessed the respective pre-defined structured dataset in one or more previous access instances.
5 . The computer system of claim 1 , wherein the metadata includes user feedback associated with the respective pre-defined structured dataset for the previous access instance.
6 . The computer system of claim 1 , wherein the at least one processor is further programmed to:
receive, via the user computer device, a question about the first pre-defined structured dataset;
route the question to a computer device associated with a data provider associated with the first pre-defined structured dataset;
receive a response for the question from the computer device associated with a data provider associated with the first pre-defined structured dataset; and
provide the response to the user computer device.
7 . The computer system of claim 6 , wherein the at least one processor is further programmed to store the question and the response in the knowledge base data for the first pre-defined structured dataset.
8 . The computer system of claim 1 , wherein the knowledge base data includes a plurality of questions and answers, and wherein the at least one processor is further programmed to instruct the user computer device to display the questions and answers for the first pre-defined structured dataset.
9 . The computer system of claim 1 , wherein the at least one processor is further programmed to analyze usage of the plurality of pre-defined structured datasets to generate a plurality of usage information for the plurality of pre-defined structured datasets.
10 . The computer system of claim 9 , wherein the at least one processor is further programmed to analyze the plurality of usage information to generate a recommendation model trained to provide one or more dataset recommendations based upon each pre-defined structured dataset and the plurality of usage information.
11 . The computer system of claim 10 , wherein the at least one processor is further programmed to:
execute the recommendation model to generate one or more first dataset recommendations based upon the first pre-defined structured dataset; and
instruct the user computer device to display the one or more first dataset recommendations for the first pre-defined structured dataset.
12 . A computer-implemented method performed by a computer system including at least one processor in communication with at least one memory device, the computer-implemented method comprising:
generating knowledge base data for each of a plurality of pre-defined structured datasets, wherein the knowledge base data includes metadata describing a respective pre-defined structured dataset, the metadata including data associated with a previous access instance of the respective pre-defined structured dataset and a link to a separate database storing the respective pre-defined structured dataset;
storing, in a first database, the knowledge base data for each of the plurality of pre-defined structured datasets;
receiving, at the first database from a user computer device, a request for knowledge base data for a first pre-defined structured dataset;
instructing the user computer device to display the knowledge base data for the first pre-defined structured dataset, including an indicator of the previous access instance of the first pre-defined structured dataset;
receiving, from the user computer device, a request for access to the first pre-defined structured dataset, wherein the request for access includes one or more database operations to be performed on the first pre-defined structured dataset;
accessing, via a first database server, the first pre-defined structured dataset; and
executing the one or more database operations on the first pre-defined structured dataset to provide results to the user computer device.
13 . The computer-implemented method of claim 12 , wherein the knowledge base data also includes a plurality of overview information for the respective pre-defined structured dataset, and wherein the method further comprises instructing the user computer device to display the plurality of overview information for the first pre-defined structured dataset.
14 . The computer-implemented method of claim 12 , wherein the knowledge base data also includes a schema defining a format of the respective pre-defined structured dataset, and wherein the method further comprises instructing the user computer device to display the schema for the first pre-defined structured dataset.
15 . The computer-implemented method of claim 12 , wherein the knowledge base data also includes a list of users registered with the computer system who have accessed the respective pre-defined structured dataset in one or more previous access instances.
16 . The computer-implemented method of claim 12 , wherein the metadata includes user feedback associated with the respective pre-defined structured dataset for the previous access instance.
17 . The computer-implemented method of claim 12 further comprising:
receiving, via the user computer device, a question about the first pre-defined structured dataset;
routing the question to a computer device associated with a data provider associated with the first pre-defined structured dataset;
receiving a response for the question from the computer device associated with a data provider associated with the first pre-defined structured dataset; and
providing the response to the user computer device.
18 . The computer-implemented method of claim 17 further comprising storing the question and the response in the knowledge base data for the first pre-defined structured dataset.
19 . The computer-implemented method of claim 12 , wherein the knowledge base data includes a plurality of questions and answers, and wherein the method further comprises instructing the user computer device to display the questions and answers for the first pre-defined structured dataset.
20 . The computer-implemented method of claim 12 further comprising analyzing usage of the plurality of pre-defined structured datasets to generate a plurality of usage information for the plurality of pre-defined structured datasets.
21 . The computer-implemented method of claim 20 further comprising analyzing the plurality of usage information to generate a recommendation model trained to provide one or more dataset recommendations based upon each pre-defined structured dataset and the plurality of usage information.
22 . The computer-implemented method of claim 21 further comprising:
executing the recommendation model to generate one or more first dataset recommendations based upon the first pre-defined structured dataset; and
instructing the user computer device to display the one or more first dataset recommendations for the first pre-defined structured dataset.
23 . A non-transitory computer-readable media having computer-executable instructions embodied thereon, wherein when executed by a computing device including at least one processor in communication with at least one memory device, the computer-executable instructions cause the at least one processor to:
generate knowledge base data for each of a plurality of pre-defined structured datasets, wherein the knowledge base data includes metadata describing an respective pre-defined structured dataset, the metadata including data associated with a previous access instance of the respective pre-defined structured dataset and a link to a separate database storing the respective pre-defined structured dataset;
store, in a first database, the knowledge base data for each of the plurality of pre-defined structured datasets;
receive, at the first database from a user computer device, a request for knowledge base data for a first pre-defined structured dataset;
instruct the user computer device to display the knowledge base data for the first pre-defined structured dataset, including an indicator of the previous access instance of the first pre-defined structured dataset;
receive, from the user computer device, a request for access to the first pre-defined structured dataset, wherein the request for access includes one or more database operations to be performed on the first pre-defined structured dataset;
access, via a first database server, the first pre-defined structured dataset; and
execute the one or more database operations on the first pre-defined structured dataset to provide results to the user computer device.