Tag: T+0

T+0 query refers to real-time data query, and the latest data can be queried during data statistics. There are also T+1, T+7, etc., which means that you can only query data 1 day or 7 days ago. Obviously, T+N query is not real-time. This article will discuss some main T+0 query technologies. Database The simplest way to realize T+0 query through database is to directly use a single business database for a query. All data are stored in one database, and it can naturally realize real-time data query. However, this method is only applicable to scenarios where the amount of data

T+0 problems T+0 queries refer to querying and summarizing data, including the latest data, in real-time. They can be easily handled directly based on the production database when the amount of involved data is relatively small. Yet, when data accumulates to a certain extent, a query on large tables in the production database will consume a lot of database resources, and when too much is used up, even business transactions are affected. This is unacceptable because transactions are the highest priority. In an effort to prevent transactions from being affected by query processing, the huge amount of historical data for