13 results about "Database services" patented technology

This invention provides a method, device, medium, and product for collecting database statistical information. The method for collecting database statistical information includes: determining the business stage of the database; obtaining the load information of the server hosting the database, and determining the load status of the server based on the load information; determining the collection granularity of the statistical information based on the business stage and the load status; and collecting the statistical information of the database according to the collection granularity. This solution helps to balance the relationship between the benefits of statistical information collection and server resource usage, ensuring high collection benefits while avoiding excessive server resource consumption during statistical information collection, which could adversely affect the operation of database services.

This invention relates to the field of resource scheduling technology, specifically to a method and system for optimizing multi-node resource scheduling in cloud databases based on a large-scale model. The invention obtains a non-computational blocking index based on the hardware resource shortage level and processor effective execution status of computing nodes at the current sampling time. If preset abnormal conditions are met, a resource conflict score is obtained based on the matching degree between the resource consumption tendency characteristics of database services and hardware pressure indicators in the current period, as well as the load activity intensity. The target interfering service and its primary congested resource for the current period are selected. Based on the resource conflict score of the target interfering service, the cumulative congestion level of its associated database service node at the current sampling time is updated. Differential scheduling is performed on the database service node to which the target interfering service belongs based on the physical attributes of the primary congested resource. This solution eliminates implicit contention for underlying physical resources by perceiving hidden congestion, accurately attributing interference sources, and implementing differentiated governance.

This paper presents a method for real-time self-optimization in database management systems (DBMS). The adaptive on-the-fly sampling technique described in this paper estimates database content statistics, which a machine learning (ML) model can use to predict configuration settings that save computing resources such as execution time and storage space. In an embodiment, the computer repeatedly samples the database content until a dynamic convergence criterion is met. In each iteration of a series of sampling iterations, a subset of rows from the database table is sampled, and the estimate of the database table's content statistics is adjusted based on the sampled subset of rows. Upon detection of dynamic convergence, the machine learning (ML) model immediately or ultimately predicts optimal values ​​for the configuration settings used for the DBMS based on the content statistics estimate.

A computing network provides a database service and implements a caching mechanism for processing database queries. The database services are provided using a primary replica of data and computing resources, and a secondary replica of the data and computing resources. The primary and secondary replicas are synchronized so that the secondary replica can provide the database services in place of the primary replica in response to a failover from the primary replica to the secondary replica. In response to initiating, by the database service, a failover from the primary replica to the secondary replica, the cached plans compiled by the secondary replica are used to process matching query batches by the secondary replica. The secondary replica processes the matching query batches without accessing plans compiled by the primary replica.

This disclosure provides a method and apparatus for creating a database. The method is executed by a database service provider in a cloud platform and includes: receiving a database creation request, the request requesting the creation of a database for a user under a user's cloud account, the cloud platform storing the user's cloud account; and responding to the database creation request, creating the database for the user under the user's cloud account. In this disclosure, the database service provider can directly create the database for the user under the user's cloud account, enabling the user to have database management permissions. This avoids the problem in traditional database creation mechanisms where the database service provider creates the database under its own cloud account, preventing the user from managing the database.

Embodiments of the present application disclose a gRPC-based database service providing method and device, a server and a medium, the method comprising: starting a gRPC service by using a preset interface definition file, listening to a specified port of the gRPC service, and exposing a unified execution method for facilitating client calling; receiving input minimum connection number parameters and maximum connection number parameters, initializing a database connection pool according to the minimum connection number and the maximum connection number; obtaining an idle connection from the connection pool when the execution method is called to execute, creating a new connection if there is no idle connection and the maximum connection number has not been reached; determining a corresponding operation type parameter according to a parameter list, executing a corresponding logical branch in the execution method according to the operation type parameter; obtaining a calculation execution result of the corresponding logical branch and returning the execution result to the client; and returning the connection to the database connection pool when the execution method is executed. The database access performance and resource utilization are improved.

Systems and methods are disclosed to implement, in a database service, applying operations to replicas of a global table based on homing rules and item attribute values. In embodiments, an instance of a database service may receive, from a client, a request to write an item to a global table. The instance may store the item at one or more replica tables at one or more different regions based a homing rule for the global table and one or more attribute values of the item.

The embodiment of the present application provides a network operating system and a communication method, the operating system is applied to a distributed decoupling chassis network device, the network operating system comprises a control plane instance and a data plane instance, the control plane instance is installed on a server in the distributed decoupling chassis network device, and the data plane instance is installed on a white box switch. By using the operating system, at least two different software systems such as the control plane instance and the data plane instance are constructed, and the distributed decoupling chassis network operating system is realized. Different instances run on different hardware components, and cooperate to complete the cooperative work of various components in the distributed decoupling chassis network device. The control plane instance and the data plane instance are connected in communication through a message transmission channel constructed according to a tunnel creation strategy and a table item transmission channel constructed according to a database service, and can realize the transmission of message information and table item control information, so as to realize the internal communication of the distributed decoupling chassis network device.

The application belongs to the technical field of cloud computing and database, and particularly relates to a cloud database fault self-recovery system and method based on a resource arrangement engine, which comprises the following steps: collecting node operation indexes through a monitoring agent deployed on a database node; when the node operation indexes deviate from preset threshold values, analyzing fault types and affected data ranges by a fault diagnosis service to generate a fault diagnosis report; receiving the fault diagnosis report by a resource arrangement engine; sending an isolation instruction to a data processing engine by the resource arrangement engine, wherein the isolation instruction comprises an isolation strategy type and the affected data range; executing an isolation operation by the data processing engine; dynamically allocating virtual computing resources for each data subset by the resource arrangement engine, and sending a reconstruction task scheduling instruction to the data processing engine; and resuming the database service after the resource arrangement engine receives a verification pass signal. The application can shorten fault recovery time, improve data logical consistency, and ensure the security of original data.

This invention relates to the field of artificial intelligence technology and discloses a workflow intelligent orchestration method based on database MCP service, including the following steps: S1, user input; S2, LLM semantic parsing; S3, database schema knowledge base invocation; S4, SQL generation; S5, database MCP service invocation; S6, AI output analysis results. This method breaks down technical barriers, enabling non-technical personnel to participate in the construction of complex data workflows, significantly reducing the technical threshold and development costs, and achieving business-driven agile development. By providing a unified interactive entry point through visualized intelligent nodes, it achieves "zero-code" rapid delivery of data query functions, significantly improving development and orchestration efficiency. By decoupling business logic (natural language description) from execution logic (SQL code) and managing metadata through a centralized knowledge base, it greatly enhances the system's flexibility and maintainability, easily responding to business and data changes.

This invention relates to the field of data storage and disaster recovery backup technology, specifically disclosing a database recovery system based on ZFS snapshot cloning and container vertical mounting. The system includes: a metadata extraction module for extracting the database type and version number from the backup task; a storage cloning module for creating a ZFS snapshot based on the backup set and generating a readable and writable clone volume; a local mounting module for mounting the clone volume to the host machine's local directory; a container orchestration module for starting a database container of the corresponding version according to the database version number and mapping the local directory to the database data directory within the container; a service detection module for detecting the database service status and outputting a success signal; and a resource reclamation module for destroying the container and deleting the clone volume after the task is completed. This invention achieves rapid database recovery and automated verification through ZFS copy-on-write cloning and container vertical mounting technology, and supports the on-demand creation and destruction of the verification environment.

A request is received for a synchronization of data for a tenant of a multi-tenant database service, the data being stored in multiple partitions of a partitioned database. A single sync token comprising a set of sort keys is used to identify a deterministic order for changes in the data for the tenant including when timestamps for a change are identical. The changes are sorted by time, tenant, object, and property. All partitions of the partitioned database are queried, and sort and deduplication are performed to determine a set of changes to be provided in response to the request.

This invention discloses a high-concurrency system based on a hybrid model, comprising: a client, integrating the functions of the presentation layer and the business processing layer, asynchronously calling the local web service of the server, where the client completes the computation and business processing in interaction with the server, realizing distributed computing based on C / S, and bearing the pressure on the server under high client concurrency; a server, providing a user interface for the client; after the client loads a static page, the static page is combined with the local web service, and the operation services in the user interface are taken over by the local web service, distributing business processing to the client; the server provides dynamic caching to provide dynamic data caching for query requests, improving the server's response speed and concurrency processing capabilities; and a database server, providing data storage services for the system. This effectively improves the high-concurrency throughput of the C / S three-tier architecture.