107 results about "Database connection" patented technology

The invention belongs to the technical field of data processing, and discloses an active intelligent operation and maintenance monitoring method for a data center, which comprises the following steps: step 1, component modeling and topology configuration; 2, carrying out distributed health detection and data acquisition; 3, performing real-time health assessment and anomaly detection; 4, performing intelligent alarm and root cause analysis; 5, unified operation and maintenance and closed-loop control are carried out; and step 6, dynamically optimizing the intelligent operation and maintenance strategy. According to the method, a monitoring object and a dependency relationship are clarified through component modeling and topological configuration, and specific scenes, such as multi-mode acquisition, active detection, index pulling, log analysis, coverage message queue theme accumulation and database connection pool exhaustion, of distributed health detection are combined. The quantitative health score is calculated based on the preset scoring model, and by combining with the dynamic baseline learned by the ARIMA or LSTM algorithm, the module abnormity can be actively detected in different periods and weekly updating, and the problems of fault discovery lagging and incomplete monitoring coverage are solved.

The invention relates to the technical field of database security, in particular to an SQLite database transparent encryption method, system and device based on a national cryptographic algorithm and a storage medium, and the method comprises the following steps: S1, when an SQLite database is opened, loading and connecting a hardware cryptographic device to obtain an encryption master key and a corresponding key handle; s2, in response to the write-in operation, calling a national secret symmetric encryption algorithm through a key handle, encrypting a plaintext of a database page to generate a page, and writing the page into a database file; s3, reading the ciphertext page in response to the reading operation, decrypting the ciphertext page through a cryptographic symmetric decryption algorithm adjusted by a key handle after analysis, recovering a plaintext page and returning the plaintext page to the application; and S4, circularly executing encryption writing and decryption reading to process the continuous request, and releasing the key handle and disconnecting the hardware connection until the database connection is closed. According to the method, transparent full disk encryption, meeting the national secret standard, of the SQLite database is achieved, the secret key safety and the operation performance are guaranteed through hardware cryptographic equipment, and good application compatibility is kept.

The invention provides a heterogeneous database query method and device, electronic equipment and a storage medium, and the method comprises the steps: carrying out security verification processing on a plurality of SQL execution requests sent by a user side, and carrying out SPI mechanism scanning processing on a plurality of database plug-ins in a heterogeneous database plug-in directory based on a high-performance database connection pool after the security verification processing is passed, determining a target database plug-in package corresponding to each SQL execution request; and performing metadata query processing on the SQL execution request in the target data source based on a database operation client interface and a metadata service interface under the target database plug-in package, and determining a structured tree result. According to the method, an extensible and dynamically integrated heterogeneous database plug-in mechanism is realized, unified access of various databases is supported, the platform maintenance cost is remarkably reduced, hierarchical metadata of any type of databases is obtained through a consistent metadata service interface, and the user experience and the cross-database query efficiency are improved.

The invention relates to a database connection method and device, computer equipment, a medium and a program product. The method comprises the following steps: acquiring connection request information and global singleton object data from a client, and obtaining a mapping relationship between an elastic public network address and a virtual private cloud address; obtaining an original response result which corresponds to an original main node confirmation command of the client and comprises address information of the replica set node; under the condition that it is determined that the connection request needs to be subjected to elastic public network address replacement according to the connection request information and the global singleton object data, a virtual private cloud address in the original response result is replaced with a corresponding elastic public network address according to the global singleton object data, and a target response result is obtained; and sending the target response result to the client, and establishing connection between the client and each node of the replica set according to address information in the target response result. By adopting the method, the database connection flexibility can be improved on the basis of ensuring the security isolation of the cloud database.

The invention discloses a method and a system for synchronizing openGauss database data to a heterogeneous database and electronic equipment, and relates to the technical field of databases. A logic replication slot and a publishing and subscribing mechanism are created in an openGauss database; configuring a source database connector; a Kafka message middleware is configured; configuring a target database connector; and starting the source database connector and the target database connector, continuously monitoring a source database change event, and transmitting the change event to the target database through Kafka. According to the method, real-time data synchronization based on openGauss logic replication, a Kafka message bus and heterogeneous database adaptation is adopted, change events are automatically captured, cross-process log sequentialization and rhythm matching are achieved depending on a WAL calibration control layer and Kafka partition buffering, millisecond-level end-to-end delay is kept, and the conversion efficiency is low.

This invention discloses an automatic inspection report generation and display method, including the following steps: Step 1: drawing a configuration screen according to requirements and selecting a database connection based on actual conditions; Step 2: configuring database request parameters and data processing parameters or functions for the cell model targeting data point objects; Step 3: querying real-time cross-section data or historical database data according to the parameters configured in the configuration screen; Step 4: updating the data results after calculation operations for the cell model in the configuration screen; Step 5: converting the configuration screen to generate a report file or database file. This invention provides a unified, universal, and feasible automated process for requesting and displaying data based on the drawing, configuration, data request, and report export functions of the configuration screen. It also utilizes server scripts to ensure the program can run effectively for a long time and is readily available with the server, and provides a downloadable inspection report function on the system interface front end.

This invention provides an information processing device, information processing method, information processing system, and program that enable centralized management of patient information by linking an electronic medical record database with databases from multiple customer acquisition media, and that utilize this information to propose medical services. [Solution] The information processing system includes a reception unit that receives patient needs, a patient information acquisition unit that acquires patient information including basic patient information and medical visit history information, a medical information acquisition unit that acquires medical information including medical treatment information and prescription details from medical institutions, an information centralized management unit that centrally manages patient information and medical information, a prompt generation unit that outputs generation commands based on the centrally managed patient information and medical information, and a proposal information generation unit that generates proposal information including medical services, medical institutions, treatment details, etc., suitable for the patient based on the generation commands.

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.

The invention relates to the technical field of databases, and provides an analysis and conversion method and device for SDE.STGEOMETRY type data. The method comprises the following steps: storing original data by using an information structure; wherein the data type of the original data is SDE.STGEOMETRY type, and the data type of the original data is SDE.STGEOMETRY type; and analyzing the point information, the point set object and the entity parameters in the information structural body to obtain target geometric data. According to the method and the system, the SDE.STGEOMETRY type data is directly processed by constructing and analyzing the information structure body, connection with a database is not needed, and the problem that the SDE.STGEOMETRY type data can only be converted through a database interface and a general format is solved.

The embodiment of the invention provides a cross-forward isolation data comparison system, method and device, a medium and a product, and relates to the field of data synchronization and verification. The system comprises a first agent which is deployed in an intranet and accesses a source end database through a database connection protocol; the second agent is deployed in an external network and establishes one-way communication connection with the first agent; the first agent is also used for transmitting the source end data of the source end database to the second agent through the forward isolation device through the one-way communication connection; and the comparison service is deployed in an external network, pulls the source end data from the interface of the second agent, and performs comparison operation on the source end data and the target end data. According to the method provided by the invention, the technical problem of data comparison in a cross-forward isolation scene is solved through the design of a double-agent architecture and a user-defined protocol, the security and reliability of data comparison are realized, and efficient and secure data comparison in a strict network isolation environment is realized.

The invention discloses a method for testing a database connector and computing equipment, and relates to a plurality of test case generation cue words, and each test case generation cue word is constructed and obtained according to different database domain knowledge. The database domain knowledge describes at least one of database connection attributes, database modes, database functions and critical conditions, the method comprises a plurality of iteratively executed test processes, and any round of test process comprises the following steps: generating historical selected times and reward values corresponding to cue words according to each test case, determining a target cue word in the cue words generated by the plurality of test cases, and updating the historical selected times of the target cue word; utilizing a large language model to generate a test case code according to the target cue word; executing the test case code by utilizing the to-be-tested connector; according to the execution result of the to-be-tested connector, the reward value is updated, automatic database connector testing is achieved, and the testing breadth and the testing depth can be both considered in the testing process.

The invention relates to a system for program control using a digital processor, and more particularly to a system for automatically generating reports about the state of thermal vacuum and manufacturing systems. The technical result, which consists in more timely generation of reports about the state of thermal vacuum and manufacturing systems, is achieved in that the present system for automatically generating reports about the state of thermal vacuum and manufacturing systems comprises a host computer interconnected with a control unit that transmits control signals to monitoring and measuring devices and a data processing unit, wherein the monitoring and measuring devices transmit data to a data collection unit, which transmits data to the data processing unit, which transmits data to the control unit, which transmits data to the host computer, and the monitoring and measuring devices include a validation device, a device for measuring the amount of aerosol particles in the air, a device for remotely recording temperature and relative humidity values, a device for monitoring the parameters of controlled environment rooms, and a module for generating a report about a set of production equipment, wherein the data collection unit is connected to a database, which is connected to the data processing unit.

The invention relates to the technical field of warehouse management, in particular to a method and device for managing a warehouse and a storage medium. Comprising the steps of obtaining a current data source rule and a current warehouse of a tenant; determining a data source to which the current warehouse belongs and a target database connection instance object; generating a current binding relationship between the abstract of the target database connection instance object and the tenant identifier, and storing the current binding relationship to a first set; when it is detected that at least one abstract exists in the second set and does not exist in the first set, closing and releasing a database connection instance object corresponding to the at least one abstract to obtain an updated second set; adding the current binding relationship in the first set to the updated second set to obtain a target second set; when it is detected that all the abstracts in the second set exist in the first set, adding the current binding relation in the first set to the second set to obtain a target second set; and releasing the target second set, thereby improving the management efficiency of the warehouse.

A system and associated methods display on a user device a non-fungible token (NFT) in an application that displays video data. The methods include storing the NFT of a user in a database accessible to the application, associating an ID of the user for the application to the NFT, and receiving a selection of the NFT during use of the application. Upon selection, the selected NFT is provided to the user device for superimposing the selected NFT over the user’s face, providing the selected NFT as a background image for the video data on the user device, or both. The user device includes a web application that connects the database to a crypto wallet containing the NFT. The NFT may be processed to crop out the eyes and mouth of the NFT for registration with the user’s eyes and mouth when the NFT is superimposed over the user’s face.

The invention particularly relates to a task dynamic parameter transmission method and device based on a big data execution engine, and relates to the technical field of big data processing, and the method comprises the steps: according to the type of an upstream task, adopting a parameter processing logic adaptive to the type of the task, and storing three types of parameters to a corresponding storage medium; two preconditions are verified, wherein the two preconditions include the dependency relationship between the downstream task configured in the platform and the upstream task, the upstream task completing output parameter configuration and the parameter state being available. According to the method, three types of parameters of constant, user-defined operation and calculation results are divided, different business scenes such as static configuration transmission, cross-task unified management and dynamic result reuse are accurately matched, and diversified parameter transmission requirements such as database connection ports, date partitions and task execution results are covered; specific parameter output logic is designed for four mainstream task types of SparkSQL, Python, Shell and RDB, and a standardized storage path and a cross-task multiplexing mechanism are adopted, so that the problems of repeated configuration and format incompatibility are avoided.

The invention discloses a database connection pool management method and device based on DataX, and solves the problems of low resource utilization rate, concurrence disorder, thread safety and the like caused by lack of a built-in connection pool in the existing DataX. The method comprises the following steps: deploying an independent connection pool service (CPS), integrating a third-party connection pool and configuring a global maximum connection number; the DataX communicates with the CPS through a network, and each Channel independently applies for connection; the CPS dynamically adjusts the DataX parallelism degree (limitation or waiting when the DataX parallelism degree is insufficient) according to the available connection number, and allocates a unique connection identifier; the DataX sends an SQL request through the identifier, and the CPS calls the third-party connection pool for execution and returns a result; and after the task is completed, notifying the CPS to release the connection. Connection multiplexing is achieved through centralized management, the physical connection sharing risk is avoided, the parallelism degree is dynamically regulated and controlled to guarantee efficient utilization of resources, and DataX task stability and thread safety are improved.

The application discloses a secret evaluation system and method based on a business system, and the secret evaluation system comprises a configuration list module, an automatic configurator, an identity authentication interface interceptor, a response interceptor and an ORM adapter; the configuration list module is connected with the automatic configurator; the automatic configurator is connected with the identity authentication interface interceptor, the ORM adapter and the response interceptor respectively; the identity authentication interface interceptor is connected with a database through the ORM adapter; and the response interceptor is connected with the database through the ORM adapter. The secret evaluation system uses a Spring SPI mechanism and encapsulates secret evaluation tools through the ORM adapter, optimizes a secret evaluation reform and development process, avoids complex data protection work in secret evaluation reform work, does not intrude on system business codes, and does not require users to care about specific implementation logic of algorithms, so that the secret evaluation system is convenient and fast to use.

The application discloses a columnar database automatic initialization and statistical calculation pipeline management method and system. The method comprises the following steps: loading a unified configuration file, defining database connection information, a calculation task list and a scheduling interval parameter; detecting an initialization state, and executing an initialization script to create a database structure if the database structure is not initialized; sequentially calling tasks in the order of the task list, and inserting a first interval between adjacent tasks; for a current task, executing a script after dynamically replacing parameters, and then immediately performing storage optimization on a table involved; waiting for a second interval after one round of tasks is completed, and repeating the cycle. The application realizes integrated management of database initialization, periodic statistical calculation and table optimization through unified configuration; sequential scheduling and two-level interval control smooth the load and prevent concurrent impact; storage optimization immediately follows calculation to ensure that data output immediately enters an optimal query state, thereby significantly improving the automation level and data service real-time performance.

The invention relates to an artificial intelligence-based precise eye movement tracking identification system and method. The intelligent interaction tracking expansion module is used for integrating and packaging a multi-source database into an HTML (Hypertext Markup Language) instruction file set, constructing a video eye movement tracking data collection platform, and intelligently interacting and expanding eye movement tracking information and high-precision eye movement tracking; the eye movement tracking and calibration module is used for controlling eye movement tracking and triggering calibration, and controlling camera access, eye movement key point identification, fixation point prediction calibration and precision test; the video synchronization and eye movement analysis module is used for constructing an immersive video playing environment, associating eye movement data with a video timestamp and carrying out gaze point eye jump behavior recognition statistics; and the data visualization and cloud storage module performs thermodynamic diagram generation rendering, composite screen snapshot generation, eye movement structured data generation and composite screen snapshot cloud storage, monitors a database loading state, a database connection state and an eye movement data uploading result, and tracks the reliability of a data acquisition process.

The invention provides an MYBATIS-based component generation implementation method and system, electronic equipment and a storage medium, and relates to the technical field of software development. According to the method, by configuring an FTL template and database connection, metadata of a database is automatically analyzed, and a four-layer framework assembly containing a BaseController, a BaseService, a BaseMapper and a BaseEntity is generated. The system can dynamically analyze a non-standard query instruction through a reflection mechanism and construct a dynamic SQL; in the code generation stage, according to field annotations and types, safety encryption and decryption annotations and flow limiting annotations supporting the national cryptographic algorithm are automatically injected. Particularly, batch write-in optimization logic based on a dynamic fragmentation strategy is built in, the optimal fragmentation size is automatically calculated in combination with database loads, system resources and data feature multi-dimensional indexes, and high-performance batch processing by using a JDK virtual thread is supported. According to the method, the development efficiency is remarkably improved, the data processing performance and the system security are improved, and the enterprise-level component can be used after being opened.

The invention discloses a containerized system start-stop control method and device, electronic equipment and a storage medium, and relates to the technical field of data processing, and the method comprises the steps: configuring a process termination signal hierarchical response mechanism of a container platform, and controlling a process termination process through a preset maximum downtime parameter; triggering a service unavailable mark based on the process termination signal, closing a monitoring port according to the service unavailable mark to intercept a new request, and cancelling interface information of the service registration center; monitoring operation states of the application layer thread pool and the timed task cluster, and waiting for all active requests of the application layer thread pool and uncompleted tasks of the timed task cluster to be processed within a preset timeout period; and sequentially closing the log framework, the thread pool and the database connection pool according to a preset resource release sequence, completing safe release of resources, and recording a log state. The method has the technical effects of guaranteeing service continuity in a containerized deployment or updating process, ensuring data integrity and realizing safe and orderly release of resources.

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 discloses a heterogeneous database synchronization method based on timing scheduling, and the method is characterized in that: a source database, a target database and a synchronization server are connected to the same network, a data MT table for recording data change is created on the source database through the synchronization server; a trigger of a source table on the source database is called through the synchronization server, the change of the source table data is monitored through the source table trigger, and the change is written into the MT table; a synchronization database list is created on the synchronization server, and the attributes of the source database and the target database are recorded; a task list is created on the synchronization server, the source database and the target database are defined, the source database and the target database are connected, the target table is created in the target database according to the source table field attribute of the source database; and the heterogeneous database synchronization method is low in cost, convenient to operate and not limited by the operating system and the database version.

A vehicle data verification apparatus includes a database (DB) and a processor connected with the DB. The processor is configured to: import at least one vehicle data set; identify whether the at least one vehicle data set is stored in the DB; verify pieces of vehicle data in the at least one vehicle data set upon identifying that the at least one vehicle data set is stored in the DB; and export a result of the verification of the pieces of vehicle data.

The application relates to the technical field of databases, and provides a database connection control method and device, computer equipment and a readable storage medium, the method comprising the following steps: obtaining service identification information of a target service; obtaining first configuration information of the target service according to the service identification information, wherein the first configuration information comprises a first connection upper limit and a connection distribution strategy; determining a second connection upper limit corresponding to each instance in the target service according to the number of instances in the target service and the first connection upper limit based on the connection distribution strategy; and sending the second connection upper limit corresponding to each instance in the target service to the target service, wherein the second connection upper limit is used for indicating the connection number of the instance to the database, the flexibility of setting the connection upper limit of the service and the instance is improved, and the disorderly expansion of the database connection number is prevented. In addition, the application also relates to the blockchain technology, and the configuration information can be stored in the blockchain.

The application provides a knowledge graph construction system and method based on a relational database, comprising a database connection module, a knowledge graph construction module and a graph editing and display module, based on form structure analysis, form association relationship identification and analysis and form basic item acquisition of the relational database, realizing graph construction and fusion integration of the relational database; based on graph visualization display, graph entity editing, graph entity relationship editing and graph extraction information configuration, realizing graph editing and display capability. The application supports graph construction of multiple data sources, breaks data islands, carries out multi-element combination of data, provides a combined information analysis basis for users, provides entity fusion integration capability, effectively improves graph availability and eliminates redundant data.

The present invention is a replacement timing prediction method for ion exchange resin charged in a non-regenerative ion exchange device constituting a sub-system of an ultrapure water manufacturing device of a specific user, using information processing means. In this replacement timing prediction method, a database is attached to the information processing means, and the replacement timing prediction method includes a step in which the database receives information related to an ion exchange resin charged in a non-regenerative ion exchange device of the specific user, and records the information received; and a step in which, based on the information recorded in the database, the information processing means predicts a next replacement timing of an ion exchange resin of a non-regenerative ion exchange device of the specific user.

The application relates to the fields of computer technology and digital medicine, and discloses an intelligent processing method and system of an SQL statement, a computer device and a medium. The method comprises the following steps: when a data operation request for a database is detected, the data operation request is intercepted and analyzed to generate database connection information; when it is determined that a target SQL script is a preset first type SQL, a target execution plan of the target SQL script is determined according to the database connection information, and a to-be-optimized parameter of the target SQL script is determined based on the plan to optimize the target SQL script. Through real-time interception of the data operation request for preset first type SQL judgment, when it is determined that the target SQL script corresponding to the request is the preset first type SQL, a target execution plan at the current time can be created to determine the to-be-optimized parameter for SQL optimization, so that each data request corresponds to the current latest execution plan, accurate reproduction and optimization of the preset first type SQL can be realized, and the stability of the system is improved.

The application discloses a database script deployment method and device and a computer readable storage medium. The method comprises the following steps: determining a database unique identifier according to a received database script deployment request; determining a current environment type and database connection information according to the database unique identifier, and connecting a target database instance corresponding to the current environment type based on the database connection information; obtaining a control file and a to-be-deployed script associated with the target database instance from a code repository, and determining a deployment sequence and a deployment mode corresponding to each to-be-deployed script according to the control file; and executing each to-be-deployed script according to the deployment sequence and the deployment mode. The database script deployment efficiency is improved.

The invention discloses a database domain name access method and device, equipment and a storage medium. The method comprises the steps that service component topology change information of a target database in a remote direct memory access environment is obtained, and the remote direct memory access environment is deployed on a containerized application management platform; based on the business component topology change information, updating a first service binding relationship corresponding to the containerized application management platform, and determining a second service binding relationship corresponding to the containerized application management platform; and performing domain name access on the target database based on the second service binding relationship. The method can realize efficient access to the database domain name, can adapt to dynamically changing service end points in a general network environment, improves the flexibility of database domain name access, improves the stability of database connection, and reduces the operation and maintenance cost, thereby ensuring efficient and stable operation of a high-performance network, and improving the reliability of the network. And the reliability and user experience of the database system are improved.