20 results about "Online transaction processing" patented technology

The invention provides predicate evaluation based on CPU utilization of a shared storage device. A hybrid transactional / analytic processing (HTAP) database includes an online transactional processing (OLTP) engine, an online analytic processing (OLAP) engine provided separately from the OLTP engine, and a shared storage that holds data for a plurality of tenants. The shared storage device is configured to receive a request from the OLAP engine for predicate evaluation for data stored on the shared storage device. The shared storage device is further configured to determine that the CPU utilization of the shared storage device exceeds a predicate rejection threshold. Upon determining that the CPU utilization of the shared storage device exceeds a predicate rejection threshold, the shared storage device is further configured to inhibit evaluation of at least a portion of the predicate.

A hybrid transactional / analytical processing (HTAP) database is provided. The HTAP database includes a shared storage holding data, an online analytical processing (OLAP) engine, and an online transaction processing (OLTP) engine provided separately from the OLAP engine. The OLTP engine includes a query router configured to route a query received by the OLTP engine to either the OLAP engine or the OLTP engine for execution.

Method and system of performing transactions with a payment card in a managed integrated payment environment comprising an integrated circuit are disclosed comprising interacting with an integrated circuit on a received payment card to obtain card data by a payment terminal and determining whether full online transaction processing of the card data is required. If full online transaction processing of the card data is required, the card data is sent to a point-of-sale terminal, which sends the card data and a transaction total for the transaction to a merchant gateway, which obtains approval or denial of the transaction. The approval or denial is provided to the PIN pad by the merchant gateway via the point-of-service terminal. The PIN pad also receives transaction data and sends the transaction data and card data to a services processor to collect metadata, perform fraud and security checks, and / or encrypt the card data.

A hybrid transactional / analytical processing (HTAP) database is provided, which includes an online transaction processing (OLTP) engine, an online analytical processing (OLAP) engine provided separately from the OLTP engine, and a shared storage holding data. The shared storage includes an OLTP storage holding data in row format for responding to queries of the OLTP engine, and an OLAP storage holding data in column format for responding to queries of the OLAP engine. The OLAP storage includes a delta store configured to record changes made to the OLTP storage in an update, and a base store configured to implement the update from the delta store on data in persistent storage in a flush. The HTAP database further includes a table metadata service configured to generate and perform operations on table metadata of the data that is updated in the flush.

This application discloses an event-driven database Autovacuum Worker scheduling method, system, and medium, belonging to the field of database resource scheduling technology. It addresses the problem of ensuring resource balance among multiple workers under high-concurrency online transaction processing loads. The method includes: real-time acquisition of multi-source events during database operation and construction of time-series data; determining trigger scores for each data table based on preset multi-dimensional event indicators; dynamically generating trigger decisions based on the type and severity of events corresponding to the trigger scores; dynamically adjusting worker processes according to the priority of the trigger decisions, the number of currently active worker processes, and system load; determining resource allocation limits based on the priorities of all active worker processes and system load; and executing table cleanup tasks through each worker process and the resource allocation limits.

Systems and methods for real time, online transaction processing are disclosed. The system may include one or more memory units storing instructions and one or more processors configured to execute the instructions to perform a method. The method may include receiving, from an event broker, event data that includes account data. The operations may include using a data structure to identify an issuer system associated with the account data and an enrollment status of the issuer system. The method may include generating a filtered transaction data structure to an analyzer and receiving a result data structure. The method may include generating, based on the result data structure, a linked data structure comprising installment loan parameters and an online address. The method may include routing the linked data structure to a user device and receiving approval data that triggers an account allocation.

The invention relates to generation of table metadata in an HTAP database during flushing. A hybrid transactional / analytic processing (HTAP) database is provided that includes an online transactional processing (OLTP) engine, an online analytic processing (OLAP) engine disposed separately from the OLTP engine, and a shared storage that holds data. The shared storage device includes an OLTP storage device that holds data for responding to a query of the OLTP engine in a row format, and an OLAP storage device that holds data for responding to a query of the OLAP engine in a column format. The OLAP storage device includes: an incremental storage region configured to record a change made to the OLTP storage device at the time of update; and a base storage area configured to implement updates from the incremental storage area on the data in the persistent storage device during flushing. The HTAP database also includes a table metadata service configured to generate table metadata of the data that is updated at the time of flushing and perform an operation on the table metadata of the data that is updated at the time of flushing.

The embodiment of the invention provides a transaction processing method and device, equipment and a storage medium, and relates to the technical field of finance, the technical field of computers and the technical field of online payment. The method comprises the steps of obtaining transaction processing information in response to a transaction processing request initiated by a target object of a client; wherein the transaction processing information at least comprises a transaction type, a transaction amount and a transaction identification code; and performing transaction processing according to the transaction type, the transaction amount and the transaction identification code to obtain a transaction processing result. According to the method, transaction processing can be directly carried out according to the transaction processing request provided by the client, the process of carrying out identity verification first after the transaction processing request is received is avoided, the transaction processing flow is simplified, the online transaction processing efficiency is improved, and the user experience is improved.

The invention provides intelligent query routing in a hybrid database. The present disclosure also provides a hybrid transaction / analytic processing (HTAP) database. The HTAP database includes a shared storage device that holds data, an online analytical processing (OLAP) engine, and an online transactional processing (OLTP) engine provided separately from the OLAP engine. The OLTP engine includes a query router configured to route a query received by the OLTP engine to the OLAP engine or the OLTP engine for execution.

The invention discloses a data heterogeneous query method, device and system and a storage medium, is applied to the technical field of data processing, realizes business decoupling and performance isolation, synchronizes data of an online transaction processing database to an online analysis processing database through a column type storage file and an object storage service, and improves the data processing efficiency. The online analysis processing database establishes a connection with the object storage service through an external table, and the query is accelerated by using the high-performance analysis capability of the online analysis processing database. Data processing and data analysis are physically separated, so that an online transaction processing database and an online analysis processing database respectively exert performance advantages, and the efficiency of data processing and data query is improved.

One or more embodiments of the invention provide a data synchronization method and device between databases, a storage medium and a product, the method is applied to a database API interface, and the database API interface is in butt joint with an online transaction processing (OLTP) database and an online analysis processing (OLAP) database; the method comprises the following steps: acquiring a data writing request initiated by a client for the OLTP database; according to the data writing request, triggering the OLTP database to execute a corresponding target data writing operation, and generating description information of target writing data corresponding to the target data writing operation; and synchronizing the target write-in data from the OLTP database to the OLAP database according to the description information.

Systems and methods for real time, online transaction processing are disclosed. The system may include one or more memory units storing instructions and one or more processors configured to execute the instructions to perform a method. The method may include receiving, from an event broker, event data that includes account data. The operations may include using a data structure to identify an issuer system associated with the account data and an enrollment status of the issuer system. The method may include generating a filtered transaction data structure to an analyzer and receiving a result data structure. The method may include generating, based on the result data structure, a linked data structure comprising installment loan parameters and an online address. The method may include routing the linked data structure to a user device and receiving approval data that triggers an account allocation.

A hybrid transactional / analytical processing (HTAP) database is provided, which includes an online transaction processing (OLTP) engine, an online analytical processing (OLAP) engine provided separately from the OLTP engine, and a shared storage holding data. The shared storage includes an OLTP storage holding data in row format for responding to queries of the OLTP engine, and an OLAP storage holding data in column format for responding to queries of the OLAP engine. The OLAP storage includes a delta store configured to record changes made to the OLTP storage in an update, and a base store configured to implement the update from the delta store on data in persistent storage in a flush. The HTAP database further includes a table metadata service configured to generate and perform operations on table metadata of the data that is updated in the flush.

A hybrid transactional / analytical processing (HTAP) database includes an online transaction processing (OLTP) engine, an online analytical processing (OLAP) engine provided separately from the OLTP engine, and a shared storage holding data of multiple tenants. The shared storage is configured to receive a request for a first scan from a first tenant and a request for a second scan from a second tenant, execute the first scan, and after a predetermined first period of time has elapsed without the first scan finishing, pause the first scan and execute the second scan.

This disclosure describes a Hybrid Transactional and Analytical Processing (HTAP) technology. An HTAP system includes: a first processing engine configured to perform online transaction processing, a second processing engine configured to perform online analytical processing, and a storage device communicating with the first and second processing engines. The first processing engine, the second processing engine, and the storage device may be modularized and configured to be decoupled from each other. The system may be configured to have the first processing engine capture data in real time, organize data in a first component of the storage device according to a first format for use by the first processing engine, propagate data to a second component of the storage device system, and organize data in a second format in the second component of the storage device for use by the second processing engine.

The embodiment of the invention provides a hybrid load scheduling method based on SQL fingerprints, and the method comprises the steps: receiving a to-be-processed SQL statement, and determining a first SQL fingerprint corresponding to the to-be-processed SQL statement; determining a target thread classification category of the first SQL fingerprint according to the first SQL fingerprint and an SQL fingerprint classification table; and processing the to-be-processed SQL statement according to the target thread classification category and a pre-allocated execution thread resource to obtain a target processing result corresponding to the to-be-processed SQL statement. The continuity of online transaction processing execution and the stability of delay are improved, the operation and maintenance efficiency is improved, and the system stability is guaranteed.

This application provides a data processing method, apparatus, device, and storage medium for multi-cluster scenarios. The method involves receiving consumption requests from data consumption applications via a forwarding proxy cluster; forwarding the consumption requests to an access control and data routing service cluster via the forwarding proxy cluster; controlling the access control and data routing service cluster to perform authentication based on the access information in the consumption request; if authentication is successful, controlling the access control and data routing service cluster to query the online transaction processing database to determine the Hadoop cluster Internet Protocol address corresponding to the consumption request, and returning the Hadoop cluster Internet Protocol address to the forwarding proxy cluster; after receiving the Hadoop cluster Internet Protocol address, controlling the forwarding proxy cluster to replace the Internet Protocol address in the consumption request with the Hadoop cluster Internet Protocol address, and sending the data access request to the corresponding Hadoop cluster according to the Hadoop cluster Internet Protocol address, thereby achieving data routing.

The invention provides a bank core system account daily end balance determination method and system, and belongs to the technical field of bank data processing, and the method comprises the steps: adding a daily end batch updating account information configuration table in a database; and after daily switching of the core system, according to the daily end batch updating account information configuration table, querying related account information in a non-account-cancelling state that the account daily end balance is not equal to the current account balance in the account table of the core system, and performing batch updating on the queried account information to obtain the updated account daily end balance. The account information can be processed in parallel in a large scale, and the daily end balance updating efficiency of the account is improved. Besides, in the process of executing the day-end batch task of the account information, day-to-day online transaction processing is carried out on the account subjected to the online accounting transaction in time, the account day-end balance calculation error of the account subjected to the accounting transaction before the day-end batch task is completed from the day switching time point of the core system is prevented, and the calculation accuracy is ensured.

Systems and methods for data partitioning are provided. The data on the data nodes are organized according to a range interval (named as a partition) with a fixed size. The index table and the log table of the data node are not partitioned. A process is disclosed that does not affect read operations by applying MVCC visibility rules, splits partitions online and moves partitions between nodes, and maximizes data availability during partition operations such as splitting and moving. A new process is also disclosed that maximizes availability in the splitting process by enabling certain write operations to be performed in the partition currently being split.

A hybrid transactional / analytical processing (HTAP) database includes an online transaction processing (OLTP) engine, an online analytical processing (OLAP) engine provided separately from the OLTP engine, and a shared storage holding data of multiple tenants. The shared storage is configured to receive a request for a first scan from a first tenant and a request for a second scan from a second tenant, execute the first scan, and after a predetermined first period of time has elapsed without the first scan finishing, pause the first scan and execute the second scan.