1 views collected around this technical thread.
This article introduces and compares four common microservice architecture patterns—aggregation, shared database, proxy (including sidecar), and asynchronous messaging—detailing their designs, advantages, disadvantages, and typical use cases for large‑scale systems.
This article explains the purpose and proper use of the SQL HAVING clause, contrasts it with WHERE, and provides multiple practical examples—including counting groups, detecting missing IDs, calculating mode and median, and filtering fully‑submitted records—while highlighting common pitfalls and performance considerations.
This article demonstrates eleven practical Pandas examples covering grouping aggregation, conditional filtering, rolling windows, multi-indexing, melting, broadcasting, concatenation, merging, time-series creation, missing-value handling, and custom function application, each accompanied by complete Python code and expected output.
This article explains the fundamentals of Domain-Driven Design (DDD), covering unified language, model abstraction, problem decomposition, aggregation, domain events, and how DDD principles translate into microservice architectures with practical code examples.
This article presents a detailed compilation of pandas built‑in aggregation methods and a wide range of custom Python functions for time‑series feature engineering, providing ready‑to‑use code snippets that cover statistical descriptors, drawdown metrics, peak detection, and more for data science practitioners.
This article explains the nature of NULL in MySQL, demonstrates why comparisons with = or != fail, shows the correct IS NULL/IS NOT NULL syntax, and discusses how NULL behaves with DISTINCT, GROUP BY, ORDER BY, and aggregate functions.
SQL database queries are essential skills for data analysts, enabling them to extract, transform, and analyze data from databases through various operations like filtering, sorting, aggregation, and joining.
This article introduces Easy-Es, a Java ORM framework built on Elasticsearch's RestHighLevelClient that simplifies query construction and CRUD operations, provides step‑by‑step setup including Maven dependencies, configuration, entity and mapper definitions, controller examples, and advanced features such as condition builders, index management, logging, and aggregation queries.
This article explains how MySQL 8.x window functions such as OVER, PARTITION BY, and ORDER BY can simplify complex ranking and aggregation queries, demonstrates creating a sample scores table, and provides practical examples of functions like ROW_NUMBER, RANK, DENSE_RANK, NTILE, LAG, and LEAD with their results.
This article provides a comprehensive guide to using Pandas for complex queries, data type conversion, sorting, adding and modifying data, advanced filtering, iteration, and functional operations, offering numerous code examples that illustrate how to efficiently clean, transform, and analyze tabular data in Python.
This article explains how to query, analyze, and visualize time‑series data stored in MongoDB using the aggregation framework, MongoDB Compass, read‑only views, the BI connector with SQL tools, as well as integrations with Spark and R for advanced analytics.
This tutorial provides a thorough overview of Elasticsearch 7.13.2 query techniques—including term, terms, range, prefix, wildcard, boolean, filter, and aggregation queries—showing both raw DSL syntax and equivalent Java High Level REST Client code, enabling developers to quickly master search operations on large datasets.
This article explains the underlying principles of Elasticsearch scoring, covering Boolean model queries, TF/IDF, field length normalization, the vector space model, and detailed aggregation examples with code snippets to illustrate practical search and analytics usage.
This article explains how to iterate over DataFrame rows with pandas iterrows(), demonstrates grouping data using pandas groupby() with examples of splitting, aggregation, transformation, and filtration, and provides complete code snippets for each operation.
This article provides a thorough guide to SQL fundamentals—including SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, aggregate functions, joins, set operations, and Oracle-specific objects—followed by a collection of common interview questions with detailed solutions, top‑N queries, and row‑to‑column transformations, while also containing promotional notes for related resources.
This article explains the principles of object‑oriented modeling, contrasting object and data models, illustrating with a simple account example, discussing composition versus aggregation, and providing Java code snippets for modeling processes such as eating, demonstrating how to design and implement domain objects and services.
This article explains how to select Redis data structures such as Bitmap, HyperLogLog, Set, List, Sorted Set, and Hash to efficiently handle massive statistical scenarios like user login status, UV counting, ranking, and set aggregation, while providing concrete command examples and best‑practice recommendations.
Learn how MySQL’s powerful join operations transform simple table queries into meaningful results, covering Cartesian products, inner, left, right joins, aggregation with group functions, and practical filtering techniques, complete with sample data, SQL syntax, and execution examples.
This article explains the fundamentals of object‑oriented modeling, contrasting data‑model and object‑model designs, illustrating attribute‑method composition, composition versus aggregation, and providing concrete Java and SQL examples such as a simple Account domain, an eating‑process model, and an open‑source e‑commerce reference.
This article explains the philosophical basis of object‑oriented thinking, distinguishes attributes and operations, compares data‑model and object‑model designs with Java and SQL examples, discusses composition versus aggregation through a digestion model, and illustrates application‑service patterns in account credit scenarios.