OpenIngres 2.0 is the result of two years of intensive research and development by Computer Associates. It is the largest and most comprehensive upgrade in the product`s history, with major user-requested enhancements and proactive improvements in usability, scalability, connectivity, and performance. Expanded replication and connectivity, and simplified SQL-driven Web development technology position OpenIngres 2.0 at the forefront of the DBMS market, particularly in the rapidly emerging world of Internet Commerce and Mobile Computing. OpenIngres/ICE (Internet Commerce Enabled) CA has combined advances in replication technology with expanded connectivity and simplified content management to allow users to easily create and maintain highly scalable and manageable Web applications. With Version 2.0, CA has moved the replication capture system into the DBMS server engine, which has improved performance of the original replication transaction. Subsets of the production database can be replicated on a Web server so that when a change is reflected to a production database, the change is reflected on the Web server in near real-time. This segregation of the production database from its replicated version on the Web server not only prevents a large volume of Web users from overloading the production database, but it also secures against adverse database impact by inexperienced or novice users. CA has also expanded OpenIngres 2.0 to include native API support for Microsoft and Netscape Web servers, adding a broader range of Web access to its previous CGI (common gateway interface) and native Spyglass Web server API support. More significant, Version 2.0 allows users to embed SQL directly into an HTML page via a new macro processor. With most database-driven Web sites, a Web page calls a program that has the SQL query embedded in it. Any time a change needs to be made to the Web page, the associated program has to be changed, tested, and put back on-line. With OpenIngres 2.0, the need to deal with these intermediate programs is eliminated. OpenIngres/Desktop The ability of Version 2.0 to replicate supersets and subsets of the production databases across multiple platforms is especially significant for mobile computing. With this product, optimised for Windows 95, a developer can write an Application against OpenIngres on one of a number of servers - OpenVMS, Windows NT or UNIX - and deploy that application directly to a laptop computer without having to change it. Other DBMS products force developers to write entirely different versions of applications for PC and laptop deployment. Replication is also important to mobile computing since it allows portions of a database to be put on a laptop computer for use in the field. For example, a sales representative could carry a personal version of the corporate sales application to enter and confirm orders. As soon as the salesperson has access to a modem, the integrated desktop replication system can update the corporate database, initiate orders, emails, and so forth. CA has invested major research and development efforts into streamlining the core OpenIngres server. Though invisible to the user, these changes improve Performance and expedite processing through the use of operating system threads, asynchronous I/O techniques, Group I/O techniques, and fine-grained protection of critical data structures. OpenIngres 2.0 includes major new features that expand on the product`s traditional leadership in manageability, and also implement a large number of user-requested enhancements such as Row-Level Locking, Alter Table and Statement Level Rules. OpenIngres 2.0 continues to build on the traditional OpenIngres strengths of automated management functions, which allow for much lower operational costs, in terms of DBA time, technical support, and overall systems administration overhead, than competing products. The simplicity of command-driven or GUI drag-and-drop database configuration, flexible and the resulting reduction in the need for excessive consulting and DBA resources set OpenIngres apart.
Share
Editorial contacts