Monday, January 09, 2006

Ingres - Business Open Source Remember Ingres (if you don't you shouldn't be reading this blog). Well, it's gone open source, and this can only be a good thing.

Key Features

* Scalable Server Architecture
With Ingres, systems can grow to meet user demands without rewrites or modification. The same application will run smoothly on a single-processor desktop system or multiprocessor enterprise servers.

* Intelligent Optimizer
Ingres delivers optimum performance by generating query execution plans based on the statistical characteristics of the data.

* Flexible Backup and Recovery
Data integrity is ensured with transaction journaling and the ability to back up data online or offline. Recovery can be to a chosen point in time for all transactions in the defined recovery period or for a more confined subset of transaction activity.

* Choice of Development Options
Since Ingres supports JDBC, ODBC, and .NET remote data connectivity, you can use a wide range of development tools to build applications that leverage Ingres and protect your investment in your staff’s existing skills.

* Ease-of-Management
Ingres is designed to require the minimum amount of maintenance and maximum availability. Less maintenance means fewer DBA’s.

* Flexible Architecture
No two organizations have the same IT infrastructure. Flexibility is the key to being able to support a given architecture and Ingres provides a number of options to achieve this.

* Choice of Distributed Processing Options
Where distributed processing is required, the Ingres Distributed Option allows multiple databases to appear as one virtual database. Alternatively, you can use the Ingres Replicator Option to push data out to other databases, keeping all data synchronized.

* Parallel Query
To fully exploit the capabilities of the latest enterprise-class servers, Ingres now processes queries in parallel across all available CPU resources, dramatically increasing the performance of the queries.

* Key Range Table Partitioning
To help ensure that you get the performance you expect from your hardware, Ingres employs new parallelization techniques. Key range table partitioning allows data to be partitioned across disks based on the value of a given key. As a result, performance can be significantly improved by performing I/O operations across all partitions in parallel.

* Active Cluster Support
Ingres has provided support for active clusters in an OpenVMS environment for many years. This functionality has been extended to include Linux distributions capable of supporting clusters. It allows a system’s workload to be spread across the nodes of a cluster. If one node fails, the remaining ones continue processing to avoid loss of service. Ingres exploits this capability and automatically balances the load across the various nodes in the cluster.

* High-Availability Cluster Support
This is a new capability that is available on Windows, Sun Solaris, HP-UX, and IBM AIX platforms. High-availability clusters offer failover support in the event of a node going down. Should Ingres fail on a node, it will be automatically restarted. Should the node running Ingres fail, the database will be started on an alternative node in the cluster.