Shulou(Shulou.com)06/01 Report--

In this issue, the editor will bring you how to understand the database. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

one

What is a database?

Here I will post the Baidu encyclopedia to you, ha, I am not easy to explain, after all, I have not reached that level.

Database (Database) is a warehouse that organizes, stores and manages data according to data structure. It came into being more than 60 years ago. With the development of information technology and market, especially after the 1990s, data management is no longer just storing and managing data, but has been transformed into a variety of data management methods needed by users. There are many types of databases, from the simplest tables that store all kinds of data to large database systems that can store massive data. In the information society, the full and effective management and utilization of all kinds of information resources is the prerequisite for scientific research and decision management. Database technology is the core part of all kinds of information systems, such as management information system, office automation system, decision support system and so on. it is an important technical means for scientific research and decision management.

There are two kinds of data, one is relational database, the other is non-relational data. Relational data stores data in the form of rows and columns for users to understand. This series of rows and columns are called tables, and a set of tables make up the database. There is a relationship between the table and the data record between the table. Non-relational data, also known as NoSQL, is Not only SQL. Its performance is based on key-value pairs, which can be imagined as the corresponding relationship between primary keys and values in the table, and does not need to be parsed by the SQL layer, so the performance will be very high, and scalability is also based on key-value pairs, and there is no coupling between the data, so it is very easy to scale horizontally. For example, we will learn that mongodb and redis are both this type of database.

two

Learning database

Today we first learn about a MySQL of relational databases.

Then we have to download mysql this tool, the website I directly posted the https://dev.mysql.com/downloads/, choose their own version of the above to download and install. Or download the XAMPP integration package, which also has MySQL programs. Baidu can download it.

Download the database and download a visualization tool so that you can store and see the data content. The visualization tool is Navicat and the download address is https://www.navicat.com/en/products. Just find Baidu with the registration code.

Then click the connection and connect to a local database first.

Fill in the above data and note that you only need to fill in the connection name and password. The ip, port and name of the local connection are fixed, so you don't need to write them yourself. Then click Test to see.

If the connection is successful, you can press OK, so that you can successfully connect to your local database.

Note: the password is set by yourself. You can click this one in mysql to set it, as shown in the following figure.

The above is the editor for you to share the database how to understand, if there happen to be similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

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.