Systems and methods for facilitating database queries
AssigneeQuerywise LLC
InventorsHans Brende, Joshua Mize, Kevin Pauli, Srivatsan Raman, Vishnu Alavur Kannan
Life of this patent
Estimating the term…
Loading patent…
AssigneeQuerywise LLC
InventorsHans Brende, Joshua Mize, Kevin Pauli, Srivatsan Raman, Vishnu Alavur Kannan
Estimating the term…
Approaches are described for facilitating database queries. A data model associated with multiple data stores is received. A natural language question for a data set maintained across these data stores is obtained, where the data set is stored in a non-standardized format and not directly accessible by the querying device. An abstracted query representation is generated and translated into a standardized expression language based on the data model. Query processing approaches identify a predefined query pattern optimized for system performance metrics. An executable query is generated from the identified query pattern and provided to access the data stores. The query is executed to retrieve the data set, formatted as a structured view for unified access to dispersed data.
A computer-implemented method for data retrieval and providing structured access to data distributed across multiple disparate data stores, the computer-implemented method comprising:
A system for data retrieval and providing structured access to data distributed across multiple disparate data stores, the system comprising:
A non-transitory computer readable storage medium storing instructions that, when executed by at least one processor of a computing system, causes the computing system to:
Dependencies are inferred from the claim text.
Drawings are temporarily unavailable. Open the PDF at USPTO
From the US filing history. Foreign family members aren’t listed.
Backward citations are indexed for grants only.
Query translation: standardisation; Simplification
Recording or statistical evaluation of computer activity, e.g. of down time, of input/output operation ; Recording or statistical evaluation of…:…
Query formulation: natural language query formulation
Query translation: translation of natural language queries to structured queries
Term end not estimated
The systems and methods disclosed herein are related generally to database queries and more specifically to facilitating database queries.
In our rapidly digitalizing world, the utilization of databases is a fundamental part of daily operations across various sectors, including business, healthcare, and education. Database structures, such as relational, NoSQL, or graph databases, each have unique schemas and indexing methods dictating how data is stored and retrieved. However, effective use of these databases presents significant challenges, particularly in accessing and querying data efficiently. Common querying languages like SQL for relational databases or Cypher for graph databases are required to extract data from these systems. There is often a significant gap between those who possess deep knowledge of these database structures and languages, and those who rely on the data to make strategic decisions or perform essential operations.
Traditional approaches have involved intermediary software tools or services that attempt to parse natural language inputs and translate them directly into query languages such as SQL. These systems often rely on predefined templates or rigid parsing rules, which can struggle with the ambiguity and variability inherent in natural language. As a result, these solutions can produce queries that are either syntactically incorrect or semantically misaligned with the user's original intention. Additionally, these approaches frequently require substantial preprocessing of the data or schema to fit the narrow confines of the system's understanding, limiting flexibility and scalability.
The accompanying drawings illustrate several embodiments and, together with the description, serve to explain the principles of the invention according to the embodiments. It will be appreciated by one skilled in the art that the particular arrangements illustrated in the drawings are merely exemplary and are not to be considered as limiting of the scope of the invention or the claims herein in any way.
FIG. 1A illustrates an example environment in which aspects of the various embodiments can be implemented.
FIG. 1B illustrates a system for facilitating database queries in accordance with various embodiments.
One or more different embodiments may be described in the present application. Further, for one or more of the embodiments described herein, numerous alternative arrangements may be described; it should be appreciated that these are presented for illustrative purposes only and are not limiting of the embodiments contained herein or the claims presented herein in any way. One or more of the arrangements may be widely applicable to numerous embodiments, as may be readily apparent from the disclosure. In general, arrangements are described in sufficient detail to enable those skilled in the art to practice one or more of the embodiments, and it should be appreciated that other arrangements may be utilized and that structural, logical, software, electrical and other changes may be made without departing from the scope of the embodiments. Particular features of one or more of the embodiments described herein may be described with reference to one or more particular embodiments or figures that form a part of the present disclosure, and in which are shown, by way of illustration, specific arrangements of one or more of the aspects. It should be appreciated, however, that such features are not limited to usage in the one or more particular embodiments or figures with reference to which they are described. The present disclosure is neither a literal description of all arrangements of one or more of the embodiments nor a listing of features of one or more of the embodiments that must be present in all arrangements.
Headings of sections provided in this patent application and the title of this patent application are for convenience only and are not to be taken as limiting the disclosure in any way.
Devices that are in communication with each other need not be in continuous communication with each other, unless expressly specified otherwise. In addition, devices that are in communication with each other may communicate directly or indirectly through one or more communication means or intermediaries, logical or physical.