Patents
Literature
Patsnap Eureka AI that helps you search prior art, draft patents, and assess FTO risks, powered by patent and scientific literature data.

3561 results about "Target database" patented technology

Therapeutic Target Database . Therapeutic Target Database (TTD) is a database to provide information about the known and explored therapeutic protein and nucleic acid targets, the targeted disease, pathway information and the corresponding drugs directed at each of these targets.

Database migration method and device, equipment and medium

The invention relates to the technical field of data processing, can be applied to business scenes of financial science and technology, medical health and the like, and discloses a database migration method, device, equipment and medium. And deploying a double-write control module of the application program layer to write the source database and the target database in parallel, and completing consistency verification through a data verification comparison task. And controlling a target database write-in channel according to a difference analysis result, closing a source database write-in channel in combination with a service takeover state, and completing a migration process from the source database to the target database. According to the method, full migration, application layer double writing, differential data verification and dynamic write-in channel control are combined, data consistency of the source database and the target database in the migration process is guaranteed, the source database and the target database are safely switched to after the service takeover capacity is verified, and the migration safety and continuity are improved.
Owner:CHINA PING AN LIFE INSURANCE CO LTD

Method and system for realizing data synchronization between heterogeneous databases based on logs

The invention discloses a method and a system for realizing data synchronization between heterogeneous databases based on logs. The method comprises the following steps: acquiring connection information of a source database and a target database; querying a table structure of the source end database and generating an SQL statement to establish a data mapping rule; matching a corresponding rule model from a mapping rule model library; if the matching is not successful, the system abnormally quits and prompts the user to create a new mapping model and add the new mapping model to the mapping rule model base; converting a table structure of the source end database into a JSON character string based on a standard field type; an SQL statement required by the target database is output through the data mapping engine module; the message monitoring program reads the data in the temporary storage area and converts the data into data meeting the requirements of the target database; formatting the converted data into SQL statements supported by a target database; and sending the generated SQL statement to a target database to complete data migration. Accurate and controllable synchronization of the data and the model in a heterogeneous environment is realized.
Owner:FUJIAN FUJITSU COMM SOFTWARE CO LTD

Method for generating SQL (structured query language) from natural language based on bidirectional mapping and semantic analysis

The invention provides a method for generating an SQL (Structured Query Language) by a natural language based on bidirectional mapping and semantic parsing, which relates to the technical field of database query and comprises the following steps of: extracting natural language query elements and packaging the natural language query elements into structured data, and establishing a mapping relationship from a query field to a service attribute and a physical data table by adopting a bidirectional Hash index technology; and automatically identifying multi-table association keys, performing semantic extension and compliance verification, generating an abstract syntax tree, performing processing according to user permission, and finally converting the abstract syntax tree into an SQL statement conforming to a target database syntax specification. According to the method, the accuracy and the efficiency of converting the natural language into the SQL are improved, and the flexibility and the safety of the system are enhanced.
Owner:北京科杰科技有限公司

SQL (Structured Query Language) statement generation method and system based on large language model

The invention provides an SQL (Structured Query Language) statement generation method and system based on a large language model. Target database metadata are collected, a structured dictionary is constructed, cue words adaptive to the large language model are generated in combination with a user query strategy, and accurate SQL generation is realized through a closed-loop execution optimization mechanism after model reasoning and SQL analysis. Through a large language model intelligent analysis technology, a multi-source heterogeneous database metadata dynamic adaptation technology and a closed-loop optimization mechanism for SQL statement generation, execution and feedback, the efficient and accurate SQL statement automatic generation function is achieved through the characteristics of cross-database grammar automatic adaptation, complex service requirement accurate analysis, intelligent error correction and the like. The system not only improves the working efficiency of developers, but also reduces the resource occupation and operation and maintenance cost of the system, and improves the accuracy and safety of data query and processing.
Owner:SHANXIN SOFTWARE CO LTD

Database multi-source heterogeneous data synchronization method and device

The embodiment of the invention discloses a database multi-source heterogeneous data synchronization method and device.The method comprises the steps that a data change event is monitored through an RPA robot deployed in a server where a source database is located, and when change operation of structured data or unstructured data is detected, an initial data set is generated; performing fragmentation processing on the initial data set to generate a plurality of data fragmentation tasks, and allocating the data fragmentation tasks to distributed computing nodes to execute parallel format conversion operation so as to generate a target data set; detecting a task execution state of the distributed computing node, and when a generation completion event of a target data set is detected, activating a data synchronization channel and transmitting the target data set to a target database; and performing conflict detection and identification based on an RPA conflict processing strategy configured in the target database, when a primary key conflict or a uniqueness constraint conflict is identified, updating the target database based on preset conflict merging indication information, and generating a data synchronization log.
Owner:FORTUNE TECH CO

Report chart automatic generation method based on natural language analysis and data query

The invention discloses a report chart automatic generation method based on natural language analysis and data query, which comprises the following steps: acquiring a natural language text, and constructing a slot set and an initial semantic fragment; executing consistency verification and ambiguity identification, and constructing a semantic framework; executing field standardization and mode alignment, generating a data query statement and establishing a traceability chain identifier; querying a target database to obtain an original data set, completing data quality self-correction, and generating a cleaned data set; calling an improved Mamba model to construct a constraint judgment matrix and outputting a target chart subset; generating a chart description grammar and an image annotation template, and executing image rendering, feature point recognition and image sidebar construction; and performing layout optimization and double compilation, and outputting a structured report file. According to the method, the chart generation automation level and the report compiling efficiency are improved, and the accuracy, traceability and specialty of the output content are ensured.
Owner:HANGZHOU LANQI TECHNOLOGY CO LTD

Agaricus bisporus automatic picking method, device and equipment based on artificial intelligence and medium

The invention relates to the technical field of intelligent agricultural equipment, and discloses an automatic agaricus bisporus picking method, device and equipment based on artificial intelligence and a medium. The method comprises the steps that RGB images and three-dimensional point cloud data of the agaricus bisporus growth environment are collected in real time through a binocular vision camera and a depth sensor which are installed at the tail end of a picking robot, and environment illumination parameters and cultivation bed coordinate information are obtained; inputting the RGB image into a pre-trained lightweight convolutional neural network, identifying a pileus contour, a stipe position and a maturity level of the agaricus bisporus, calculating a space coordinate, a height and a growth inclination angle of the agaricus bisporus based on the three-dimensional point cloud data, and constructing an agaricus bisporus target database; a mechanical arm picking path is generated based on the agaricus bisporus target database, and path weight parameters are optimized online through a preset reinforcement learning model; according to the maturity grade and morphological characteristics of the agaricus bisporus, the clamping force and the rotating angle of the end effector are dynamically adjusted, and automatic picking of the agaricus bisporus is completed.
Owner:FUJIAN POLYTECHNIC OF WATER CONSERVANCY & ELECTRIC POWER

SQL statement generation method and device based on large model

ActiveCN118981475AImprove final accuracyimprove semantic understandingDigital data information retrievalSemantic analysisSoftware engineeringDistributed database
The embodiment of the invention provides an SQL (Structured Query Language) statement generation method and device based on a large model, and relates to the field of distributed technologies, for example, the field of distributed databases. The method comprises the steps of obtaining an initial query statement of a user and initial database mode information of a target database; and inputting the user initial query statement and the initial database mode information of the target database into a large language model to obtain a structured query language (SQL) query statement. According to the embodiment of the invention, the SQL generation accuracy can be improved based on the large language model.
Owner:PINGCAP XINGCHEN (BEIJING) TECH CO LTD

Agile remote sensing satellite on-satellite full-autonomous task planning system

The invention discloses an on-satellite full-autonomous task planning system for an agile remote sensing satellite. Comprising an imaging target database module, a high-precision orbit prediction and orbit calculation module, a target visible arc section calculation module, an imaging task preprocessing module, a subsystem constraint model module, an imaging task planning module, a data transmission task planning module, a solid memory autonomous erasing module, an instruction data block generation module and a satellite state real-time monitoring module. By carrying out constraint modeling on subsystems or single machines such as load, data transmission, control and the like, an on-satellite full-autonomous operation process from receiving of subsystem or single machine instruction blocks from user requirements is established, satellite control is effectively simplified, and remote control uploading efficiency and on-satellite autonomous operation capacity are improved. And through a satellite state real-time monitoring module, the execution condition of tasks on the satellite, satellite state changes and the like are monitored in real time, task execution stopping, whole satellite sun-facing or re-planning are further triggered, task requirements and environment changes are quickly responded, task plans are formulated and adjusted in real time, and the task execution efficiency is improved.
Owner:BEIJING INST OF CONTROL ENG

Database data real-time synchronization method and device

The invention discloses a database data real-time synchronization method and device, and relates to the technical field of data synchronization, the method comprises the following specific steps: S100, task receiving and preprocessing: receiving a synchronization task request from a source database, including a to-be-synchronized data set and target database information, and performing data format verification and duplicate removal processing; s200, performing priority evaluation and sorting: performing priority evaluation on the synchronization tasks according to a preset rule, and performing sorting according to priorities; according to the method, the priority and the data volume of the synchronization task and the load condition of the target database are dynamically evaluated through an intelligent scheduling and load balancing mechanism, so that the execution sequence and the speed of the synchronization task are intelligently adjusted, and the task with high priority can be preferentially processed; and meanwhile, resource waste on low-load nodes or overload on high-load nodes are avoided.
Owner:GUANGZHOU RONGPENG INFORMATION TECH CO LTD

Database adaptive migration method and system based on credential environment

The invention provides a database adaptive migration method and system based on a credential environment, and relates to the technical field of data processing.The method comprises the steps that an intelligent migration model is used for analyzing the structure, including a table structure, index configuration, constraint conditions and data types, of a source database, data size distribution is calculated, and a source database structure feature result is generated; according to a source database structure feature result, automatically selecting and configuring a target database type, adjusting environment parameters of a target database, and generating target database configuration information; according to the structure of a source database and configuration information of a target database, a data mapping rule is automatically established by utilizing an intelligent migration model, and the data mapping rule comprises automatic correspondence of table names and field names, automatic conversion of data types, and an automatic migration scheme of indexes and constraints. According to the method, automatic and intelligent migration from the source database to the target database is realized through the intelligent migration model, the performance is automatically optimized, the migration report is generated, and the migration efficiency and quality are improved.
Owner:FUJIAN QIXIANGSI NETWORK TECHNOLOGY CO LTD

Multi-modal multi-source heterogeneous data fusion method

A multi-modal multi-source heterogeneous data fusion method belongs to the technical field of data processing, and comprises the following steps: S1, configuring a data pipeline from an original database to a target database, and fully extracting source data from the original database to the target database through the data pipeline to obtain a source-attached data set; s2, performing structuralization and cleaning operation on the source pasting data set to obtain a first data set; s3, dumping the first data set to obtain a second data set; s4, performing data fusion processing, including data mapping and conversion and data standardization, on the second data set to obtain a third data set; s5, performing feature extraction and processing on the third data set for different types of data to obtain a final data set; and S6, performing persistent storage on the final data set. According to the multi-modal multi-source heterogeneous data fusion method provided by the invention, the data quality problem in multi-modal multi-source heterogeneous data fusion can be effectively solved, and the consistency and reliability of a fusion result are improved.
Owner:山东齐鲁壹点传媒有限公司

Structural prompt-based reasoning collaborative SQL generation method

The invention relates to the technical field of natural language processing, and discloses a structure prompt-based reasoning collaborative SQL generation method. According to the method, a small model carries out structured analysis on natural language query and a target database mode, SQL substructures and combination sequence prompts are generated, a large model constructs a multi-path inference tree based on the prompts, and path nodes sequentially generate SQL substructure fragments. Top-k paths are screened through path node scores and path cumulative scores, comprehensive sorting is performed by applying a heuristic scoring function, and candidate SQL with the highest score is selected. And verifying and correcting the candidate SQL according to execution feedback, and outputting a final SQL result after ensuring that semantics and structures are correct. According to the method, the problems of insufficient reasoning ability of a small model, poor reasoning stability and illusion of a large model and the problems of Tree-of-Though reasoning path redundancy and frequent focus switching are solved, the reasoning reasonability and execution efficiency in a Text2SQL task are improved, and the method is suitable for an application scene from a complex natural language to structured query.
Owner:EAST CHINA UNIV OF SCI & TECH

Database test case extension method and device based on large language model and readable medium

The invention discloses a database test case extension method and device based on a large language model and a readable medium. The method comprises the following steps: constructing a feature knowledge base corresponding to each database management system; identifying an original dialect feature in an original query SQL statement of the initial database management system through an error recovery mechanism, and performing dialect mapping on the original dialect feature in a feature knowledge base corresponding to the target database management system to obtain a target dialect feature and a description and an example corresponding to the target dialect feature; inputting an original SQL (Structured Query Language) statement of the initial database management system into the conversion model, constructing a first cue word, and guiding the conversion model to generate an original SQL statement of the target database management system through the first cue word; and inputting the original query SQL statement of the target database management system into the fine-tuned variation model corresponding to the selected variation strategy, and generating the variation query SQL statement of the corresponding target database management system, thereby effectively improving the universality and reliability.
Owner:XIAMEN UNIV

Contract text structured processing method and device, equipment and storage medium

The invention provides a structured processing method and device for a contract text, equipment and a storage medium, and the method comprises the steps: carrying out the preprocessing of the contract text, generating a standardized word sequence, and enabling the standardized word sequence to comprise a plurality of word sequences and part-of-speech tagging information of each word sequence; the standardized word sequence is input into a named entity recognition model to recognize key entities in the contract text, key terms in the contract text are extracted based on a machine learning algorithm, the key entities include both parties of the contract, the amount of the contract and the name of a product, and the key terms include payment terms, delivery terms, default responsibility terms and force majeure terms; through dependency syntactic analysis and a semantic role labeling model, analyzing to obtain a semantic relationship between the key entities and the key terms; and storing the extracted key entities, key terms and semantic relationships in a target database in a structured form, and establishing a target index to support quick query. According to the invention, the error rate of manual processing is reduced.
Owner:BEIJING CESI TECH CO LTD +1

Query statement conversion method and device based on large model, equipment and medium

The invention discloses a query statement conversion method and device based on a large model, equipment and a medium, and relates to the field of computer science, and the method comprises the steps: obtaining a natural language query statement sent by a user side, comparing the natural language query statement with a high-frequency problem in a target knowledge base, and obtaining a query statement conversion result; whether a high-frequency problem with the similarity with the natural language query statement exceeding a preset similarity threshold value exists in the target knowledge base or not is judged; if the high-frequency problem that the similarity with the natural language query statement exceeds a preset similarity threshold does not exist, determining a target database table corresponding to the natural language query statement based on the target knowledge graph, and extracting a creation statement corresponding to the target database table, so as to determine target information corresponding to the target database table according to the creation statement; and analyzing the target information by using a preset large model to generate an SQL statement corresponding to the natural language query statement. According to the method and the device, the natural language query statement can be efficiently and accurately converted into the structured SQL statement.
Owner:SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD

Cross-database unified management and operation method and system

The invention provides a cross-database unified management and operation method and system, and relates to the technical field of databases, and the method comprises the following steps: establishing a connection by obtaining database connection information; extracting a database structure by using a dialect strategy processor and mapping the database structure into a unified description; converting the operation instruction into a standard intermediate statement; converting the intermediate statement into a target database execution statement by using a grammar analysis module and a conversion rule; and executing and monitoring in a transaction unit mode. Unified management and operation of different types of databases are realized, the consistency and reliability of database operation are improved, and the development difficulty of cross-database operation is reduced.
Owner:北京科杰科技有限公司

SQL cross-database conversion method and device, equipment and storage medium

The invention relates to the technical field of artificial intelligence and the field of financial science and technology, and discloses an SQL (Structured Query Language) cross-database conversion method, which comprises the following steps of: acquiring SQL data from a plurality of database systems, performing vectorization processing, storing the SQL data into an SQL vector database, and performing fine tuning training on a preset model by utilizing the data to obtain an SQL conversion model. And receiving a to-be-converted SQL statement and a target database type, analyzing the to-be-converted SQL statement through the SQL conversion model, converting the to-be-converted SQL statement into a natural language description, and generating a target SQL statement corresponding to the target database type by using the natural language description. Through the automatic SQL conversion process, the dependence on manual intervention is reduced, the accuracy and efficiency of cross-database SQL statement conversion are remarkably improved, the method is suitable for a complex multi-database operation environment, and the consistency and reliability of data processing are ensured.
Owner:CHINA PING AN PROPERTY INSURANCE CO LTD

Database migration method and device, electronic equipment and storage medium

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.
Owner:CHINA PING AN LIFE INSURANCE CO LTD

SQL (Structured Query Language) generation method and system based on large language model, terminal and medium

The invention belongs to the field of SQL generation, and particularly discloses an SQL generation method and system based on a large language model, a terminal and a medium, a natural language query statement and a target database mode are transmitted into the large language model, and N candidate tables most relevant to user query are selected and fed back by the large language model according to a first prompt word; selecting and feeding back a plurality of candidate data columns most relevant to the user query from each candidate table by the large language model according to the second cue word; retrieving an example question and answer pair similar to the user query from the vector database, wherein the example question and answer pair comprises an example question and an example SQL statement; generating a plurality of candidate SQL statements by the large language model according to the third cue word; and carrying out confidence coefficient filtering on the plurality of generated candidate SQL statements, and selecting a final SQL statement. According to the method, the natural language query statement is converted into the SQL statement through the large language model, the SQL statement generation efficiency and accuracy are improved, and then the usability and accuracy of database query are improved.
Owner:山东浪潮智慧医疗科技有限公司

Processing method and device based on database query, equipment and medium

The embodiment of the invention provides a processing method and device based on database query, equipment and a medium. The method comprises the steps that a user query problem is obtained; according to the user query question, screening out candidate database modes from a plurality of database modes in a preset database, and extracting key content information from the user query question; converting the key content information into a content identifier which can be identified by a database, and screening out a target database mode from the candidate database modes; function structure information of the user query problem is determined, and a query statement skeleton of the user query problem is determined according to the function structure information; and filling the content identifier and the target database mode in a query statement skeleton to obtain a database query statement, and executing a query operation in a database through the database query statement. The database query statement is automatically generated according to the user query problem, the query operation is executed, and the query efficiency and accuracy are remarkably improved.
Owner:CHINA TELECOM ARTIFICIAL INTELLIGENCE TECHNOLOGY (BEIJING) CO LTD

Heterogeneous database real-time synchronization method supporting full increment integration

The invention discloses a method for supporting real-time synchronization of a full-increment integrated heterogeneous database, which comprises the following steps of: designing a uniform interface layer to configure a source database and a target database, and compiling a specific adapter for each supported database type through a database adapter mode; respectively initializing a log parser, a transaction manager and a data buffer area; reading and analyzing the newly added log record, only extracting data of a change part for each data change record, and putting the extracted incremental data into a data buffer area; performing data format conversion and establishing a mapping relation between the source data model and the target data model; packaging data generated by the data capture layer into a message, sending the message to a message queue, and receiving the sent message by a real-time synchronization engine; and monitoring the whole synchronization process, and storing logs generated by the data capture layer and the real-time synchronization engine into a target database by using a message queue. The method has the advantages of real-time performance and wide supportability.
Owner:ANHUI KELI INFORMATION IND

Webpage generation method and device, electronic equipment and storage medium

The invention discloses a webpage generation method and device, electronic equipment and a storage medium, and relates to the technical field of computer software or other related fields, the method comprises the following steps: receiving demand information of a user for an expected webpage, and inputting the demand information into a target language model to obtain N pieces of component information in the expected webpage, N being a positive integer; retrieving a target database based on the N pieces of component information to obtain a retrieval result; inputting fusion demand information of the retrieval result and the demand information into the target language model to obtain a configuration code which is used for describing the page layout, the component attribute and the application logic of the expected webpage; and analyzing the configuration code to obtain a corresponding source code, and rendering the page based on the source code to obtain a target webpage corresponding to the expected webpage. According to the method and the device, the technical problem that the generated webpage does not accord with the intention of the user due to understanding limitation of a low-code platform fused with a large language model in related technologies is solved.
Owner:TRAVELSKY TECHNOLOGY LIMITED

Intelligent question and answer method and device, equipment, storage medium and program product

The invention discloses an intelligent question answering method and device, equipment, a storage medium and a program product, and relates to the technical field of business intelligence, and the intelligent question answering method comprises the steps: receiving a question input by a user; according to the problem, prompt words are generated through a preset multi-scene knowledge base, and the multi-scene knowledge base is generated based on a preset knowledge configuration file; inputting the cue word into a preset large language model to obtain a query code output by the large language model; and according to the query code, performing data query on a target database to obtain an answer of the question. According to the method, intelligent question answering of the configurable multi-scene knowledge base is realized, the problem that the existing intelligent question answering cannot effectively adapt to different scenes is solved, and the adaptive capacity of the intelligent question answering to different scenes is improved.
Owner:SHENZHEN JINZHENG YOUZHI TECH CO LTD

Multi-source heterogeneous database SQL statement sensitivity calculation method

The invention discloses a multi-source heterogeneous database SQL (structured query language) statement sensitivity calculation method, relates to the technical field of SQL query, and aims to accurately calculate and add noise of a proper magnitude in a complex SQL statement. The adopted scheme is as follows: receiving and preprocessing an SQL query request, and disassembling the SQL query request to generate an abstract syntax tree; traversing the abstract syntax tree, identifying syntax features needing to be processed, defining a rewriting rule, and modifying and optimizing corresponding nodes in the abstract syntax tree; selecting a serialization format, and converting the optimized abstract syntax tree into corresponding serialization data; and performing semantic analysis and logic analysis on the serialized data, binding semantic information contained in the request with metadata information of a target database, calling a sensitivity evaluation algorithm, and performing sensitivity calculation on the request. The sensitivity obtained through calculation is used for guiding data noise addition in an SQL query result.
Owner:INSPUR SOFTWARE TECH CO LTD

Data migration verification method and system for credential and credential platform

The invention provides a credential platform data migration verification method and system, and relates to the technical field of computers.The method comprises the steps that all to-be-migrated source data in a credential platform database are read, basic information of the source data is obtained, and a data label is set for each piece of data; reading fields and contents in the migration data, and constructing a data similarity verification model; selecting a migration path and a target database according to the migration demand, and dynamically evaluating the similarity between the source data and the target data through a data similarity verification model; verifying the migrated source data based on the target database, and performing incremental verification on data of different fields in the table; the data table of the to-be-migrated source data is verified in real time among different migration nodes, data changes on each node are verified step by step through an increment verification mechanism, if data missing or verification inconsistency occurs in the verification process, an alarm mechanism is triggered, and the problem of data missing or inconsistency can be automatically recognized and corrected.
Owner:HANGZHOU ZHONGER NETWORK TECH CO LTD

Method for realizing SQL grammar conversion of different databases based on middleware and middleware

The invention discloses a method for realizing SQL (Structured Query Language) grammar conversion of different databases based on middleware and the middleware, belongs to the technical field of databases, and aims to solve the technical problem of how to realize SQL grammar conversion of different databases through the middleware. The following operations are executed through the middleware to realize the grammar conversion of the SQL between the source database and the target data constructing an abstract syntax tree AST by taking various SQL elements as nodes; operating nodes in the AST on the basis of requirements of a target database; based on the data type in the target database, performing data type mapping by applying a data type conversion rule, and generating an SQL statement adapted to the target database; performing security check on the generated SQL statement; caching the query result and the generated SQL statement based on a caching mechanism; and recording the conversion process and query processing of the SQL statement.
Owner:INSPUR ZHUOSHU BIG DATA IND DEV CO LTD

Method and system for generating Text2SQL (Structured Query Language) driven by large language model

The invention provides a Text2SQL generation method and system driven by a large language model, and the method comprises the steps: recognizing key entities and relationships in a natural language question through the large language model, and carrying out the construction to obtain a query graph; constructing a hierarchical graph representation model based on the database mode of the target database; searching candidate sub-image sets which have the same structure as the query graph and are in semantic association with the query graph from the constructed graph representation model; and constructing a structured Prompt template based on the candidate sub-image set and the user question, generating an initial SQL statement, and outputting a final query result after grammar and semantic detection correction. According to the method, a traditional database is converted into the graph knowledge base, so that the SQL generation accuracy and performance are improved; guiding the large model to generate an SQL (Structured Query Language) meeting business requirements through knowledge graph storage and retrieval table and column information; and the accuracy of the SQL is continuously optimized by utilizing a self-adaptive feedback mechanism, so that the method is particularly suitable for a large-scale complex query scene, and self-improvement and customization of the model are realized.
Owner:SOUTH CENTRAL UNIVERSITY FOR NATIONALITIES

SQL (Structured Query Language) statement generation method and system based on long and short term memory of large language model

The invention provides an SQL statement generation method and system based on long and short term memory of a large language model, and relates to the field of man-machine interaction, the SQL statement generation method comprises the following steps: obtaining a preset large language model, and extracting mode design information of a target database of the large language model through a database administrator; analyzing and complementing the pattern design information, and generating long-term memory to introduce a large language model; extracting query elements through multiple rounds of conversations between a user and the model, and generating short-term memory to introduce a large language model; and obtaining an SQL generation task, and generating an SQL statement according to the large language model after the long-term memory and the short-term memory are introduced, so as to extract information from the target database. According to the method, the long and short term memory ability is introduced into the large language model, the flexible interaction ability of the large language model is fully utilized on the basis of a prompt word project of context learning, the user is gradually prompted and recommended to improve the query request, and the accuracy and availability of the generated SQL can be improved.
Owner:TOGEEK

Knowledge base generation method and device, electronic equipment and medium

The invention provides a knowledge base generation method and device, electronic equipment and a medium, and relates to the technical field of artificial intelligence. The method comprises the steps of obtaining knowledge data; auditing the knowledge data according to a preset rule, and taking the data passing the auditing in the knowledge data as first knowledge data; based on the first knowledge data, performing data classification and structured processing to obtain second knowledge data, and storing the second knowledge data in a target database; updating the original knowledge data by using the second knowledge data at the first moment, and storing the original knowledge data into the target database at the second moment; and responding to a target interaction instruction of the user, taking the target database as a knowledge base of the large model, and outputting response information of the target interaction instruction. Through the technical scheme provided by the invention, the problem of management difficulty caused by untimely updating of the knowledge base, various content types, complicated knowledge sources and the like in related technologies is solved, and the updating frequency and the management efficiency of the knowledge base are improved.
Owner:PICC LIFE INSURANCE CO LTD