Informix Standard Engine (SE)
Informix Standard Engine (SE) is ideal for small applications because of its extremely low system overhead (12 Mb disk footprint). Pretty much regardless of hardware, SE is quick and exceptionally reliable. Informix has all but removed any limitation in file-based data storage however you’re unlikely to want to put any more than about 100 users on one of these systems. SE provides connectivity through JDBC and ODBC, so it makes a good choice for light applications on small open systems such as Linux. There is no penalty for developing an application on SE and migrating this to IDS over time. There is even a trade-up option if you are moving from SE to IDS.
Informix Database New License Pricing
Informix Database Annual Support Pricing
Informix DB Tools New License Pricing
Informix DB Tools Support Renewal Pricing
Excellent performance – A cost-based query optimizer combined with flexible indexing options allows Informix® SE to maintain excellent performance even for complex queries. Informix SE also allows for very large (up to 1TB) databases on new operating systems that support large file sizes.
Ease of Administration – Informix SE takes advantage of native UNIX operating system and file management, making backing up databases and tables as simple as backing up any other UNIX. Informix SE includes easy-to-use utilities that allow users to migrate Informix SE data to another Informix SE database–or to the Informix Dynamic Server?, providing an upgrade path to a high-performance, parallel-processing database server.
Connectivity – Informix SE provides a wide range of client connectivity options: It supports the traditional Informix client tools (such as Informix SQL and 4GL) and other development and reporting tools through support for the ODBC and JDBC standards. ODBC and JDBC drivers are available for a variety of platforms, broadening the range of client solutions available.
Data Integrity – The transaction logging feature of Informix SE supplies an audit trail of data changes, ensuring fundamental data integrity and allowing fast and reliable restoration of databases when a system failure occurs. During a transaction, changed data is locked to prevent another user from altering that data at the same time. The impact of locking during transactions can be optimized through the flexible choices of lock and read isolation levels available in Informix SE.
Data Consistency – Informix SE integrity constraints, stored procedures and triggers allow data validation rules to be defined centrally in the database. These rules ensure that information inserted or updated in the database meets the business criteria determined by the specific application.
Data Security – Informix SE provides security controls at the database, table, column and stored procedure levels. Stored procedure permissions can be used to restrict user access to business functions rather than underlying data, allowing extreme flexibility in determining user rights.
Manuals SE Download Download now
Release Notes SE Download Download now
Machine Notes SE Download Download now