42 results about "Database engine" patented technology

The embodiment of the invention provides a database processing method and device, a storage medium and a program product, and the method comprises the steps: obtaining target data through an interaction interface of a preset model deployed in a database engine; according to the target data, generating decision suggestion information through a preset model; and generating an operation and maintenance instruction according to the decision suggestion information, transmitting the operation and maintenance instruction to a target execution unit in the database engine through the interactive interface, and executing the operation and maintenance instruction through the target execution unit. According to the embodiment of the invention, the preset model is tightly coupled with the database engine, so that analysis and decision can be efficiently performed in real time in the database system, the operation and maintenance efficiency of the database system is effectively improved, and the intelligent automatic monitoring, learning and intelligent operation and maintenance capabilities of the database system can be realized; and the database system can respond and process business requirements more efficiently and stably.

Methods for replicating transactional tables of a transactional database to a recipient system, such as an analytical database, and maintaining updates to those transactional table representations are disclosed. More particularly, change-data-capture items are generated by a transport engine, that is separate from a database engine for the transactional database. Also, schema data is maintained out-of-band from the database engine and is stitched with committed change payload contents by the transport engine.

The invention discloses a definition-based data copying and migrating method, which comprises the following steps of: reading user configuration data, and analyzing and recombining the configuration data; performing mode algorithm processing on the mode structure to obtain a statement trunk; performing configuration algorithm processing on the configuration structure to obtain statement conditions; performing data structure and grammar analysis algorithm processing on the data structure to obtain a table name, a field and an affiliated rule; processing the statement trunk and the statement condition by adopting an assembly algorithm, and generating a dynamic statement with the table name, the field and the affiliated rule; performing batch execution and performing log recording; judging whether inverse operation is needed or not, if the inverse operation is needed, returning to the first step, and if the inverse operation is not needed, backing up the data. According to the scheme, a database data migration tool is provided, compatibility and adaptation of any database and any type are achieved, and meanwhile the most compatible type is automatically adapted to use according to the database engine.

The invention relates to an interactive monitoring method and device for a database running state and electronic equipment. The method comprises the steps that when an interaction instruction in a digital or keyword form input by a user is received, a database running state index is obtained from the interior of a database engine; according to a preset diagnosis rule, key indexes are extracted from the database operation state indexes, the key indexes are integrated, and a refined index set is generated; the refining index set is used as an analysis object, index analysis of the corresponding analysis dimension is triggered according to the interaction instruction, and an analysis result is obtained; and performing layered display on the refining index set based on an analysis result. The technical problem that existing database monitoring lacks real-time performance, flexibility and operation efficiency is solved.

This application provides a data sorting method, a database engine, and a storage medium. In this application, for scenarios involving multi-column sorting, the data rows to be sorted are first grouped according to the clustering column. Then, the sorting is performed between and within each data group according to the sorting column, using the same sorting order. The sorting result obtained in this way retains the clustering characteristics of the clustered columns while essentially ensuring the global order of the data, which is beneficial for improving the computational performance related to the clustered columns. Especially when querying based on the sorting result, it ensures that the performance of queries by data range is largely unaffected, while significantly improving the performance of queries by data grouping.

The automatic detection of inconsistencies in a database system is described. A first signature and a second signature are received. The first signature is a signature of a result of a first execution of the query against a database by a first version of database engine program code. The second signature is a signature of a result of a second execution of the query by a second version of the database engine program code. A determination is made of whether the first signature and the second signature match. In response to the first signature and the second signature failing to match, an inconsistency report regarding at least one of the first or second versions of the database engine program code is generated and remediation regarding at least one of the first or second versions of the database engine program code is performed.

The invention discloses a data query method, device and equipment and a storage medium, and relates to the technical field of data processing.The method comprises the steps that a data query instruction and a target query database corresponding to a current data query task are determined according to a data query request; detecting whether the data query instruction accords with a database grammar specification corresponding to the target query database; if not, performing grammar conversion on the data query instruction based on a preset grammar tree analysis mode to obtain a target data query instruction; and performing data query based on the target data query instruction. According to the method, when the data query instruction does not conform to the grammar specification of the target database, grammar conversion can be performed on the data query instruction, and data query is performed based on the target data query instruction obtained after conversion; therefore, the technical problems that in the prior art, during cross-database query, query scripts need to be frequently modified to adapt to grammar differences of different database engines, time is consumed, and errors are prone to occurring are solved.

A system and method include receiving, by a database engine of a database system associated with a virtual computing system, a user request via a dashboard for provisioning a source database with the database system, receiving, by the database engine via the dashboard, selection of a database engine type, and receiving, by the database engine via the dashboard, selection of a Service Level Agreement (“SLA”) and a protection schedule. The system and method also include provisioning, by the database engine, the source database based upon the database engine type, creating, by the database engine, an instance of a database protection system based upon the SLA and the protection schedule, including associating the instance of the database protection system with the source database, and displaying, by the database engine, the source database within the dashboard.

The application discloses a financial-grade database multidimensional security management and control system and method, relates to the technical field of financial data security management and control, and deploys a quantum encryption network and a backup key pool; initializes a data hierarchical management mechanism and a key management hub; transforms a database engine and builds a trusted audit hub, and deploys a security agent on a database node. Through the cooperation of the quantum encryption network and the post-quantum backup key pool, the high security of quantum encryption is utilized to resist traditional and quantum computing threats, and the encryption service is ensured not to be interrupted when the quantum network is abnormal, thereby meeting the continuity requirement of financial transactions; fine-grained data grading is combined with a differentiated security strategy, encryption algorithms, access permissions and retention periods are configured for high-sensitive, medium-sensitive and low-sensitive data respectively, precise protection is realized, and operation efficiency is taken into account; and a multi-role key cooperation mechanism avoids single-point key leakage, and the original key is destroyed after the key is generated, so that the key security is further improved.

The application discloses a processing method of cross-engine transactions, which can be applied to a database system, the database system can at least include a first database engine and a second database engine, and the method comprises the following steps: acquiring timing information, the timing information can indicate that a first sub-transaction of a first cross-engine transaction is not later than a first sub-transaction of a second cross-engine transaction in performing a target operation, the target operation can be accessing data in the first database engine, and according to the acquired timing information, it can be determined that data first accessed by a second sub-transaction of the first cross-engine transaction in the second database engine is not later than data first accessed by a second sub-transaction of the second cross-engine transaction in the second database engine in timing, so that the data accessed by the two cross-engine transactions is consistent in timing. In addition, the application also discloses a processing device, equipment and medium of cross-engine transactions.

The application relates to the technical field of data calculation, and provides an index calculation method and device, which comprises the following steps: storing a plurality of target index groups generated by an electronic spreadsheet software and corresponding configurable files; wherein the configurable files represent the calculation rules of the values of the plurality of original indexes for determining the values of the business indexes in the corresponding target index groups; determining an index calculation request; wherein the index calculation request carries a target index group or the identification of the target index group; determining the values of the plurality of original indexes matched by the target index group; calling a database engine to calculate the values of the plurality of original indexes matched by the target index group based on the calculation rules indicated by the configurable file matched by the target index group, so as to determine the values of the business indexes in the target index group. The configurable file of the target index group is maintained by using the electronic spreadsheet software, the dimension difficulty is reduced, the calculation process of the business indexes is converted into the execution process of the database engine, and the extension is facilitated.

The automatic detection of inconsistencies in a database system is described. A first signature and a second signature are received. The first signature is a signature of a result of a first execution of the query against a database by a first version of database engine program code. The second signature is a signature of a result of a second execution of the query by a second version of the database engine program code. A determination is made of whether the first signature and the second signature match. In response to the first signature and the second signature failing to match, an inconsistency report regarding at least one of the first or second versions of the database engine program code is generated and remediation regarding at least one of the first or second versions of the database engine program code is performed.

The embodiment of the invention provides a method, device and equipment for generating a database, a storage medium and a computer program product. The method includes receiving a user input for generating a database. The method further comprises the step of obtaining a code of a target database, wherein the code of the target database is generated by the target model according to user input. And displaying a data table of a target database on the interface, wherein the target database is generated by executing the code by the database engine. The method further includes displaying the updated data table on the interface according to the adjustment in response to receiving the adjustment for the data table. According to the method disclosed by the embodiment of the invention, the machine learning model is combined with the database engine, so that not only can the database code meeting the user input be generated, but also the database can be generated by executing the code, namely, the customized database is generated and previewed in a one-key manner, and the generation efficiency of the database and the user experience are greatly improved.

The invention discloses a financial-level database multi-dimensional security management and control system and method, and relates to the technical field of financial data security management and control. A quantum encryption network and a standby key pool are deployed; initializing a data level-to-level management mechanism and a key management center; a database engine is transformed, a credible auditing center is built, and a security agent is deployed at a database node. According to the invention, through cooperation of the quantum encryption network and the post-quantum standby key pool, high security of quantum encryption is utilized to resist traditional and quantum computing threats, encryption service is ensured not to be interrupted when the quantum network is abnormal, and the requirement of financial transaction continuity is met; fine-grained data grading is combined with a differentiated security policy, an encryption algorithm, an access permission and a retention period are configured for high-sensitivity, medium-sensitivity and low-sensitivity data respectively, and the operation efficiency is considered while precise protection is achieved; a multi-role key cooperation mechanism avoids leakage of a single-point key, and the key security is further improved by combining the design that the original key is destroyed after the key is generated.

The invention discloses a multi-stage verification method and system for a business object data migration process and a server. The method comprises the following steps: verifying a to-be-migrated object generated according to a migration demand; after a data migration packet generated based on the to-be-migrated object enters a mapping engine for migration data conversion, field-level verification is carried out; and after the mapping is completed, analyzing a return code of the database engine for returning a write-in result in real time. According to the method, the problems of incomplete coverage, lack of pertinence and low automation degree of data migration verification are solved, accurate identification and intelligent disposal of abnormal behaviors in each migration link are realized, and the integrity, accuracy and smoothness of data migration are improved.

A database engine may track granularity levels for accessing a spatial index. Granularity levels of a spatial index may be evaluated to identify those granularity levels that identify data objects in a data set. An indication of the identified granularity levels may be stored as part of metadata for the data set. When a spatial query directed to the data set is received, the spatial index may be accessed at the identified granularity levels indicated in the metadata for the data set as part of processing the spatial query.

Embodiments of the present application provide a table data batch synchronization method and device, a storage medium and a program product. In the present application, the application layer no longer needs to separately judge the existence of each data in the target table and construct an insertion or update instruction, but the decision-making right is given to the database engine layer, and the database engine is taken as the core execution unit to automatically complete based on the index field value; by integrating the data reading of the intermediate table and the conditional writing of the target table in a single batch synchronization statement, the number of interactions between the application layer and the database is significantly reduced, and the system overhead caused by high-frequency SQL parsing, transaction opening and network round trip in the piece-by-piece processing mode is avoided; at the same time, by batch deleting the intermediate table data after synchronization, and combining the single transaction submission mechanism, the atomicity and consistency of the data synchronization process are ensured. Based on this, while ensuring the accuracy of the data, the execution efficiency and system stability of large-scale data synchronization are greatly improved.

This invention provides a spatial planning data quality inspection method, device, and medium based on an embedded database. First, quality inspection configuration information is loaded, and the local data packets to be inspected are imported into an embedded database engine that supports spatial expansion, forming a local temporary quality inspection database. Based on the quality inspection configuration information, internal quality checks are performed on the data in the local temporary quality inspection database using spatial SQL functions. Then, an external consistency check is performed by loading a remote database through an external data connection. Finally, the results of the internal quality check and the external consistency check are structured and saved to the result table of the embedded database. This invention directly accesses local data packets and remote databases through the embedded database engine, and uses SQL spatial functions to implement integrated automatic quality inspection by executing quality inspection operators within the database kernel. This reduces the difficulty of developing quality inspection operators and significantly improves the efficiency and standardization of quality inspection of detailed land spatial planning data.

The invention relates to the technical field of databases, and provides a multi-database fusion access method, device and system applied to a scientific investigation ship. According to the method, characteristics of collected data of a scientific investigation ship are mapped into data tags, the data tags comprise frequency-variant FB-Type, slow-variant MB-Type and stable ST-Type, and different data path strategies are matched for the data tags; the collected data of different data labels can move to respective database engines along a preset strategy; the method comprises the following steps: importing collected data with an FB-Type data tag into a time sequence database; the collected data with the MB-Type data tag is imported into a document type database; and the collected data with the ST-Type data tag is imported into the relational database, so that the problem of poor practicability of heterogeneous data stored in a single database architecture is solved.

The application relates to the technical field of databases, and provides a multi-database fusion access method, device and system applied to a scientific research ship. The application maps the characteristics of collected data of the scientific research ship into data tags respectively, the data tags include FB-Type of frequency variation type, MB-Type of slow variation type and ST-Type of stability type, and different data channel strategies are matched for the data tags respectively; the collected data of different data tags will go to respective database engines along preset strategies; wherein the collected data with the FB-Type data tag is imported into a time series database; the collected data with the MB-Type data tag is imported into a document type database; and the collected data with the ST-Type data tag is imported into a relational database, so that the problem that heterogeneous data stored in a single database architecture is poor in practicability is solved.

The invention relates to a multi-dimensional data query method based on an embedded engine and dynamic aggregation, and the method comprises the steps: integrating the fact data of different databases and the corresponding dimension description data through constructing a data wide table, and forming a single table containing a dimension field and a measurement field; on the basis, different data processing modes are selected according to the analysis result of the multi-dimensional query request input by the user. For the condition that only the basic aggregation task is contained, corresponding processing is directly executed in a target database where the data wide table is located; for the condition containing the complex calculation task, basic aggregation processing is firstly carried out in the target database to obtain basic aggregation data, then an aggregation file corresponding to the basic aggregation data is read through the embedded database engine, and processing operation corresponding to the complex calculation task is executed. Intermediate links of the query process are reduced, the query efficiency is improved, meanwhile, it is ensured that data used for complex calculation has normalization and consistency, and then the query accuracy is improved.

Techniques for building, validating, and utilizing custom database software in a shared management environment are described. A database customization service allows users to provide database installation files as part of a configuration to generate a custom database engine version. The creation of custom database engine versions may be governed by policy, and the database customization service may provide recommendations for creating custom database engine versions according to various criteria. The custom database engine version can be built, and its functionality and correctness verified. Users may launch database instances using these custom database engine versions that can be managed under a shared management scheme where both users and the database customization service can perform host-level management.

The invention relates to a flash memory optimization method and system in computing storage equipment and electronic equipment. The method can comprise the steps of obtaining a data access request generated by a database engine and semantic prompt information associated with the data access request; identifying the data access request to obtain a target operation type and a target logic address; analyzing the semantic prompt information to obtain data category information and access mode information; under the condition that the target operation type is a writing type, writing the target data into a target physical area in the flash memory according to the data type information; and under the condition that the target operation type is a reading type, loading the target data page and the predicted data page from the flash memory to a cache region in the dynamic random access memory according to the access mode information. According to the technical scheme provided by the invention, differentiated data placement based on the data category and predictive data loading based on the access mode can be realized, and the data writing performance and reading delay of the computing storage equipment are optimized.

The invention relates to the technical field of data processing, in particular to a query optimization method and system based on an algorithm engine, and the method comprises the steps: firstly receiving an initial logic analysis instruction aiming at a target data storage cluster, then traversing all query columns of the initial logic analysis instruction to extract a trend query column containing a trend analysis function, and then, carrying out query optimization on the trend query column containing the trend analysis function; and performing logic rewriting on the trend query column by adopting a preset rewriter to obtain a query rewriting instruction containing multi-table association, and finally submitting the query rewriting instruction to a pre-configured database engine to return a query result related to trend analysis. Compared with the prior art, the method has the advantages that the content of the multi-associated data does not need to be inquired manually and independently, the possibility of memory overflow of a system end caused by multi-manual operation is reduced, the possibility of field repetition is also reduced, and therefore the method has higher stability and lower resource consumption.

The invention relates to the field of data analysis, in particular to an intelligent decision analysis method and system based on multi-source data fusion and a dynamic template, and the method comprises the steps: receiving structured and unstructured data sources through an API gateway, executing data updating operation in a preset time period to obtain a data updating record, and storing the data updating record as an Excel file; converting the Excel file into a table structure according to sheet through an Excel-to-database engine, judging a field type in the table structure, and storing the field type in a database to obtain a field type database; constructing an analysis data set based on the field type database; generating a vector curve graph, a natural language query result and a time dimension word cloud according to the analysis data set; and carrying out confidence verification by utilizing a cross-engine verification chain, and binding the vector curve graph, the natural language query result and the time dimension word cloud by utilizing a dynamic association generator after verification is completed to obtain a decision analysis report. The decision analysis report generation efficiency and accuracy can be improved.

The present application relates to the technical field of data processing and database permission control, in particular to a table type piecework data filtering processing method and system with editing permission restriction, comprising: obtaining enterprise organization structure and piecework business data, establishing a three-dimensional permission matrix according to user roles, data fields and piecework types; based on historical piecework data, statistically calculating average piecework amount and standard deviation, and setting a dynamic trigger threshold in combination with a risk tolerance coefficient; calculating the effective permission data set of the current session according to the current user identity; intercepting the front-end table type piecework data filtering request, parsing it into an abstract syntax tree and performing condition injection and reconstruction before handing it over to the database engine for execution; using hash chain technology to generate tamper-proof audit logs for permission rule changes or data access operations; the present application realizes fine-grained permission control, automatic collection of abnormal amounts, and traceable access behavior.

The invention discloses a correction method and a generation system for converting a natural language into an SQL (Structured Query Language) of a large language model, and belongs to the technical field of artificial intelligence and databases. The correction method comprises the following steps: receiving a natural language query request and database mode information, and generating an initial SQL statement by utilizing the large language model; inputting the generated SQL statement into a static analysis module, and carrying out feature matching based on a preset logic inverse mode rule base; if the inverse mode is matched, logic correction feedback is generated, and rewriting is triggered; after the SQL statement passes the static analysis, submitting the SQL statement to a database engine for execution; if the execution is successful, obtaining a query execution plan of the query; analyzing the query execution plan, and identifying a performance bottleneck index; and if the performance bottleneck exists, generating performance optimization feedback and sending the performance optimization feedback to the large language model for rewriting. According to the method, manual intervention can be greatly reduced, correct SQL grammar can be ensured, and reliable logic and efficient execution can be ensured.

Aspects of the disclosure provide for a computing device implementing a Digital Intelligence (DI) engine, for managing and querying a database of interrelated keywords obtained from data local to the computing device. The DI engine maintains a database of keywords parsed from various sources of data received by the computing device. The DI engine can generate weights to strengthen or weaken the association between keywords. When a query for a keyword is received, for example by another device implementing an instance of the DI engine, the computing device can receive the query, identify a keyword specified as part of the query, and send keywords associated with that specified keyword, as output. The DI engine can use the sent keywords to facilitate and manage transactions, including determining the cost-bearing party.

The invention discloses a dialogue type information query method for a structured database in the power field, which comprises the following steps: acquiring an initial structured query statement based on a natural language query text and database mode information; abstract syntax tree analysis is conducted on the initial structured query statement, a table name set and a column name set referenced in the initial structured query statement are extracted, a target database is inquired to obtain alignment auxiliary information, and the alignment auxiliary information comprises list alignment information and knowledge alignment information; based on the alignment auxiliary information, the natural language query text and the database mode information, performing fusion, generating optimization prompt information, inputting the optimization prompt information into a large language model, and generating candidate structured query statements; and submitting the candidate structured query statements to a database engine for pre-execution verification, and outputting the structured query statements passing the verification. The method solves the problems of illusion and lack of knowledge in the application of a large model in the electric power vertical field.

Systems and methods for apportioning cloud-based resources through the use of domain name services based on real-time cloud-based database engine traffic patterns. For example, the system may monitor incoming cloud-based database engine traffic over a plurality of disparate computer network resources. The system may generate a first recommendation for domain name service based on the first difference, wherein the first recommendation requests a modification of an allocation of the plurality of disparate computer network resources.