Skip to content
Tagged articles

Data Modeling

341 articles · Page 4 of 4
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.

Data ModelingOneDatabig data
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.

Data ModelingHBaseNoSQL
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.

Data ModelingDigital TwinIoT
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.

Data ModelingETLbig data architecture
0 likes · 18 min read
Mafengwo’s Data Warehouse & Middle Platform: Architecture, Modeling, Toolchain
Big Data Technology & Architecture
Big Data Technology & Architecture
Sep 24, 2019 · Databases

Overview of Apache Cassandra: History, Features, and Use Cases

This article provides a comprehensive overview of Apache Cassandra, covering its origins at Facebook, key architectural features such as distributed design, elastic scalability, tunable consistency, and high availability, as well as typical deployment scenarios and notable companies that use it.

Apache CassandraData ModelingHigh Availability
0 likes · 14 min read
Overview of Apache Cassandra: History, Features, and Use Cases
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.

BackendData ModelingJava
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.

Data ModelingElasticsearchFilesystem Cache
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.

Data ModelingElasticsearchFilesystem Cache
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.

Data ModelingElasticsearchPagination
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.

Best PracticesData ModelingIndexing
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.

Data ModelingHBaseNoSQL
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.

CypherData ModelingIndexing
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.

AIData Modelinge-commerce
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.

Data ModelingElasticsearchindex 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.

Data Modelingattributese-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 KylinData ModelingOLAP
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.

Data ModelingJavaMVC
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.

Data ModelingJavaMVC
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.

CTEData ModelingSQL
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.

Data ModelingDatabase ArchitectureMongoDB
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.

Data ModelingElasticsearchIndexing
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.

Data Modelingbehavior analysisbig data
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.

Data ModelingWeb Frameworkevent-driven architecture
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.

Data ModelingNoSQLdatabase scaling
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.

Data ModelingGreenplumMPP
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.

Data ModelingHierarchical Modeldatabase
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.

BackendData ModelingWeb Framework
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.

Data ModelingFrontend Developmentevent-driven architecture
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.

Data ModelingNoSQLdatabase selection
0 likes · 11 min read
Choosing the Right NoSQL Database for Your Application: Use Cases and Recommendations

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.

Data ModelingDocument DatabaseNoSQL
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.

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