1439 results about "SQL" patented technology

The invention relates to the technical field of database operation and maintenance, in particular to a database operation and maintenance decision-making method and device based on a large language model.The method comprises the steps that real-time operation indexes and historical log data of a database are collected, and multi-dimensional time sequence features are extracted; and analyzing the characteristics by using a large language model, judging whether a performance bottleneck or an abnormal risk exists or not, and determining the relevance between the performance bottleneck or the abnormal risk and a database performance problem. If the risk exists, acquiring a system load sudden change trend and a resource request rate, quantifying a system pressure degree, and inputting a performance optimization model to generate an adaptive tuning strategy; calculating statement complexity through an SQL audit log, and selecting an index adjustment strategy in combination with an index optimization model; evaluating the influence of the tuning strategy and the index strategy on the throughput, the response delay and the resource utilization rate, and determining a target high-performance strategy; according to the scheme, accurate optimization and efficient operation and maintenance of database performance are realized through intelligent analysis and dynamic adjustment and optimization.

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.

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.

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.

The invention discloses a human resource data natural language query and SQL generation method and system, and relates to the technical field of SQL generation, and the method comprises the steps: preprocessing a natural language query text input by a user, and constructing a query semantic tree; traversing the query semantic tree to generate a candidate entity set, determining an unambiguous entity through a three-layer ambiguity resolution mechanism of semantic scoring, service verification and cross validation, identifying a composite intention, disassembling the composite intention into a sub-intention sequence, and generating an SQL operation instruction set in combination with a preset SQL operation mapping rule; based on the SQL operation instruction set and the human resource data association model, determining a data table set and an association path, generating a dynamic calculation logic and structured condition expression, and constructing a structured query skeleton; according to the method, the personalized SQL template is dynamically generated according to the query skeleton, after filling, grammar verification, strategy optimization and logic consistency verification are performed, and the optimized SQL statement is output, so that the query accuracy and performance are remarkably improved.

The invention provides a field NL2SQL data automatic synthesis method and system based on a large language model, and the method comprises the steps: building an SQL template library through collecting a public data set and real business query data, carrying out the grading according to the SQL complexity, and forming an SQL template set covering different difficulties; specific SQL queries are generated based on an SQL template library and a large language model, verification is carried out through multiple mechanisms such as grammar check, execution verification and result dimension consistency check, and correctness and performability of the SQL queries are ensured. Generating a plurality of candidate natural language questions according to the verified SQL query and the large language model, calculating a semantic consistency score of each candidate question and the SQL query through a cross consistency evaluation mechanism, screening out the question with the most consistent semantics as a final question-answer pair sample, and meanwhile, eliminating low-quality samples by setting a consistency threshold value, so as to obtain a final question-answer pair sample; and the data accuracy and consistency are further improved.

The invention provides an SQL statement generation method and system based on execution of feedback iterative correction, and relates to the technical field of large language models.The method comprises the steps that a query request of a user is received, and metadata information of a target database is obtained; generating a current SQL statement based on the query request and the metadata information; pre-executing the current SQL statement in a database sandbox environment; obtaining a pre-execution result, directly outputting the pre-execution result if the pre-execution result succeeds, and performing iterative loop if the pre-execution result fails; and analyzing error information in the pre-execution result, and determining an error type. According to the method, the illusion problem of a large language model is fundamentally solved, and the semantic correctness of SQL generation is ensured. And meanwhile, the iterative correction process replaces low-efficiency manual cue word adjustment, so that the use experience and the problem solving efficiency can be remarkably improved. In addition, the whole pre-execution process is completed in a sandbox environment, so that the influence of potential misoperation on production data is effectively isolated, and the safety of the system is enhanced.

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 a water conservancy intelligent question-answering system and method based on knowledge enhancement and data driving, and aims at water conservancy business structured and unstructured data query, through loop optimization driven by positive and negative examples, precise classification of secondary intentions of water conservancy problems is realized, knowledge questions and answers, data query and professional water conservancy subclass questions and answers can be distinguished, and the system and the method can be applied to water conservancy business. And the semantic analysis efficiency is improved. Aiming at the problem of low query accuracy of retrieval enhancement generation in the field of water conservancy, a differential water conservancy knowledge base oriented to professional books, industrial standards and laws and regulations is constructed, local and networking information is processed through a multi-source knowledge fusion and conflict resolution mechanism, and the accuracy, interpretability and traceability of question and answer content are improved. Aiming at the problems of complex operation and low semantic query accuracy in query of massive water conservancy business data and monitoring data, multi-layer constraint Text-to-SQL conversion is performed based on water conservancy business knowledge, high-precision semantic query and automatic visual output of water conservancy structured data are realized, and query efficiency is improved.

The invention discloses an interactive data insight system based on a large language model. The interactive data insight system comprises an intention recognition and classification module, an entity extraction module, an entity and business term alignment module, an SQL generation module and a structured query verification module. The key technical problems that an existing natural language data analysis system is insufficient in semantic understanding, inaccurate in entity alignment, weak in multi-round dialogue support, unstable in SQL generation, lack of safety and the like can be solved, semantic understanding and natural language interaction of complex business data are achieved, the data analysis threshold is greatly reduced, and the data analysis efficiency is improved. And the query efficiency and the result controllability are improved.

The invention discloses a natural language database query method and system based on large-model two-channel context enhancement, and the method comprises the steps: carrying out the parallel execution of a business link and a mode link on a query statement, and respectively outputting business context information and mode link information; carrying out vectorization fusion on the two types of information to generate combined context information; generating a query intention vector based on the combined context information, and outputting a complexity label of the query statement through a complexity calculation model; and generating a prompt template according to complexity label differentiation, inputting a large model to generate an SQL statement, and executing query. Through a double-channel cooperation mechanism, the problems of semantic ambiguity, database structure complexity, poor field adaptability and the like in natural language query are solved, query accuracy and response efficiency are improved, and the method is suitable for multi-industry complex database scenes.

A database query processing method includes receiving a natural language request for information contained within a database from a user in an application session, prompting a large language model to generate a SQL request, and receiving a particular SQL request from the large language model that is parsed to identify a command to access one or more database structures. A security predicate is appended to the command, creating a modified SQL request, to enforce one or more database access constraints constraining a user-authenticated client device that submitted the request that is not enforced in a database session between the application and a database. The modified SQL request is used to access data in the database session, and a visualization of the accessed data is caused to be displayed in the application session.

The invention discloses a method and a system for generating an SQL (Structured Query Language) query based on a natural language question. The method comprises the following steps: converting mode information of a target database and the natural language question into semantic vector representation; based on the semantic vector representation, a simplified database mode set related to SQL query is screened out through an attention mechanism; based on the natural language problem, the simplified database mode set and preset database constraint information, generating an SQL structural skeleton, and filling specific elements of the SQL structural skeleton to form a preliminary SQL query; and performing dynamic correction and verification on the initial SQL query by utilizing a large language model, and outputting a final SQL query. According to the method, association mining between user query and a database mode is effectively enhanced by utilizing a context-aware cross-encoder mechanism, and an implicit corresponding relation between a natural language problem and a database table / column can be more accurately identified and utilized.

The invention discloses a data analysis method and system based on a large model. The method comprises the steps that natural language query of a user is received; performing semantic coding and intention analysis on the natural language query based on a pre-trained large language model; based on metadata retrieval of vector similarity, obtaining metadata related to natural language query semantics from a vector database; generating corresponding structured query parameters through the large language model in combination with the obtained metadata and the natural language query; according to the structured query parameter, generating an executable structured query language statement; and executing the structured query language statement to obtain a data query result. According to the method, the problems of insufficient semantic comprehension ability, low metadata retrieval precision and poor query generation controllability in the prior art are solved.

The invention discloses a version updating method and device, equipment and a storage medium, and relates to the technical field of version updating, and the version updating method comprises the following steps: obtaining to-be-updated version information of to-be-updated software, intercepting an original structured query language (SQL), and generating a syntax tree corresponding to the original SQL, the to-be-updated version information comprises to-be-updated SQL and to-be-updated code blocks; according to the to-be-updated SQL, performing field updating on the syntax tree and then converting to generate a target SQL; according to the code task identifier of the to-be-updated code block, determining a code position of an original code block, and generating a target code; based on the target SQL and the target code, version updating and testing are conducted on the software to be updated, and a version updating task is completed. According to the method, a low-code platform can be helped to accurately identify data and code change ranges, codes and scripts are automatically combined, and the purpose of reducing version updating time is achieved.

Retrieval of structured tabular data in a retrieval-augmented generation (RAG) platform is described. An example method includes receiving a tabular file including structured data, extracting short and long metadata from the file, and generating a dataset agent object using the extracted metadata. A human-readable description is associated with the structured data, and the dataset agent object and metadata are stored in a metadata index. A natural language query is received through a query agent object rendered within a canvas including interconnected agent objects. A dataset agent object is identified based at least in part on metadata filtering using the natural language query and short metadata. A structured query conforming to structured query language syntax is generated using a large language model (LLM) and executed on the structured data. A response including the result set and dataset agent identifier is generated and transmitted to a downstream agent object for further processing.

Systems and methods are provided for enabling search and query functions. A query system having a framework, executed on one or more processors, includes a plurality of Artificial Intelligence (AI) agents working to support one of text-to-Structured Query Language (SQL) or text-to-Python, wherein the plurality of AI agents include a first AI agent prompted to act as a research analyst for performing a task of interpreting a natural language query from a user, wherein the natural language query relates to natural language to the one of text-to-SQL or text-to-Python; a second AI agent prompted to act as a search data engineer for performing a task of executing a search based on the natural language query; and a third AI agent prompted to act as a code developer for performing a task of writing code based on the search, wherein the plurality of AI agents act autonomously yet collaboratively.

Disclosed are a data query method and system, and a related device, relating to the field of artificial intelligence. The method comprises the following steps: a data query system acquires input data; obtains, on the basis of the input data, metrics to be queried as requested by a user; uses, on the basis of said metrics, a multi-agent collaborative processing strategy to confirm a data query result, the multi-agent collaborative processing strategy being used for indicating a manner of implementing data retrieval on the basis of at least one of a graph model and a vector database; and presents the data query result, wherein the graph model expresses, in a graph-based form, correspondences between the metrics and between the metrics and database table data, and the vector database expresses, in a vector-based form, descriptive texts and computational formulas of the metrics. In this way, even if the expression of input data differs from the expression of fields in the database, or if metrics to be read are not present in the database, corresponding SQL statements can still be obtained by means of the graph model or the vector database, thereby reducing the error rate of natural language query, and meeting the query requirements of users.

The invention discloses a method for generating statements from natural languages to SQL (Structured Query Language) based on a large language model agent. The method comprises the following steps of: constructing an LLM (Logical Language Model) guide table mode index for a target database; obtaining a user natural language question and extracting a keyword; searching in an LLM guidance table mode index according to the keyword, and screening related data tables; splicing the table mode information and the keywords of the related data table into a user natural language problem, and constructing an enhanced cue word; based on the large language model intelligent agent, generating SQL statements according to the enhanced cue words and verifying the SQL statements, if the SQL statements succeed in verification, obtaining the required SQL statements, and if the SQL statements fail in verification, performing iterative closed-loop correction on the generated SQL statements through an SQL statement closed-loop correction workflow; if the corrected SQL statement is successfully verified, the required SQL statement is obtained, and if the corrected SQL statement fails and the number of times of correction reaches a threshold value, the suggestions that the natural language problem of the user has defects and is modified are output. According to the method, the accuracy and success rate of SQL statement generation can be improved.

The invention provides an execution feedback and iterative optimization-based natural language to SQL (Structured Query Language) conversion method. The method comprises the following steps of: generating a plurality of candidate SQL statements; performing parallel execution on the candidate SQL statements, and capturing grammar error information in execution results and line number classification numbers of different candidate SQL return results; generating an error pattern abstract based on the grammar error information, converting the error pattern abstract into a natural language constraint instruction, and injecting the natural language constraint instruction into a prompt word generated in the next round; when the line number classification number is smaller than or equal to a preset threshold value, a self-consistency voting mechanism is adopted, a candidate SQL set with the largest number of returned same lines is selected, and the SQL with the shortest execution time is selected from the set to serve as final output. According to the method, the accuracy, robustness and execution efficiency of conversion from the natural language to the SQL can be remarkably improved by executing a feedback-driven multi-round iterative optimization mechanism.

The invention provides a method and device for generating an SQL instruction through a dialogue type natural language, and relates to the technical field of language processing.The method comprises the steps that a natural language query request input by a user is received; calling a neural symbol reasoning module to extract a query intention and a key entity list, generating a plurality of candidate SQL instructions through symbol reasoning, and evaluating confidence; if the highest confidence coefficient is lower than a set threshold value, multiple rounds of dialogue clarification are initiated and fed back to the neural symbol reasoning module; calling an adaptive SQL reconstruction engine to perform screening, reconstruction or optimization based on a dynamic data environment on the target candidate SQL instruction; and executing the final SQL instruction, obtaining a query result and returning the query result to the user. By means of the method and device, the technical problem that in the prior art, due to fuzziness of natural language query and dynamic complexity of a data environment, SQL instruction generation accuracy is low, and then query execution efficiency is affected is solved, and the query execution efficiency is improved while SQL semantic accuracy is guaranteed.

The invention discloses an association mapping method and system based on an API and a database sensitive field. Comprising the following steps: generating a tracking identifier for a current HTTP request through a global interceptor, and storing the tracking identifier and request context information into a thread context; intercepting an SQL (Structured Query Language) statement sent to a database by the application program, and analyzing the SQL statement to extract a data table name and a field name set accessed by a current HTTP (Hyper Text Transport Protocol) request; identifying sensitive fields in all access fields in the field name set; generating an associated log record based on the accessed sensitive field set, the SQL statement, the tracking identifier and the request context information; and analyzing the API response data to obtain a response field set, and establishing an association mapping relationship between the accessed sensitive field set and the response field set, so as to create complete data flow link information based on the association mapping relationship and the association log record. The data security of the sensitive data can be improved.

The invention discloses a cross-heterogeneous database data migration method and system, and the method comprises the steps: building a multi-data-source connection among multiple data sources, and enabling the multi-data-source connection to be used for representing the incidence relation between a source database and a target database; obtaining a source data table based on the migration sql, and querying source data corresponding to the source data table from a source database; converting the source data based on a preset model mapping rule to obtain target data; determining a target database into which the source data is migrated according to the multi-data source connection, and writing the target data into the target database to realize data migration; and performing data verification on the target database according to the checking rule to obtain a migration result, and generating a result report according to the migration result. According to the method, the source data is converted into the target data through the preset model mapping rule, migration obstacles caused by structural differences among heterogeneous databases are effectively solved, the consistency of the data is ensured through the checking rule, and the accuracy of data migration is improved.

The invention belongs to the technical field of data statistics, and particularly discloses a Python-based dynamic SQL (Structured Query Language) generation and data statistics method and system, a terminal and a medium. The method comprises the following steps: acquiring statistical demand configuration in an Excel file; analyzing the Excel file to generate a structured data object, and carrying out semantic analysis and metadata consistency verification on the natural language description; constructing an SQL abstract syntax tree through a Python analysis module, and executing syntax mapping and function replacement according to a database adaptation rule; connecting a target database through a Python database driver and executing an SQL query statement; and after a query result is obtained, outputting an Excel file, a visual chart or interface data. According to the method, automatic analysis, SQL dynamic generation, safe execution and intelligent result output of data statistics requirements are realized.

In one example, a method performed by a processing system including at least one processor includes automatically inferring metadata about a structured query language database, constructing, based on the metadata, a prompt for generating a new structured query language query to be executed against the structured query language database, and providing the prompt to a language model for use in generating the new structured query language query.

The invention discloses a row-level data permission authorization method and device, equipment and a medium, and relates to the technical field of computers. Comprising the following steps: registering basic data into a preset database; configuring a corresponding field management user with a field management authority for the preset service field; creating or updating a record in a user data permission table based on the user permission application to determine a permission relationship between the user identifier and the entity data; registering a service data table and a mapping relation between an entity column and an entity type in the service data table in a preset service field based on a user instruction of a field management user; and dynamically generating a permission filtering condition based on the query SQL and the user identifier so as to generate an SQL statement with permission filtering, and querying corresponding service data from the service data table based on the mapping relationship so as to generate a corresponding query result based on the service data. Therefore, the efficiency and flexibility of line-level data permission authorization can be improved on the premise of ensuring data security.

The invention provides a data dynamic exporting method and system based on template configuration. The method comprises the steps that a data exporting request for exporting data in a data source in a report form is obtained; verifying the user permission data in the request to generate a verification result; when the verification result is that the verification is passed, generating a dynamic SQL statement according to template metadata corresponding to the template classification data; executing paging query according to the dynamic SQL statement, and performing data processing and streaming writing on data acquired from a data source to which data to be exported belongs in batches; and when the paging query is finished and data processing and streaming writing of the data obtained in the last batch are completed, generating a temporary file, and returning a downloading link to the client for triggering downloading of the data in the temporary file and generating a report corresponding to the data export request. According to the method and the system, the template adjustment efficiency is improved, the memory consumption is reduced, and the big data export success rate is greatly improved.

The invention provides an automatic material identification and matching method and system for a three-dimensional model and a medium, and relates to the technical field of material management, and the method comprises the steps: constructing a standardized material database, and extracting and standardizing material attribute information; analyzing first material description information in the three-dimensional software model by utilizing an SQL (Structured Query Language), and matching the first material description information with the material attribute information to obtain a first material matching result; extracting second material description information in the project material document by using VBA programming, and matching the second material description information with the material attribute information to obtain a second material matching result; and data integration is carried out through PowerBI, and a project material state visual billboard is constructed. The technical problems that in the prior art, a unified standardized material database is lacked, material description formats in different sources are inconsistent, expression is not standard, a construction material list cannot be accurately generated, and informatization and intellectualization of project material management are limited are solved.

The invention discloses a power distribution network semantic analysis and intelligent number asking method and system based on NL2DSL, and relates to the technical field of power distribution network data query. The method comprises the following steps: receiving a natural language question of the power distribution network, clarifying fuzzy terms through multiple rounds of asking, and outputting a clarified question; based on the historical dialogue and the terminology library optimization problem, generating a standardized and optimized problem; taking a semantic layer of the power distribution network as a unique true phase source, and converting an optimized problem into an initial DSL (Digital Subscriber Line) by combining RAG and Prompt engineering; a compliance DSL is output through double-layer protection of static rule verification and dynamic service verification; and analyzing the compliant DSL and associating the pre-calculation model to generate an optimized SQL, and outputting a structured result after execution. The method can improve the query accuracy and the data security, reduces the maintenance cost, and is suitable for the full-scene intelligent number asking demand of the power distribution network.