Know free Oracle/SQL Server databases

Know free Oracle/SQL Server databases

 

Large databases such as Oracle and SQL server also have free versions, which can meet the needs of many small and medium projects. However, many project engineers do not know how to use open-source databases such as MySQL, PostgreSQL, and Firebird.

 

In addition, the free version of large databases has many advantages. For example, in the project design and development phase, you can use the free version of the database for development and testing, to the deployment phase, and then select the standard or enterprise version of the large database for deployment. To achieve lightweight agile development.

 

For college students, for the purpose of learning, installing the free version of the large database is enough and will not consume too much personal computer resources.

 

Finally, there will be no copyright dispute over the use of the free version of large databases.

 

The following describes the free version of large databases:

 

1. Oracle Database 10g express Edition
Oracle 10g quick edition (xe) is a small entry-level database based on the Oracle Database 10g 2nd code base. It has the following advantages:
(1) free development, deployment and distribution without worrying about copyright issues.
(2) download speed: The English version is only 165 MB, and the multi-language version is only 216 MB.
The corresponding client tool is also small, 30 mb.
: Http://www.oracle.com/technology/software/products/database/xe/htdocs/102xewinsoft.html
(3) easy to manage.

Oracle officially said this. Oracle Database Xe is an excellent entry-level database for the following users:
* Developers who are devoted to PhP, Java,. net, XML, and open-source applications;
* DBAs that require free entry-level databases for training and deployment;
* Independent software vendors (ISVs) and hardware vendors that require free distribution of entry-level databases;
* Educational institutions and students who need to use the free database in the course.

Oracle Database Xe does not limit the size of the target host to be installed and the number of CPUs (one database per computer ).

 

[Restrictions] A database can store up to 4 GB of user data, and the database can use up to 1 GB of memory, and only one CPU is used on the host.

 

Ii. SQL Server 2008 expression Edition
Microsoft's SQL Server 2008 is also a very good database, and also released the corresponding free version, namely expression edition. The features are as follows:
(1) simple and free
· Quickly establish and deploy database solutions
· Easy backup and recovery
· Integrated Graphic management tools, supporting report production and full text search
· Suitable for Building Web site applications and independent applications
(2) powerful functions
· High Performance
· Use the same database engine as SQL Server 2008
· Fully compatible with SQL Server 2008
(3) Integration
· Integrated development with Visual Studio
· Use business intelligence and office Integration
· Support for PHP
(4) easy to learn
: Http://www.microsoft.com/Downloads/details.aspx? Familyid = B5D1B8C3-FDA5-4508-B0D0-1311D670E336 & displaylang = ZH-CN
The file size is 558 MB.

 

[Restrictions] A single processor is supported. A database can store up to 4 GB of user data, and a database can use up to 1 GB of memory.

 

Iii. DB2 express-C
DB2 express-C is a fully authorized free product released by IBM for the community. It does not limit the time and data size. This database server can be used for application development and deployment for free.
After isV and business partners register with IBM, they can also deliver DB2 express-c free of charge in their solutions.
The size of Windows 32-bit v9.7 is 400 mb.
: Http://www.ibm.com/developerworks/cn/downloads/im/udbexp/

[Advantage] DB2 express-C database does not limit the number of users and the size of the database.
[Restrictions] the DB2 express-C database engine can only use 2 CPU cores and 2 GB of memory.

 

4. cloudscape of IBM
Cloudscape is an open-source and free database provided by IBM.
Cloudscape is a lightweight and embedded relational engine provided in the form of Java class libraries. Its Local interface is Java database connectivity (JDBC) with Java link extensions ). It implements the sql92e standard and many SQL 99 extensions. The engine provides transaction and crash recovery, supports multiple connections, and supports multiple threads using one connection. Because cloudscape is a Java class library, you can easily embed it into any Java application or server architecture without compromising the Java features of the application. When you need to expand the database, cloudscape supports complex SQL transactions and JDBC, which allows it to migrate applications to other SQL databases, such as IBM DB2 Universal Database (UDB ).
[Advantages] Open Source.

 

To sum up, do not think of MySQL as you can during project development, and the future of MySQL after it is acquired by Oracle is unknown. In fact, we still have many choices.