Here are some details about the database.
Common database differences and functional aspects:
Access is a desktop database, which is only suitable for applications with small data. It is very good and efficient when dealing with a small amount of data and databases accessed by a single computer. But it cannot access more than four clients at the same time. Access database has certain restrictions. If the data reaches 100M, it is easy to cause server iis to fake death, or consume server memory to cause server crash.
SQL Server is a medium-sized database based on server, which can be suitable for the application of large-capacity data and is much better than Access in function management. It has powerful efficiency in dealing with massive data, flexibility and expansibility in background development. Because now the database is managed by standard SQL language, if it is a standard SQL language, both of them can be basically used. Access database can be used in all double-line shared spaces of 92HeZu network, and also supports SQL Server. There are many extensions of SQL Server, and stored procedures can be used, and the database size is not limited.
SQL Server functions:
1. Real client/server architecture.
2. Graphical user interface makes system management and database management more intuitive and simple.
3. Rich programming interface tools provide more choices for users to design programs.
4.SQL Server is fully integrated with Windows NT, which makes use of many functions of NT, such as sending and receiving messages, managing login security, etc. SQL Server can also be well integrated with Microsoft BackOffice products.
5. It has good scalability and can be used across multiple platforms, from notebook computers running Windows 95/98 to large multiprocessors running Windows 2000.
6. Support for Web technology enables users to easily publish data from the database to the web page.
7.SQL Server provides data warehouse function, which is only available in Oracle and other more expensive DBMS.
MySQL is an open source small relational database management system, which was developed by MySQL AB Company in Sweden and given away by 92HeZu for free. At present, MySQL is widely used in small and medium-sized websites on the Internet. Because of its small size, high speed and low total cost of ownership, especially open source, many small and medium-sized websites choose MySQL as the website database to reduce the total cost of ownership.
MySQL features:
1 MySql is fully multithreaded. Threads are lightweight processes that can flexibly provide services to users without occupying too many system resources.
2.MySql can run under different operating systems. Simply put, MySql can support Windows95/98/NT/2000 and various operating system platforms such as UNIX, Linux and SUN OS.
3.MySql has a very flexible and secure authority and password system. When customers connect with MySql server, all password transmission between them is encrypted, and MySql supports host authentication.
4.MySql supports Windows ODBC. MySql supports all ODBC 2.5 functions and many other functions, so that you can connect MySql server with Access, which greatly expands the application of MySql.
5.MySql supports large databases. Although a web page written in Php is enough to store more than 100 records, MySql can easily support a database with tens of millions of records.
6.MySql has a very fast and stable thread-based memory allocation system, which can be used continuously without worrying about its stability.
7. Powerful query function. MySql supports all operators and functions of the SELECT and WHERE statements of the query, and can mix tables of different databases in the same query, thus making the query fast and convenient.
PHP provides strong support for MySql, and PHP provides a set of MySql functions to support MySql in all directions.