MySQL Introduction--"1"

First, Introduction

Database(Database)is in accordance withData Structureto organize,Storageand Management Data Warehouse, which was generated more than 60 years ago, withInformation Technologyand the development of the market, especially after the 1990s,Data ManagementIt's not just about storing and managing data, it's transforming it into the kind of data management that users need.

TwoDatabase Type

database is usually divided into hierarchical database, network-type database and relational database three kinds.

and the different databases are based on different Data Structure to contact and organize.

2.1relational database

• Two-dimensional table. (Column: field, row: Record)

• MySQL and Oracle database, the most common operation is MySQL.

• through SQL Structured Query Statements store data that manages relational databases.

• maintaining data security and consistency is strong. ACID theory.

2.2Non-relational database (Nosql) Knowledge Summary:

• A database product that is functionally unique for a specific scenario, with high performance and ease of use.

• NoSQL is not a negative relational database, but rather an important complement to a relational database.

• NoSQL is designed to be high-performance, high-concurrency, ignoring features that affect high performance and concurrency.

• NoSQL Typical product memcached(pure memory),Redis(persistent cache),Momgodb

Common relational database product introduction1. Oracel Database2. mysql database3. mariadb Database4. SQL Server Database5. Access databaseGeneral Non-relational database product introduction

1. memcached (key-value )

• Key-value Type Database

• Pure Memory Database

• Persistent Memcachedb

2. Redis (key-value )

Redis data is cached in memory. The difference is that Redis periodically writes the updated data to disk or modifies the operating system to write the appended record file, and implements Master-slave(Master-Slave) synchronization on this basis.

• support memory cache, this function is equivalent to memcached.

• supports persistent storage.

• The data type is richer and more powerful than other Key-value libraries.

• Support master-slave cluster, distributed cluster.

• Host special functions such as queues.

application: Cache changes access Redis from Access memcached.

3. MongoDB (document-oriented)

MongoDB is a product between a database and a non-relational database.

This article is from "Song Someone C" blog, please be sure to keep this source http://syaving.blog.51cto.com/5614476/1878651

MySQL Introduction--"1"