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.
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.
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.
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.
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.
This guide explains the fundamentals of conceptual data modeling with PowerDesigner, covering entities, attributes, identifiers, data items, and various relationship types, and shows step‑by‑step how to create and configure these elements in a CDM.
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.
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.
This article details how Discord scaled from tens of millions to over a hundred million daily messages by replacing MongoDB with Cassandra, covering the motivations, data model design, handling of tombstones, performance results, unexpected issues, and future scalability plans.
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.
This article details a comprehensive e‑commerce data architecture, covering product module design, SKU handling, packaging strategies, order schema, promotion tracking, visit analytics, and reporting best practices, offering practical insights for building robust backend systems.
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.
This article compares traditional relational table design with HBase's column‑family model, showing how tables, rows, column families, and versioned cells are defined and how data is inserted using HBase's put commands.
This article explains how to define data elements, choose meaningful names, apply ISO‑11179 naming patterns, select appropriate SQL data types, and use domains, constraints, and default values to build clear, maintainable, and high‑performance relational database schemas.
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.
The article explains the goals of user behavior analysis, details two implementation methods for single-step and multi-step path conversions using log preprocessing, adjacency matrices, and KMP pattern matching, and illustrates these techniques with a Baidu Doctor product line case study.
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.
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.
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.
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.
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.
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.
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.
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.
