167 results about "Database access" patented technology

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 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 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 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.

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.

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 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.

The invention provides a database access flow control method and device, a storage medium and a program product. Determining a target query statement with relatively high resource consumption from a plurality of query statements received by the target database in a near period of time under the condition of determining that the load of the target database is abnormal; extracting a target query statement template from the target query statement; determining a priority level of the target query statement template based on a pre-constructed query statement metadatabase; wherein the query statement meta-database is constructed on the basis of historical query statements, and priority levels corresponding to different query statement templates are recorded in the query statement meta-database; and determining a flow limiting strategy corresponding to the priority level of the target query statement template, so that the target database performs flow limiting processing on a subsequently received query statement belonging to the target query statement template based on the flow limiting strategy.

To provide a backup condition specification screen that a user can operate, and achieve a balance between a backup frequency according to an operational status and a storage capacity required for the backup.SOLUTION: An automatic analysis system comprises: an automatic analysis device that records an analysis result in a database; and a data backup processing section that backs up data recorded in the database to another recording device on the basis of a condition designated by a user. The automatic analysis system comprises: an input / output processing section that receives a condition for backing up data according to processing contents of the automatic analysis device; an operation condition storage section that stores the backup condition; an association information storage section that stores association information associating an access status of the automatic analysis device to the database with the processing contents of the automatic analysis device; and a database access detection section that detects the access status of the automatic analysis device to the database, and backs up data if the detected access status matches the condition stored in the operation condition storage section on the basis of the association information.SELECTED DRAWING: Figure 1A

The invention relates to the technical field of databases, in particular to a multi-database access method and system oriented to a heterogeneous database environment, and the method comprises the following steps: responding to a database access request sent by an application system, receiving and analyzing a protocol command in the database access request, and extracting to obtain an SQL (Structured Query Language) statement; performing grammar structure analysis and table field and function identification on the SQL statement, and performing item-by-item conversion and rewriting on a grammar keyword, a function and an expression according to a target database dialect rule to generate a standardized executable SQL instruction structure; the executable SQL instruction structure is sent to a target database to be executed, a CDC mechanism is triggered according to the SQL type in the execution process, and data change information is analyzed and recorded; and responding to the operation of finishing SQL execution by the target database, and returning an execution result to the application system. According to the method, the cross-database access efficiency and reliability can be improved, and the development and maintenance cost is reduced.

A method includes accessing a structured content item from a first database and event data from a second database, the event data including sets of event attributes in a multi-dimensional namespace and associated with a respective point in time; determining a relevancy profile characterizing a metric of relevancy of the structured content item over a respective time interval, the metric of relevancy including a distance in the multi-dimensional namespace between attributes associated with the structured content and the sets of event attributes; generating, using the relevancy profile, second digital content including a subset of the structured content item; and providing the second digital content for rendering on a device. Related apparatus, systems, techniques and articles are also described.

This application provides an authentication method, apparatus, medium, and electronic device. The method includes: after a client obtains a first ticket through a first key distribution center and first user identity information, obtaining second user identity information corresponding to the first user identity information; obtaining a second ticket from a second key distribution center through the second user identity information; and providing the second ticket to a server, so that the server determines whether it can receive a database access request from the client based on the second ticket. This application provides a dual-KDC authentication method that hides actual user information, thus preventing user information leakage.

Provided in the present application are a database request processing method and apparatus, an electronic device, and a readable medium. The method comprises: acquiring a database access request, the database access request comprising a database access statement; performing semantic analysis on a target statement structure of the database access statement to obtain a target statement structure identifier corresponding to the target statement structure; on the basis of the statement structure identifier, retrieving from a rate-limiting policy set a target policy entry corresponding to the target statement structure identifier, the target policy entry comprising statement execution information of the target statement structure and a target statement rate-limiting policy for the target statement structure; and if the statement execution information does not reach a rate-limiting condition in the target statement rate-limiting policy, executing the database access request.

The invention relates to the technical field of computers, in particular to a message pulling method and device and electronic equipment.The method comprises the steps that a message pulling request is obtained, and the message pulling request comprises a starting sequence number of a request for pulling a message and the pulling number; based on the reference serial number and the minimum serial number of the message cached by each cache block in the cache, performing cache block query in the cache, and determining a target cache block; wherein the reference serial number is initialized as a starting serial number; reading a target number of messages of which the serial numbers are not smaller than the reference serial number and the serial numbers are minimum in the target cache block, and adding the read messages into a return data packet; wherein the target number does not exceed the pulling number; if the number of messages in the return data packet reaches the pulling number, sending the return data packet to the client; in the message pulling process, the message pulling request is to read the required message from the target cache block, so that the access to the database is avoided, and the access pressure of the database is reduced.

An online system displays items to a user in search results based on appeasement scores for the items, adjusted according to how specific the search query is. The online system receives a search query from a user of an online system. The online system computes a query specificity score, a measure of the specificity of the search query. The online system accesses candidate items from a database that potentially match the search query. For each candidate item, the online system may compute or predict an appeasement score. The online system adjusts the appeasement score based on the query specificity score such that a more specific query weights the appeasement score lower than a less specific query. The online system may then compute a ranking score based on the adjusted appeasement score and display the candidate items to the user based on their ranking scores.

The invention provides a database access method and system supporting unified authentication and business model mapping, and the method comprises the steps: uniformly converting a query request into a standard abstract syntax tree, and intercepting an identity certificate in the query request to construct a complete authority context object; mapping the permission context object into a temporary role name with the minimum required permission, and sending the temporary role name to a key management system to generate a temporary database connection voucher; the permission context object is received, and a specific RLS predicate character string and a CLS function expression are generated based on a preset RBAC strategy rule, an RLS constraint predicate template and a CLS constraint desensitization function template; based on the business model, mapping the standard abstract syntax tree to generate an initial logic query plan; and according to the RLS predicate character string and the CLS function expression, forcibly solidifying the security policy into the initial logic query plan to generate a target logic query plan. The technical problem that authentication and authorization mechanisms are separated in the prior art is solved.

The application provides a database access method and device. The method comprises the following steps: determining a virtual IP address pre-solidified by a micro-service application; sending a connection request to the virtual IP address, so that a database connection agent on a database server side returns database metadata according to the connection request; receiving the database metadata; determining a target driver type according to a database category, loading a database driver corresponding to the target driver type, and creating a database connection pool by using the database driver according to database connection information. In the method, the micro-service application can receive the database metadata returned by the database connection agent, which comprises a database category and database connection information, by sending a connection request to the virtual IP, and dynamically constructs a database connection pool according to the database metadata. The process does not require the application to perceive information of a real database, shields differences of heterogeneous databases, realizes zero modification of configuration, and significantly reduces the workload of application deployment and operation and maintenance.

The invention provides a multi-database coprocessing system, and relates to the technical field of computer data process.The system comprises a main transaction database, a unified query scheduling module and at least one secondary database, and the main transaction database is used for processing write-in operation and storing a first data set; the first data set is recent data in a preset time range; the secondary database is used for storing a second data set synchronized from the main transaction database; the second data set is full data; the unified query scheduling module is used for determining a target service type corresponding to a query request in a plurality of preset service types when the query request is received, determining a target database access strategy corresponding to the target service type based on a corresponding relationship between the preset service type and the database access strategy, and sending the target database access strategy to the query scheduling module; and executing the target database access strategy. According to the method, on the basis of ensuring the reliability of the query result, the real-time service requirement can be met, and complex analysis can be supported.