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

134 results about "Reference table" patented technology

A reference table (or table of reference) may mean a set of references that an author may have cited or gained inspiration from whilst writing an article, similar to a bibliography. It can also mean an information table that is used as a quick and easy reference for things that are difficult to remember such as comparing imperial with metric measurements. This kind of data is known as reference data.

Cross-device clock correction method supporting accurate synchronization of meters

The invention discloses a cross-device clock correction method supporting accurate synchronization of meters, and aims to improve the data time consistency among multiple meter devices and meet the requirements of high-precision electric power measurement and event analysis. The method comprises the following steps: acquiring a network time protocol timestamp and a first sampling time sequence in a reference meter, generating a clock reference signal, and broadcasting the clock reference signal to a corrected meter; comparing the corrected meter with a local second sampling time sequence, and calculating a clock skew coarse value vector; further performing wavelet decomposition on the offset coarse value, extracting to form a drift feature vector, fusing the drift feature vector with a historical template, and calculating a unified correction parameter set by using a Bayesian recursion method; and generating a correction pulse sequence carrying a delay residual compensation code based on the parameter set, sending the correction pulse sequence to a corrected meter, calling an interpolation compensation function to construct a piecewise polynomial drift compensation table, and finally realizing dynamic correction and cross-device accurate synchronization of a local real-time clock.
Owner:SHENZHEN FRIENDCOM TECH DEV +1

Intelligent AI question and answer method and device based on domain knowledge graph and table paraphrasing enhancement generation and program product

The invention provides an intelligent AI question answering method based on domain knowledge graph and table paraphrasing enhancement generation, which comprises the following steps: constructing a domain knowledge graph, and performing paraphrasing enhancement on a domain database table to obtain a table paraphrasing enhancement knowledge base; receiving a user question, and analyzing a keyword of the user question through a natural language processing technology; performing intention understanding analysis on the keyword based on a domain knowledge graph to obtain a knowledge graph retrieval result, the knowledge graph retrieval result at least comprising N pieces of similar path information matched with a user question in the knowledge graph; searching M reference tables in a table paraphrasing enhancement knowledge base based on the N pieces of similar path information; and generating an SQL query statement according to the N pieces of similar path information and the M reference tables by utilizing a language large model, and querying in a database based on the SQL query statement to obtain an answer to the user question.
Owner:NEWCAPEC ELECTRONICS CO LTD

Method and system of optimizing query input for generating codes using large language models

A method and system of optimizing query input for generating a set of code using a large language model (LLM), is disclosed. A processor receives a user query input by a user for querying the LLM to generate the set of code corresponding to a user-defined coding language. A set of primitive queries are determined from the user query based on the predefined keyword reference table and using an NLP model. Metadata is determined from the set of primitive queries. A query type is determined from a set of predefined query types of the user query using a machine learning model. An optimized query is determined based on the query type and the metadata using the NLP model and a historical database. The set of code is determined corresponding to the user-defined coding language based on the query type and the optimized query by querying the LLM.
Owner:L&T TECH SERVICES LTD

Computer implemented method for defect detection in an object comprising integrated circuit patterns and corresponding computer-readable medium, computer program and system

The invention relates to a computer implemented method for defect detection in an object comprising integrated circuit patterns comprising: obtaining an imaging dataset and a reference dataset of the object; generating an input representation of a subset of the imaging dataset and a reference representation of a corresponding subset of the reference dataset in a feature space; and detecting defects in the object by comparing the input representation to the reference representation in the feature space. The invention also relates to a corresponding computer-readable medium, computer program product and system for defect detection.
Owner:CARL ZEISS SMT GMBH

Capturing temporary database tables for analyzing a database query

Methods for capturing temporary database tables for analyzing a database query are provided. Aspects include obtaining a capture pattern and the database query having a sequence of statements. Aspects also include determining that a first statement of the sequence of statements matches the capture pattern, creating a list of temporary tables based on the first statement, and determining that a second statement of the sequence of statements includes one of a drop, commit, and truncate commands that correspond to a table in the list of temporary tables. Aspects further include creating a copy of the table in the list of temporary tables, generating an updated first statement by replacing a reference to the table in the list of temporary tables with a reference to the copy of the table, removing the table from the list of temporary tables, and executing the database query by performing the sequence of statements.
Owner:INTERNATIONAL BUSINESS MACHINE CORPORATION

Multi-modal data archiving processing system based on cloud computing

The invention provides a multi-modal data archiving processing system based on cloud computing, and relates to the technical field of data processing, and the system is used for obtaining an archiving request and an archiving task, determining an archiving type, a processing priority and a task number according to the archiving request and the archiving task, recording a memory identifier, an execution path and a cache address of a processing node, and storing the memory identifier, the execution path and the cache address of the processing node; the method comprises the following steps: extracting a structured field group and an unstructured content block of an archiving task, mapping the structured field group according to fields to generate a structure reference table, segmenting the unstructured content block according to a time sequence to generate a content time stream, recording each field mapping and time segmentation operation, and determining a reference relationship between each field mapping and time segmentation operation and a processing node; and determining a task number, a resource state and a data fragment of each processing node to obtain state anchoring data, combining the structure reference table and the content time stream with the state anchoring data into a double-layer archiving component, and archiving the double-layer archiving component. According to the method, content backtracking and operation backtracking can be carried out on the multi-modal data archiving process.
Owner:HANGZHOU YIKANGXIN TECH CO LTD

Method and system for calibrating an ECU function

The invention relates to a method for calibrating a control unit function of a control unit (10), in particular an ECU control unit, comprising - Providing (S10) n-dimensional lookup tables (50) and / or maps for at least one control unit function of at least one control unit (10); - Transforming (S20) the n-dimensional lookup tables (50) into a channel-based data representation (220); - Processing (S30) the channel-based data representation (220) in a calibration module (400), wherein the calibration module (400) comprises a software application with artificial intelligence algorithms that generates calibration results (470) from the channel-based data representation (220); - Calculating (S40) output data (550) from the calibration results (470) in a transformation form of modified lookup tables (55) and / or maps for calibrating the control unit function of the control unit (10).
Owner:DR ING H C F PORSCHE AG

Method and system for controller to automatically generate graphical control logic

The invention belongs to the technical field of power grids, and particularly relates to a method and system for a controller to automatically generate graphical control logic. The invention discloses a method and a system for automatically generating graphical control logic by a controller. The method comprises the following steps of: storing control logic information by utilizing a configuration database; loading a database, reading an algorithm model, an algorithm instance and an algorithm parameter reference table in the database, and automatically generating visual control logic; and generating a corresponding control logic diagram based on label analysis. By automatically generating and managing complex control logic, the working efficiency can be greatly improved. Through graphical representation and layout optimization, readability and maintainability of control logic can be improved. And through label analysis and reference jump, the experience of the user in the use process can be improved. A user can realize the turning among different control logic pages by clicking the reference of one algorithm instance, so that the complicated control logic can be more conveniently understood and managed.
Owner:NANJING GUODIAN NANZI WEIMEIDE AUTOMATION CO LTD

Method of estimating a direction of arrival of an electromagnetic wave at an antenna array

The invention relates to a method for estimating the direction of arrival of an electromagnetic wave at an antenna array (2), comprising the steps of: —estimating (202) a covariance matrix of signals acquired by the antenna array (2); —calculating (204) a normalised eigenvector of the covariance matrix; —correlating (205) the normalised eigenvector with a first reference table and a second reference table so as to produce a first correlation spectrum and a second correlation spectrum comprising correlation indices associated, respectively, with different directions of arrival; —constructing (312) a third reference table by linear combination of the first reference table and the second reference table with a polarisation component of the electromagnetic wave in the first direction and the second direction, respectively; —correlating (314) the normalised eigenvector with the third reference table so as to produce a third correlation spectrum comprising correlation indices associated with different directions of arrival; —identifying (316) a direction of arrival associated with a maximum correlation index of the third correlation spectrum.
Owner:SAFRAN ELECTRONICS & DEFENSE (FR)

Database selection rate determination method and device, medium and product

The invention provides a database selection rate determination method and device, a medium and a product. The method for determining the selection rate of the database comprises the steps of obtaining a query statement, wherein query conditions of the query statement comprise connection conditions of a foreign key reference table and a foreign key referenced table; searching and storing a reference column filtering condition about a reference column of the foreign key referenced table in the query statement; obtaining an initial foreign key connection selection rate for the foreign key reference table and the foreign key referenced table, wherein the initial foreign key connection selection rate is one fraction of the total row number of the foreign key referenced table; and correcting the initial foreign key connection selection rate according to a reference column filtering condition to obtain a finally used foreign key connection selection rate. Therefore, according to different filtering conditions, the method can be suitable for a more appropriate foreign key connection selection rate, so that the cardinality estimation accuracy of the connection query of the foreign key reference table and the foreign key referenced table is improved.
Owner:CETC JINCANG (BEIJING) TECH CO LTD

New well yield prediction method based on time sequence alignment and related equipment

The invention discloses a new well yield prediction method based on time sequence alignment and related equipment, and belongs to the technical field of oilfield development. Historical data of all single wells are acquired, the historical data are classified according to areas, production years and well types, and a new well yield prediction result is obtained by using a time sequence alignment method. Establishing a single-well daily oil production reference table according to regions, well types and years, and finally predicting the yield of the new well in combination with the production plan data of the new well. By adopting the method, the low-efficiency repeated labor of data collection and arrangement can be reduced, the working efficiency is improved, an existing contribution rate prediction method is replaced, the prediction precision is improved, the average prediction error rate is smaller than 5%, technical support is provided for annual production allocation, monthly production allocation, planning scheme compiling, yield monitoring and early warning services, and the method is suitable for popularization and application. And meanwhile, the method can be extended to the fields of previous-year well yield prediction and measure effect prediction, and has a wide application prospect.
Owner:PETROCHINA CO LTD

Power distribution network equipment operation data event association analysis method and system

The invention provides a power distribution network equipment operation data event association analysis method and system, and relates to the technical field of power distribution network operation data analysis, and the method comprises the steps: obtaining the operation data of each equipment, and formulating a construction plan containing the construction project, time, required resources, project position and other contents according to the operation data; setting the consulting authority of constructors to the construction project, constructing a consultable, and constructing a single model containing a top layer, a sub-layer and a bottom layer according to the consultable; and associating the construction plan to the single model to obtain a construction path, and sending the path to a construction principal in a preset time before construction, thereby being capable of associating the operation data of the equipment with the construction event, ensuring smooth implementation of the construction project of the power distribution network, and realizing scientific, normalized and intelligent management.
Owner:STATE GRID GANSU ELECTRIC POWER CORP +1

Document knowledge management method and system based on text retrieval enhancement generation

The invention discloses a document knowledge management method and system based on text retrieval enhancement generation, and belongs to the technical field of computer intelligence. The method comprises the steps that a document uploaded by a user is preprocessed, knowledge text blocks are divided, meta-knowledge is extracted and vectorized, and a document knowledge system is constructed; when a user puts forward a question, analyzing the question through a knowledge calling agent, and constructing a knowledge reference table containing meta-knowledge, knowledge text blocks and knowledge sources in combination with meta-knowledge and vector similarity retrieval; the user question and the knowledge reference table are fused to form a context, a large model is driven to generate an accurate answer, and knowledge tracing is provided; the question and answer effect is evaluated according to user feedback and knowledge reference accuracy, if the effect is good, question and answer pairs are stored as new knowledge, document slice parameters and the knowledge retrieval range are dynamically adjusted according to the evaluation result, and continuous optimization of a knowledge system is achieved. According to the method, the accuracy of semantic comprehension and retrieval can be improved, and the utilization capability of document knowledge is enhanced.
Owner:JIANGXI NORMAL UNIV

Estimating the Confidence of the Output of a Generative Machine Learning Model

PendingUS20260252965A1EngineeringMachine
A method for estimating a level of confidence of a response that a AI / ML model delivers in response to a query, includes obtaining a representation of the query in a space; determining a closeness of the representation to one or more reference representations of reference inputs that are known to belong to a domain of validity (DOV) of the AI / ML model, determining the level of confidence based at least in part on this closeness; and in response to the level of confidence being lower than a predetermined threshold: obtaining feedback whether the response provided by the AI / ML model is correct; and when this feedback indicates that the response is correct, determining that the representation of the query belongs to the DOV, wherein the query relates to a property of an industrial asset in an industrial plant, and / or of an industrial process executed on this industrial plant.
Owner:ABB (SCHWEIZ) AG

Expression editing method and device, electronic equipment and storage medium

The invention provides an expression editing method and device, electronic equipment and a storage medium. The expression editing method comprises the steps of detecting whether an expression algorithm corresponding to wafer data to be detected exists in a plurality of first reference expression algorithms in a drop-down box option of an expression editor page or not; if the to-be-detected wafer data does not exist, screening out a plurality of second reference expression algorithms from the plurality of first reference expression algorithms in the drop-down box option, performing combined operation and analysis processing on the plurality of second reference expression algorithms, and determining a target expression algorithm of the to-be-detected wafer data; and processing the to-be-detected wafer data based on a target expression algorithm to determine a result value of the to-be-detected wafer data, so as to determine whether the to-be-detected wafer has defects or not according to the result value. According to the method, the expression algorithms are combined to obtain the target expression algorithm of the wafer data, and the target expression algorithm is quickly analyzed, so that the defect of the wafer data is more accurately determined, and the product quality is improved.
Owner:赛美特信息集团股份有限公司

Automatic SRAM (Static Random Access Memory) configuration method and system based on dynamic adjustment and interpolation calculation

The invention relates to the field of chip design, in particular to an automatic SRAM (Static Random Access Memory) configuration method and system based on dynamic adjustment and interpolation calculation. The method comprises the following steps: firstly, confirming a configuration requirement and generating a matching item, searching a record completely matched with the matching item in a reference table, if the record is found, reading a minimum period corresponding to the record, judging whether the minimum period meets the requirement, if so, passing the configuration and generating an SRAM, otherwise, based on historical data points in the reference table, determining that the configuration is successful. Calculating the minimum period corresponding to the configuration requirement by using linear interpolation, judging whether the minimum period meets the requirement or not, generating the SRAM if the minimum period meets the requirement, otherwise, splitting the width or depth according to the priority, calculating the minimum period corresponding to the split width or depth, stopping splitting until the minimum period meets the requirement, and generating the SRAM according to the current width and depth. According to the invention, efficient and accurate SRAM configuration can be realized, and especially, the optimal configuration can be automatically selected in the face of technical node change.
Owner:SHANDONG SINOCHIP SEMICON CO LTD

Cache and operation method thereof

The invention provides a cache and an operation method thereof. The cache includes a reference table and a hit-miss check unit. The hit-miss check unit is coupled to the reference table. In response to one of the plurality of computing cores sending a replacement request to the cache, the hit-miss check unit checks a corresponding reference bit corresponding to a target cache line of the replacement request in the reference table. In response to the corresponding reference bit corresponding to the target cache line in the reference table indicating that the target cache line is quit, the hit-miss check unit executes the replacement request. In response to the fact that the corresponding reference bit corresponding to the target cache line in the reference table indicates that the target cache line is busy, the hit-miss check unit does not temporarily execute the replacement request until the corresponding reference bit corresponding to the target cache line of the replacement request in the reference table indicates that the target cache line is quit.
Owner:SHANGHAI BIREN TECH CO LTD

Data blood relationship construction method and device, computer equipment and storage medium

The invention provides a data blood relationship construction method and device, computer equipment and a storage medium, and belongs to the technical field of big data processing. The method comprises the steps of obtaining target business data of a to-be-constructed data blood relationship; performing structured processing on reference table data in a plurality of data rows of the target business data to obtain a first dependency relationship among the reference table data; performing structured processing on the respective field data of the multiple pieces of reference table data to obtain a second dependency relationship among the respective field data of the multiple pieces of reference table data; and constructing a data blood relationship of the target business data based on the first dependency relationship and the second dependency relationship. By adopting the method, the working efficiency of constructing the big data real blood relationship can be improved.
Owner:CHINA PING AN LIFE INSURANCE CO LTD

A browser-based PDF file parsing method, system and storage medium

The application relates to a browser-based PDF file parsing method, system and storage medium, which comprises the following steps: loading and parsing a PDF file to obtain description text associated with the PDF file; according to a PDF format rule, extracting a cross-reference table of the PDF file from the description text, and parsing a plurality of object data of the PDF file according to the cross-reference table; finding and reading the object data, and composing content elements according to position information and / or size information of the object data; according to a rendering rule of the browser, converting corresponding content in the content elements into document object model (DOM) nodes described in a hypertext markup language (HTML) + cascading style sheets (CSS) format; and rendering the content corresponding to the PDF file according to the document object model (DOM) nodes described in the hypertext markup language (HTML) + cascading style sheets (CSS) format through the browser to obtain content presented by the PDF file.
Owner:XIAMEN HUANLEGUANG TECH CO LTD +1

Motor phase current reconstruction

A system controller for a motor drive system comprising a phase current reconstructor configured to perform operations. The operations comprise receiving a stator current angle and a plurality of phase current sense signals from a plurality of respective devices that in operation drive the motor drive system, selecting, based on the received stator current angle, a reference table from among a plurality of reference tables that store reconstruction scaling factors for respective phase currents, obtaining, from the selected reference table, respective reconstruction scaling factors for the respective phase currents, generating, from the obtained reconstruction scaling factors, respective reconstructed phase current magnitude values for the plurality of devices, and outputting the reconstructed phase current magnitude values.
Owner:POWER INTEGRATIONS INC

Analysis result management device, analysis result management method, and program product

The invention relates to an analysis result management device, an analysis result management method, and a program product. This analysis result management device manages a plurality of pieces of static analysis result data obtained by analyzing a source code by means of different analysis tools, and is provided with: a warning correspondence table that associates different warning tables, which are output by different analysis tools for warnings of the same type, with identification information; an input unit that receives input of a plurality of static analysis results of the source code; and a hash value calculation unit that calculates a hash value of the alert using data relating to the alert as an input, the hash value calculation unit reading identification information when there is the identification information corresponding to the alert table that is the subject of the hash value calculation with reference to the table, and calculating the hash value of the alert based on the read identification information. Calculating a hash value by using the read identification information instead of the warning table; a database which stores the warning data and the hash value in association with each other; and a display unit that displays the data stored in the database.
Owner:DENSO CORP

Energy storage container fault early warning method and device based on real-time monitoring

The invention provides an energy storage container fault early warning method and device based on real-time monitoring, and relates to the field of intelligent models. The method comprises the following steps: constructing a standardized multi-dimensional time series data set based on multi-modal operation state data; constructing a state estimation digital twin based on the multi-dimensional time sequence data set and the energy storage container topology model; defining a system association graph structure based on the energy storage container topology model, and constructing a state reference representation based on the state estimation digital twin; constructing a space-time diagram convolutional neural network model by taking the system association diagram structure and the state reference representation as constraint conditions; outputting a system health state evaluation vector through the space-time diagram convolutional neural network model, and calculating a system fault probability index value; and outputting maintenance early warning information corresponding to the target energy storage container based on the system fault probability index value. The problem that the fault diagnosis accuracy of the energy storage container is greatly reduced due to the fact that the incidence relation between multi-source weak anomalies cannot be recognized in the prior art is solved.
Owner:XIAOGAN CORNEX NEW ENERGY INNOVATION TECHNOLOGY CO LTD

Prediction device and prediction method

Understand the effects of manipulations on biological components. [Solution] The prediction device includes a first acquisition unit that acquires a first dataset including a first set of a first sequence of a first gene involved in a trait and its phenotype, a second acquisition unit that acquires a second sequence, a first setting unit that sets an editing cost for a reference sequence based on the change between each phenotype in the first set and the reference phenotype in the reference sequence, a second setting unit that updates the editing cost, a first generation unit that generates a first list of first sequences included in the second sequence, a second generation unit that generates a second list of first sequences including the second sequence, a first identification unit that identifies a third sequence in the first list that has the smallest effect of genome editing, a second identification unit that identifies a fourth sequence in the second list that has the largest effect of genome editing, and a prediction unit that predicts a new phenotype under the second sequence based on the proportional relationship between the editing distance between different sequences and the change in each of the two sequences, the first dataset, the third sequence, the fourth sequence, and the editing cost.
Owner:NAT AGRI & FOOD RES ORG

Data query method and device, equipment and medium

The invention provides a data query method and device, equipment and a medium, and relates to the technical field of computer software, in particular to the technical field of databases. The method comprises the steps that a logic query request for a logic wide table is received, the logic wide table is constructed based on multiple physical tables, and multiple groups of dependency relationships exist among the multiple physical tables; analyzing the logic query request to determine a to-be-queried target table in a plurality of physical tables; sorting the plurality of groups of dependencies to obtain a global dependency sequence and a reference table in the plurality of physical tables; on the basis of the topological structure, determining a necessary dependence path from the reference table to the target table; respectively converting at least one necessary dependency relationship included in the necessary dependency path into physical table connection relationships, and sequentially combining the physical table connection relationships according to the sequence of the at least one necessary dependency relationship in the global dependency relationship sequence to obtain a physical query statement; and performing data query by utilizing the physical query statement.
Owner:BEIJING BAIDU NETCOM SCI & TECH CO LTD

A new well production prediction method based on time series alignment and related equipment

This invention discloses a new well production prediction method and related equipment based on time series alignment, belonging to the field of oilfield development technology. This method acquires historical data from all individual wells, classifies the historical data according to region, production year, and well type, and then uses time series alignment to establish a reference table for daily oil production of individual wells by region, well type, and year. Finally, it combines this with the production plan data of new wells to predict the production of new wells. This method reduces inefficient and repetitive data collection and processing, improves work efficiency, replaces existing contribution rate prediction methods, and improves prediction accuracy, with an average prediction error rate of less than 5%. It provides technical support for annual production allocation, monthly production allocation, planning scheme preparation, production monitoring, and early warning operations. Furthermore, it can be extended to the fields of previous year's well production prediction and measure effect prediction, showing broad application prospects.
Owner:PETROCHINA CO LTD

A Digital Rights Protection Method Based on the Extension of PDF Security Mechanism

The present invention discloses a digital copyright protection method based on the extension of the PDF security mechanism. By encrypting the cross-reference table and the root node and blocking the physical and logical entrances, any PDF parser is prevented from entering the parsing process, thus achieving an encryption effect. In addition to the document control means stipulated by the standard, custom security control options can also be extended, including the number of words copied, the number of reading times, the number of printing times, etc. At the same time, since only a very small amount of data is encrypted, the encryption and decryption performance is greatly improved, and the larger the file, the more obvious the improvement. When the downloaded PDF file is opened on the current device, if it is copied to other computers, it is ensured that the PDF file cannot be opened by any PDF reading tool, thereby preventing the spread of PDF files and achieving the copyright protection of PDF files.
Owner:XIAN YOUKAN ELECTRONIC TECH CO LTD

Detection tool based on product position detection

The utility model relates to the field of part hole detection, in particular to a detection tool based on product position detection, which comprises a detection frame, a plurality of reference stations, a plurality of reference pins, a plurality of pressure heads and a plurality of limiting blocks. The reference table is arranged on the detection frame according to the size and shape connecting line of a to-be-detected product, a reference hole is formed in the top of the reference table, and through cooperation of the reference table, the reference pin, the pressing head and the limiting block, high-precision detection of the hole position and the position degree of the product can be achieved. And particularly, the design of diversified reference pins such as the reference pin B and the reference pin C is adopted, so that the detection of hole sites with different shapes and sizes can be adapted, and the accuracy and the reliability of detection are greatly improved.
Owner:WUXI MICRO RES PRECISION PRESS PARTS

Hash connection implementation method, electronic equipment, computer readable storage medium and computer program product

The invention discloses a Hash connection implementation method, electronic equipment, a computer readable storage medium and a computer program product, and the method comprises the steps: creating a reference table according to an implementation method for foreign key reference and connection query based on an array index, automatically creating a reference array index for the reference table through a specified option when the reference table is created, and automatically creating a connection query result according to the reference array index. Meanwhile, a referenced array index is automatically created for the referenced table; a column of reference is added to the created reference array index, and a new reference array index is obtained; constructing a byte array according to [the maximum subscript used in the quoted array index corresponding to the quoted table / 8] + 1, and setting the content of the byte array as 0; for all records meeting conditions in the referenced table, setting a bit corresponding to the byte array as 1; all units in the reference array index are sequentially scanned, and for the matching condition, the required referenced table and the corresponding record information of the reference table are directly output to an upper-layer operator.
Owner:JIANGSU DAMENG DATABASE CO LTD

Query using device, method for producing view information, and program

It was necessary to master complex queries such as SQL to obtain the necessary information. [Solution] For each of two or more queries, an object definition having two or more object information having an object name and a table name is obtained from the query, an integrated object definition is obtained from the two or more object definitions in which the object information is made unique, the integrated object definitions are stored, and for each of two or more queries, a joined table definition is obtained from the query in which a base table name and one or more joined table information having a table name of a join operation is obtained, and an integrated table definition is obtained from the two or more joined table definitions in which the one or more joined table information that pairs with the same base table name is made unique.By using a query utilization device 1, required information can be easily obtained without having to master complex queries.
Owner:INFORMEX

SQL statement generation method and device based on multiple libraries

The invention provides an SQL statement generation method and device based on multiple libraries, and relates to the technical field of artificial intelligence. The method comprises the following steps: acquiring first table establishment information and second table establishment information of a plurality of databases in a target scene; determining first reference table building information corresponding to the to-be-processed query from the second table building information on the basis of input length limitation of a specified model; controlling the specified model to identify a database object and an object relationship related to the query to be processed according to the first reference table building information and a preset compression rule to obtain skeleton information; retrieving second reference table establishment information from the second table establishment information by using the skeleton information; and controlling the specified model to perform expansion processing on the skeleton information according to the second reference table building information and the to-be-processed query to obtain a target SQL statement corresponding to the to-be-processed query. According to the method, the length of the table building information is compressed, so that information loss can be reduced to the greatest extent, and then the accuracy of generating the SQL in the multi-library scene can be improved.
Owner:ZHUO SHIZHIXING (YIBIN) TECHNOLOGY CO LTD