Frank Z

Breaking Down Data Silos With a Unified Data Warehouse: An Apache Doris-Based CDP

An insurance company uses Apache Doris in replacement of Spark+Impala+HBase+NebulaGraph, in their Customer Data Platform for 4 times faster customer grouping.

March 19, 2024

· 2,646 Views · 2 Likes

A Financial Anti-Fraud Solution Based on the Apache Doris Data Warehouse

This post will go into detail about how a retail bank builds its fraud risk management platform based on Apache Doris and how it performs.

February 26, 2024

· 3,255 Views · 1 Like

How Inverted Index Accelerates Text Searches by 40 Times

This post is a deep dive into the inverted index and NGram BloomFilter index, providing a hands-on guide to applying them for various queries.

February 1, 2024

· 2,276 Views · 2 Likes

Fast, Secure, and Highly Available Real-Time Data Warehousing Based on Apache Doris

A whole-journey guide for financial users looking for fast data processing performance, data security, and high service availability.

January 11, 2024

· 2,342 Views · 1 Like

Apache Doris Speeds Up Data Reporting, Tagging, and Data Lake Analytics

The user leverages the capabilities of Apache Doris in reporting, customer tagging, and data lake analytics and achieves high performance.

December 29, 2023

· 4,328 Views · 2 Likes

From Elasticsearch to Apache Doris: Upgrading an Observability Platform

An observability platform replaces its data query and storage engine and realizes 70% less storage costs and 200%~400% query performance.

December 20, 2023

· 3,368 Views · 1 Like

Introduction to Apache Doris: A Next-Generation Real-Time Data Warehouse

This is a technical overview of Apache Doris, introducing how it enables fast query performance with its architectural design, features, and mechanisms.

December 13, 2023

· 2,708 Views · 2 Likes

Data Analysis for Live Streaming: What Happens in Real Time Is Analyzed in Real Time?

This post is about how a live streaming service provider with 800 million end users found the right database to support its analytic solution.

November 16, 2023

· 1,799 Views · 2 Likes

Less Components, Higher Performance

This post is about building a unified OLAP platform to undertake all their customer-facing, analyst-facing, and management-facing data analysis workloads.

November 2, 2023

· 2,502 Views · 1 Like

Auto-Synchronization of a Whole MySQL Database for Data Analysis

Learn how to automatically ingest and update MySQL or Oracle database into an OLAP engine, and say goodbye to tedious manual configuration.

October 13, 2023

· 2,473 Views · 1 Like

Database in Fintech: How To Support 10,000 Dashboards Without Causing a Mess

This article introduces the lifecycle of financial metrics in a database, from how they're produced to how they're efficiently presented in data reports.

October 11, 2023

· 1,781 Views · 1 Like

Migrating From ClickHouse to Apache Doris: What Happened?

Explore this migration process from ClickHouse to Apache Doris to figure out if it is the right move for you and your data.

October 2, 2023

· 2,104 Views · 1 Like

Choosing an OLAP Engine for Financial Risk Management: What To Consider?

This post provides reference for what you should take into account when choosing an OLAP engine in a financial scenario.

August 16, 2023

· 1,702 Views · 1 Like

Is Your Latest Data Really the Latest? Check Your Data Update Mechanism

This is about how to support both row updates and partial column updates in a database in a way that is simple in execution and efficient in data quality guarantee.

July 26, 2023

· 5,193 Views · 2 Likes

For Entry-Level Data Engineers: How To Build a Simple but Solid Data Architecture

This article aims to provide a reference for non-tech companies who are seeking to empower their business with data analytics.

July 12, 2023

· 2,441 Views · 1 Like

Hot-Cold Data Separation: What, Why, and How?

Hot data is the frequently accessed data, while cold data is the one you seldom visit but still need. Separating them is for higher efficiency in computation and storage.

June 28, 2023

· 2,034 Views · 1 Like

Database Dissection: How Are Fast Data Queries Implemented?

What's more important than the quick performance itself is the architectural design and mechanism that enable it. The rest will be easy.

June 23, 2023

· 5,756 Views · 1 Like

Say Goodbye to OOM Crashes

A more robust and flexible memory management solution with optimizations in memory allocation, memory tracking, and memory limit.

June 14, 2023

· 1,824 Views · 1 Like

Understanding Data Compaction in 3 Minutes

Think of your disks as a warehouse: The compaction mechanism is like a team of storekeepers who help put away the incoming data.

June 6, 2023

· 2,554 Views · 1 Like

Building A Log Analytics Solution 10 Times More Cost-Effective Than Elasticsearch

Inverted indexing in Apache Doris 2.0.0 realizes two times faster log query performance than Elasticsearch with 1/5 of the storage space it uses.

May 19, 2023

· 4,748 Views · 4 Likes

30,000 QPS Per Node: How We Increase Database Query Concurrency by 20 Times

Learn five ways to accelerate point queries and four methods to improve concurrency further: row storage format, short circuit, prepared statement, and row storage cache.

April 26, 2023

· 1,405 Views · 1 Like