Tagged articles
ELT
17 articles · Page 1 of 1
This article explains the core differences between ETL, ELT, and ETLT data integration patterns, emphasizing that the key distinction is where transformation occurs—before or after loading—and provides five decision criteria for choosing the right approach based on data latency, raw data retention, compute costs, and business logic volatility.
ELTETLETLT
0 likes · 16 min read

The article breaks down the distinct purposes of data synchronization, ETL, ELT, and full data integration, explains the problems each solves, provides criteria for choosing the right approach, and highlights how a unified platform can manage the entire data pipeline.
Data EngineeringELTETL
0 likes · 14 min read

This article explains the four common data integration patterns—ETL, ELT, API‑based, and message‑queue approaches—detailing their core workflows, suitable scenarios, advantages, and trade‑offs so readers can choose the method that best fits their business and technical constraints.
APIData EngineeringELT
0 likes · 10 min read

This article compares ETL and ELT across workflow, efficiency, data volume, supported data types, resource consumption, transformation capabilities, technical requirements, error handling, and maintenance cost, and provides practical criteria for enterprises to select the most suitable approach.
ELTETLbig data
0 likes · 13 min read

This article explains how dbt drives automated data modeling and governance, how DataOps practices bring agility and control to data projects, and how StarRocks’ lakehouse architecture enables real‑time and batch analytics, illustrated with concrete workflows, version‑control conventions, and enterprise case studies.
Data ModelingDataOpsELT
0 likes · 14 min read

This article details the real‑world migration of Southeast Asian tech leader GoTerra from BigQuery to MaxCompute, showcasing how the open‑source dbt‑maxcompute adapter enables smooth ELT transitions, advanced incremental strategies, performance gains, ecosystem compatibility, and comprehensive best‑practice implementations for large‑scale data pipelines.
ELTIncremental StrategyMaxCompute
0 likes · 13 min read

This article introduces Apache SeaTunnel, a modern data integration platform designed for the EtLT era, detailing its architecture, core connector APIs, checkpoint mechanism, model inference, multi‑table synchronization, the high‑performance SeaTunnel Zeta engine, OLAP use cases, community roadmap, and the commercial WhaleTunnel product.
Apache SeaTunnelELTETL
0 likes · 22 min read

The article examines the evolution of data integration architectures—from traditional ETL through ELT to the emerging EtLT model—highlighting their advantages, disadvantages, industry trends, maturity stages, and practical guidance for enterprises and professionals navigating modern big‑data pipelines.
DataOpsELTETL
0 likes · 31 min read


ITPUBDec 28, 2023 · Databases
ByConity 0.3.0 introduces a new inverted index supporting Chinese tokenization, a shared‑storage leader election mechanism, enhanced cold‑read performance via Prefetch and adaptive mark allocation, and an upgraded ELT pipeline with BSP mode, all detailed with implementation steps, code examples, and future roadmap.
ByConityCold ReadELT
0 likes · 13 min read

This article explains how ByteHouse, a cloud‑native data warehouse, shifts traditional ETL to ELT, simplifies data pipelines, enhances scalability, and introduces advanced features such as stage‑by‑stage scheduling, adaptive resource management, async execution, and future roadmap for big‑data workloads.
ByteHouseELTSQL Optimization
0 likes · 16 min read

This article introduces LakeSoul, an open‑source end‑to‑end real‑time lakehouse framework, detailing its design philosophy, key technologies such as ELT, metadata management, upsert and merge‑on‑read capabilities, performance benchmarks, real‑world use cases, and the roadmap for future enhancements.
ELTFlink CDCLakeSoul
0 likes · 18 min read


21CTOJun 20, 2023 · Fundamentals
ETL extracts, transforms, then loads data, while ELT extracts, loads, and transforms later, each offering distinct advantages; the article compares their processes, key differences, and factors such as data volume, complexity, latency, and cost to help businesses choose the optimal integration approach.
ELTdata integrationdata warehousing
0 likes · 12 min read

This article explains data integration fundamentals, compares data integration tools such as Stitch, Fivetran, and Airbyte, describes the concepts of data warehouses and data lakes, outlines ETL vs ELT processes, and explores building modern data stacks with Flink CDC and cloud services.
ELTETLFlink CDC
0 likes · 17 min read

This article examines the explosion of heterogeneous data sources, the limitations of traditional data lakes and warehouses, and proposes a distributed lakehouse architecture that integrates advanced management layers to improve data governance, reliability, and support both SQL and advanced analytics workloads.
ELTETLdata governance
0 likes · 29 min read

This article examines the essential considerations for selecting a modern data warehouse—including data volume, staffing, scalability, and pricing models—while comparing on‑premise and cloud solutions such as Redshift, BigQuery, and Snowflake to help organizations make informed decisions.
ELTETLcloud
0 likes · 9 min read


ITPUBJan 22, 2023 · Big Data
This article details a banking‑focused real‑time data‑warehouse solution that leverages Flink Table Store to handle both incremental fact‑table updates and full‑table dimension calculations, compares three traditional approaches, and explains data ingestion, query modes, export options, and future streaming‑warehouse directions.
ELTFlinkTable Store
0 likes · 20 min read

This article examines essential considerations such as data volume, personnel support, scalability, and pricing models when selecting a data warehouse solution, comparing on‑premise options with modern cloud services like Redshift, BigQuery, and Snowflake for various workload sizes.
ELTETLcloud
0 likes · 11 min read
