BestHub
Sign in
Tag

SQL standards

0 views collected around this technical thread.

Architecture & Thinking
Architecture & Thinking
May 31, 2022 · Databases

Master Database Naming: Standards, Design & SQL Best Practices

This comprehensive guide details naming conventions for databases, tables, columns, indexes, views, procedures, functions, triggers, users, and constraints, along with design principles for objects, storage engines, character sets, table structures, field types, index strategies, and SQL usage to ensure consistency, performance, and maintainability in MySQL environments.

MySQLSQL standardsSchema Design
0 likes · 22 min read
Master Database Naming: Standards, Design & SQL Best Practices
Xiaolei Talks DB
Xiaolei Talks DB
Apr 29, 2022 · Databases

Essential Database Naming and Design Standards for TiDB & MySQL

This guide outlines comprehensive naming conventions, table design rules, SQL best practices, and TiDB‑MySQL compatibility differences to help developers create consistent, performant, and maintainable database schemas.

Database DesignSQL standardsTiDB
0 likes · 13 min read
Essential Database Naming and Design Standards for TiDB & MySQL
DataFunTalk
DataFunTalk
Oct 7, 2020 · Big Data

Yanxuan Data Warehouse: Architecture, Standards, and Evaluation Framework

This article outlines the Yanxuan data warehouse’s layered architecture, the offline and real‑time development platforms, the comprehensive standards for metric definition, model design, and SQL development, and proposes a six‑dimensional evaluation system covering data norms, security, quality, stability, continuous improvement, and development efficiency.

Big DataData EngineeringData Warehouse
0 likes · 12 min read
Yanxuan Data Warehouse: Architecture, Standards, and Evaluation Framework
Laravel Tech Community
Laravel Tech Community
Aug 2, 2020 · Databases

MySQL Database Design and SQL Writing Standards

This document outlines comprehensive MySQL database design standards and SQL writing guidelines, covering naming conventions, character sets, table and column specifications, index design, partitioning, data types, transaction handling, and prohibited statements to ensure stable, performant, and maintainable production databases.

Database DesignIndexingMySQL
0 likes · 18 min read
MySQL Database Design and SQL Writing Standards
Architecture Digest
Architecture Digest
Feb 5, 2020 · Databases

Comprehensive MySQL Database Naming, Design, Field, Index, and SQL Development Standards

This article presents a thorough set of MySQL best‑practice guidelines covering object naming conventions, basic table design, column definitions, index creation, index usage policies, SQL coding standards, and operational behaviors to improve performance, maintainability, and data integrity.

Database DesignIndexingMySQL
0 likes · 19 min read
Comprehensive MySQL Database Naming, Design, Field, Index, and SQL Development Standards
Java Captain
Java Captain
Mar 20, 2019 · Databases

Comprehensive MySQL Database Design and Development Standards

This article presents a detailed set of MySQL database naming conventions, design principles, field type recommendations, index strategies, and SQL development best practices to improve performance, maintainability, and security while avoiding common pitfalls such as reserved keywords, oversized tables, and inefficient queries.

Database DesignIndexingMySQL
0 likes · 17 min read
Comprehensive MySQL Database Design and Development Standards