312 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 an RDMA Chain-based LSM Tree key value type database access method. The method comprises the following steps: a database client sends a request containing a version number, a key and an operation type to a database server main node; the server main node analyzes the request and processes the request according to the operation type; during write operation, a new serial number is generated, and data is inserted into a skip list of a memory table MemTable; when reading operation is carried out and the version number is smaller than 0, whether a key exists or not is checked through a Bloom filter, if yes, query is carried out at a secondary node through the RDMA technology, and if not, an SSTable file in a disk is directly accessed; and when the reading operation is performed and the version number is greater than or equal to 0, preferentially searching the data of the corresponding version in the MemTable, and if the data of the corresponding version fails, querying the SSTable. Through the RDMA technology, CPU occupation and network round-trip time are reduced, and the response speed and concurrent processing capacity of the system are improved.

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.

Compact hosting of database query processors is performed using virtualization snapshots. When a request to access a database is received via a previously established connection from a client for an idle query processor that is not currently executing, a virtualization snapshot may be identified that is associated with the idle query processor. The virtualization snapshot of the query processor may be used to restore the query processor into virtual execution on a host system for the database using an origin snapshot that shares clean pages across multiple query processors on the host system. The request may be performed by the restored query processor in virtual execution on the host system.

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.

The embodiment of the invention provides a database access management method and device, electronic equipment and a storage medium. The method comprises the following steps: acquiring database configuration information, wherein the database configuration information comprises a mapping relationship between each business data source and each piece of sub-table information of a database; a persistent object interface is obtained, the persistent object interface is analyzed, an SQL execution statement of the access operation is obtained, the persistent object interface is pre-configured to execute the access operation for the database based on the request of the business object, and the access operation comprises one of data addition, data deletion, data modification and data query in the database; querying a business data source corresponding to the table division information from the database configuration information based on the table division information in the SQL execution statement; and routing the business data source to the target database. Therefore, sub-library storage of the business data is realized, coupling complexity and invasiveness of codes are reduced, and lightweight operation of sub-library processing of the business data is realized.

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.

The present invention provides a database access method and related devices based on an edge-cloud-end system. The method includes constructing an edge-cloud-end system of a terminal, an edge gateway, and a cloud server; deploying an enterprise metadata knowledge base, an AI model, and an enterprise database in the edge-cloud-end system based on customer requirements; receiving a demand prompt word input by a user through an intelligent agent in the terminal; obtaining a routing policy through the intelligent agent based on the deployment scenarios of the enterprise metadata knowledge base, the AI model, and the enterprise database and with the principle of giving priority to local gateway processing; and programmatically processing the demand prompt word based on the routing processing policy, the edge gateway, and the cloud server. The database access method of the present invention borrows an AI model for code generation, reduces the development difficulty, and the enterprise metadata knowledge base, the AI model, and the enterprise database are flexibly deployed based on customer requirements, and the terminal intelligent agent can flexibly route. The present invention has better adaptability and can better meet the enterprise requirements.

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.

The invention relates to the technical field of database security, and discloses a secure access method for a database, comprising: receiving an access request sent by a client for a target database, and generating device verification data and user verification data; presetting a database comparison table and a user password comparison table; performing preliminary verification on the equipment verification data based on the database comparison table, performing final verification on the user verification data based on the database comparison table and the user password comparison table, and if the final verification is passed, allowing the client to access the target database; and if the preliminary verification or the final verification is not passed, obtaining a temporary access application form of the database management end, performing secondary verification on the equipment verification data and the user verification data based on the temporary access application form, and if the secondary verification is passed, allowing the client to access the target database. Through a multi-verification mechanism, the risk that illegal users access the database is greatly reduced, and the security of database access is effectively improved.

The embodiment of the invention discloses an API risk assessment method, an API risk assessment device, electronic equipment, a chip and a computer readable storage medium, and the method comprises the steps that a corresponding relation between an API path and a target database is established, and the target database is a database accessed by an API; sensitive value grade labeling is carried out on sensitive data attributes in the target database; carrying out risk index labeling on the access operation type; based on the corresponding relation from the API path to the target database, the sensitive data attribute in the target database after sensitive value grade labeling and the access operation type after risk index labeling, risk evaluation is conducted on the API, and an evaluation result is obtained.

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.