Editing Ingres (database) (section)

==Features==
Major features as available in Actian Ingres 11.2:

* A broad subset of [[SQL-92|ANSI/ISO SQL-92]], as well as extensions;
* Cross-platform support;
* [[atomicity, consistency, isolation, durability|ACID]] compliance;
* [[Stored procedure]]s in both SQL and QUEL;
* [[Database trigger|Triggers]];
* [[Cursor (databases)|Cursors]];
* Updatable [[View (SQL)|views]];
* Primary and secondary indexes;
* [[Foreign key|Foreign Keys]], as well as constraints and indexes on them;
* Partitioned tables with pruning of partitions in optimizer;
* Query [[cache (computing)|caching]];
* Sub-[[Select (SQL)|SELECTs]] (i.e. nested SELECTs);
* Embedded SQL, statements that can be embedded in a host language such as C;
* [[Unicode]] support;
* [[Information schema]] through '''iidbdb''' catalog, the instance's "master database" catalog, which holds information on other databases in the instance, database locations, users, permits, etc.  Each database within the instance will also hold data such as table column info in its system catalogs. There are numerous ways to access this data, for example via SQL or via a GUI interface such as Actian Director or Visual DBA (VDBA). Other command line utilities such as vwinfo and infodb will also give database and/or table column data;<ref>{{cite web | url=https://docs.actian.com/ingres/11.2/#page/StarUser/iidbdb_Catalogs.htm | title=iidbdb Catalogs | publisher=[[Actian]] | date=2023-03-14 | access-date=16 June 2023}}</ref>
* Workload management, a set of SQL Mode options to control [[Run time (program lifecycle phase)|runtime]] behavior;
* [[Database replication]] support through Ingres Replicator, which can also be used with Enterprise Access products, enabling to replicate data to other databases: [[Oracle (database)|Oracle]], [[MS SQL]], [[IBM DB2]], [[Record Management Services|RMS]], [[Oracle Rdb]], [[DATACOM/DB]], and [[IBM Information Management System|IBM IMS]];