Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "the definition of mysql database". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

What is a database? A warehouse where data is stored

Traditional relational databases: mysql, oracle, db2, sysbase

Mysql and oracle are the most popular on the Internet.

What is a relational database?

1. Two-dimensional table

2. Mysql is most commonly used in Internet operation and maintenance.

3. Access data through sql structured query statement

4. It is very strong in keeping data consistency, ACID theory.

Features: reading and writing is more about dealing with disks. Data consistency security

Disadvantages: slow speed

Non-relational database

Nosql,not only sql aims at high efficiency and high performance.

All factors that have nothing to do with efficiency and performance should be abandoned as much as possible.

It is a supplement to relational database.

Getting hotter and hotter

Memcached pure memory cache software

Key-- > value key-value pair form stu001--- > oldboy

Redis memory persistence software (disk)

Data type key---- > values key-value pair form stu001--- > oldboy

More data types:

Key--- > values collection set list list.

Summary of nosql non-relational database

1. Nosql is not a negation of relational database, but an important supplement to relational database.

2. Nosql for high performance. Born with high concurrency

3. Nosql typical products memcahed (pure memory), redis (persistence) mongdb (database of documents)

Why choose mysql?

1. Mysql has excellent performance, stable service and few abnormal redundant machines.

2. Mysql is open source code without copyright restriction, autonomy and cost of use.

3. Mysql has a long history, and communities and users are very active when they encounter problems, so they can look for treasure beads.

4. Mysql software is small in size, easy to install and use, easy to maintain and low cost of installation and maintenance.

5. Mysql brand word-of-mouth effect, so that enterprises do not need to consider it directly, LNMP LEMP popular architecture

6. Mysql supports multiple language operating systems, provides multiple api interfaces, and supports multiple development languages, especially for the popular php language.

This is the end of the definition of mysql Database. Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.