MariaDB (MySQL) Application Basics

MARIADB Application Basics

============================================================================

Overview:

MySQL Introduction

★ Data Model : Hierarchical model, mesh model, relational model 、......

• Relational Model:

Two-dimensional relationship: Table

Row: Row, Entity

Column: Colume, attribution

Index: Data structure, assist to complete the search;

★ Dmbs : Database Management system Data Management Systems

• < Span style= "padding:0px;margin:0px;font-family: ' italics ', ' italics _gb2312 ', Simkai;font-size:18px;color:rgb (0,0,0);" >rdbms : Relational DBMS-relational database management system

• < Span style= "padding:0px;margin:0px;font-family: ' italics ', ' italics _gb2312 ', Simkai;font-size:18px;color:rgb (0,0,0);" >sql Engine:

     

• Storage Engine : Storage Engine (responsible for managing files down, providing relational models upward)

Data in MySQL is stored in files (or memory) in a variety of different technologies. Each of these technologies uses different storage mechanisms, indexing techniques, locking levels, and ultimately offers a wide range of different capabilities and capabilities. By selecting different technologies, you can gain additional speed or functionality to improve the overall functionality of your application

Attention:

The SQL Engine interpreter provides commands that are interpreted by the SQL engine and submitted to the storage engine for execution, so the SQL engine simply explains what the storage engine is really doing.

relational database in order to interact also need to provide a client, the client input SQL statements, SQL engine interpretation (lexical analysis, parsing), submitted to the storage engine to execute;

★SQL Interface:

• Sql:structure Query Language (Structured Query language), even if an interpreter, provides the programming ability;

• ansi:sql-Standard, SQL-86, SQL-89, SQL-92, SQL-99, SQL-03, ...

• SQL code

Storage Routines: Storage routing

Stored Procedures: Storage procedure

Storage functions: Storage function

Trigger: Trigger

Events Scheduler: Event Scheduler

MariaDB (MySQL) Application Basics