How the database is selected
Commonly used databases are divided into five kinds: (a), Access (ii) SQL Server (iii) MySQL (iv) Oracle (v) SQLite, then, users want to make a website, in the end what kind of database is suitable for their own? Here is a brief introduction to the common database what is the difference or functional aspects.
1. Access
Access is an associative data-sequencing system published by Microsoft that is often used to develop Web applications that use ASP technology to run on IIS. However, in Access is a small database, the use of the fundamental business limitations, when the database is too large or when visiting burden high performance will drop sharply.
2. Mysql
MySQL is a small relational database management system, the developer of the Swedish Mysqlab Company, was acquired by Sun Company on January 16, 2008. MySQL is widely used in small and medium-sized websites on the internet. Because of its small size, fast speed, low total cost of ownership, especially the open source, many small and medium-sized web sites in order to reduce the total cost of ownership of the site chose MySQL as the site database.
3. SQL Server
SQL Server is characterized by a true client/server architecture, and 10 is a graphical user interface that makes database management more intuitive and straightforward. It also provides a rich programming interface tool for users to design a larger selection of redundancy.
4. Oracle
Oracle database system is one of the most popular client/server (client/server) or B/s architectures in the United States Oracle Corporation (Oracle) provides a distributed database-centric set of software products. For example, Silverstream is a database-based middleware. Oracle database is the most widely used database management system in the world, as a general database system, it has complete data management function; As a relational database, it is a complete relational product; It realizes distributed processing function as a distributed database. But all of its knowledge, as long as it learns Oracle knowledge on one model, can be used on all types of machines.
5, SQLite
SQLite, is a lightweight database, is to comply with acid-related database management system, its design goals are embedded, and has been used in many embedded products, it occupies very low resources, in embedded devices, may only need hundreds of K of memory enough. It can support Windows/linux/unix and so on mainstream operating system, and can be combined with many programming languages, such as C #, PHP, Java, and ODBC interface, also compared to MySQL, PostgreSQL's two open source world-famous database management system, it's faster than they can handle.
Selection of Databases (ii)