| CPC G06F 16/24528 (2019.01) [G06F 11/3409 (2013.01); G06F 16/24535 (2019.01)] | 20 Claims |
|
1. A computer-implemented method for data retrieval and providing structured access to data distributed across multiple disparate data stores, the computer-implemented method comprising:
receiving a data model associated with a plurality of data stores connected via a network;
obtaining a natural language question from a user for a data set comprising data associated with data elements, the data set being maintained across the plurality of data stores and stored in a non-standardized format, wherein the data elements lack predefined relationships or schema-level linkages, the plurality of data stores being accessible by the user via a client-side interface but not directly accessible by a computing device processing the natural language question, wherein one or more of metadata and/or query-specific parameters are transmitted to the computer device for query processing;
generating an abstracted query representation from the obtained natural language question, wherein the abstracted query representation comprises an intermediate representation of the natural language question that comprises relevant entities and intents of the natural language question without specific database syntax;
translating the abstracted query representation into a standardized expression language based at least in part on the data model describing entities, attributes, and relationships within the plurality of data stores, wherein translating utilizes a large language model (LLM) for linguistic and syntactic processing, and wherein the standardized expression language comprises a format compatible with multiple types of database management systems and includes specific syntax for at least one of data types, operations, or conditions;
executing a set of lookup functions to identify a predefined query pattern for querying the plurality of data stores, wherein the predefined query pattern corresponds to the standardized expression language, the predefined query pattern being selected based on at least one system performance metric;
generating an executable query from the identified predefined query pattern, the executable query being optimized for the at least one system performance metric across the plurality of data stores; and
providing the executable query to a client-side agent with access to the plurality of data stores, the client-side agent executing the executable query to retrieve the data set, wherein the data set is formatted as a structured view enabling unified access to data dispersed across the plurality of data stores.
|