|
Ingres supports large commercial and government applications and is a fully open source SQL relational database management system. It is controlled by the Ingres Corporation. The University of California at Berkeley started the research project of Ingres in the early 1970s. In the process several commercial database applications such as Sybase, Microsoft SQL Server, NonStop SQL were generated by Ingres.
It is important to note that Ingres 9.3 was actually released on 7th October 2009. Only Linux and Windows were concentrated by the release of Ingres 9.3. Just a year later Ingres 10 was released too. It can be certainly said that Ingres 10 is an upgrade of all earlier versions. It is interesting to note that an Ingres installation has the capacity to support several databases though they are owned by several users known to the installation. As a matter of fact many databases will be available simultaneously after installation.
Any data location known to the installation creates each database. Default of II_DATABASE is imagined if no data location is mentioned. Ingres is all about a database with multiple locations. Ingres has several other advantages as well. One of the most important advantages of being a database with multiple locations is the allowing of parallel backups thereby controlling the rising backup time.
The point of creation is the point that allows you to know whether a database is public or private. You have to know that a public database is accessible to all known Ingres users. On the other hand a private data base is not accessible to all users but is accessible to only permitted users. This is the main difference between a public database and a private database. Ingres uses the IngresSTAR server to distribute database system. Ingres uses four kinds of tables, namely, Heap, Hash, ISAM and B-tree. There are six available page sizes, namely, 2K, 4K, 8K, 16K, 32K and 64K. Each page can hold a maximum of 512 rows of data.
|
