137 results about "Database interface" patented technology

The invention discloses an RAG enhanced Text-to-SQL (Structured Query Language) query method and system for a large-scale database environment. The method comprises the following steps: constructing a vector database; based on the original query of the user, generating query enhancement description aiming at Schema recall and query enhancement description aiming at SQL (Structured Query Language) by utilizing LLM (Logistics Language Model); carrying out Schema recall and historical question and answer pair recall operations in a double-way parallel manner by utilizing an RAG technology and relying on the constructed vector database; based on query enhancement description, recalled Schema and historical question and answer pairs, generating an SQL query statement by using LLM in combination with RAG, and realizing Text-to-SQL conversion; the generated SQL query statement is subjected to post-processing optimization through a database interface, the post-processing optimization comprises grammar verification, performance optimization and error correction, the SQL query statement is combined for execution and feedback, efficient, accurate and reliable natural language query is achieved, and continuous optimization can be conducted through user feedback.

The invention belongs to the field of civil aviation, provides a civil aircraft field service operation scheduling control system, and aims to solve the problem of low cooperative efficiency of multiple links of ground service scheduling. File management is based on an Ali cloud OSS development interface, supports multi-format files, and realizes functions of permission access, encryption and the like; communication adopts an MQ / MQTT architecture to construct an IM system, and supports multi-type message transmission and http network communication; data processing packages a multi-language database interface, and internal and external network secure intercommunication is realized through a gatekeeper agent. Flight functions cover and guarantee node management and control, dynamic updating, cross-department communication, real-time flight data butt joint, task distribution of unified operation according to work types, and support of multi-terminal such as a web terminal and a handheld terminal and nailing access. Ground service multi-scene requirements can be met, and the operation efficiency and the management level are improved.

The invention relates to the technical field of information security, in particular to an intelligent evaluation method and system for network security level protection, and the method comprises the following steps: carrying out the hierarchical analysis of security policy rule dependency based on a network equipment connection relation, a router configuration file and a firewall rule list, extracting the interaction protocol and priority of a dependency item, and carrying out the hierarchical analysis of the security policy rule dependency; and identifying and correcting the existing inconsistency, and generating an optimized security policy model in combination with a network security level protection requirement. According to the invention, through the optimized security policy model, the analysis comprehensiveness and accuracy are improved, policy vulnerabilities are reduced, an access control rule path is analyzed, a database interface is combined, the systematic risk identification capability is enhanced, the vulnerability patch priority and coverage are combined, the risk prevention and control capability matrix is optimized, and the prevention and control blank area is compared; the security policy coverage depth is improved, accurate evaluation and path optimization of the network security capability are realized, and the coverage efficiency and the evaluation applicability are improved.

A method for carrying out RAG index evaluation on an RAG system put into production comprises the steps that a test set is prepared in advance, and the content of the test set is lt; an original question and a correct answer gt; a two-tuple list; the RAG index evaluation method specifically comprises the following steps of 1, calling an RAG module interface of a production environment by using an original problem in a test set, and obtaining a model reply and a reference text list; 2, the original question, the model reply, the reference text list and the correct answer form evaluation data according to an input parameter format of an evaluation framework; and 3, calling an evaluation data interface of an evaluation framework by using the evaluation data obtained in the step 2, and generating an evaluation result by the evaluation framework. According to the method, RAG evaluation can be carried out under the condition that a model and a database interface used in a production environment are not provided.

The invention discloses a three-dimensional model lightweight reconstruction and rendering method based on multi-strategy collaboration, and the method comprises the steps: 1, extracting geometric information, appearance information and semantic attribute information of a three-dimensional model, separating the geometric information from the appearance information and the semantic attribute information, and storing the semantic attribute information to a three-dimensional model database; 2, instantiating components with the same geometric structure in the three-dimensional model, realizing material sharing through a material reference mechanism, and reducing rendering overhead on the premise of not changing the structure of the model; step 3, carrying out lightweight processing on the exported geometric and appearance information to obtain reconstructed lightweight models with different precision grades; and 4, dynamically adjusting the geometric complexity of the lightweight model through the sight distance and the frame rate by using a hierarchical calculation algorithm for rendering, and meanwhile, obtaining component semantic attribute information and synthesizing the semantic attribute information by calling a three-dimensional model database interface to realize visual display of the reconstruction model.

The invention relates to an interface design method for a dynamic performance analysis and evaluation system of a virtual power plant. The interface design method comprises the following steps: dividing the dynamic performance analysis and evaluation system of the virtual power plant into a sensing layer, a communication layer, a data access layer, a data layer, a service layer, an application layer and a display layer according to functions; different interfaces are designed for each level, including a standardized data acquisition protocol and a high-frequency data transmission mechanism of a sensing layer, a multi-protocol compatibility and protocol conversion design of a communication layer, a unified data format and efficient data transmission of a data access layer, and a database interface and file storage interface design of a data layer. The authentication service, authority management and data access service of the service layer, the modular interface design and real-time data interaction of the application layer, and the cross-browser compatible design and data visualization function of the display layer. By optimizing the design of the system interface, efficient, safe and stable data processing and communication are realized, and the real-time performance, compatibility and user experience of the system are improved.

The invention relates to a battery database access system and method based on Dify and a large model question and answer mechanism, and the system comprises a front end interaction module which is responsible for carrying out information interaction with a user, receiving a natural language question of the user, and transmitting the question to a rear end for processing; the Dify agent management module is responsible for task distribution and user intention recognition; the Prompt generation and scheduling module is responsible for converting the user problem into a query request which can be understood and processed by the system; the database interface module is responsible for being connected with a new energy battery database; the large model generation module is used for generating natural language answers of the user questions through a large language model; and the context management module is responsible for storing and managing context information in multiple rounds of conversations. A user can intelligently interact with the new energy battery database through a natural language, and can easily and efficiently access information in the real-time database.

The invention relates to the technical field of big data, and discloses a database deadlock detection and analysis method, which comprises the following steps of: loading a configuration file, extracting a monitoring interval parameter and a log level parameter, connecting a target database according to the configuration file, periodically acquiring state information of affairs and resources through a database interface, and storing the state information as a state snapshot; initializing a data structure of the resource waiting graph, adding transaction nodes, resource nodes, request edges and occupation edges based on the state snapshots, performing depth-first search on the resource waiting graph to detect whether a loop exists or not, judging whether transactions and resources related to the loop form deadlocks or not, and recording related information; a report of a deadlock cause analysis and solution is generated based on the transaction state, the resource state, the loop information, the occupancy relationship, and the waiting relationship. According to the method, the state snapshot is constructed by periodically collecting the state information of the affairs and the resources, and the deadlock problem is quickly positioned and accurately analyzed in combination with initialization and dynamic updating of the resource waiting graph.

The invention provides an outline content generation method and system combined with natural language processing, and the method comprises the steps: firstly carrying out the medical semantic analysis of a medical question text inputted by a user, obtaining a question feature set, calling a medical literature database interface for retrieval based on the question feature set, and obtaining a matched medical literature knowledge set; extracting medical knowledge units with independent semantics from the literature knowledge set to generate a structured knowledge unit set, performing association matching on the structured knowledge unit set and the question feature set, distributing weights according to question type identifiers and information demand strength parameters to generate a weighted knowledge integration result, and performing knowledge integration on the weighted knowledge integration result; and finally, generating a medical question answering text according to a weighted knowledge integration result, and feeding back the medical question answering text to a user interaction interface for display, so that accurate, comprehensive and personalized medical question answering can be provided for the user, and the question answering quality and the user experience of a medical academic community are improved.

Described herein is an apparatus and method for generating a medical database query. An apparatus may include at least a processor; and a memory communicatively connected to the at least processor, wherein the memory contains instructions configuring the at least processor to receive a first natural language database query; input the first natural language database query into a large language model (LLM); receive from the LLM a feature set; using a medical database query map, generate a first medical database query as a function of the feature set; and generate, using the LLM, an aggregated output by querying a medical database interfaced with the LLM using the first medical database query.

The invention relates to the technical field of power system automation, in particular to a gateway machine double-confirmation closed-loop test system and method, and the system comprises an intelligent equipment simulation module which is used for simulating secondary equipment in an intelligent substation, achieving the transmission of remote signaling and telemetering data, and responding to remote control and remote regulation commands; the multi-source database interface module is used for being connected with a database of the tested gateway machine and querying, analyzing and monitoring data of the database; the master station protocol simulation module is used for simulating a master station protocol and communicating with the tested gateway machine; the intelligent analysis module compares and analyzes signal data from different modules through double-layer verification to ensure the consistency and accuracy of the data; the intelligent equipment simulation module, the multi-source database interface module and the master station protocol simulation module are respectively connected with the tested gateway machine and the intelligent analysis module. According to the method, the whole-process data reliability and the system function integrity are ensured.

The present invention relates to a method for executing first natural language instructions relating to desired analytical processing of data in a database stored on data storage means (12) of a first server (1), characterized in that it comprises the following being implemented by data processing means (21) of a second server (2): (a) obtaining said first instructions from a client terminal (10); (b) translating said first instructions into an abstract syntax tree; (c) generating, from said abstract syntax tree, second instructions in an object-oriented programming language different from an operating language of said database; (d) executing said second instructions in a virtual machine implemented by the data processing means (21) so as to carry out said desired analytical processing, comprising triggering requests on said database in said operating language of the database, said virtual machine using an object kernel interfacing with said database.

The invention discloses a broadband oscillation parameter identification method based on Bayesian reasoning. The method comprises the following steps: acquiring PMU oscillation recording data by connecting a WAMS database interface; setting a decomposition window length, initializing VMD parameters, and carrying out modal decomposition to obtain each oscillation mode; bayesian reasoning is carried out on the oscillation modes, and posterior parameter distribution and a mean value of broadband oscillation mode parameters (including amplitude, frequency and damping) are obtained through MCMC solving. The invention provides a broadband oscillation parameter identification method based on Bayesian reasoning, and the method system can judge and identify the modal components of complex multimode aliasing broadband oscillation signals, and accurately infer the modal information (including amplitude, frequency and damping) of the broadband oscillation data of a power grid.

The invention relates to the technical field of instruction standardization methods, and discloses an artificial intelligence-based instruction standardization method, which comprises the following steps of: obtaining structured and unstructured original data through a database interface, an API (Application Program Interface) and a social media monitoring tool; processing the collected original data by adopting a data cleaning and preprocessing method to obtain a high-quality data set; and constructing a prediction model based on the high-quality data and a deep learning algorithm, inputting the high-quality data set into the model, optimizing model parameters by adopting a training and verification method, and outputting a prediction result. According to the instruction standardization method based on artificial intelligence, multiple data sources are integrated, the diversity and integrity of data are improved, the prediction capability and response speed of the system are enhanced, the influence of invalid or wrong data on subsequent analysis is reduced through a strict data cleaning process, and the data quality of an input model is ensured.

The invention discloses an enterprise service post function analysis and management method based on big data, and relates to the technical field of data mining, and the method comprises the steps: obtaining the big data of applicants based on a database API interface of a talent recruitment platform, and constructing an applicant database; based on the function range of the enterprise vacant posts, task types covered by the function range are analyzed, and the function requirements of the enterprise vacant posts are quantified; performing association matching with an applicant database according to the function requirements of the enterprise vacant posts, screening out applicants meeting the function requirements, substituting the applicants into role positioning of a team where the enterprise vacant posts are located, and analyzing the degree of adaptation between each candidate person and the team where the enterprise vacant posts are located; and marking the candidate person with the optimal adaptation degree, and generating an enterprise vacant post recruitment task. The method has the advantages that the degree of fitting between the enterprise recruiters and the posts is improved, and meanwhile the cooperation level between the whole teams is maximized.

A system and method are disclosed for interfacing with one or more databases using natural-language queries. The system translates a natural-language input into an intermediate formal representation, such as a Concept Query Language (CQL), which references domain concepts rather than database-specific structures. A data access subsystem maps these domain concepts to database-specific queries using a domain dictionary, enabling seamless translation across heterogeneous databases and database management systems (DBMSs). The system supports distributed data retrieval, error recovery, and dynamic query planning. A presentation subsystem formats the results into user-friendly outputs such as charts or tables. The architecture allows for modular grammar and dictionary configuration, enabling rapid adaptation to new domains, schemas, or user roles without procedural code changes. This approach improves accessibility, maintainability, and scalability of database interactions by abstracting technical complexity from end users.

The invention relates to the technical field of system database management, in particular to an intelligent monitoring analysis method and system for gate opening and closing working condition data, and the method comprises the steps: obtaining fault records from a historical fault data storage library of a specified gate, and constructing a fault feature library; acquiring historical monitoring data of the sensor group, performing pattern recognition and statistical analysis to form a fault feature weight table, and storing the fault feature weight table in a data cleaning database; and classifying the sensor group through a database index technology by utilizing the fault feature weight table, the external prediction data and the sensor installation position data, and storing a classification result into a sensor level index table. And a distributed data intelligent monitoring system is formed through N independent data processing units in combination with a database interface protocol. The data processing unit comprises a data acquisition layer, a data real-time analysis layer, a data cleaning and quality control layer and a data storage and retrieval layer, and high-efficiency processing and retrieval of data are ensured.

The invention discloses a cross-database Rest interface implementation method and system based on tagging dynamic configuration, relates to the technical field of interface dynamic deployment and structure configuration management, and is used for solving the problems of difficult structure change adaptation, difficult data source dynamic binding and complex multi-source query fusion. By defining a mapping relation of an interface label, a structure snapshot and a field triple, a field with an unstable structure is identified, and a structure drift coupling map is constructed, so that the dynamic adaptation of the structure is realized. The system supports cache setting and paging according to interface granularity, supports a structure snapshot regular acquisition and version management mechanism, and ensures interface availability and consistency in a structure change process. The method has the capabilities of deployment automation, structure fault tolerance and dynamic scheduling execution, and is suitable for a REST interface management system in a multi-source heterogeneous database fusion scene.

The invention relates to a shield tunnel settlement control reinforcement method based on multi-source data fusion driving, which comprises the following steps: S1, data acquisition: acquiring multi-source heterogeneous original data through a sensor network and database interface deployed in a shield tunneling machine and a construction area; s2, data preprocessing; s3: big data analysis modeling: comprising the following sub-steps: S31: normalizing physical significance; s32, carrying out model training; s4, real-time settlement risk assessment: predicting future settlement volume and dividing risk levels to obtain a risk assessment report; s5, intelligent reinforcement decision and execution: parameters of grouting equipment or a shield tunneling machine are controlled for real-time reinforcement; and the reinforced effect data is fed back to the step S1 to form closed-loop control. Compared with the prior art, the method has the advantages that the accuracy, robustness and physical interpretability of the settlement prediction model are improved, high precision and self-optimization of the prediction model are realized, and active and accurate intervention, high integration, self-optimization and the like are realized.

An application for dynamic, granular access permissions can include a database interface, a user interface, a login process, an administrator, an event handler and an authorization process. The database interface can be an interface to an access control permissions database that stores roles, actions, or policies for users of the application. The login process can authenticate a user and determine a default set of access control permissions for that user when they are using the user interface. The administrator can provide access control permissions for a user by using the database interface. The event handler can dynamically modify access to functionality in the user interface based on an event. The authorization process can determine whether a request from the user interface is authorized before process the request. The authorization process can use access control permissions from the administrator and either a scope limited or a temporally limited access permission.

The database data synchronization system comprises a front-end operation module, a rear-end analysis module, a database interface module and a scheduling module, and the front-end operation module is realized based on Vue3 and used for receiving synchronization task information input by a user, configuring the synchronization task information into a JSON data format and sending the synchronization task information to the rear-end analysis module; the rear-end analysis module is realized based on a Go language and a Gin framework and is used for analyzing JSON data sent by the front-end operation module, and the database interface module is used for specifying an interface specification, realizing interface instances of various heterogeneous databases and supporting database type expansion by realizing the interface specification. The scheduling module comprises a process control module, a queue generation module, a data conversion module, a task scheduling module, a database interface scheduler module, a concurrent processor module and an error warning module, various databases can be easily expanded, and the efficiency and the success rate of data migration are improved by adopting field type intelligent mapping and a concurrent processing mechanism.

The invention provides a multi-source data fused power line tree barrier risk assessment and decision support system. The system mainly comprises the following steps of: 1, realizing real-time acquisition and storage of data by integrating various sensors and database interfaces; 2, preprocessing, cleaning and fusing the collected multi-source data, and extracting information valuable for tree barrier risk assessment; 3, based on the processed multi-source data, evaluating the tree obstacle risk of the power line by adopting an advanced algorithm model; and 4, making a scientific decision by a decision maker according to a risk assessment result. According to the multi-source data fused power line tree barrier risk assessment and decision support system provided by the invention, an efficient, accurate and reliable tree barrier risk assessment and decision support scheme is provided by combining advanced technologies such as big data analysis, multi-source data fusion and a decision support system according to the actual demand of power line tree barrier risk assessment.

This application provides a database interface routing method, apparatus, computer device, and storage medium. The method obtains the database type of the current service and the database type of the next service to be operated on. If the database type of the current service and the database type of the next service are inconsistent, it sends an interface routing instruction for the source database corresponding to the current service. It obtains a pre-annotated adaptive interface routing engine, searches for a database interface matching the target database type from the adaptive interface routing engine as the target interface, and routes the source database to the target interface according to the target routing rules to operate the next service. This achieves lossless database switching and intelligent routing of database interfaces, ensuring secure and lossless migration of data between different database types without affecting the current service, and improving the compatibility of services on the same platform and the efficiency and security of business operations within the platform.

The invention provides a method and system for accessing a database interface layer through an SAS language based on C + + middleware. The method comprises the following steps that the C + + middleware is called to obtain SAS statements of SAS language analysis software originating from the C + + middleware; performing word segmentation identification on database information in the SAS statement, and calling a database connection module of the C + + middleware based on the database information to establish a database connection pool; identifying the SAS statement by using the C + + middleware and converting the SAS statement into a database recognizable statement; the C + + middleware is used for transmitting the database recognizable statements to the corresponding database through the database connection pool, the problem that in the prior art, SAS language analysis software cannot be directly and efficiently connected with a universal database is solved, and high-performance, high-reliability and safe data access can be achieved.

The application relates to an interface design method of a virtual power plant dynamic performance analysis and evaluation system, which comprises the following steps: dividing the virtual power plant dynamic performance analysis and evaluation system into a perception layer, a communication layer, a data access layer, a data layer, a service layer, an application layer and a display layer according to functions; designing different interfaces for each layer, including a standardized data acquisition protocol and a high-frequency data transmission mechanism of the perception layer, multi-protocol compatibility and protocol conversion design of the communication layer, unified data format and efficient data transmission of the data access layer, database interface and file storage interface design of the data layer, authentication service, permission management and data access service of the service layer, modular interface design and real-time data interaction of the application layer, and cross-browser compatibility design and data visualization function of the display layer. Through the design optimization of the system interface, efficient, safe and stable data processing and communication are realized, and the real-time performance, compatibility and user experience of the system are improved.

The invention relates to the technical field of computer data processing, and particularly provides a configuration-based interface data automatic integration processing method which comprises the following steps: S1, configuration management, including database and interface configuration, parameter mapping rules and data storage rules; s2, an interface calling engine which comprises dynamic parameter replacement, a protocol adapter and a retry mechanism; s3, a data storage engine which comprises intelligent table establishment and transaction management; s4, performing task scheduling; s5, performing mail notification; and S6, performing data export. Compared with the prior art, the technical problem that non-technical personnel cannot autonomously connect interface data can be solved, the deployment and maintenance cost of the data acquisition system is remarkably reduced, and the data integration efficiency is improved.

The application relates to the field of gas pipeline network operation, and discloses an intelligent monitoring system and method for dynamic residual capacity of a gas pipeline network, which comprises the following steps: an industrial computer is connected with a SCADA system intermediate database interface, a production information system interface and a GMS system interface through communication optical cables; a real-time QPT metering module, a hydraulic simulation module, a risk assessment module, a scene generation module, a historical production database module, a user shipping management module and a residual capacity monitoring module are arranged in the industrial computer; the production information system interface is connected with the historical production database module, the SCADA system intermediate database interface is connected with the real-time QPT metering module, and the GMS system interface is connected with the user shipping management module; the historical production database module, the real-time QPT metering module and the user shipping management module transmit the received information to the scene generation module, the hydraulic simulation module, the risk assessment module and the residual capacity monitoring module in sequence after processing, and the dynamic residual capacity is calculated in real time.

Embodiments of the present application provide a read-write separation method, an electronic device and a storage medium. The read-write separation method comprises: in response to receiving a service request, intercepting an interface in the service request marked with a first annotation, and obtaining a second annotation marked on an interface method of the interface; the first annotation is used to indicate that the interface is a database interface, and the second annotation is used to indicate a data source required by the interface method, the data source comprising a master data source and a slave data source; and based on the second annotation, a target data source used when executing an SQL statement in the service request is selected. In the embodiments of the present application, the interface method in the database interface can be intercepted without concerning the business logic, so even if the business logic of the master data source and the slave data source exists in the interface method at the same time, the data source required for use can be accurately selected based on the second annotation when executing the SQL statement in the interface method, so that the read-write separation can be more accurately implemented.

The invention discloses a voice medical equipment query system based on mobile equipment, and belongs to the field of medical equipment management, information technology, voice recognition technology, natural language processing technology and database technology, and the system comprises a mobile application interface which is used for receiving voice input of a user and displaying a query result of medical equipment information; the voice recognition module is used for converting a voice instruction of a user into a text and optimizing terms of the medical industry; the natural language processing module is used for analyzing the query intention of the user and generating a query request for the medical instrument database; a database interface module; according to the hospital medical instrument information query system, mobile equipment, a voice recognition technology, a natural language processing technology and a database technology are integrated, the efficiency and the accuracy of querying medical instrument information by medical professionals are improved, and the security and the privacy of data are ensured.

The invention relates to the technical field of databases, and provides an analysis and conversion method and device for SDE.STGEOMETRY type data. The method comprises the following steps: storing original data by using an information structure; wherein the data type of the original data is SDE.STGEOMETRY type, and the data type of the original data is SDE.STGEOMETRY type; and analyzing the point information, the point set object and the entity parameters in the information structural body to obtain target geometric data. According to the method and the system, the SDE.STGEOMETRY type data is directly processed by constructing and analyzing the information structure body, connection with a database is not needed, and the problem that the SDE.STGEOMETRY type data can only be converted through a database interface and a general format is solved.