847 results about "Query language" patented technology

The invention discloses a Text2SQL (Structured Query Language) implementation method and system, and relates to the field of data processing, and the method comprises the following steps: firstly, receiving a natural language query, and analyzing a query intention, field classification and a key entity through a planner; the searcher obtains domain knowledge, entity information, a database table structure and a historical query mode in a multi-path parallel mode based on the planning result; the generator constructs an SQL framework according to the retrieval result and generates an initial statement; the verifier carries out grammar, table field, authority and logic multi-dimensional verification on the SQL, and if the verification fails, iteration adjustment is carried out to generate logic; when the SQL is executed, the result is formatted and a natural language explanation containing query logic, a data source and a calculation method is generated if the SQL is executed successfully, and a diagnosis and error correction mechanism is started for correction and then rechecking is performed if the SQL is executed unsuccessfully. According to the method, through deep fusion of domain knowledge, whole-process verification error correction and interpretability enhancement, the accuracy, robustness and user interaction experience of SQL conversion in a professional scene are improved.

Systems, methods, devices, and computer readable storage media described herein provide techniques for generating and / or repairing query language (QL) queries. In an aspect, an embedding is determined based on a request to generate a QL query. The embedding is compared to a layer embedding(s) of a deep data map to determine a similarity between a layer embedding and the embedding satisfies similarity criteria. A prompt is provided to a large language (LLM) to cause the LLM to generate the QL query, the prompt comprising a description of an item associated with the layer embedding. In another aspect, an alert indicating an undefined variable of the QL query is received. A query embedding associated with the QL query is compared to the layer embedding(s) to determine a candidate variable. The candidate variable is substituted in for the undefined variable, and a response comprising the repaired QL query is generated.

The invention provides an intelligent data query method based on a natural language, and relates to the technical field of intelligent data processing and natural language interaction.The intelligent data query method comprises the steps that firstly, enterprise original data is subjected to standard treatment, and a standardized theme database and a data directory and index definition document are constructed; key semantics are extracted based on unstructured knowledge, and a domain knowledge vector library is fused and constructed by combining document text fragments and vector representation of a mapping relation between historical questions of a user and an SQL (Structured Query Language). And after receiving a natural language question of a user, calling a large language model to identify a task type, and distinguishing knowledge questions and answers, data query and complex analysis. Executing corresponding operations according to different types: directly retrieving a vector library by knowledge questions and answers to generate answers; extracting keywords in data query and generating a query request in combination with context; and in the complex analysis, predefined workflow is judged and executed or intelligent agent processing is called, and query or analysis requirements are output.

A natural language to database query converter (converter) receives a natural language query from a user (i.e., a user utterance) and identifies a cybersecurity domain related to intent of the natural language query. The converter then generates a database query for a query language of the cybersecurity domain corresponding to the natural language query with a large language model (LLM). An initial prompt to the LLM generated by the converter specifies a grammar of the query language and instructs the LLM to generate an initial database query that functions like the natural language query and satisfies the grammar. If a lint program determines that the initial database query is not valid for the query language, the converter generates a follow-up prompt to the LLM that indicates valid database queries from which to generate a follow-up database query. A query parser retrieves data that satisfy the initial or follow-up database query and a visualization / summarization module generates graph visualizations and summaries of the retrieved data.

The invention discloses a multi-table combined natural language query SQL (structured query language) generation method, which comprises the following steps of: 1, constructing a database meta-knowledge graph, and establishing a triple storage comprising a table structure, a primary and foreign key relationship and business description for each data table; 2, receiving a natural language query request, and calculating the topic relevancy between query semantics and each database table through a pre-trained topic matching model; 3, dynamically constructing a view, and logically associating the database tables of which the theme relevancy exceeds a threshold value to form a temporary view; 4, generating a context enhancement prompt, and combining the temporary view structure, the field semantic description of the view and the view content sample to form a structured prompt; 5, inputting the natural language query and the structured prompt into the large language model to generate candidate SQL statements; and step 6, executing verification and iterative optimization on the candidate SQL statements, verifying logic correctness through SQL execution plan analysis and result sampling, and triggering and prompting a reconstruction mechanism when detection is abnormal.

According to the artificial intelligence-based data analysis system and method provided by the invention, a set of novel data analysis system architecture is designed, and key technical components such as natural language processing, a large language model, database query optimization, multi-modal visualization and a semantic knowledge graph are fused; data transmission between modules is realized through unified intermediate data objects such as a structured query intention, an analytic tree and a structured query language template object, and asynchronous collaboration is realized through event driving and a message queue mechanism, so that a non-professional user can input an analysis request through a natural language; semantic analysis, structured query language query statement generation, data query and result visualization presentation are automatically completed, the method can be widely applied to data analysis scenes in the industries of government affairs, traffic, finance, education and the like, the data use efficiency is improved, the technical threshold is reduced, and the digital decision-making ability is enhanced.

The invention relates to the technical field of artificial intelligence large language models, and discloses a data attribution analysis task processing method, system and device based on a large language model and a storage medium. The data attribution analysis task processing method is applied to data attribution equipment and specifically comprises the following steps that S101, user input is received through a multi-mode input interface, and the user input comprises natural language problems, structured data files or API data streams; by means of the natural language understanding ability of the large language model, the system can directly analyze service problems put forward by a user in a daily term, professional data query languages are not needed, non-technical personnel can conveniently use the system, the data retrieval time is shortened to be within 3 minutes from 30 minutes on average through the automatic SQL query generation technology, the efficiency is improved by 10 times, and the method is suitable for large-scale popularization and application. The system can intelligently identify the database fields corresponding to the business indexes and generate optimized query statements.

The invention relates to the technical field of semantic processing, in particular to a context-aware SQL (structured query language) generation method based on table field semantic enhancement, which comprises the following steps of: acquiring financial management and investment combination data of a user and mode information of a background database, constructing a mixed semantic index database, receiving natural language query input by the user, and generating a query result. Performing intention judgment on the query by utilizing the lightweight intention classification model, and if the intention is judged to be matched, calling a parameterized SQL template bound with the query intention and filling parameters to generate a final SQL query; if it is judged that the query intention is an exploration type intention, executing a two-stage SQL generation process, including generating an SQL skeleton according to the query intention, performing target type field recall based on the SQL skeleton, and filling the recalled field into the SQL skeleton to generate a final SQL query; and monitoring the execution performance of the final SQL query, and updating the query popularity metadata and the calculation cost metadata. According to the method, the SQL generation efficiency is improved through intelligent shunting and self-optimization.

The invention provides a data query method and system for converting a natural language into a database query language, and the method comprises the steps: analyzing the natural language input of a user through a multi-modal understanding agent on the basis of constructing a dynamic knowledge graph based on metadata, combining a historical session with a business term table, eliminating ambiguity, and generating a standardized Query, a retrieval routing agent selects a query strategy according to Query complexity, simple query directly matches a cache template, complex query traverses a knowledge graph, and related tables, fields and service constraints are returned; then, an expert committee agent generates an SQL (Structured Query Language) by adopting multi-stage collaboration, executes plan pre-evaluation, and selects a version with the highest comprehensive score; the test agent simulates and executes the SQL in the isolation environment, and verifies the grammar legality and the field permission; and finally, executing the detected SQL, and processing a result. According to the method, the accuracy of converting the natural language into the SQL (NL2SQL) in a complex database scene can be effectively improved.

The invention relates to the technical field of resource matching, and discloses a cross-platform e-commerce resource dynamic matching search method, which comprises the following steps: carrying out real-time analysis on commodity description information from different e-commerce platforms, extracting a core attribute of a commodity and generating a unified semantic representation; when cross-platform data conflicts occur, a conflict resolution strategy is dynamically generated, and the conflict resolution strategy is executed by a local preprocessing module; acquiring data content after conflict resolution, selecting a target edge node based on the data content in combination with user geographical location information, and dynamically configuring a cache data set of the target edge node; and generating corresponding multi-dimensional matching features based on user intention information in a natural query language in combination with the commodity data in the configured cache, determining a candidate commodity set and a corresponding search result based on the multi-dimensional matching features, obtaining feedback information of the user on the search result, and updating the intention analysis model and the matching strategy based on the feedback information. According to the invention, efficient cross-platform resource matching can be realized.

The invention relates to the technical field of databases, can be applied to the field of science and technology finance / digital medical treatment, and discloses a database migration method and device, electronic equipment and a storage medium. The method comprises the steps that database structured query language identifiers are defined, strategy classes corresponding to all databases are packaged, and a strategy context management container is created; receiving a target database type, dynamically loading a strategy type instance according to the type, and generating an executable query strategy chain according to the strategy type instance; when a database query request is received, matching a corresponding strategy type instance, and processing an original database query statement to generate a target database executable instruction; controlling a query strategy chain to execute a single-path or double-write-path mode through a common switch, and transmitting the instruction to a strategy type instance for execution; and analyzing a return result of the target database, performing conversion adaptation through the strategy type instance, and returning a conversion adaptation result. The method realizes automatic migration, reduces cost and risk, and improves system performance.

The invention discloses an SQL statement structure verification system based on large model and knowledge graph fusion enhancement. The SQL statement structure verification system comprises a knowledge graph construction module, an input design module, a verifier design module and an output design module. According to the method, a knowledge graph is introduced as a structured semantic support, and a closed-loop enhancement processing flow of SQL statements from generation, verification to optimization is realized in combination with a structure perception cue word design, a rule verification mechanism and a Function Call feedback interface; the defects that an existing Text2SQL method is insufficient in structural understanding, lack of semantic reasoning, weak in generalization ability, dependent on computing power and the like are overcome. According to the method, triple guarantee of semantic perception, rule driving and model assistance is realized, the accuracy, robustness and interpretability of SQL generation are remarkably improved, and the cognitive load and operation risk of non-professional users in database interaction are effectively reduced.

Techniques for grammar powered retrieval augmented generation for domain specific languages are disclosed. In some embodiments, a system, a process, and / or a computer program product for grammar powered retrieval augmented generation for domain specific languages includes automatically generating a seed dataset for a domain specific language (DSL) (e.g., a resource query language (RQL), and wherein the RQL is generated for RQL for multi-domain security applications); expanding the seed dataset for the DSL using a Large Language Model (LLM); and validating the seed dataset for the DSL, wherein the seed dataset for the DSL is input to the LLM for fine tune training of the LLM (e.g., fine-tuned for a cloud security application).

The invention discloses a natural language-to-SQL (Structured Query Language) method and system based on RAG (Random Access Gateway) enhancement, and the method comprises the steps: constructing a query intention graph through dependency syntax analysis, recognizing and complementing semantic missing components, and forming complete semantic representation; vector representation is carried out on the business term segments by adopting vectorization coding, accurate definitions of business terms are obtained from a factory structured knowledge base, and an enhanced context set is formed through expansion retrieval in a low-confidence region; an SQL template mapping network is established based on historical query records, a mapping relation matrix is generated through field candidate matching, mapping conflict positions are identified, and multiple SQL candidate sequences are generated; grammar verification is carried out on the candidate sequence to identify grammar errors, semantic consistency verification is carried out to calculate the intention alignment degree, and an optimal SQL statement is selected through a deviation correction factor; and performing formatting processing and statistical abstract on an execution result, and providing data query capability for scenes such as factory quality management and equipment maintenance.

The invention discloses a self-adaptive NL2SQL method and system based on a large language model and retrieval enhancement. The method comprises four key steps of mode linking, example enhancement and SQL generation, multi-path thinking chain fusion reasoning and multi-round self-correction. The system comprises the following modules: a knowledge base management module, an input analysis and preprocessing module, a mode link module, an example enhancement module, an SQL (Structured Query Language) generation module, an SQL fusion and optimization module, an SQL execution and feedback module, a multi-round self-correction module, a Prompt construction and context management module, a system interface module and a content generation module. The method has the advantages that multiple large models are supported, a data source is quickly accessed, a user-defined prompt structure is configured, good engineering maintainability and scene adaptability are achieved, and SQL generation accuracy, performability and universality are improved.

Methods, systems, and apparatus, including computer programs encoded on computer-storage media, for generating structured query language using machine learning. In some implementations, a system provides an interface configured to receive input comprising data processing criteria expressed in natural language text. The system receives natural language input through the interface, where the natural language input specifies one or more criteria for retrieving or generating data from a data set. The system obtains a structured query language (SQL) statement generated by an artificial intelligence or machine learning (AI / ML) model based on the natural language input, and the system provides the SQL statement through the interface.

The present application discloses a database query method and apparatus, an electronic device, and a non-volatile storage medium. The method comprises: determining a knowledge graph corresponding to a database to be queried, wherein the knowledge graph is used for representing a logical structure and an association relationship of data in said database; determining similarity scores between user question text and graph nodes in the knowledge graph, and determining a target node from among the graph nodes of the knowledge graph on the basis of the similarity scores, wherein the similarity scores are used for representing the degree of association between the graph nodes and the user question text; and on the basis of the target node, generating database schema information corresponding to said database, and using a large language model to generate, on the basis of the database schema information, a structured query language statement corresponding to the user question text.

According to the method and device for generating the SQL statement based on the natural language, the equipment and the storage medium provided by the invention, the query instruction input by the user is received, and the query instruction is the natural language; performing semantic analysis on the query instruction; performing semantic vector coding on the query instruction, and performing similarity retrieval in a preset vector database to obtain semantic enhancement information related to the query instruction; filling a preset structured prompt template with the semantic analysis result and the semantic enhancement information to obtain prompt input information; and inputting the prompt input information into a large language model to generate an SQL statement. According to the method, semantic analysis and vector coding are performed on the natural language instruction of the user, and semantic enhancement is performed in combination with the preset vector database, so that the generation process has context semantic support, and the integrating degree of the generation result and the intention of the user is effectively improved.

Systems and methods for processing search queries are provided. A method, according to one implementation, includes a step of receiving a query from a user interface, the query including one or more questions or commands pertaining to datasets stored in a relational database. The method also includes a step of generating a prompt having instructions related to how a Large Language Model (LLM) is to handle a complex query having one or more cascading dependencies. Also, the method includes a step of providing the prompt, datasets, and query to an LLM with instructions to convert the query into Structure Query Language (SQL) code.

The invention discloses a database question and answer model training method and device, a storage medium and computer equipment, and the method comprises the steps: associating standard structured query language statements, standard execution result answers and standard natural language questions, and generating training annotation data; and collecting simulation derivation problems possibly proposed for the database to obtain non-labeled data for training. Based on a GRPO reinforcement learning framework and a scoring reward function provided by a double-tower model, training is carried out on the scoring reward function by utilizing training labeling data, supervised fine tuning training is carried out on a database question and answer model, and non-labeling data for training, format rewards, executable rewards and scoring rewards of the scoring reward function are combined, so that the scoring reward function of the database question and answer model is obtained. And continuing to train the database question and answer model after supervised fine tuning training. Preliminary training is carried out through a small amount of annotation data, then subsequent training is carried out through non-annotation data, the reasoning ability of the model can be stimulated, the annotation cost is reduced, and the training efficiency is improved.

A structured query language statement generation method, executed by an electronic device, and comprising: determining a natural language text representing a query task, and determining a preset database, the preset database comprising at least one data table, and each data table comprising at least one field (101); on the basis of the natural language text, determining, from the preset database, at least one task-associated field and at least one task-associated data table which are associated with the natural language text (102); rewriting the natural language text on the basis of the task-associated field to obtain a rewritten natural language text (103); acquiring prompt information for the rewritten natural language text, the prompt information being used for guiding a query statement generation model in generating a structured query language statement (104); performing question classification on the rewritten natural language text to obtain question type information of the rewritten natural language text (105); and generating the structured query language statement of the rewritten natural language text by means of the query statement generation model on the basis of the task-associated field, the task-associated data table, the prompt information, and the question type information (106).

An illustrative method for querying multiple datasets may include generating, based on models each associated with and defining attributes of a different datasets stored in a plurality of data stores, a semantic layer defining relationships between the models and that provides a centralized application programming interface (API) for exposing the datasets by way of a common query language, receiving, by way of the centralized API, a query request for information that depends on data included in multiple datasets included in the plurality of datasets, querying, based on the query request and the relationships between the models defined by the semantic layer, the multiple datasets, and presenting, based on the querying, a query result representative of the information that depends on the data included in the multiple datasets.

The invention relates to an SQL (Structured Query Language) optimization interaction method and device based on a deep learning framework large model. The method comprises the steps that a statement construction model used for generating and optimizing SQL statements is deployed in a target system; in response to a natural language demand input by a user in the target system, identifying key elements in the natural language demand, and verifying whether the key elements exist in an enterprise data platform connected with the target system in combination with the enterprise data dictionary; inputting the target key elements passing the verification into a statement construction model, and generating a target SQL statement and a corresponding performance optimization suggestion; converting the target SQL statement into a service execution step according to the execution logic, and generating service description information; displaying the target SQL statement and the corresponding generation progress to a user in real time in an interactive interface; and displaying performance optimization suggestions and / or business description information matched with the target SQL to a user in an interactive interface to assist the user in realizing SQL operation related to enterprise business.

Methods, systems, and devices for data management are described. The method may include generating, for a database table and using a language model, candidate structured query language (SQL) queries and candidate query intents using a set of SQL query templates and table metadata for the database table, where each candidate SQL query is associated with a respective candidate query intent. The method may include validating the respective candidate query intents by translating the candidate query intent into a test SQL query and determining whether the test SQL query corresponds to a candidate SQL query associated with the candidate query intent. The method may include augmenting each query intent with contextual cues resulting in anchor query candidates for each query intent and generating anchor queries for the database table based on whether the anchor query candidates for each query intent results in identification of the database table by the language model.

The invention belongs to the technical field of urban low-carbon planning, and relates to a low-carbon community evaluation index library dynamic construction method and system. The method comprises the steps of knowledge graph mode layer construction, knowledge extraction, semantic relation enhancement and fusion and graph database storage. Defining the types of the entities and the semantic relationship between the entities to obtain a mode layer with a hierarchical topological structure; knowledge extraction: mapping the entity relationship in the mode layer into a knowledge extraction template; after an extraction result is subjected to subgraph structured organization, vector space mapping is carried out, semantic association strength among indexes is calculated, and entity alignment is carried out by adopting a knowledge fusion mechanism driven by a large language model; and importing the knowledge graph subjected to semantic relationship enhancement into a graph database through a query language. According to the method, efficient construction and expansion of the cross-domain index library can be realized; the adaptability of the index system is enhanced; and in combination with a knowledge fusion feedback mechanism, the mode layer is dynamically adjusted, so that the data processing efficiency and accuracy are improved.

The invention discloses a method and a system for querying from a natural language to an SQL (Structured Query Language) based on retrieval enhancement generation and autonomous planning. The method comprises the following steps: acquiring a multi-source knowledge base; acquiring natural language query information of a user; generating preliminary intention information according to the natural language query information of the user; generating a retrieval strategy according to the preliminary intention information; according to the retrieval strategy, performing retrieval in parallel or in series so as to obtain multi-dimensional context information; generating a prompt word with enhanced context according to the multi-dimensional context information and the natural language query information of the user; and generating an SQL statement according to the context-enhanced cue word. According to the intelligent agent method and system, the user query context can be deeply understood, the multi-dimensional knowledge base is autonomously utilized, and the high-accuracy SQL is generated.

The invention discloses an intelligent government affair question counting method and device based on a large model, equipment and a medium, and relates to the field of natural language processing, and the method comprises the steps: carrying out the standardization processing of government affair item consultation questions obtained from a target user side, obtaining corresponding standardization questions, determining a structured query language based on the standardization questions and a preset large model, and obtaining the structured query language; querying in a preset government affair database by using a structured query language; if the corresponding first target government affair data is queried in the preset government affair database, determining a first target result returned to the target user side based on the preset large model and the first target government affair data; and if the first target government affair data is not queried in the preset government affair database, querying in the Internet by using the standardized problem, and determining a second target result returned to the target user side based on the queried second target government affair data and a preset large model. Therefore, the accuracy of the government affair question service can be improved.

The invention discloses a retrieval enhancement generation method and system based on hybrid retrieval and adaptive sorting, and relates to the technical field of artificial intelligence and natural language processing. Comprising the following steps: 1, analyzing a query language and providing multi-path retrieval: receiving a natural language query input by a user, and performing semantic analysis and structured processing; starting dense vector retrieval and sparse semantic retrieval in parallel, and respectively obtaining candidate document sets from the knowledge base; 2, candidate mixed result fusion is carried out, wherein duplicate removal and preliminary fusion are carried out on candidate documents obtained through dense retrieval and sparse retrieval, and a unified candidate document pool is formed; all the candidate documents are evaluated according to the query semantic matching degree, document authority and quality, context coherence and generation task type factors, sorting weights are dynamically generated based on all the factors, and a candidate document pool is resorted; and constructing a structured context prompt prompt, inputting the structured context prompt prompt into a pre-trained large model, and generating final response content.

A system (100) for adaptive data blending across heterogeneous BI platforms for real-time decision making, comprising: (a) a data source abstraction module configured to establish standardised and secure connections with several different Business Intelligence (BI) platforms and convert their native data structures into a unified intermediate schema; (b) a real-time data ingestion and synchronisation module operable to continuously monitor and retrieve data updates from the BI platforms using event-driven mechanisms and configurable synchronisation policies; c) an adaptive data mapping and transformation module designed to intelligently harmonize, adapt, and semantically translate disparate data formats using rule-based logic and AI-assisted schema mapping; (d) a semantic context and metadata management module configured to maintain a unified data dictionary, track data sequence and maintain semantic consistency across platforms; (e) a cross-platform query orchestration engine designed to decompose common user queries, translate them into platform-specific query languages, execute them across the relevant BI platforms, and aggregate the results into a coherent output; (f) a decision intelligence and recommendation module that analyses the mixed data to generate real-time insights, alerts and contextual recommendations for decision support; and (g) a security, governance and compliance module configured to enforce access controls, maintain audit trails and ensure compliance with data protection regulations; h) the system provides seamless, real-time and secure data blending to enable consistent analytics and decision-making across heterogeneous BI environments.

A method and system for verifying a structured query language (SQL) query are provided. The method includes: receiving a first request to retrieve first data that is accessible via a database; identifying an intention of the first request; generating, based on the first request, a first SQL query to retrieve the first data from the database; predicting, based on the generated first SQL query, an output of the generated first SQL query; determining whether the predicted output matches the identified intention of the first request; generating, based on the determining of whether the predicted output matches the identified intention of the first request, a second SQL query to retrieve the first data that is accessible via the database, when the predicted output of the first SQL query does not match the identified intention of the first request.