Actian’s Ingres is a leading, enterprise-grade database management system designed to reduce IT costs and time-to-value, while delivering the strength and features expected from an enterprise-class database. Ingres 10.2 is the latest version of the database, containing enhancements that will make it easier to internationalize customer applications. Along with improved performance and reduced configuration overhead, users can take their first steps into big data analytics with the new Window functions.
Check out these related products: Enterprise Access – lets developers build one client application that can access data on multiple DBMS platforms. EDBC – Directly connects business applications to mainframe databases.
What’s New in Ingres 10.2
Geospatial enhancements – We’ve added eight 2-D (flat earth), twenty-seven 3-D (round earth) and fifteen 4-D (2-D and 3-D plus time series) data types and eight linear functions
Remote GCA – Permits a GCA client process to connect to a remote installation without requiring a Name Server or Communications Server to be running in the client installation
UTF-8 Transliteration – Mapping between UTF-8 and non-UTF-8 character sets
Incorporate spatial data alongside your transactional data within a single repository and remove the barriers for managing spatial data types using a file-based approach. Now you can manage spatial data as part of a transaction, and share data in spatial cases with a platform for development of modern applications.
Ingres 10.2 Benefits
50 new geospatial data types
Simple introduction to analytics with Window functions
Enterprise Access allows a single application to run against multiple databases without needing to know or use host specific syntax or datatypes. The Enterprise Access server implements an interface similar in appearance and behavior to each of the supported DMBS platforms. It is an Ingres connectivity option that allows Ingres applications to run against non-Ingres databases such as Microsoft SQL Server and Oracle.
EDBC provides real-time high performance read/write connectivity to z/OS databases from Windows client/server and Internet, Intranet, and Extranet business applications. EDBC directly connects business applications to enterprise databases on the z/OS mainframe platform, such as CA-Datacom/DB Database, CA-IDMS/DB Database, DB2, CICS/VSAM and VSAM.
Enterprise Access 3.0 Benefits
Support for Microsoft SQL Server 2014
Improved compatibility with Ingres 10.2, including SELECT statement enhanced with OUTER JOIN
Support for SQL Server Native Client 10
Support for Big INT data types for SQL Server, Oracle, IBM DB2 UDB
Extended system catalog changes for OpenROAD 6.2 features support