BestHub
Sign in
Tagged articles

data modeling

275 articles · Page 3 of 3
DataFunTalk
DataFunTalk
Sep 24, 2020 · Databases

Understanding OLAP vs. OLTP and the Fundamentals of Data Warehousing

This article explains the core differences between OLTP and OLAP, evaluates whether traditional OLTP databases like MySQL can handle analytical workloads, introduces benchmark queries, and provides a comprehensive overview of data‑warehouse concepts such as data sources, fact and dimension tables, multi‑dimensional modeling, and common cube operations.

AnalyticsData WarehouseHTAP
0 likes · 21 min read
Understanding OLAP vs. OLTP and the Fundamentals of Data Warehousing
政采云技术
政采云技术
Aug 30, 2020 · Frontend Development

High-Quality Maintainable Code: Data Modeling for Frontend Development

This article explains the fundamentals of data modeling for front‑end development, covering its three core elements, integrity constraints, domain‑driven design, layered architecture, and practical guidelines for building clean, maintainable front‑end data models.

Domain-Driven Designdata modelingfrontend
0 likes · 14 min read
High-Quality Maintainable Code: Data Modeling for Frontend Development
Programmer DD
Programmer DD
Aug 22, 2020 · Backend Development

Why Elasticsearch Can Be Slow and How to Supercharge Its Performance

This article examines common Elasticsearch interview questions, explains why initial searches can be slow, and provides practical strategies such as leveraging filesystem cache, data pre‑heating, cold‑hot index separation, minimal document design, and scroll or search_after APIs to dramatically improve search performance and pagination efficiency.

ElasticsearchFilesystem CachePerformance Optimization
0 likes · 13 min read
Why Elasticsearch Can Be Slow and How to Supercharge Its Performance
Big Data Technology & Architecture
Big Data Technology & Architecture
Aug 16, 2020 · Big Data

Designing a Reusable and Standardized Data Warehouse Model for a Data Middle Platform

The article explains how to evaluate and improve data warehouse design by measuring completeness, reusability and standardization, proposes concrete metrics such as cross‑layer reference rate and model reuse coefficient, and outlines a step‑by‑step process—from ODS control to domain division, dimension unification, fact‑table integration, model development and migration—while introducing the EasyDesign tool for systematic management.

Data PlatformGovernanceMetrics
0 likes · 14 min read
Designing a Reusable and Standardized Data Warehouse Model for a Data Middle Platform
Ctrip Technology
Ctrip Technology
Aug 6, 2020 · Big Data

Data Governance Practices and Model Design in Ctrip Vacation Data Warehouse

This article shares the practical experience and thinking behind Ctrip's vacation data governance project, covering team efficiency optimization, demand sorting, data domain definition, warehouse layering, unified dimension modeling, metric standardization, and the overall benefits of a centralized data governance framework.

Big DataCtripData Governance
0 likes · 17 min read
Data Governance Practices and Model Design in Ctrip Vacation Data Warehouse
Xianyu Technology
Xianyu Technology
Aug 6, 2020 · Product Management

Xianyu Product Understanding and Quality Item Selection Framework

Xianyu’s new quality‑item framework evaluates each listing through product, supply‑demand, price, and seller attributes to compute a quality score, optimizes a balanced pool of high‑quality items, and—validated by back‑testing and simulations—boosts click‑through and payment conversion rates dramatically.

Optimizationdata modelinge-commerce
0 likes · 8 min read
Xianyu Product Understanding and Quality Item Selection Framework
Tencent Cloud Developer
Tencent Cloud Developer
Jul 13, 2020 · Big Data

Building MVP: A Lightweight Big Data Analysis System for Product Growth

The article describes how a lightweight big‑data analysis platform called MVP was built from scratch—using a User‑Event‑Config model, HDFS + ClickHouse + Spark, and four modules for metric monitoring, root‑cause alerts, deep growth analysis, and A/B testing—enabling real‑time insights in seconds instead of days and dramatically accelerating product‑growth operations.

AARRR ModelClickHouseHDFS
0 likes · 9 min read
Building MVP: A Lightweight Big Data Analysis System for Product Growth
58 Tech
58 Tech
Jul 13, 2020 · Big Data

Design and Implementation of a Financial Data Warehouse: Architecture, Modeling, Quality Monitoring, and Metadata Management

This article presents a comprehensive design and implementation guide for a financial data warehouse, covering background needs, modeling methodology choices, a layered architecture, data quality monitoring, metadata management, naming and coding standards, and future development directions.

Big DataData QualityData Warehouse
0 likes · 11 min read
Design and Implementation of a Financial Data Warehouse: Architecture, Modeling, Quality Monitoring, and Metadata Management
Architecture Digest
Architecture Digest
Jul 8, 2020 · Backend Development

Understanding GraphQL: Advantages Over REST and Core Concepts

This article explains the limitations of traditional REST APIs, introduces GraphQL as a flexible alternative, and details its core concepts, type system, server‑client architectures, deployment options, and popular tools and services for modern backend development.

API designGraphQLREST
0 likes · 14 min read
Understanding GraphQL: Advantages Over REST and Core Concepts
Big Data Technology Architecture
Big Data Technology Architecture
Jul 8, 2020 · Big Data

Key Interview Questions on Data Warehousing, Data Platforms, and Related Technologies

This article compiles a comprehensive set of 32 interview questions covering data warehouse fundamentals, data platform construction, modeling approaches, real‑time architectures, data quality, governance, Hive optimization, and related analytical techniques to help candidates prepare for data engineering roles.

Data PlatformData WarehouseETL
0 likes · 4 min read
Key Interview Questions on Data Warehousing, Data Platforms, and Related Technologies
Architects Research Society
Architects Research Society
Jun 15, 2020 · Databases

Overview of Data Modeling, Architecture, Master Data Management, Metadata, and Data Quality

This article explains the concepts of data modeling and architecture, including logical data, process, and rule modeling, various data model types, master data management principles, metadata categories, and data quality management practices, highlighting their roles in enterprise information systems.

Data QualityMaster Data ManagementMetadata
0 likes · 9 min read
Overview of Data Modeling, Architecture, Master Data Management, Metadata, and Data Quality
JD Tech Talk
JD Tech Talk
Jun 5, 2020 · Information Security

From System Engineering to Anti‑Black‑Market: Lin Yuansheng’s Journey in JD’s Intelligent Risk Detection

Lin Yuansheng, JD’s first post‑doctoral researcher, leverages his system‑engineering background and big‑data analytics to build models that identify black‑market accounts, improve network risk perception, and demonstrate how academic research can be rapidly applied to real‑world e‑commerce security challenges.

Risk Detectiondata modelingsystem engineering
0 likes · 8 min read
From System Engineering to Anti‑Black‑Market: Lin Yuansheng’s Journey in JD’s Intelligent Risk Detection
dbaplus Community
dbaplus Community
Jun 2, 2020 · Big Data

How Cainiao Built a Scalable Real‑Time Data Warehouse with Flink

Facing growing order volumes and strict timeliness demands, Cainiao’s tech team overhauled its real‑time data warehouse by redesigning data models, adopting Flink for streaming computation, upgrading data services, and exploring innovative tools, sharing practical lessons and future directions for large‑scale logistics analytics.

Big DataFlinkStreaming
0 likes · 18 min read
How Cainiao Built a Scalable Real‑Time Data Warehouse with Flink
ITPUB
ITPUB
Jun 1, 2020 · Databases

How Ant Financial Scales Payments: Data Patterns and Disaster‑Recovery Strategies

This article examines how Ant Financial redesigned its payment system’s data layer after retiring mainframes, detailing RTO/RPO goals, CAP trade‑offs, vertical and horizontal sharding, blacklist‑based accounting DR, failover mechanisms for transactions, and the role of OceanBase in achieving strong consistency and low‑latency recovery.

Disaster Recoverydata modelingdatabase sharding
0 likes · 17 min read
How Ant Financial Scales Payments: Data Patterns and Disaster‑Recovery Strategies
Architects Research Society
Architects Research Society
May 25, 2020 · Databases

Concern-Driven Data Architecture and Full-Scale Schema Modeling

The article explores a concern‑driven approach to data architecture, introducing a full‑scale schema modeling framework that balances data control, flexibility, push/pull delivery, and governance, and discusses multi‑level concerns, property‑graph standards, and practical scenarios for evolving schemas in complex business contexts.

Property Graphconcern-drivendata modeling
0 likes · 18 min read
Concern-Driven Data Architecture and Full-Scale Schema Modeling
Efficient Ops
Efficient Ops
May 20, 2020 · Operations

How to Build a Sustainable CMDB: Three Essential Phases for Reliable Operations

This article explains how to design, implement, and maintain a robust Configuration Management Database (CMDB) by focusing on simple modeling, establishing data closure loops, and efficiently handling existing inventory, while leveraging Kafka, Flink, Elasticsearch, and Neo4j for fast querying and topology visualization.

AutomationCMDBMonitoring
0 likes · 19 min read
How to Build a Sustainable CMDB: Three Essential Phases for Reliable Operations
HomeTech
HomeTech
May 20, 2020 · Big Data

AutoHome Data Warehouse Architecture and Layered Model Design

This article describes AutoHome's data warehouse architecture, detailing its background, business pain points, layered model design (RDM, ADM, GDM, FDM, Stage/BDM, DIM, TMP), advantages in performance, cost, efficiency, quality, and various application scenarios including BI, analytics, and decision support.

BIETLdata modeling
0 likes · 10 min read
AutoHome Data Warehouse Architecture and Layered Model Design
DataFunTalk
DataFunTalk
May 14, 2020 · Big Data

Building a Real-Time Data Warehouse at Cainiao: Architecture, Model Upgrades, Engine Enhancements, and Service Innovations

This article shares Cainiao's practical experience in constructing a real-time data warehouse, covering the shortcomings of the previous architecture, the evolution of data models, the migration to Flink with advanced features like retraction and timer services, and the modernization of data services and tooling to support high‑throughput logistics scenarios.

Big DataData ServiceFlink
0 likes · 16 min read
Building a Real-Time Data Warehouse at Cainiao: Architecture, Model Upgrades, Engine Enhancements, and Service Innovations
WecTeam
WecTeam
Apr 8, 2020 · Frontend Development

How MPM Revolutionizes H5 Page Data Modeling for Efficient Multi‑Platform Rendering

This article details how JD's MPM visual H5 page builder tackles complex data‑request challenges by introducing a unified data model, request aggregation, and three‑end rendering support, offering a scalable solution that improves performance, maintainability, and developer experience across web, app, and server‑side rendering.

H5MPMdata modeling
0 likes · 23 min read
How MPM Revolutionizes H5 Page Data Modeling for Efficient Multi‑Platform Rendering
360 Quality & Efficiency
360 Quality & Efficiency
Mar 24, 2020 · Big Data

Understanding Granularity in Data Warehouse Design

This article explains the concept of granularity in data warehouse design, describing data models composed of structures, operations, and constraints, illustrating how granularity affects storage detail, query performance, and resource consumption, and recommending a dual‑granularity approach to balance efficiency and analytical depth.

AnalyticsBig DataData Warehouse
0 likes · 5 min read
Understanding Granularity in Data Warehouse Design
Big Data Technology Architecture
Big Data Technology Architecture
Feb 15, 2020 · Databases

An Introduction to HBase: Architecture, Data Model, Storage Engine, Indexing, Features, and Use Cases

This article provides a comprehensive overview of HBase, covering its LSM‑Tree based storage engine, key‑value data model, column‑family storage design, indexing mechanisms, major advantages and drawbacks, and typical scenarios where HBase excels for massive, high‑throughput data workloads.

Distributed storageHBaseIndexing
0 likes · 8 min read
An Introduction to HBase: Architecture, Data Model, Storage Engine, Indexing, Features, and Use Cases
Big Data Technology Architecture
Big Data Technology Architecture
Feb 13, 2020 · Big Data

Evolution of Cainiao's Real-Time Data Warehouse Architecture: Model, Compute Engine, and Data Service Upgrades

The talk details Cainiao’s evolution of its real‑time data warehouse architecture, covering the original 2016 model, compute and service challenges, the 2017 multi‑layer data model redesign, migration to Flink, practical cases of state retraction, timeout statistics, smart optimizations, and the unified data service platform.

Data ServiceFlinkReal-Time Data Warehouse
0 likes · 16 min read
Evolution of Cainiao's Real-Time Data Warehouse Architecture: Model, Compute Engine, and Data Service Upgrades
58 Tech
58 Tech
Feb 10, 2020 · Big Data

Construction and Practice of a Site-wide User Behavior Data Warehouse at 58.com

This article systematically describes the challenges, design principles, modeling methods, layered architecture, implementation steps, and standards used in building a comprehensive user behavior data warehouse for 58.com, highlighting practical experiences and future improvement directions.

Big DataData QualityData Warehouse
0 likes · 11 min read
Construction and Practice of a Site-wide User Behavior Data Warehouse at 58.com
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 26, 2019 · Databases

Database Design: From ER Modeling to Normalization

This article explains the importance of good database design, walks through the stages of building an ER conceptual model, shows how to map entities, attributes, and relationships to relational schemas, and demonstrates how normalization (1NF, 2NF, 3NF, BCNF) improves schema quality using practical examples.

Database DesignER Modelingdata modeling
0 likes · 17 min read
Database Design: From ER Modeling to Normalization
vivo Internet Technology
vivo Internet Technology
Dec 18, 2019 · Big Data

Comprehensive Overview of Big Data Architecture, Lambda/Kappa Models, and End-to-End Data Platform Design

The article surveys modern big‑data architecture, contrasting Lambda and Kappa models, highlights common governance and integration pain points, and proposes an end‑to‑end platform featuring unified metadata, stream‑batch processing, one‑click ingestion, standardized modeling, intelligent query abstraction, and a comprehensive development IDE.

Big DataData PlatformETL
0 likes · 13 min read
Comprehensive Overview of Big Data Architecture, Lambda/Kappa Models, and End-to-End Data Platform Design
Big Data Technology & Architecture
Big Data Technology & Architecture
Nov 13, 2019 · Databases

ClickHouse Engines: Use Cases, Syntax, and Limitations

This article provides a comprehensive overview of ClickHouse, covering its typical application scenarios, inherent limitations, common SQL syntax, default values, data types, materialized and expression columns, and detailed explanations of its various storage engines such as TinyLog, Log, Memory, Merge, Distributed, Null, Buffer, Set, MergeTree, ReplacingMergeTree, SummingMergeTree, AggregatingMergeTree, and CollapsingMergeTree, accompanied by practical code examples.

Big DataClickHouseDatabase Engines
0 likes · 25 min read
ClickHouse Engines: Use Cases, Syntax, and Limitations
System Architect Go
System Architect Go
Oct 27, 2019 · Databases

Mastering InfluxDB: Data Types, Schema Design, and Index Configuration

This guide explains InfluxDB’s schemaless data types, best practices for designing tag‑and‑field schemas, and how to choose and configure its in‑memory or TSI indexes, including key parameters such as max‑series‑per‑database and max‑values‑per‑tag for optimal performance.

ConfigurationIndexingInfluxDB
0 likes · 6 min read
Mastering InfluxDB: Data Types, Schema Design, and Index Configuration
System Architect Go
System Architect Go
Oct 25, 2019 · Databases

Understanding InfluxDB: Core Concepts, Architecture, and Design Trade‑offs of a Time‑Series Database

This article explains the fundamentals of time‑series databases, introduces InfluxDB’s key components such as databases, measurements, retention policies, tags, fields, series, and points, describes the line protocol syntax, compares it with traditional databases, and outlines the design trade‑offs that shape its performance and limitations.

Database DesignInfluxDBLine Protocol
0 likes · 10 min read
Understanding InfluxDB: Core Concepts, Architecture, and Design Trade‑offs of a Time‑Series Database
Meituan Technology Team
Meituan Technology Team
Oct 17, 2019 · Big Data

OneData Methodology: Building a Unified Data Warehouse Architecture and Governance Framework

By adapting Alibaba’s OneData methodology, the project establishes a unified data‑warehouse architecture, standards, and governance framework—including consolidated business intake, standardized design layers, naming conventions, and delivery metrics—that resolves data‑quality issues, enhances scalability and reusability, and delivers faster, reliable data support for evolving business needs.

Big DataData ArchitectureData Governance
0 likes · 15 min read
OneData Methodology: Building a Unified Data Warehouse Architecture and Governance Framework
Sohu Tech Products
Sohu Tech Products
Oct 17, 2019 · Databases

HBase Table Design Strategies and Best Practices

This article explains HBase's data model and key components, details column descriptor options such as BloomFilter, Compression, Versions, TTL, and MinVersion, and provides practical design guidelines for columns, rowkeys, high vs. wide tables, region pre‑splitting, and hotspot mitigation to achieve optimal performance.

HBaseNoSQLTable Design
0 likes · 17 min read
HBase Table Design Strategies and Best Practices
Alibaba Cloud Developer
Alibaba Cloud Developer
Oct 12, 2019 · Big Data

How Alibaba Turned a Mall into a Fully Digital IoT Ecosystem

This article details how Alibaba engineers built a digital mall by defining a unified device data dictionary, deploying Niagara IoT, implementing edge‑computing with IBOS, constructing a layered data‑center architecture, and delivering analytics, visualization, and service platforms for traffic, transaction, and membership insights.

Digital TwinIoTdata modeling
0 likes · 13 min read
How Alibaba Turned a Mall into a Fully Digital IoT Ecosystem
Mafengwo Technology
Mafengwo Technology
Sep 26, 2019 · Big Data

Mafengwo’s Data Warehouse & Middle Platform: Architecture, Modeling, Toolchain

This article details Mafengwo’s journey in constructing a data warehouse and data middle platform, covering the core three‑layer architecture, hybrid modeling approaches, the supporting toolchain for data synchronization, scheduling, and metadata management, and the design of an indicator platform for business analytics.

Big Data ArchitectureData Middle PlatformData Warehouse
0 likes · 18 min read
Mafengwo’s Data Warehouse & Middle Platform: Architecture, Modeling, Toolchain
Alibaba Cloud Developer
Alibaba Cloud Developer
Aug 27, 2019 · Backend Development

Building a Simple IM System with Alibaba Tablestore Timeline: A Step‑by‑Step Guide

This article explains how to model and implement a basic instant‑messaging system using Alibaba Tablestore's Timeline model, covering message storage, relationship management, metadata handling, real‑time notification, multi‑device synchronization, and provides complete Java code examples for each functional module.

Instant MessagingJavaTablestore
0 likes · 23 min read
Building a Simple IM System with Alibaba Tablestore Timeline: A Step‑by‑Step Guide
21CTO
21CTO
Jul 11, 2019 · Big Data

Boost Elasticsearch Queries on Billions of Docs: Filesystem Cache & Smart Design

Elasticsearch performance at billions‑scale can be dramatically improved by leveraging the OS filesystem cache, limiting indexed fields, separating hot and cold data, pre‑warming caches, and using scroll or search_after for pagination, while avoiding costly joins and ensuring the dataset fits in memory.

ElasticsearchFilesystem Cachedata modeling
0 likes · 12 min read
Boost Elasticsearch Queries on Billions of Docs: Filesystem Cache & Smart Design
Architecture Digest
Architecture Digest
May 28, 2019 · Backend Development

Improving Elasticsearch Query Performance for Billion‑Scale Datasets

To boost Elasticsearch query speed on billions of records, allocate sufficient filesystem cache memory, store only searchable fields, separate hot and cold data, warm up cache, avoid complex joins, and replace deep pagination with Scroll API or search_after for millisecond‑level responses.

ElasticsearchFilesystem Cachedata modeling
0 likes · 10 min read
Improving Elasticsearch Query Performance for Billion‑Scale Datasets
dbaplus Community
dbaplus Community
May 21, 2019 · Big Data

How to Supercharge Elasticsearch Queries on Billions of Records

This article explains why Elasticsearch can be slow on massive datasets, then details practical techniques—leveraging filesystem cache, pre‑heating hot data, separating hot and cold indices, designing lean document models, and avoiding deep pagination—to achieve sub‑second query performance at billions‑scale.

Big DataElasticsearchdata modeling
0 likes · 11 min read
How to Supercharge Elasticsearch Queries on Billions of Records
Senior Brother's Insights
Senior Brother's Insights
Apr 20, 2019 · Databases

Essential MySQL Database Design and Coding Standards for Reliable Systems

This guide outlines comprehensive MySQL naming conventions, table and column design rules, indexing best practices, SQL coding standards, and operational recommendations to improve performance, maintainability, and security while avoiding common pitfalls such as redundant indexes, unsafe data types, and excessive batch operations.

Database DesignIndexingSQL Standards
0 likes · 19 min read
Essential MySQL Database Design and Coding Standards for Reliable Systems
JD Tech
JD Tech
Feb 18, 2019 · Big Data

Understanding HBase: Advantages, Use Cases, Data Model, and Architecture

This article explains HBase as a high‑performance, column‑oriented distributed storage system, outlines its advantages and limitations, presents real‑world scenarios such as seller operation logs and message logs, and details its data structures, architecture components, and design considerations for big‑data applications.

Distributed storageHBaseNoSQL
0 likes · 9 min read
Understanding HBase: Advantages, Use Cases, Data Model, and Architecture
ITPUB
ITPUB
Jan 10, 2019 · Databases

Mastering Neo4j: From Graph Modeling to Advanced Cypher Queries

This comprehensive guide explains Neo4j's label‑property graph model, node and relationship creation, Cypher syntax, indexing, constraints, schema inspection, and best practices for avoiding duplicate data, providing practical examples and performance tips.

ConstraintsCypherIndexing
0 likes · 29 min read
Mastering Neo4j: From Graph Modeling to Advanced Cypher Queries
Alibaba Cloud Developer
Alibaba Cloud Developer
Aug 31, 2018 · Artificial Intelligence

How Alibaba Built an E‑commerce Knowledge Graph to Power Smarter Search

This article explains Alibaba’s end‑to‑end approach to constructing an e‑commerce knowledge graph—detailing the background, challenges, data‑structuring methods, schema design, modular architecture, and deployment pipeline that enable deep user‑intent understanding across complex shopping scenarios.

AIKnowledge GraphOntology
0 likes · 13 min read
How Alibaba Built an E‑commerce Knowledge Graph to Power Smarter Search
Architecture Digest
Architecture Digest
Jul 9, 2018 · Databases

Elasticsearch Index Design and Sharding Principles

This article outlines practical guidelines for designing Elasticsearch indices, comparing single versus time‑based indexes, detailing mapping settings, shard allocation strategies, and deduplication methods, while providing concrete examples and code snippets for effective search infrastructure management.

Elasticsearchdata modelingindex design
0 likes · 5 min read
Elasticsearch Index Design and Sharding Principles
Architecture Digest
Architecture Digest
Jan 22, 2018 · Fundamentals

Designing a Basic Product Model for E‑commerce Systems

This article explains how to design a flexible product model for e‑commerce by evolving from simple category‑article structures to a richer schema that includes brands, attributes, specifications, and separate SKU entities, enabling effective filtering, search, and integration with other services.

Attributesdata modelinge-commerce
0 likes · 6 min read
Designing a Basic Product Model for E‑commerce Systems
ITPUB
ITPUB
Sep 22, 2017 · Big Data

How Baidu Waimai Scaled Traffic Analysis with Apache Kylin: A Deep Dive

This article presents a detailed case study of Baidu Waimai's traffic analysis platform, outlining the data challenges of high dimensionality and volume, the evaluation of OLAP engines, the adoption of Apache Kylin for pre‑computation, the end‑to‑end data modeling, cube construction, incremental builds, and integration with Saiku‑Mondrian reporting, while sharing practical lessons and performance gains.

Apache KylinBig DataOLAP
0 likes · 29 min read
How Baidu Waimai Scaled Traffic Analysis with Apache Kylin: A Deep Dive
21CTO
21CTO
Jul 29, 2017 · Backend Development

Why JavaBeans Fall Short: Embracing Maps for Cleaner Backend Design

The article explores a programmer’s view of software as code and data, distinguishes persistent and transient data, critiques JavaBean‑centric MVC architecture, and proposes key‑value Maps as a more flexible, decoupled alternative for backend development.

JavaMVCdata modeling
0 likes · 8 min read
Why JavaBeans Fall Short: Embracing Maps for Cleaner Backend Design
Architecture Digest
Architecture Digest
Jul 28, 2017 · Backend Development

Understanding Programs, JavaEE MVC, and Why Maps Can Replace JavaBeans

The article reflects on the nature of programs as code and data, distinguishes persistent and transient data, explains JavaEE MVC and multi‑layer architecture, critiques the overuse of JavaBeans, and advocates using key‑value Maps as a simpler, more flexible data‑transfer model.

JavaMVCdata modeling
0 likes · 10 min read
Understanding Programs, JavaEE MVC, and Why Maps Can Replace JavaBeans
Qunar Tech Salon
Qunar Tech Salon
Jun 18, 2017 · Databases

Understanding and Applying Common Table Expressions (CTE) in SQL

This article introduces Common Table Expressions (CTE) in SQL, explains how they improve query readability and enable writable temporary tables, demonstrates multi‑table modifications, advanced CRUD scenarios, implements a ring‑buffer using CTE, and discusses performance benefits and potential pitfalls.

CTESQLdata modeling
0 likes · 12 min read
Understanding and Applying Common Table Expressions (CTE) in SQL
Architecture Digest
Architecture Digest
May 6, 2017 · Databases

MongoDB Architecture and Practical Usage at the MamaBang Platform

The talk outlines MamaBang's evolution from MySQL to a multi‑zone MongoDB cluster, compares MongoDB with relational databases, discusses data‑model design, sharding, replication, transaction handling, operational challenges, and offers practical advice for teams considering MongoDB adoption.

Database ArchitectureMongoDBSharding
0 likes · 19 min read
MongoDB Architecture and Practical Usage at the MamaBang Platform
High Availability Architecture
High Availability Architecture
Apr 14, 2017 · Databases

Recent Improvements in Elasticsearch 5.x and Outlook for 6.0

This article reviews the latest Elasticsearch 5.x enhancements—including append‑only indexing, range fields, removal of the _all field, unified highlighter, keyword normalizer, multi‑word synonyms, field collapsing, cancellable searches, partitioned term aggregations, cluster allocation explain, Java REST client updates, cross‑cluster search, batched reduce phases—and previews the major features expected in Elasticsearch 6.0 such as sparse doc values, index sorting, sequence numbers, seamless rolling upgrades, type removal, index‑template inheritance, load‑aware shard routing, and X‑Pack extensions like SQL and machine learning.

ElasticsearchIndexingSearch
0 likes · 15 min read
Recent Improvements in Elasticsearch 5.x and Outlook for 6.0
Architects' Tech Alliance
Architects' Tech Alliance
Nov 28, 2016 · Big Data

User Profiling: Concepts, Stages, and Data Modeling Methods

This article explains the concept of user profiling, outlines its four-stage construction process, discusses the significance of tagging users, and details practical data modeling techniques—including static and dynamic data sources, weight calculations, and real‑world examples—aimed at improving precision marketing and recommendation systems.

Big DataTaggingbehavior analysis
0 likes · 44 min read
User Profiling: Concepts, Stages, and Data Modeling Methods
Architecture Digest
Architecture Digest
Jun 24, 2016 · Fundamentals

Rethinking Web Frameworks: From Ideal Design to Practical Implementation

This article explores how an ideal web framework—featuring a unified data model, reusable code, event‑driven logic, and language‑agnostic architecture—can be realized in practice, discussing frontend and backend realities, graph‑based data modeling, and the benefits for maintainability and extensibility.

Event-Driven ArchitectureWeb Frameworkdata modeling
0 likes · 25 min read
Rethinking Web Frameworks: From Ideal Design to Practical Implementation
21CTO
21CTO
May 15, 2016 · Databases

Why MySQL Still Matters and When to Choose NoSQL Alternatives

The article compares relational databases like MySQL—highlighting their consistency, transaction support, and join capabilities—with NoSQL alternatives, explaining each type’s strengths and limitations in handling massive writes, schema changes, variable fields, and simple queries, and guides developers on when to choose each.

NoSQLRelational Databasedata modeling
0 likes · 10 min read
Why MySQL Still Matters and When to Choose NoSQL Alternatives
dbaplus Community
dbaplus Community
Feb 22, 2016 · Databases

Mastering Greenplum: Planning, Data Modeling, and Daily Ops Best Practices

This article delivers a comprehensive guide to Greenplum deployment, covering early architecture planning, data‑model design, daily maintenance best practices, system‑table management, diagnostic tools like gpcheckcat, and detailed troubleshooting techniques for persistent tables and other common issues.

GreenplumMPPSystem Tables
0 likes · 13 min read
Mastering Greenplum: Planning, Data Modeling, and Daily Ops Best Practices
Architect
Architect
Nov 30, 2015 · Databases

A Historical Overview of Database Models: From Hierarchical to Relational and Beyond

This article traces the evolution of database models—from early hierarchical and network structures through the relational revolution and entity‑relationship diagrams to modern distributed and multi‑tenant designs—highlighting key concepts, technical challenges, and the theoretical foundations that shaped today’s data storage systems.

Hierarchical Modeldata modelingdatabase
0 likes · 27 min read
A Historical Overview of Database Models: From Hierarchical to Relational and Beyond
21CTO
21CTO
Sep 15, 2015 · Fundamentals

Can a Unified Event‑Driven Architecture Revolutionize Web Frameworks?

This article explores how ideal web frameworks could evolve by separating data description from logic, using event‑driven architectures, graph databases, and cross‑language integration to achieve minimal, maintainable, and extensible code, while contrasting current practices like React, Angular, and Meteor.

Event-Driven ArchitectureWeb Frameworkbackend
0 likes · 26 min read
Can a Unified Event‑Driven Architecture Revolutionize Web Frameworks?
21CTO
21CTO
Sep 14, 2015 · Fundamentals

Can Event‑Driven Architecture Revolutionize Web Frameworks?

The article explores how ideal web frameworks could evolve by separating data description from logic, using event‑driven architectures, graph databases, and cross‑language components to achieve minimal, maintainable, and extensible code, while discussing practical implementations, challenges, and philosophical foundations.

Event-Driven Architecturedata modelingfrontend development
0 likes · 25 min read
Can Event‑Driven Architecture Revolutionize Web Frameworks?
Qunar Tech Salon
Qunar Tech Salon
Aug 24, 2015 · Databases

Choosing the Right NoSQL Database for Your Application: Use Cases and Recommendations

This article surveys major NoSQL data models—including document, graph, relational, object, key‑value, BigTable‑type, data‑structure, and grid databases—and provides practical guidance on selecting the most suitable database for various application requirements such as scalability, consistency, transaction support, and data complexity.

NoSQLdata modelingdatabase selection
0 likes · 11 min read
Choosing the Right NoSQL Database for Your Application: Use Cases and Recommendations
Art of Distributed System Architecture Design
Art of Distributed System Architecture Design
Aug 3, 2015 · Databases

Relational vs. Document-oriented NoSQL Databases: Differences, Data Models, and Practical Guidance

This article compares relational databases with distributed document-oriented NoSQL databases, explaining their scaling models, data modeling differences, and offering practical advice on when and how to adopt document databases such as SequoiaDB for flexible, high‑performance applications in the big‑data era.

Document DatabaseNoSQLSequoiaDB
0 likes · 11 min read
Relational vs. Document-oriented NoSQL Databases: Differences, Data Models, and Practical Guidance
Architect
Architect
Jul 9, 2015 · Databases

Building a Flexible, Searchable, Low-Latency Product Catalog with MongoDB

This article explains how retailers can replace costly ETL‑driven vendor systems with a centralized MongoDB‑based service architecture, detailing data models for products, variants, store‑specific pricing, and multi‑facet search, and showing query and indexing techniques to achieve fast, reliable catalog access.

IndexingMongoDBProduct Catalog
0 likes · 11 min read
Building a Flexible, Searchable, Low-Latency Product Catalog with MongoDB