Ingres Star

Ingres Star enables you to operate on a combination of local and remote Ingres databases operating in a variety of hardware and software environments. Ingres Star performs two phase commit for distributed Ingres transactions. Ingres DTP applications can participate in two phase commit transactions coordinated by TP monitors in environments that include both Ingres and other database management systems. Ingres DTP applications and Ingres Star applications can operate simultaneously against the same Ingres DBMS server. The following table compares Ingres Star with Open TP systems:

Feature	Ingres Star	Open TP System
Typical application	Distributed decision support applications	Distributed online transaction processing (OLTP) applications
Scope and nature of typical application	Enterprise-wide	Mission-critical
Transaction commitment protocol	Two phase commit across multiple Ingres databases	Heterogeneous two phase commit coordinated by external transaction managers
Application programming interface	SQL	SQL plus TP system application programmer interface (API)