What are the hot databases at present? The concept of database was mentioned in the previous Micronet, and we have roughly understood some basic knowledge of database. In fact, in my daily production, data base It is also closely related to us. When we call, surf the Internet, and go to the bank for transactions, we need to access different databases. These databases have their own characteristics, but they all have the common characteristics of the databases we mentioned earlier. As far as today's content is concerned, we have popularized some database knowledge. What are the hot databases at present? Focus on research today The server Let's take a look at the database's micro network, and hope it can be helpful to everyone.

1 Microsoft Office Access database

This is a relational database management system released by Microsoft. The combination of Microsoft Jet Database Engine and graphical interface features is a system program of Microsoft Office. Office Professional and higher versions are sold separately. Like other office applications, ACCESS supports Visual Basic macro language, can be used for object-oriented programming, and can reference multiple objects.

Another thing to note is that most of my VBA database solutions are shared with you based on Microsoft Office Access 2013.

2 MySQL database

A relational database management system, developed by MySQL AB in Sweden, is currently an Oracle product. MySQL is one of the most popular relational database management systems at present, and can be said to be one of the best applications in WEB applications. This kind of database stores data in different tables instead of putting all data in a large warehouse, thus increasing the speed and flexibility of reading.

The SQL language used by MySQL is the most common standardized language for accessing databases. It is small in size, fast in speed and low in overall cost of ownership, especially open source. Generally, MySQL is selected as the website database for small and medium-sized website development.

3 Oracle database

The database management system is introduced by Oracle. Oracle is the company that shut down in Beijing a few years ago. The CEO once said that China cannot produce more engineers than the United States. As an engineer learning materials, I really feel a little proud and awe the opponent when I see this sentence. This is power, but to be honest, our technology really needs to be improved, and we need some practical talents. However, many people in China are keen on capital operation, but it is difficult for capital operation appreciation to produce forward-looking scientific research results, and they can only create more funds at most. China's software industry still needs efforts, and WPS has a long way to go.

Oracle database has complete data management function, relational product, distributed processing function, and can realize data warehouse operation with ORACLE.

4DB2 database

The relational database management system is developed by IBM in the United States. Its main operating environment is UNIX (including IBM's own AIX), Linux and Windows server versions. DB2 is mainly used for large-scale application systems, and has good scalability. It can be supported from mainframe to single user environment, and is applicable to all common server operating system platforms. The system has a high level of data availability, integrity, security, recoverability, and the ability to execute small to large applications. It has basic functions and SQL commands that do not depend on the platform. By using data grading technology, mainframe data can be easily downloaded to the LAN database server, so that both client/server users and LAN applications can access mainframe data, and make database localization and remote connection transparent.

DB2 is famous for its very complete query optimizer. Its external connections improve query performance and support multitask parallel queries. Due to its strong network support capability, each subsystem can connect to thousands of distributed users and activate thousands of active threads at the same time, especially suitable for large distributed application systems.

The above databases are popular at present, and of course there are others. Readers can learn about them online. I just said that these are just for application. I can't spend half a day without even knowing the database and its simple knowledge.

From several years of experience, I always believe that VBA should not put too much pressure on VBA. VBA mainly deals with practical problems in work. It is cars and electric vehicles that connect the station with the address, rather than planes and high-speed trains. If you travel thousands of kilometers and can be reached by car, it is really better to take planes and high-speed trains. Therefore, I will mainly explain the operation of VBA and ACCESS databases here. Other databases are only for reference. Since ACCess database is a part of OFFICE, it is sufficient for most VBA users.

MySQL database: hopechilam.com