Ingres Database: Open Source Relational Database Management System
Before there was Sybase, before there was SQL Server, there was Ingres. Ingres Database is a commercially supported, open-source relational database management system that can reduce your IT costs and reduce your time to value. Ingres technology has been supporting mission-critical workloads for over thirty years. Originally funded by U.S. defense agency and the National Science Foundation, Ingres has been leading the industry with innovative technology for decades and helping manage the most demanding enterprise applications of Fortune 500 companies. Core Ingres technology forms the foundation, not only for Ingres Database, but numerous other industry-leading RDBMS systems as well. Ingres continues to drive both technological and business innovation providing the enterprise features you need with the Open Source model you want.
Product Highlights:
- Security features for Sarbanes Oxley / HIPPA Compliancy. Ingres supports roles, role separation, and Kerberos authentication to meet the demands for increased data protection. Ingres also provides the robust auditing features many current regulations require to protect your sensitive data.
- Web 2.0 Support. Ingres provides the features needed for today's web-based business applications. These include support for complex, distributed transactions, XML support, advanced development and flexible deployment for service oriented architecture (SOA).
- Scalability. Large tables can be divided into partitions, based on range, a list of values or a hash value to improve performance. The table appears as a single entity to users, but access is improved by eliminating partitions for data retrieval. Ingres supports multiple levels of sub-partitions to give you the ability to design tables to match your usage requirements. Ingres Database also helps manage growing amounts of data in a cost-effective manner using a variety of compression algorithms.
- High Performance. To fully exploit the capabilities of SMP and multi-core platforms, Ingres processes queries in parallel across all available CPU resources, which can dramatically improve the performance of your queries.
- Multilingual Applications. As businesses expand beyond national borders, the ability to store and present information in multiple languages is rapidly becoming a requirement for any database. Ingres supports all facets of Unicode, which lets you store data in multiple languages in a single database.
- Flexible Backup and Recovery. Data integrity is provided by transaction journaling and the ability to back up data online or offline. Recovery can be complete to a specific point in time for the entire database, or for a more confined set of data.
- High Availability. Information in Ingres can be centrally located or distributed across geographically dispersed servers using sophisticated multi-master replication to provide high availability failover sites or workload distribution. Ingres can also run on clusters of servers, providing transparent high availability and as well as scalability benefits.
- Backward Compatibility. Everything changes over time. However, with Ingres , your applications won't need to change when you upgrade your database. Our commitment to backward compatibility ensures that programs written for Ingres will continue to work unchanged with newer versions of Ingres. In addition, database upgrades occur "in place." There is no requirement to unload and reload your data when upgrading your Ingres software.
- Extensive Development platform options. Ingres supports development with JDBC, ODBC, .NET, PHP, Perl, Python, Ruby and Eclipse remote data connectivity, so developers can use a wide range of development tools to build applications that leverage Ingres and protect your investment in your staff's existing skills.
- Extensive Platform Support. Ingres runs on virtually every popular operating system, including Linux, Windows and many varieties of UNIX. Multi-platform support gives you the ability to choose the most appropriate system vendor, increasing your flexibility.
- Easy-to-use tools. Ingres includes a sophisticated, GUI-based tool, Visual DBA, for remote administration. In addition, many popular database management tools such as Toad®, Nagios®, SQuirreL support Ingres Database.
- Best Support in the Industry. Ingres's support organization offers 24x7 follow-the-sun support with one of the highest satisfaction ratings in the industry. In addition, Ingres supports our products for an unprecedented 15 years to help minimize disruption ensure stability and security of your environment.