-
Book Overview & Buying
-
Table Of Contents
AI-Ready PostgreSQL 18
By :
In this chapter, we reviewed two approaches to moving data from the transactional system to the analytics system: logical replication to create a near-real-time solution, and batch copying, which is much simpler to implement but does not support real-time analytics.
Because the batch-copy approach is straightforward to implement and operate, it is often used as a starting point. It can create the same data model as the logical replication approach, but it introduces significant delays between the transactional and analytics systems. Also, in very large data warehouses, a complete refresh of the data requires lengthy batch windows and can quickly become impractical.
Both solutions can be used for the first two steps of the ELT process introduced in this chapter, and they create the data foundation for the transformation step of the ELT process, which will be discussed in the next chapter.
Scan the QR code...