283 results about "Database access" patented technology

Secure access to a database is facilitated by an LLM. A natural language (NL) query is received and passed to an LLM in a prompt along with all or part of a commands for accessing a database without passing the data stored in the database. The prompt may further include instructions to generate one or more commands to access the database to retrieve data responsive to the query. The instructions may instruct the generation of a URL to access relevant data. Data responsive to the command may be embedded in a document presented to a user. The document may be selected by the LLM in response to a second prompt. The command is executed with respect to the database only upon validating access of a user to the data referenced by the command.

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

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

The invention relates to the field of database reading, and particularly discloses an efficient database reading method based on multi-level cache optimization and dynamic index fragment.The efficient database reading method comprises the steps that high-frequency query data is accurately recognized through a sliding window algorithm, a dynamic cache loading and preheating strategy is implemented, query delay is effectively shortened, and the database burden is relieved; intelligent distribution of index fragments is realized by applying a consistent Hash algorithm, and the query efficiency is greatly improved in cooperation with distributed query routing and transaction processing optimization; the query load balancing ensures stable and efficient operation of the system in a high-concurrency scene by means of weighted polling and a minimum connection strategy in combination with real-time monitoring and an elastic capacity expansion and contraction mechanism. According to the method, the database access efficiency and the dynamic adaptive capacity are remarkably improved, and the method is particularly suitable for a large-scale distributed data processing environment.

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 discloses a database access parameter real-time cooperative processing method and device based on multi-level cache, and belongs to the technical field of computer data caching. The method comprises the steps that a version number management table is configured; establishing a four-level cache architecture of a transaction-level cache layer, a process-level cache layer, a distributed cache layer and a database cache layer; receiving a transaction request, creating a transaction level cache layer and loading current version number information; comparing the version number in the transaction level cache layer with the version number in the process level cache layer; according to the version number comparison result, obtaining parameter data from the corresponding cache level according to a preset cache access priority strategy; and when the parameter change is detected, updating the corresponding version number in the version number management table, and updating the cache layer data as required. According to the method, real-time global effectiveness of parameter change is realized, parameter consistency of in-transit transaction is guaranteed, system processing performance and throughput are improved, system reliability and fault-tolerant capability are enhanced, and system resource utilization rate is optimized.

Record-level transaction conflicts may be detected at storage nodes of a database back-end storage service. When a prepare statement is received, a storage node can determine whether another prepare statement acting on at least one of the same records has succeeded. If so, then the storage node can indicate to the database access application that there is a conflict, allowing the database access application to wait to try again or abort the transaction.

A medical imaging system includes a workstation and software configured for accessing medical image data from a database and generating one of more of 1D, 2D, 3D and 4D representations of the medical image data on one or more virtual reality imaging devices, where the virtual display is manipulatable by a user through a user interface associated with the virtual reality imaging device.

The invention discloses an AI security monitoring method and system based on database access analysis. The method comprises the following steps: acquiring an access request of a target user to a target database; based on a neural network model, predicting a key concerned field in the access request; according to a plurality of historical access records related to the target database, analyzing a field risk corresponding to the key concerned field; and determining an access strategy when the target user accesses the target database according to the field risk. It can be seen that accurate database access control based on the key concern field and risk assessment can be achieved, the safety and access efficiency of the target database are improved, and the access vulnerability risk caused by the risk field is reduced.

The invention discloses a low-altitude logistics unmanned aerial vehicle anti-interference system, and the system comprises an environment sensing module which comprises a global sensing monitoring module, an intelligent analysis module and decision module, a multi-level anti-interference execution module, and a continuous optimization module; the global sensing monitoring module comprises a basic monitoring module and an enhanced monitoring module, the basic monitoring module comprises an electromagnetic spectrum sensor, a GNSS signal detector, a laser radar, a meteorological sensor and an unmanned aerial vehicle state sensor, and the enhanced monitoring module comprises an SDR spectrum analysis unit and an environment database access module; and the intelligent analysis module and decision module comprises an interference identification and risk quantification module and a decision verification module. The invention aims to provide the low-altitude logistics unmanned aerial vehicle anti-interference system, so as to solve the problems that the unmanned aerial vehicle only depends on a traditional electromagnetic sensor to identify fixed frequency band interference in low-altitude flight, so that missed judgment and misjudged judgment are caused, and the unmanned aerial vehicle is not influenced. And excessive response or insufficient response can be solved.

Disclosed techniques relate to using machine learning for sports applications. In an example, a method for generating textual summaries using one or more generative machine learning models is disclosed. The method can include receiving, from a client device, a request for a summary of a sporting event. The method can include accessing, from a database, one or more database records including sports related data that is associated with the sporting event. The method can include formulating, from the database records, a machine learning model prompt. The method can include providing the machine learning model prompt to the one or more generative machine learning models. The method can include receiving, from the one or more generative machine learning models, a textual summary of the sporting event. The method can include outputting the textual summary to the client device.

The invention provides an autonomous controllable database intelligent adaptation method and system oriented to localization ecology, and belongs to the technical field of database middleware and cloud native resource management. When the request label is missing or wrong, JDBC metadata, a system function return value and system table structure features are collected through detection connection to generate database fingerprints, and the database type and version are recognized in the localized feature library. For an SQL execution request, parsing the SQL into an abstract syntax tree based on a unified syntax parser, rewriting nodes according to a dialect rule base to generate a target dialect SQL, and performing paging, identification column generation, identifier reference, transaction-related semantic verification, execution plan optimization and dynamic routing execution; and thermally loading from the plug-in warehouse when the driver is missing. And for the resource opening request, calling a Kubernetes Operator to automatically create a domestic database instance, and returning connection information. The system integrates a national cryptographic algorithm and behavior auditing, and realizes connection information protection and abnormal SQL detection.

The invention relates to the technical field of database security and anomaly detection, in particular to a database access anomaly detection method based on semantic vector and graph embedding, which is characterized by mainly comprising the following steps: preprocessing a data set, and extracting semantic units in the data set; a Word2Vec model is adopted to train the semantic unit, and a semantic vector of the SQL statement is generated; constructing a heterogeneous information graph taking a user, an operation type and a database table as nodes; establishing an undirected edge based on an entity association relationship, taking an association frequency as a weight, and taking a semantic vector as a node initial feature of the heterogeneous information graph; adopting a graph attention network GAT as a graph embedding algorithm to train the heterogeneous information graph, and generating a graph embedding feature corresponding to each database access statement; the graph embedding features are grouped according to a database table, and a sliding window is adopted to generate a corresponding time sequence; inputting the time sequence into the LSTM network, jointly optimizing graph embedding loss, time sequence modeling loss and regularization loss based on a designed total loss function to complete model training, and outputting time sequence features; and calculating the similarity between the output time sequence characteristics and the real image embedding characteristics, and judging whether the corresponding SQL operation is an abnormal operation or not according to a comparison result of the similarity and a threshold value. According to the method, SQL semantics, entity association and time sequence dependence multi-dimensional information can be fully fused, the accuracy and recall rate of anomaly detection are effectively improved, and reliable support is provided for database security protection.

A system (200) and a method (400) for determining the outcome of an assessment of a candidate (102(1)) are disclosed. The method (400) includes accessing assessment data (220) associated with the candidate (102(1)) enrolled in a study program from a database (204) associated with the system (200). The method (400) further includes determining a study plan for the candidate (102(1)) by mapping at least one study material with at least one learning outcome of the study program associated with the candidate 102(1). The prediction model (222) is further configured to update the study plan based on at least one behavior of the candidate (102(1)). The prediction model (222) is further configured to determine an outcome of an assessment of the candidate (102(1)) based on the at least one behavior of the candidate (102(1)) using the study plan.

The invention discloses an AI collaborative interaction system and device of a cross-platform standardized database, and relates to the technical field of AI collaborative interaction systems, the AI collaborative interaction system comprises a data processing module, a standardization module, an interface module, a data management module, a prediction module and an interaction feedback module; the data processing module is used for collecting original data by adopting a distributed crawler technology to obtain a basic data set; the standardization module is used for carrying out standardization processing on the basic data set to obtain a standardized data packet; the interface module is used for performing cross-platform database access operation on the standardized data packet by adopting an abstraction layer design method to obtain a cross-platform query result; the cross-platform query result obtained by the interface module is analyzed and optimized by adopting the machine learning algorithm, the query performance is improved, the system can automatically identify and optimize the query path through the application of the machine learning algorithm, and the query efficiency is remarkably improved.

The embodiment of the invention relates to a database access method based on a middleware system and the middleware system. Initialization is firstly executed through data middleware, a database connection request of a service application is analyzed, a target database instance is determined, and an associated application end token is obtained. And the middleware requests a target database connection credential from the configuration center, and the configuration center sends an encryption credential after verifying the token. The middleware decrypts the credential, initiates connection establishment of the target database, encapsulates the target database into a data source after successful connection, and returns the data source to the business application; and the business application indirectly accesses the target database through an interface or an identifier provided by the datastore middleware. On the premise that database connection credentials are not directly exposed, the connection between the service application and the database is safely established.

Requests for records are performed at a record-aware distributed storage system. A request at a storage service engine for records received from a database access application has a time value identified corresponding to a state of a table and storage nodes that store the records. Requests are sent to the storage nodes to obtain the records. The storage nodes may identify rowblocks with respective record identifier ranges and time value ranges corresponding to the records and the time value for the access request. A result may be returned to the database access application based on the records received from the storage nodes.

The invention relates to the technical field of power system automation, and provides a global database connection number control method and system based on an end side, and the method comprises the steps: calling a database connection assembly to achieve the access to a multi-type heterogeneous database service; the method comprises the following steps: transforming a heterogeneous database access component, adding a database connection handle state monitoring function module, and traversing heterogeneous database connection handles and releasing idle overtime database connection according to the current read-write state of the connection handles; when the non-idle database connection handle reaches the timeout time, the database connection is not forcibly released; after the database connection handle is automatically disconnected, the database connection is recovered when the current database connection handle generates the read-write request again; judging whether the current global connection number is out of limit or not, if yes, waiting until idle connection occurs, and then establishing new database connection; and setting the connection timeout time of the request database, and returning the timeout time. The method can be compatible with various types of heterogeneous databases.

The invention provides a regular batch data processing method and system and a storage medium, and relates to the technical field of batch data processing. The method comprises the following steps: importing collected field data and storing the field data in a database, creating a data index for the field data and storing the data index in a cache; sorting the data indexes in the cache by using an improved merge sorting algorithm to obtain new data indexes; setting a timed task, acquiring field data in batches from the database according to the new data index and the capture frequency of the timed task, and determining a target data processing thread through a distributed lock mechanism to acquire the field data; and forwarding the obtained field data, and sending a processing result to a specified terminal and displaying the processing result. According to the method, the data is captured through the cache according to the sorted index, the response time and the database access frequency are reduced, the field data are processed in real time in the message middleware through the timed task, a visual visual interface is generated, and the data processing and interaction efficiency is improved.

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

A system for indexing changes to an ontology into multiple databases and related methods are disclosed. The system is programmed to receive original data from data sources, transform the original data to ontology data, represent the ontology data in multiple forms respectively in the multiple databases, and process requests to access the ontology data from user accounts using the multiple databases. The system is programmed to subsequently merge changes to the ontology data based on updates from the data sources and edits from user accounts, create index data for the merged changes, and transmit the index data to the multiple databases.

The invention relates to the technical field of databases, and discloses a database access method and device, equipment and a medium, comprising: in response to a first query request, determining a target database corresponding to a target measurement point in the first query request, and calling a target connector for the target database; converting the first query request into a calling instruction adaptive to a target database based on the target connector; initiating a second query request to the target database based on the target connector and the calling instruction, and receiving an original query result returned by the target database; and processing the original query result, and generating and displaying a target chart. Different types of time sequence databases are adapted through the connector, so that unified processing of query requests and data formats is realized, and the efficiency of data query and report generation is improved.

The application relates to the technical field of computers, in particular to a distributed cloud native database management method and system. The method comprises the following steps: deploying multiple distributed database clusters based on a containerized deployment K8S framework; creating a unique database for each database cluster, and performing permission isolation at a user level; providing access to the database in a single cluster based on a memfire-cloud server provided by the K8S framework; performing user access and database access in a load balancing manner; expanding and shrinking the database cluster resources and storage space on demand; when a node fails and cannot be accessed, a K8S framework starts a new node, and database data information of the failed node is restored to the new node. The application can construct multiple distributed clusters on a K8S platform, and can add a database cluster in one key mode; the clusters are isolated from each other and do not interfere with each other, so that resource isolation between users is achieved, and database level isolation is achieved.

Embodiments of the present application disclose a database access method and device, electronic equipment and a storage medium. The method comprises: in the loading and displaying process of a target page, extracting a first query instruction built in the target page; verifying whether the first query instruction can be recognized by a backend database; if it is determined that the first query instruction cannot be recognized by the backend database, constructing an instruction conversion request matched with the first query instruction, and sending the instruction conversion request to a target middleware; wherein the target middleware is configured to convert the first query instruction in the instruction conversion request into a second query instruction that can be recognized by the backend database, and obtain database feedback data matched with the second query instruction from the backend database; receiving the database feedback data sent by the target middleware, and performing front-end display on the database feedback data. The technical solution of the embodiments of the present application can isolate the front end and the backend during the upgrading of the database front end and the backend, and does not affect the normal operation of the business.

This application relates to a distributed system processing method, apparatus, electronic device, and storage medium. The method includes: responding to a swimlane configuration request, generating a corresponding data processing instruction and sending it to a database management system, so that the database management system creates a swimlane shadow table with the same structure as the online table according to the data processing instruction, copies a specified range of target data from the corresponding online table to the swimlane shadow table, and returns; when a database access request carrying a swimlane identifier is received, rewriting the online table name in the SQL statement to the corresponding shadow table name according to the swimlane configuration rules, and routing the rewritten SQL request to the swimlane shadow table. This enables the database management system to create a swimlane shadow table with the same structure as the online table and copy a specified range of target data from the corresponding online table to the swimlane shadow table, without manual intervention in database table structure creation and data migration, greatly reducing operational complexity and improving configuration efficiency.

The invention discloses an energy storage data non-inductive access system and method based on RPC proxy and distributed storage. The system comprises a plurality of slave cabinets and a master cabinet. The slave cabinets store time sequence data and self information including cabinet identifiers, cabinet websites and database access ports in a local database, and periodically report the time sequence data through multicast; the master cabinet does not persistently store slave cabinet data, and a slave cabinet discovery module of the master cabinet monitors multicast and automatically generates and maintains a dynamic slave cabinet information list containing cabinet identifiers of the slave cabinets and database connection addresses; and the energy storage application layer initiates an SQL access request by calling a unified RPC interface of the main cabinet, an embedded database access proxy engine analyzes the SQL and queries a list, establishes connection with a target slave cabinet database, forwards and executes, and returns a result through the RPC. According to the invention, distributed storage and transparent unified non-inductive access of data are realized, capacity expansion of a main cabinet disk is avoided fundamentally, application development is simplified, and plug-and-play expansion of the system is supported.

In the present application, the 5G Core Network (5G-CN) comprises various network functions (NFs) interacting with each other over a Service-Based Architecture (SBA) interface. Each NF has specific functionality and offers a set of services to other NFs. Among them, the Unified Data Repository (UDR) is responsible for storing all information related to User Equipment (UE) in a database. This storage information contains subscription data, exposure data, application data, and policy data. Another NF called the Unified Data Management (UDM) serves as the front-end interface to UDR for accessing the subscription data of the UE(s) from the database. UDM manages data for access authentication, access authorization, user registration, user identification handling and so on. Yet another NF is Network Exposure Function (NEF) that acts as a gateway for an external untrusted application function (uAF) to avail services from 5G-CN after prior authorization and authentication based on operator policies. Apart from this, it is also responsible for translation of external information from uAF to internal information that other NFs can understand and vice versa.

A hosting service enables streamlined scaling of features that relate to data storage management. The scaling is powered by deployment of microservices, each one directed to a discrete feature of a data storage management system. In addition to scaling on demand, the disclosed hosting service provides additional value-added features, such as streamlining intra-system handling, auditing, and reporting of logs generated by microservices; standardizing exception handling; mediating port assignments for co-located microservices to avoid collisions; streamlining formats for inter-microservice communications; streamlining local database access; etc. Advantageously, the disclosed solution off-loads the storage manager, and additionally improves system performance by scaling various functions and by streamlining interoperability among components. Furthermore, the disclosed solution also enables the hosting service in general, and each discrete microservice in particular, to be enhanced, deployed, and scaled separately and asynchronously from each other and from the storage manager.

The present invention discloses a method for simplifying the addition, deletion, modification, and query of one-to-many association tables in a Java program. The method comprises the following steps: S1: designing an association table; S2: defining a basic entity class; S3: defining a business entity class; S4: defining a basic database access layer interface; S5: defining an association table database access interface; S6: defining an association table operation interface; and S7: adding addition, deletion, modification, and query methods for the association table to the association table operation interface, and completing the logic code in Java. The present invention reduces the need for repeated method definitions and SQL writing in association table functions during Java business development, shortening R&D time and saving development costs. The unified definition increases code readability, facilitates subsequent unified modification and logic iteration, and improves the versatility and reusability of association tables.

The invention discloses a method and a system for generating SQL (Structured Query Language) statements in a template configuration manner, and belongs to the technical field of database access. The method comprises the following steps: firstly, solidifying four tuples of stmttype, field,: tbl and where on a template side by using XML / JSON, locking one of four styles of% s,-, {} and: name at one time by using a placeholder style arbiter, and generating a golden sequence vector after DOM / JSON double analysis and regular global scanning; then, parameters are obtained on the data side through db / file / API three-state routing, a single quotation is automatically added to string / data class values through a silicon-level quotation hardening circuit, number class values are directly transmitted in an unvarnished mode, and object-by-object fusing check is conducted through a key integrity sniffer in a batch scene; and finally, performing mmap original text re-loading on each record by a template hot loading isolator on a generation side, and realizing page-level isolation and zero-residue output by combining SIMD replacement and cache line scouring. The method is suitable for high-security, high-concurrency and high-real-time scenes such as cloud, edges and production lines.