51 results about "Active database" patented technology

A database migration system and method that provides continuous transaction service during migration. The invention allows minimal transaction service down time during database migration. The active database is copied to a target and updated at least one time. In one preferred embodiment, updating occurs over decreasing time intervals. When the time intervals become sufficiently short, transition to the target server is implemented by queuing transaction requests from the source server and then executing them on the target server.

Disclosed are active and standby databases, consistency checking and recovering methods and apparatuses, and a storage medium. The consistency checking method comprises: sending a file exporting instruction to an active database, and exporting a to-be-checked active file from the active database; sending a file exporting instruction to a standby database, and exporting, from the standby database, a standby file corresponding to the active file; and comparing the active file with the standby file, to determine consistency between the active file and the standby file according to a comparison result.

The invention provides a method for the hot standby of dual database servers in the technical field of database systems. A system comprises an active database server and a standby database server. The two servers perform regular handshake, master-slave negotiation, data access and data synchronization through a synchronization network port. A server network port of the active database server employs a virtual Internet protocol (IP) address to externally provide server service, and a service network port of the standby database server does not externally provide database service. A database client accesses the active database server through the virtual IP address by adopting a transmission control protocol (TCP). A flexibly selectable real-time/quasi-real-time database synchronization mechanism, a comprehensive data consistency detection method for the active and standby database servers and a selectable data consistency recovery means are provided by the invention.

A data synchronization method is provided to enhance reliability and performance of the database. The data reflection method selection unit of the active server weights collected values in the resource utilization table by multiplying the collected values by assessment coefficients assigned to the individual collected values in an assessment coefficient table and sums up the weighted values to calculate an assessment value for each data reflection method, and determines the data reflection method whose assessment value is minimum. The log data transmission unit, according to the determined data reflection method, sends log data that is reflected on the active database to the standby server, which forms one of the duplicated servers making up the redundant configuration. The data reflection method identifies the content to be transmitted.

The invention relates to an allocation and recovery method of database connections. According to the allocation and recovery method, a database connection pool is used; the database connection pool comprises a global connection pool and a logical connection pool; the global connection pool comprises queues; the logical connection pool comprises queue corresponding to all databases. According to the invention, the queue structure of two connection pools is used, so that the connection in the sequence corresponding to the least active database or the connection never used can be found rapidly through the global connection pool, and the full utilization of connection resources of all the databases can be ensured.

Techniques are disclosed relating to efficiently processing of concurrent database transactions. In one embodiment, a database system receives a first key-value pair for a database transaction and stores the key-value pair in a data structure for active database transactions. The storing may include indexing into a hash table of the data structure with a key of the key-value pair to identify a hash bucket of the hash table corresponding to the key, acquiring a latch associated with the identified hash bucket, and, based on a state of the acquired latch, appending, to the hash bucket, a record specifying the key-value pair. The database system may cause the key-value pair from the data structure to be committed to persistent storage in response to the database transaction being committed.

A system that generates display objects in a graphical user interface that enable the user of an application which accesses a data repository through result sets to dynamically construct a new query to show all database records having the same contents as a specified set of fields in a currently active database record. Display objects are further generated that enable the user to specify how the contents of the selected fields are to be matched (e.g. exact matching, inclusion, etc.) and/or logical relationships between specified field contents (e.g. Boolean operators such as AND, OR, NOT, etc.). In one embodiment, once a query is defined in this way, it is stored, for example in the user's profile, so that the user can access it across uses of the application.

The invention discloses a device and method for quickly comparing table data in an active-active database. and the device comprises an extraction module which is used for extracting the table data ofto-be-compared data tables in a source end database and a target end database, and transmitting the extracted table data to-be-compared table data organized according to a preset comparison statementrule to a comparison control module; a comparison pool used for distinguishing and storing inconsistent table data in to-be-compared data tables of the source end database and the target end database; a comparison control module used for analyzing the content of the obtained to-be-compared table data, judging a data source of the to-be-compared table data, traversing data records opposite to thedata source in the comparison pool according to a judgment result, matching the data records, and inserting or deleting the data records of the to-be-compared table data in the comparison pool according to a matching result; and a comparison result output module used for outputting and displaying the remaining records of the comparison pool after the comparison control module compares all to-be-compared table data of the source end database with all to-be-compared table data of the target end database.

A system and method for adaptive advertisement management for the serving of vehicle description pages and an automated customer engagement thereof. The system is a cloud-based network containing a campaign database, an analytics database, an adaptive advertisement management, a short message service server with automated response capabilities, and user mobile and compute devices that transmit a vehicle description page associated with an advertisement campaign embedded with a communication initiator for display on a customer computing device. Taken together or in part, said system optimizes advertising campaigns across multiple platforms, provides strong analytics for all advertising types while allowing users to engage with advertising quickly and in a real-time automated fashion.

A method for preventing suspension of transactions in a database computing system by monitoring active database logs of the database computing system is provided. The method comprises switching archive units of the database computing system due to full database log condition occurring during system operations of the database computing system. The method further comprises maintaining a database log history table, wherein the database log history table captures a threshold count of the active database logs generated by system threads of the database computing system. The method further comprises defining a temporary location for archiving the active database logs based on the switched archive units of the database computing system, and the maintained threadhold count of active database logs in the database log history table due to full database log condition occurring during system operations of the database computing system.

The invention provides a database multi-activity method and a device. The method comprises the steps of obtaining to-be-multi-activity database nodes in a database architecture; for each database nodeto be active, obtaining data to be written; storing the to-be-written data to a to-be-active database node; synchronizing the to-be-written data to other to-be-activated database nodes of the database architecture in real time; data synchronization among the database nodes to be active is realized; according to the method, through obtaining to-be-written data of each to-be-active database node; storing the data to be written into a database node to be active, synchronizing the to-be-written data to other to-be-activated database nodes of the database architecture in real time, data synchronization between the database nodes to be active is realized, the situation that the whole service or part of the service is unavailable due to the failure of a single database is avoided, multiple activities of simultaneously providing the service by multiple database nodes are realized, and the disaster tolerance capability is improved.

The embodiment of the invention provides a database connection storm monitoring method and device, and the method comprises the steps: inputting an obtained active database connection number into a preset connection pool configuration algorithm model, and outputting database connection pool parameters; and configuring the database connection pool parameters to each micro-service instance. According to the database connection storm monitoring method and device provided by the embodiment of the invention, the database connection pool parameters are calculated by utilizing the preset connection pool configuration algorithm model according to the obtained active database connection number, and the occurrence probability of the database connection storm is reduced through the database connection pool in each micro-service instance. Moreover, manual participation is not needed, horizontal expansion can be realized, multiple sets of micro-service systems are controlled at the same time, the workload is effectively reduced, and the working efficiency is improved.

A method and arrangement for tracking individual operations executed in a specific computer program, where inputs made by the user are detected. Each detected input is compared with a set of operations defined in advance, which have been stored in an operation database. If a detected input matches some predefined operation in the comparison, that operation is registered as an executed activity in an activity database. The procedure is repeated for a number of inputs as executed during a recording session, wherein an activity list of performed operations is created in the activity database. This list can then be retrieved, after the recording session in order to track individual operations. Thereby, a course of events can be analyzed in detail after using the computer program, e.g. with the purpose of discovering erroneous operations.

The invention provides a business report integration method and device, equipment and a storage medium, and the method comprises the steps: searching a source database storing business reports; reading library table information in each source database, and generating a data dictionary according to each piece of library table information; generating acquisition scripts corresponding to the business reports according to the data dictionary, and acquiring task scripts for operating the business reports according to the acquisition scripts; recursively analyzing each task script to obtain a coupling relationship among the business reports; and obtaining the business reports in each source database, and storing the business reports and the coupling relationship between the business reports to obtain the target database. The method and device have the beneficial effects that the target database not only has all the business reports in each source database, but also reserves the coupling relationship among the business reports in the active database.

A system and method for adaptive advertisement management for the serving of product description pages and an integrated customer user engagement thereof. The system is a cloud-based network containing a campaign database, an adaptive advertisement management, a short message service server, and user mobile and compute devices that transmit a product description page associated with an advertisement campaign embedded with a communication initiator for display on a customer computing device. Taken together or in part, said system optimizes advertising campaigns across multiple platforms, provides strong analytics for all advertising types while allowing users to engage with advertising quickly and easily through various call to action types.

The invention provides a page data sending method. The method is used for sending page data to a client logged in by a user and comprises the steps that an activity database is established, the activity database is used for recording the number of times that all activity links are displayed for different users and the situation that activity pages corresponding to the activity links are requestedto be displayed by the user, and the initial value of the number of times that the activity links are displayed is 0; receiving a page request of a client, wherein the page request comprises user recognition information; based on the user recognition information, determining an activity link contained in the page data sent to the client according to a predetermined activity link display rule; sending page data containing the activity link, and meanwhile, increasing the display frequency of the corresponding activity link in the activity database by 1; and obtaining a situation that each activity page is requested to be displayed by a user, and updating the activity database. According to the method, marketing campaign delivery is more effectively carried out, the display strategy of the campaign page is optimized, and the marketing cost is reduced.