47 results about "Database connectivity" patented technology

The invention relates to the technical field of data processing, can be applied to business scenes of financial science and technology, medical health and the like, and discloses a database data verification method which comprises the following steps: configuring source database connection parameters and target database connection parameters, setting comparison task parameters, and associating the comparison task parameters with corresponding database connection parameters; determining a source table and a target table corresponding to the source table identifier and the target table identifier, executing table structure comparison to generate a structure difference record, determining a data range according to a comparison mode parameter, executing data volume comparison to generate a quantity difference value, determining a data sampling strategy, and performing content comparison to generate a feature identifier comparison result; and finally, integrating the structure difference record, the quantity difference value and the feature identification comparison result to generate a verification report. According to the method, the data range and the sampling strategy are driven by comparing the mode parameters, so that the integrated processing of structure comparison, quantity comparison and content comparison is realized, and the accuracy and efficiency of data synchronization verification are improved in a heterogeneous database environment.

The invention provides a multi-version dynamically expandable data source method and device, a terminal and a storage medium, and relates to the technical field of database data source loading. The method comprises the steps that a JAVA SDK package is created, the JAVA SDK package comprises core dependence, a core entity class, a core interface class, a database connection pool management core class, thread isolation, a routing data source class and basic attributes and target data source mapping of the routing data source class, and the target data source mapping is used for storing a loaded database connection pool; initializing a system database connection pool in the application system based on a JAVA SDK packet; after a system database connection pool in an application system is initialized, a new database connection pool is dynamically expanded in the application system based on a JAVA SDK package. The system has the design characteristics of strong dynamic expansion capability and loose coupling, the flexibility and expansibility of the system can be greatly improved, and the development and maintenance cost is reduced.

The invention discloses a database connection pool management method and device, equipment and a storage medium, and relates to the technical field of database management, the method comprises the following steps: creating a corresponding cluster connection pool for each cluster according to cluster parameter information and cluster configuration information, the cluster connection pool comprising a plurality of connection clusters, the connection cluster comprises a plurality of target connections, and the target connections carry first tags and timers; creating a database cluster pool according to the corresponding relationship between the cluster identifier and the cluster connection pool; and managing the target connection based on the database cluster pool, the first tag and the timer. The database connection resources are managed in a unified manner through the two-stage pool, so that the overhead of connection establishment and disconnection is reduced, and the processing efficiency is improved. And assigning a label to each connection, and upgrading the database connection pool into unequal stateful connections. And the timer is used for marking and tracking the use condition of each connection, so that the life cycle of the connection can be managed, and the management efficiency of the connection pool is improved.

The invention discloses a remote database synchronization system and method based on incremental data extraction and verification, and belongs to the technical field of data transmission and database synchronization. In order to improve synchronization efficiency and data consistency and adapt to a complex and changeable distributed database environment, the system comprises a variable detection module, a data application module, a data transmission module, a data verification module and an exception handling module, the variable detection module and the data application module are respectively connected with the data transmission module, the data transmission module is respectively connected with the data verification module and the exception handling module, and the exception handling module is further connected with the data verification module; the source database is connected with the variable detection module, and the target database is connected with the data application module and the data transmission module. Through incremental extraction, compression transmission and batch writing technologies, the data transmission and synchronization efficiency is greatly improved, and the method adapts to a high-frequency data change scene; and through a multi-level data verification mechanism and an exception recovery strategy, the integrity and accuracy of data synchronization are guaranteed.

The invention relates to the technical field of data processing, and particularly provides a data format conversion method, system and device and a storage medium, and the method comprises the steps: reading and storing content data in a target document by using a third-party library; acquiring database connection information and a field mapping rule; splicing the content data into a structured statement which can be identified by the database based on a field mapping rule; establishing communication connection with the database by utilizing database connection information, and storing the structured statement to the database; and accessing the database, and querying the structured statement to verify the storage validity of the structured statement. According to the invention, automatic conversion of document formats is realized, and the method has high flexibility and accuracy.

The invention discloses an off-line medicine taking method and device of a medicine cabinet, a medium and equipment. The working state of the medicine cabinet is judged by intelligently monitoring the API interface response and the database connection state of the medicine cabinet, and seamless switching between the online mode and the offline mode is achieved. In the offline state, the system uses locally stored user data to complete identity verification, retrieves drug information of a user to provide a required first drug, and updates locally cached data to reflect a current drug inventory state. And once the medicine cabinet recovers to the online state, the system synchronously updates the medicine inventory information of the preset cloud server by using the online cache data and the latest medicine inventory data, so that the updated second medicine inventory is obtained. And then, the system refreshes the online cache data again according to the second medicine inventory updated by the cloud, so that the response speed and the data access efficiency of the medicine cabinet are ensured. The problem that an existing medicine cabinet cannot accurately and efficiently take medicine offline is solved.

The invention relates to a data quality inspection method capable of dynamically expanding, which can dynamically add, modify and delete a data quality inspection rule, dynamically store database connection information and the quality inspection rule in a database, and obtain the database connection information and the quality inspection rule from the database in real time when the quality inspection is executed; the execution process of quality inspection is dynamically scheduled according to a frequency defined by a user, and comprises the following steps: realizing a quality inspection rule management system, performing the quality inspection execution process: performing timed task scheduling, acquiring a quality inspection rule, connecting a database, executing data query, executing quality inspection logic and storing a quality inspection result, and performing the quality inspection result processing process: performing anomaly detection, generating a quality inspection report and sending the report. The problem that a traditional data quality inspection system is insufficient in rule expansibility, complex rule support, database type adaptability and exception handling efficiency is solved, and quality monitoring and verification of large-scale and multi-source heterogeneous data are achieved by dynamically registering database links and quality inspection rules and combining complex expression analysis.

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 method and system for accessing a database interface layer through an SAS language based on C + + middleware. The method comprises the following steps that the C + + middleware is called to obtain SAS statements of SAS language analysis software originating from the C + + middleware; performing word segmentation identification on database information in the SAS statement, and calling a database connection module of the C + + middleware based on the database information to establish a database connection pool; identifying the SAS statement by using the C + + middleware and converting the SAS statement into a database recognizable statement; the C + + middleware is used for transmitting the database recognizable statements to the corresponding database through the database connection pool, the problem that in the prior art, SAS language analysis software cannot be directly and efficiently connected with a universal database is solved, and high-performance, high-reliability and safe data access can be achieved.

The invention discloses a framework technology implementation method for unifying query grammar and a corresponding database query system. The JDBC parser parses the task information to obtain JDBC connection information and a task SQL (Structured Query Language); initializing database connection information according to the JDBC connection information, sending a task SQL to an SQL syntax tree analyzer for syntax tree analysis, and sending an SQL syntax tree generated by analysis and a database type to an SQL syntax tree converter; an execution statement is generated according to the SQL syntax tree, and the execution statement and a database type are sent to a task executor; connecting a corresponding database according to the database connection information; after receiving the execution statement, the task executor calls the database according to the type; the database returns an execution result to the task executor; the return result is sent to the corresponding result converter according to the database type; and the result is responded to the user. According to the method, the difference between the SQL grammar is shielded, and the defect that the component is not provided with the SQL is overcome.

This invention provides a method and system for accessing a database interface layer using SAS language based on C++ middleware. The method includes the following steps: calling C++ middleware to obtain SAS statements from SAS language analysis software; identifying database information in the SAS statements through word segmentation, and establishing a database connection pool based on the database information by calling the database connection module of the C++ middleware; using the C++ middleware to identify the SAS statements and convert them into database-recognizable statements; and using the C++ middleware to pass the database-recognizable statements to the corresponding database through the database connection pool. This solves the problem in the prior art that SAS language analysis software cannot directly and efficiently connect to general databases, and enables high-performance, high-reliability, and secure data access.

This invention discloses a data-based low-code development method, system, device, and medium, belonging to the field of database and low-code technology. The technical problem this invention aims to solve is how to build applications in low-code that are compatible with existing system data and enable rapid access to existing information system data. The technical solution adopted is as follows: Configuring database data to be retained: configuring the database connection URL, obtaining all tables in the corresponding database through the URL, creating a new database configuration table, and saving tables to be used later in the new system; Generating front-end pages based on database tables and SQL: embedding commonly used page templates in the low-code platform, selecting the database table to generate the front-end page, which has CRUD (Create, Read, Update, Delete) functions, and configuring the page's operation buttons and query conditions; configuring the front-end page style and reassembling the application menu information; configuring the application user center; generating the back-end framework and compilable front-end code; writing business code online and dynamically verifying it.

The application discloses a kind of flow TDengine database data self-defined synchronization method for power system, this method includes: database table and field synchronization method, data timing automatic synchronization method, database table is shown after synchronization.Database table and field synchronization method, by manual mode, add the database connection information of different levels, when manually triggering database or database table synchronization, connection path is automatically created in system, obtain database or table information and persist to local database, simultaneously it will be saved to Redis database.Data timing automatic synchronization method, in the scheduling task in system, create new scheduling task, and bind the data exchange connection line that has been created, that is, data can be extracted to receiver database at specified time point.Effectively improve data interaction efficiency, and power system data transmission efficiency, realize the purpose of data synchronization between different subject data in multi-layer architecture.

The application discloses a transaction processing method and device based on database connection, equipment and storage medium. The transaction processing method comprises the following steps: intercepting a database connection request; detecting whether the intercepted database connection request is from an open transaction; if yes, establishing the connection between the transaction and the database according to the database connection request; listening to the transaction and establishing a script record of the transaction; and determining an optimizable transaction record according to the script record. The transaction processing method based on database connection provided by the application embodiment realizes efficient listening to the transaction execution process, can automatically discover and determine the optimizable transaction record, realizes timely discovery and determination of the optimizable transaction record, facilitates staff to optimize the optimizable transaction record in time, reduces the error rate of the transaction execution process, improves the transaction execution efficiency, and reduces the artificial workload and the artificial cost.

Communication connections with databases, such as when deployed as a database layer of a system architecture, are resource intensive to establish, take down, and maintain. However, from the applications' perspective, deployed in a business logic layer, more database connections result in less delay interacting with the databases. In order to optimize system resources, systems and methods are disclosed that create an optimized number of database connections and / or application connections, that are then maintained and shared by the applications via a proxy intercepting the communications and forwarding the communications to the database via the optimized number of pooled database connections. The connections may be multiplex so that simultaneous communications may be hosted concurrently.

The invention discloses a structured query statement extraction method and device, equipment and a storage medium. The method comprises the steps that a module set, an environment variable set, a database connection tool set and an accessed database type set used by a Perl script to be processed are determined; constructing a virtual module set according to the module set, constructing a virtual database set according to the database type set, and constructing a virtual database connection tool set according to the database connection tool set; based on the module set, the environment variable set, the virtual module set, the virtual database connection tool set and the virtual database set, constructing a virtual environment for running the Perl script; and executing the Perl script in the virtual environment to obtain a structured query statement extraction result of the Perl script. In this way, generalization, safety and integrity of SQL statement extraction in the Perl script can be improved.

The invention provides a database access method and device. The method comprises the following steps: determining a pre-cured virtual IP address of a micro-service application; a connection request is sent to the virtual IP address, so that a database connection agent on one side of the database server returns database metadata according to the connection request; receiving database metadata; and determining a target drive type according to the database category, loading a database drive corresponding to the target drive type, and creating a database connection pool according to the database connection information by using the database drive. In the method, a micro-service application can receive database metadata which is returned by a database connection agent and comprises a database category and database connection information by sending a connection request to a virtual IP (Internet Protocol), and dynamically construct a database connection pool according to the database metadata, so that the application does not need to perceive information of a real database in the process; differences of heterogeneous databases are shielded, zero modification of configuration is realized, and the workload of application deployment operation and maintenance is remarkably reduced.

The invention discloses a database connection sequence adjusting method based on an encoder-decoder architecture, and relates to the technical field. The method comprises the following steps: extracting table sequences with different lengths and column sets thereof from a database, constructing a predicate set of each column, and integrating information to obtain original connection sequence data; based on each table sequence of the original connection sequence data, constructing an SQL statement corresponding to the table sequence, executing the SQL statement through a database management system to obtain a real cardinal number of a predicate, and updating the original connection sequence data; the real cardinal number of the predicate is injected into a syntax tree of the SQL statement, query is optimized, table data information of a physical operator tree of the SQL statement is extracted, and optimal connection sequence data is obtained; the original connection sequence data and the optimal connection sequence data are used for training a transform model, and training is carried out; and pre-processing a newly queried SQL statement and inputting the pre-processed SQL statement into the model to obtain an accurate connection sequence adjustment result.

The invention relates to the technical field of data processing, and discloses a data dynamic verification method and device, computer equipment and a storage medium, the method comprises the following steps: configuring a connection pool corresponding to a multi-source database, and establishing a connection with the multi-source database based on the connection pool; setting a data verification rule, executing the data verification rule based on the specified object set and the corresponding database connection in the connection pool, and dynamically generating a structured query statement as an execution result; and outputting a verification conclusion based on the execution result and a preset expected value. According to the method, from database connection establishment, rule execution, query result comparison and conclusion output, full-process automation is achieved, connection with a multi-source database can be established, cross-database data verification is achieved, and the problems that in the prior art, multi-rule configuration is not supported, and cross-database query is difficult are solved.

The invention discloses a data exporting method and device, a storage medium and electronic equipment. The method relates to the field of financial science and technology or other fields, and comprises the following steps: determining a first thread and a second thread from a plurality of threads under the condition that a data export request is received; reading a key and a data type corresponding to the key from the target database node through a first database connection instance in the first thread; obtaining a value corresponding to the key from the target database node through a second database connection instance in the first thread; and exporting the read key, the value corresponding to the key and the data type corresponding to the key as a target file through a second thread. Through the data exporting method and device, the problem that the exporting efficiency is low when the data in the database node is exported as the file in the prior art is solved.

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.

The invention provides a calling configuration method, system and device based on an SQL template release interface and a medium, and belongs to the technical field of network data processing. The method comprises the steps that a data source is established to be connected with a front-end interface, and database information is configured; defining a multi-data source adapter, and creating corresponding database connection according to database information configured in a front-end interface; defining interface basic information and a corresponding SQL template; configuring a request parameter list, and defining parameters and parameter types corresponding to placeholders in the SQL template; generating request parameters according to the request parameter list, and defining a data model to describe response parameters of the interface; and debugging and verifying the interface, and issuing the verified interface. According to the invention, the reusability of the interface is improved. A data model for generating request parameters and defining response parameters standardizes input and output of an interface. Through the definition of the data model, the interface data structure is clear. And debugging, verifying and issuing the interface to improve the stability of the system.

Communication connections with databases, such as when deployed as a database layer of a system architecture, are resource intensive to establish, take down, and maintain. However, from the applications' perspective, deployed in a business logic layer, more database connections result in less delay interacting with the databases. In order to optimize system resources, systems and methods are disclosed that create an optimized number of database connections and / or application connections, that are then maintained and shared by the applications via a proxy intercepting the communications and forwarding the communications to the database via the optimized number of pooled database connections. The connections may be multiplex so that simultaneous communications may be hosted concurrently.

Systems and methods are disclosed for optimizing database join operations in large-scale relational databases using an integrated framework of quantum annealing, swarm intelligence, and genetic algorithms. The system employs quantum annealing to learn data distribution patterns, normalizing and transforming data to identify optimal join strategies and correlations across tables. Swarm intelligence predicts access patterns by deploying artificial ants to navigate data blocks, converging on high-relevance areas for prefetching. Genetic algorithms estimate join selectivity, calculating expected record counts to allocate resources efficiently. Learned index structures, dynamically created and tuned based on identified patterns, enhance retrieval speed with minimal storage. Additional features include learned Bloom filters for accurate join candidate selection, predictive page loading to reduce I / O wait times, and join order optimization to minimize intermediate result sizes. This modular, adaptive approach ensures rapid, resource-efficient query responses across diverse applications, such as banking and e-commerce.

The invention discloses a data-based low-code development method, system and device and a medium, belongs to the technical field of databases and low codes, and aims to solve the technical problem of how to enable a low-code construction application to be compatible with original system data, realize quick access to original information system data and improve the development efficiency. According to the technical scheme, the method comprises the steps of configuring to-be-reserved database data: configuring a database connection url, obtaining all tables corresponding to a database through the url, creating a new database configuration table, and storing a subsequent to-be-used table of a new system; a common page template is built in the low-code platform, the front-end page generated by the database table is selected, the front-end page has the functions of addition, deletion, modification and query, and meanwhile operation buttons and query conditions of the page are configured; configuring a front-end page style, and reassembling application menu information; configuring an application user center; generating a rear-end framework and a front-end compilable code; business codes are written in online, and dynamic verification is carried out.

Techniques for database connection management and governance in a multi-tenant provider network are described. One or more database broker instances connect to client applications and can obtain database connections for those client applications. The database connections can be pinned to particular client applications and / or multiplexed by and thus shared by multiple clients.

The present invention discloses a method for replicating a low-code application between multiple tenants based on SaaS, comprising the following steps: Step S1: exporting a low-code application, which includes resource information of application configuration; Step S2: the tenant imports the low-code application; Step S3: creating a tenant database and a database connection pool; determining whether there is connection information of the database connection pool of the current tenant in the tenant's low-code library, and if so, establishing a database connection according to the connection information of the database connection pool; otherwise, creating an independent business library for the tenant, instantiating the tenant's database connection pool based on the business library connection information, and adding it to a dynamic data source set, and establishing a database connection according to the connection information of the database connection pool; Step S4: the low-code application is executed in the tenant's independent business library, and is isolated based on the tenant.

The present invention discloses a real-time data synchronization method and system for a power distribution network. The method includes the following steps: a main server detects whether an abnormality has occurred in a database or a side server connection; if the database connection is normal, the main server selects a corresponding data synchronization mode according to the synchronization mode configuration of the database, and notifies the side server to perform data synchronization; if an abnormality has occurred in the database connection, the main server packages and compresses all database files and sends them to the side server, so that the side server receives the corresponding files and expands them to the corresponding database. The present invention not only guarantees the performance requirements of the power distribution system for real-time data through the classification processing of real-time data, but also ensures that the data update equivalence has the least impact on other functions in the case of large data volume, and at the same time, in the case of system abnormality, data can be restored safely and reliably; the real-time hot standby capability of the power distribution network system is improved.

The embodiment of the application discloses a method for connecting GeoServer and a hive database, which comprises the following steps: obtaining connection parameters of a data source to be connected through a plug-in; sending the connection parameters to the GeoServer through the plug-in to determine a database corresponding to the connection parameters; establishing a data source object corresponding to the database through the plug-in; the data source object comprises a database identifier and a database driver class name; and establishing a connection between the GeoServer and the database based on the database identifier and the database driver class name through the plug-in. The method makes the GeoServer capable of publishing contents in the database, and has the characteristics of high cohesion and low coupling and good plug-and-play characteristics because the method is realized in the plug-in mode.

The application discloses a kind of database connection number anomaly detection, upper limit adjustment and quantity prediction system, including M1 data preprocessing module: for reading the connection number of corresponding database and writing M2 data storage module;M2 data storage module: for receiving data from other modules;M3 connection number threshold calculation module: for calculating observation connection number upper limit threshold, observation connection number lower limit threshold;M4 observation connection number upper limit threshold, observation connection number lower limit threshold, for sending alarm information;M5 design connection number threshold dynamic adjustment module: for adjusting connection number;M6 connection number capacity prediction module: prediction is carried out to future design connection number upper limit threshold.The application can realize the monitoring, deployment and prediction to database connection pool.