12 results about "On line analytical processing" patented technology

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.

The invention relates to the technical field of remote sensing, in particular to a remote sensing image on-line analysis processing system, which comprises an identification module used for acquiring a target remote sensing image and corresponding auxiliary geographic data; the correction module is used for correcting the target remote sensing image; the processing module is used for optimizing the correction result of the target remote sensing image; through multi-source data fusion, efficient storage, an adaptive correction model and a real-time error feedback mechanism, the problems of low precision, poor efficiency and insufficient complex scene adaptability in traditional remote sensing image processing are solved, high-precision and high-efficiency online analysis processing is realized, and the application value of the remote sensing image is remarkably improved.

This disclosure describes storage techniques for hybrid transactional and analytical processing. Data captured by a first processing engine can be received. The first processing engine can be configured to perform online transactional processing. Multiple copies of a logical log generated based on the data can be distributed to an incremental repository by applying a consensus protocol on the multiple copies. Data in the incremental repository is stored in a row format and is visible to queries of online analytical processing performed by a second processing engine. Data can be flushed from the incremental repository to a base repository based on one or more predetermined rules. Data in the base repository is stored in a columnar format and is accessible by the second processing engine.

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.

A bank-level dynamic random access memory (DRAM) process-in-memory (DRAM-PIM) filtering architecture is provided to accelerate database online analytical processing (OLAP) queries. Also, sub-array-level dynamic random access memory (DRAM) process-in-memory (DRAM-PIM) filtering architectures are provided to accelerate database online analytical processing (OLAP) queries.

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.

An enhanced multidimensional data management system significantly reduces the resources required to convert a spreadsheet into an enterprise collaborative system. A spreadsheet may be imported as is without modifications. Additional information that cannot be automatically inferred about the data model used in the spreadsheet is obtained. Dimensions, timescale, and measure data are clearly defined and located. The spreadsheet is kept in the system in the form of both a spreadsheet and as a multidimensional data structure such as an online analytical processing (OLAP) cube or structure. This duality allows the spreadsheet to be manipulated as if it was an OLAP cube, modifying iterations within the dimensions, and the OLAP cube to be computed as if it was a spreadsheet.

The present disclosure provides a hybrid transactional and analytic processing database with shared smart storage. 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 for a first scan from a first tenant and a request for a second scan from a second tenant, perform the first scan, and suspend the first scan and perform the second scan after a predetermined first time period has elapsed without the first scan being ended.

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.

The invention belongs to the technical field of oil storage tank safety protection, and particularly relates to an oil storage tank accessory anti-freezing and anti-blocking risk diagnosis device in a low-temperature environment and a use method. Comprising an electric valve, the electric valve is installed on a switching pipeline and a buffer pipeline, the switching pipeline is communicated with the buffer pipeline, the buffer pipeline is communicated with a low-temperature test pipeline, the low-temperature test pipeline is led into a low-temperature box, the low-temperature box is connected with a console, and a risk diagnosis control software system is arranged in the console. The research and development of the device fill the blank of storage tank accessory operation state risk diagnosis technical equipment in the domestic main oil and gas area freezing and blocking environment, and perfects the real environment mimicry simulation analysis means of the storage tank accessory. The risk diagnosis control software system has the functions of real-time automatic monitoring, adjustment, storage, transmission, online analysis and processing and the like of parameters such as flow, wind speed, pressure, temperature and the like, real-time display and output of a detection diagnosis result curve are achieved, and errors caused by manual audition judgment are overcome.

Here is database integration in which a relational table and an analytic view are generated and configured in a relational database for acceleration and optimally populated from summarization hierarchies derived from a dimension in a multidimensional database. This approach is a new way to transfer online analytical processing (OLAP) metadata from a multidimensional database to a relational database. Shared members may cause this approach to generate a directed acyclic graph (DAG) that organizes the metadata. The OLAP content generated in the relational database has a novel data topology that is unconventional because relational data normalization strategies such as third normal form (3NF) are avoided. This novel data topology achieves unprecedented data locality of metadata in a relational database. Due to optimization techniques such as graph coloring for detection and resolution of conflicts caused by shared members, the accuracy and speed of the data integration between the two databases is increased.

Here is database integration in which a relational table and an analytic view are generated and configured in a relational database for acceleration and optimally populated from summarization hierarchies derived from a dimension in a multidimensional database. This approach is a new way to transfer online analytical processing (OLAP) metadata from a multidimensional database to a relational database. Shared members may cause this approach to generate a directed acyclic graph (DAG) that organizes the metadata. The OLAP content generated in the relational database has a novel data topology that is unconventional because relational data normalization strategies such as third normal form (3NF) are avoided. This novel data topology achieves unprecedented data locality of metadata in a relational database. Due to optimization techniques such as graph coloring for detection and resolution of conflicts caused by shared members, the accuracy and speed of the data integration between the two databases is increased.