BestHub
Sign in
Tagged articles
53 articles
Page 1 of 1
Data Party THU
Data Party THU
Apr 9, 2026 · Fundamentals

Mastering Numeric Feature Scaling: 4 Techniques with Scikit‑Learn

This article explains why numeric feature engineering is essential for machine learning, outlines the challenges of differing scales and outliers, and demonstrates four preprocessing methods—Standardization, Robust Scaler, Power Transformer, and Normalization—using the California housing dataset with detailed code examples and visual analysis.

feature scalingnormalizationnumeric preprocessing
0 likes · 11 min read
Mastering Numeric Feature Scaling: 4 Techniques with Scikit‑Learn
AI Frontier Lectures
AI Frontier Lectures
Mar 19, 2026 · Artificial Intelligence

Why Sharing Parameters in Vision Transformers Hurts Performance—and How Layer Specialization Fixes It

The article analyzes the hidden conflict between [CLS] and patch tokens in Vision Transformers, reveals how shared normalization and linear layers cause computational friction, and demonstrates that layer‑specific parameters dramatically improve dense prediction tasks without increasing inference FLOPs.

Computer VisionDense PredictionLayer Specialization
0 likes · 9 min read
Why Sharing Parameters in Vision Transformers Hurts Performance—and How Layer Specialization Fixes It
Java Architect Handbook
Java Architect Handbook
Jan 13, 2026 · Databases

When to Normalize or Denormalize? A Deep Dive for Java Interview Prep

This article breaks down the interview expectations around database normalization, explains the theory and trade‑offs of normalization versus denormalization, provides SQL code examples, compares design impacts, offers best‑practice guidelines, and warns against common misconceptions.

Database designDenormalizationInterview Preparation
0 likes · 11 min read
When to Normalize or Denormalize? A Deep Dive for Java Interview Prep
Ray's Galactic Tech
Ray's Galactic Tech
Jan 12, 2026 · Databases

Master MySQL: Production-Ready Database Design & Operations Handbook

An experienced MySQL practitioner shares a comprehensive production‑grade design and operations guide, covering primary key selection, normalization, indexing, data types, sharding, foreign key trade‑offs, naming conventions, transaction handling, NULL usage, type safety, read/write splitting, caching, triggers, logging, monitoring, partitioning, security, and a three‑layer summary.

Database designmysqlnormalization
0 likes · 9 min read
Master MySQL: Production-Ready Database Design & Operations Handbook
Ray's Galactic Tech
Ray's Galactic Tech
Dec 15, 2025 · Databases

Mastering Database Design: From Core Principles to Modern Distributed Practices

This comprehensive guide walks you through fundamental database design goals, a step‑by‑step lifecycle, nine essential strategies—including normalization, indexing, and security—plus modern distributed and NoSQL considerations, performance tuning, high‑availability tactics, and practical tools for robust data governance.

Data GovernanceDatabase designNoSQL
0 likes · 11 min read
Mastering Database Design: From Core Principles to Modern Distributed Practices
Architect-Kip
Architect-Kip
Nov 13, 2025 · Databases

Mastering Database Table Design: 12 Essential Table Types and Best Practices

Effective data modeling is crucial for system stability, and this guide walks you through core principles, twelve common table patterns—from batch and log tables to hierarchical and bitmap structures—detailing design rules, trade‑offs, usage scenarios, and practical examples to help you avoid costly redesigns.

data modelingnormalizationsql
0 likes · 24 min read
Mastering Database Table Design: 12 Essential Table Types and Best Practices
AIWalker
AIWalker
Mar 14, 2025 · Artificial Intelligence

Dynamic Tanh Lets He Kaiming and LeCun Drop Transformer Normalization in 9 Lines

Researchers He Kaiming, Yann LeCun and colleagues propose a 9‑line Dynamic Tanh (DyT) layer that replaces LayerNorm/RMSNorm in Transformers, showing comparable or superior accuracy across vision, language, speech and DNA tasks while also reducing inference latency on modern GPUs.

AI researchDeep LearningDynamic Tanh
0 likes · 18 min read
Dynamic Tanh Lets He Kaiming and LeCun Drop Transformer Normalization in 9 Lines
Test Development Learning Exchange
Test Development Learning Exchange
Nov 21, 2024 · Artificial Intelligence

Data Preprocessing: Standardization, Normalization, and Missing Value Imputation with Python

This tutorial demonstrates how to perform essential data preprocessing techniques—including standardization, min‑max normalization, and various missing‑value imputation methods—using pandas and scikit‑learn in Python, providing code examples and explanations to help you prepare datasets for machine‑learning models.

Pythonmissing value imputationnormalization
0 likes · 6 min read
Data Preprocessing: Standardization, Normalization, and Missing Value Imputation with Python
Baobao Algorithm Notes
Baobao Algorithm Notes
May 5, 2024 · Artificial Intelligence

Deep Dive into Transformer Mechanics: Scaling, Q/K Projections, FFNs, and More

This article provides concise technical explanations for 25 common questions about Transformer models, covering scaled dot‑product attention scaling, separate Q/K projections, feed‑forward network design, attention variants, normalization, LoRA versus full‑parameter training, KV‑cache, pre‑ and post‑norm, computational cost analysis, and advanced position‑encoding techniques.

LLMLoRATransformer
0 likes · 25 min read
Deep Dive into Transformer Mechanics: Scaling, Q/K Projections, FFNs, and More
Java Captain
Java Captain
Feb 1, 2024 · Databases

Best Practices for MySQL Table Design

This article outlines ten essential MySQL table design best practices, covering requirement analysis, data type selection, normalization, indexing, keys, character sets, storage engines, partitioning, backup, and performance monitoring to improve scalability, maintainability, and efficiency.

Database designStorage Enginebest practices
0 likes · 5 min read
Best Practices for MySQL Table Design
Architects Research Society
Architects Research Society
Nov 27, 2023 · Databases

Formal Naming of Data Schemas, Structures, and Models: Distinctions and Methodology

The article explains the differences between data schemas, data structures, and data models, proposes a systematic naming approach, and outlines a five‑schema architecture—including business, view, logical, deployment, and physical schemas—while addressing terminology challenges and normalization processes.

Data StructureDatabase designdata modeling
0 likes · 12 min read
Formal Naming of Data Schemas, Structures, and Models: Distinctions and Methodology
21CTO
21CTO
Sep 28, 2023 · Databases

8 Common Database Design Mistakes and How to Fix Them

This article outlines eight frequent database design pitfalls—ignoring data purpose, poor normalization, redundancy, weak referential integrity, underusing engine features, composite primary keys, bad indexing, and confusing naming conventions—and provides practical guidance on how to avoid or correct each issue.

best practicesindexingnormalization
0 likes · 10 min read
8 Common Database Design Mistakes and How to Fix Them
Continuous Delivery 2.0
Continuous Delivery 2.0
Sep 21, 2023 · Operations

Scaling DevOps in Large Organizations: Normalization, Standardization, and Platformization

The article outlines how organizations over a hundred engineers must go beyond merely copying DevOps practices by adopting three progressive steps—normalization, standardization, and platformization—to achieve measurable, scalable efficiency, and concludes with a promotional notice for a Python‑based continuous deployment training course.

OperationsPlatformizationnormalization
0 likes · 8 min read
Scaling DevOps in Large Organizations: Normalization, Standardization, and Platformization
Model Perspective
Model Perspective
Mar 13, 2023 · Fundamentals

Mastering TOPSIS: Step-by-Step Guide with Python Implementation

This article explains the TOPSIS multi‑criteria decision‑making technique, outlines its mathematical formulation, walks through the seven procedural steps, and demonstrates a complete Python example that normalizes data, computes distances, scores alternatives, and ranks the best solution.

PythonTOPSISnormalization
0 likes · 8 min read
Mastering TOPSIS: Step-by-Step Guide with Python Implementation
IT Architects Alliance
IT Architects Alliance
Jan 13, 2023 · Databases

Database Design Fundamentals: Key Concepts, ER Diagrams, and Normal Forms

This article explains fundamental database design concepts, including candidate and primary keys, attributes, relations, ER diagram components, and detailed descriptions of the first, second, third, and BC normal forms with examples and how to resolve insertion, deletion, update, and redundancy anomalies.

Database designER Diagramdata integrity
0 likes · 9 min read
Database Design Fundamentals: Key Concepts, ER Diagrams, and Normal Forms
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Sep 28, 2022 · Databases

10 Essential Database Design Practices Every Developer Should Follow

This article explains why solid database design is crucial for scalable applications and outlines ten best‑practice guidelines—including stakeholder input, choosing the right DB type, consistent naming, normalization, documentation, security, scalability, stored procedures, modeling time, and thorough testing.

Database designDocumentationScalability
0 likes · 9 min read
10 Essential Database Design Practices Every Developer Should Follow
21CTO
21CTO
Sep 16, 2022 · Databases

10 Essential Database Design Practices Every Developer Should Follow

This article explains why thoughtful database design is critical for scalable applications and outlines ten best‑practice guidelines—including stakeholder input, choosing the right DB type, consistent naming, normalization, documentation, security, scalability, stored procedures, modeling effort, and thorough testing—to help developers build robust, high‑performance data stores.

Database designNoSQLbest practices
0 likes · 9 min read
10 Essential Database Design Practices Every Developer Should Follow
IT Architects Alliance
IT Architects Alliance
Aug 25, 2022 · Databases

Relational Database Design: ER Modeling, Normalization, Storage Engine, Charset, Data Types, and Index Design

The article provides a comprehensive guide to relational database design using MySQL, covering ER modeling, normalization (BCNF and 3NF), storage engine selection, character set and data type choices, as well as index design principles illustrated with a student course selection example.

Data TypesDatabase designStorage Engine
0 likes · 17 min read
Relational Database Design: ER Modeling, Normalization, Storage Engine, Charset, Data Types, and Index Design
Architect's Guide
Architect's Guide
Aug 21, 2022 · Databases

Relational Database Design with MySQL: ER Modeling, Normalization, Storage Engine, Charset, Data Types, and Index Design

This article explains relational database design using MySQL, covering ER modeling, BCNF and 3NF normalization, storage engine and charset choices, data type selection, and index design, illustrated with examples and practical guidelines for building a student course selection system.

Data TypesDatabase designER Model
0 likes · 15 min read
Relational Database Design with MySQL: ER Modeling, Normalization, Storage Engine, Charset, Data Types, and Index Design
Model Perspective
Model Perspective
May 25, 2022 · Fundamentals

Mastering the CRITIC Method: Step-by-Step Guide to Weight Determination

This article explains the CRITIC (Criteria Importance Through Inter‑criteria Correlation) method, detailing its use of standard deviation and inter‑criterion correlation to compute criterion weights through a clear three‑step evaluation process with references to scholarly applications.

Criticdecision makingmulti-criteria decision analysis
0 likes · 2 min read
Mastering the CRITIC Method: Step-by-Step Guide to Weight Determination
Code DAO
Code DAO
Dec 5, 2021 · Artificial Intelligence

Why Neural Networks Need Batch Normalization: Principles and Mechanics

The article explains the principle behind Batch Normalization, why it is essential for training deep neural networks, how it standardizes activations, the role of learnable scale and shift parameters, the computation steps during training and inference, and discusses placement strategies within a model.

Batch NormalizationDeep LearningNeural Networks
0 likes · 9 min read
Why Neural Networks Need Batch Normalization: Principles and Mechanics
NiuNiu MaTe
NiuNiu MaTe
Sep 23, 2021 · Databases

Essential MySQL Interview Guide: Core Concepts, Queries, and Best Practices

This article walks through essential MySQL interview topics, covering basic concepts, OLTP vs OLAP, normalization forms, DML/DDL/DCL, varchar vs char trade‑offs, storage engines, ACID properties, primary and foreign keys, and how to monitor running queries, all presented from an interviewer's perspective.

ACIDDatabase InterviewSQL Basics
0 likes · 8 min read
Essential MySQL Interview Guide: Core Concepts, Queries, and Best Practices
DataFunTalk
DataFunTalk
Aug 10, 2021 · Artificial Intelligence

Practical Deep Learning Tricks: Cyclic LR, Flooding, Warmup, RAdam, Adversarial Training, Focal Loss, Dropout, Normalization, ReLU, Group Normalization, Label Smoothing, Wasserstein GAN, Skip Connections, Weight Initialization

This article presents a concise collection of practical deep‑learning techniques—including cyclic learning‑rate, flooding, warmup, RAdam, adversarial training, focal loss, dropout, various normalization methods, ReLU, group normalization, label smoothing, Wasserstein GAN, skip connections, and weight initialization—along with code snippets and references for implementation.

Deep LearningGANRegularization
0 likes · 8 min read
Practical Deep Learning Tricks: Cyclic LR, Flooding, Warmup, RAdam, Adversarial Training, Focal Loss, Dropout, Normalization, ReLU, Group Normalization, Label Smoothing, Wasserstein GAN, Skip Connections, Weight Initialization
php Courses
php Courses
May 19, 2021 · Databases

Fundamentals of Relational Databases: Key Concepts and Common Questions

This article provides a comprehensive overview of relational database fundamentals, covering common DBMS products, SQL language components, integrity constraints, transactions, locking, views, stored procedures, indexes, normalization, key differences, constraints, optimization techniques, storage engines, and performance strategies for high‑traffic sites.

Database OptimizationRelational DatabaseTransactions
0 likes · 12 min read
Fundamentals of Relational Databases: Key Concepts and Common Questions
Laravel Tech Community
Laravel Tech Community
Nov 19, 2020 · Databases

Fundamental Principles of Database Design: Entities, Keys, Normalization, and Optimization

This article outlines essential database design concepts, covering the relationship between source documents and entities, primary‑foreign key design, basic table characteristics, normalization standards, handling many‑to‑many relationships, primary key strategies, data redundancy, ER‑diagram considerations, view usage, and performance‑boosting techniques.

Database designForeign Keydata redundancy
0 likes · 12 min read
Fundamental Principles of Database Design: Entities, Keys, Normalization, and Optimization
Architecture Digest
Architecture Digest
Nov 12, 2020 · Databases

Key Principles of Database Design: From Entity Relationships to Performance Optimization

This article outlines essential database design principles, covering entity‑document relationships, primary and foreign keys, basic table characteristics, normalization versus denormalization, handling many‑to‑many relations, view usage, integrity constraints, and performance‑boosting techniques such as the “Three‑Less” rule and partitioning.

ER DiagramForeign Keynormalization
0 likes · 13 min read
Key Principles of Database Design: From Entity Relationships to Performance Optimization
Java Captain
Java Captain
Sep 22, 2020 · Databases

MySQL Basics: DDL/DML/DCL/TCL Commands, Normal Forms, and Table Pivoting

This article provides a comprehensive overview of fundamental MySQL concepts, covering DDL, DML, DCL, and TCL commands, detailed explanations of first to third normal forms, common anomalies, and practical examples of converting between horizontal and vertical table structures using SQL scripts.

DDLDMLTCL
0 likes · 13 min read
MySQL Basics: DDL/DML/DCL/TCL Commands, Normal Forms, and Table Pivoting
JavaEdge
JavaEdge
Aug 23, 2020 · Databases

Mastering Database Normalization: First, Second, and Third Normal Forms Explained

This article explains the concepts, requirements, and practical examples of the first, second, and third normal forms in relational databases, showing how to identify repeated groups, handle composite keys, and eliminate transitive dependencies to achieve a well‑structured schema.

databasesfirst normal formnormalization
0 likes · 4 min read
Mastering Database Normalization: First, Second, and Third Normal Forms Explained
Selected Java Interview Questions
Selected Java Interview Questions
Aug 4, 2020 · Databases

Fundamental Concepts and Best Practices for Database Design

This article presents a comprehensive guide to database design, covering the relationship between source documents and entities, primary and foreign keys, table properties, normalization standards, handling many‑to‑many relationships, key selection, data redundancy, ER diagram considerations, view usage, intermediate and temporary tables, integrity constraints, the "Three‑Few" principle, and practical techniques for improving database performance.

Database designER DiagramForeign Key
0 likes · 14 min read
Fundamental Concepts and Best Practices for Database Design
ITPUB
ITPUB
Jul 29, 2020 · Databases

Why Database Normalization Matters: A Practical Guide to 1NF, 2NF, and 3NF

This article explains the concepts of the first, second, and third normal forms in relational databases, shows concrete table examples, discusses why normalization is important for consistency and storage efficiency, and explores denormalization trade‑offs and modern JSON support in MySQL and NoSQL systems.

1NF2NF3NF
0 likes · 10 min read
Why Database Normalization Matters: A Practical Guide to 1NF, 2NF, and 3NF
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
Java Captain
Java Captain
Nov 1, 2019 · Databases

Key Principles of Database Design: Primary/Foreign Keys, Normalization, and Table Types

This article explains the relationships between source documents and entities, the role of primary and foreign keys, the characteristics of base tables, normalization standards, handling many‑to‑many relationships, primary‑key generation methods, data redundancy concepts, ER‑diagram best practices, view usage, and performance‑optimizing techniques for relational databases.

Database designER DiagramForeign Key
0 likes · 14 min read
Key Principles of Database Design: Primary/Foreign Keys, Normalization, and Table Types
Youzan Coder
Youzan Coder
Sep 18, 2019 · Big Data

Applying Newton's Law of Cooling to Transaction Scoring in DMP User Profiling

The article proposes using Newton’s law of cooling to score DMP user transactions, assigning higher weights to recent purchases that decay exponentially over time, deriving a cooling constant from boundary conditions, and normalizing the resulting heat‑based scores through log‑scaling and a sigmoid‑like mapping to a 0‑100 range.

Big DataDMPNewton cooling law
0 likes · 4 min read
Applying Newton's Law of Cooling to Transaction Scoring in DMP User Profiling
GF Securities FinTech
GF Securities FinTech
May 28, 2019 · Frontend Development

Mastering Redux: Designing Scalable State Structures for React Apps

This article explains why Redux is useful for large React applications, categorizes typical state types, and presents practical patterns—including UI‑driven structures, direct API mapping, and normalized entities—along with code samples and loading‑state management techniques to build maintainable front‑end codebases.

ReactReduxState Management
0 likes · 13 min read
Mastering Redux: Designing Scalable State Structures for React Apps
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Aug 21, 2018 · Databases

Mastering MySQL: Keys, Transactions, Indexes, Joins, and Optimization Essentials

This article explains fundamental MySQL concepts including primary, candidate, super and foreign keys, transaction ACID properties, view creation, differences among DROP, DELETE and TRUNCATE, index structures and types, join variations, normalization forms, optimization techniques, replication mechanisms, engine distinctions, and logging formats.

ReplicationTransactionsdatabase
0 likes · 29 min read
Mastering MySQL: Keys, Transactions, Indexes, Joins, and Optimization Essentials
ITFLY8 Architecture Home
ITFLY8 Architecture Home
May 31, 2018 · Databases

Master Relational Database Design: From Basics to Normalization

This article walks through choosing a web framework and database, introduces relational databases, explains design steps such as requirement analysis, table creation, primary key selection, relationship modeling (one‑to‑many, many‑to‑many, one‑to‑one) with SQL examples, and covers normalization forms, integrity rules, and indexing strategies.

Database designForeign KeyRelational Database
0 likes · 19 min read
Master Relational Database Design: From Basics to Normalization
Hulu Beijing
Hulu Beijing
Jan 23, 2018 · Artificial Intelligence

Feature Engineering for Structured Data: Normalization, Encoding & Interaction

This article explains the fundamentals of feature engineering for structured data, covering why and how to normalize numerical features, various categorical encoding techniques, methods for creating high‑dimensional interaction features, and decision‑tree based strategies for efficiently discovering valuable feature combinations.

categorical encodingfeature engineeringinteraction features
0 likes · 12 min read
Feature Engineering for Structured Data: Normalization, Encoding & Interaction
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Aug 5, 2017 · Databases

Mastering Database Schema: From Normalization to Sharding and Scaling

This comprehensive guide explores essential database design principles—including normalization, denormalization, data partitioning, routing, and scaling techniques—offering practical strategies to optimize schema structures, reduce redundancy, and improve performance for both relational and NoSQL systems.

Database designDenormalizationSchema Optimization
0 likes · 27 min read
Mastering Database Schema: From Normalization to Sharding and Scaling
ITPUB
ITPUB
Feb 13, 2017 · Databases

Mastering SQL: Joins, Normal Forms, Indexes, and Optimization Techniques

This article explains SQL join types, the three normal forms, table creation and alteration commands, data integrity constraints, practical query‑optimization tips, the roles and differences of clustered and non‑clustered indexes, and the distinctions between stored procedures and functions.

Database designJoinsStored Procedures
0 likes · 7 min read
Mastering SQL: Joins, Normal Forms, Indexes, and Optimization Techniques
ITFLY8 Architecture Home
ITFLY8 Architecture Home
Nov 18, 2016 · Databases

Mastering Database Schema: From Normalization to Sharding Strategies

This article explores core database design concepts, covering normalization principles, denormalization tactics, schema simplification, MySQL architecture, various data partitioning methods—including vertical, horizontal, logical, and time‑based sharding—and practical routing and storage optimizations for high‑performance systems.

Denormalizationdatabasesnormalization
0 likes · 27 min read
Mastering Database Schema: From Normalization to Sharding Strategies
ITPUB
ITPUB
Dec 18, 2015 · Databases

Mastering Database Schema Design: From Normalization to Sharding and Scaling

This article explains essential database design principles—including normalization, denormalization, join avoidance, and various sharding techniques—while also covering scaling strategies such as vertical upgrades, horizontal partitioning, and the use of flash storage to boost performance.

Database designDenormalizationnormalization
0 likes · 27 min read
Mastering Database Schema Design: From Normalization to Sharding and Scaling
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