Ingres (database)

Ingres [ in - grεs '] is a free relational database system. His name is an acronym of interactive graphics retrieval System. Ingres was born in the 1970s under the direction of Michael Stonebraker at the University of California, Berkeley. He wanted to demonstrate the concept of a relational database. The source code of Ingres was available under a BSD -like license. A follow-up project of Michael Stonebraker was Postgres, from the then today's open source PostgreSQL project emerged.

For the development of the system, Michael Stonebraker, Eugene Wong and Gerald Held in 1988 received the ACM Software System Award.

History

Ingres was in versions 6.4 and IngresII long time a widely used DBMS, mainly in the data center operations of universities and other public bodies. For a while it could still hold its own against the dominance of Oracle is due to favorable licensing costs. On the grounds that the performance of Ingres is comparable to other major DBMS, by the then owner, Computer Associates have been greatly raised the royalties, whereby a major advantage over Oracle was lost. As a result, Ingres installations were increasingly replaced by Oracle implementations. (Worldwide in 2004 only about 15,000 installations). To stop the utter destruction of Ingres, Ingres r3 was released as open source software from version Ingres.

Besides the low royalties IngresII had versus about Oracle preference to a lower demand for resources, so it could also be used on smaller machines. Disadvantages were the more difficult to handle, is lower numbers of platforms on which ran the system, and less Ingres - enabled applications. With responsible for the decline were the lack of marketing by Computer Associates and the resulting lack of sales as well as a lack of IT engineers who have mastered this system and could be used in case of need for emergency use.

A weakness of IngresII was that the processing of an SQL statement could not be performed simultaneously by multiple processors. Even if multiple CPUs are used, it could happen that a large query the full resources of a CPU received, so that the required communication between the CPU-based Ingres servers was no longer possible and as a result there was a severe drop in performance. The current version is familiar with this problem no longer, because CPUs can execute queries of labor.

Ingres today

Since 2005, Ingres is again an independent company, headquartered in Redwood City (California ) and offices across 5 continents. In Germany Ingres has offices in Langen ( Hessen) and in Ilmenau ( Thuringia). The current version of Ingres Ingres is 10

Ingres is now the world's leading enterprise open source database and the second largest open source company in the world. Strategic partnerships include inter alia with Red Hat and Novell.

Mid-2010 was (announced Windows 64- bit) with Vectorwise initially for Linux 64 -bit released a new database engine, which relies on the data processing on the processor cache and thus significantly accelerates the data analysis for read applications.

"We ported a business application from Oracle to Ingres VectorWise and were astounded by the substantial performance Increases, Which were up to 70 ×. "

Revision history

  • Berkeley Ingres ( " University " Ingres, currently v. 8.9, public domain )

The Berkeley Ingres in an earlier version was ( first Relational Technology, then Ingres Corporation, then ASK / Ingres, then bought by Computer Associates, now investment firm Garnett & Helfrich Capital, under the name Ingres Corporation ) from the basis for the commercial Ingres OpenINGRES, on the other hand also for the public domain postgres whose version 4.2 was the basis for today's PostgreSQL.

  • Ingres 5.x
  • Ingres 6.1-6.3
  • Ingres 6.4
  • OpenINGRES 1.0 to 2.0
  • IngresII 2.0 to 2.6
  • Ingres r3 (3.0) (under the "CA Trusted Open Source License " )
  • Ingres 2006 ( version 2 of the GPL)
  • Ingres 2006 Release 2
  • Ingres Database 9.2
  • Ingres Database 9.3
  • Ingres Database 10
BSD licenses Oracle Corporation
412632
de