Q: About Informix Online Server?

hi, i've heard about Informix Online Server but i'm not quite sure about the tech stuff behind. Is it something on the server side? Or it is something put to the client side to make it connect to the database easier? Is it using ODBC or OLE DB or something else? Thanx. rgds, thenard Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.

Informix-Online is just a brand-name denoting a specific engine of Informix. It was the first offered after Informix-SE (standard engine/online engine) about version 5.5, if I remember correctly. I think 7.0 was really associated the most with Online. Then came Universal Server, yada.yada. Informix-CLI is an Informix ODBC client. It is a bundled version I-NET for Win95/NT and the Intersolv ODBC driver. Maybe you looking for Informix-CLI? ~~~~~~~~~~~~~~~~~~~ Scott R. Kennedy, President Kennedy Systems, Inc. KSINC@AOL.COMical

KSINC wrote: > > Informix-Online is just a brand-name denoting a specific engine of Informix. It > was the first offered after Informix-SE (standard engine/online engine) about > version 5.5, if I remember correctly. I think 7.0 was really associated the > most with Online. Then came Universal Server, yada.yada. Close, KSINC: Thenard, Online Server is the older name of Informix's enterprise level database servers, the first to permit 24x7 operation and live online archiving while the data was being actively updated, hence the name "online". A Brief history of Informix Online Servers Informix's first database 'engine' was the Standard Engine product, a relational database built over Informix's standard setting CISAM library. SE was followed by the Turbo Engine, an attempt to build a faster, shared memory based, fully online 24x7 database server. Turbo had some problems and was redesigned and renamed. Informix Online was the server that replaced the Informix Turbo and it was Informix's first 24x7 always "online" database server. Online (or just OL) (and to some extent turbo), unlike the Informix Standard Engine (SE), allowed one to have one's data available all the time since it could be backed up while users where actively accessing and updating the data. The first version designated "Online Server" was OL 4.00 (I believe Turbo was Vers. 2.10 the versions were changed to align the versions of 4GL with engine version numbers). OL 4.01 was followed by OL 5.00 which added stored procedures and OL 5.01 which added triggers. The next big change was the Informix Online Dynamic Server (ODS) which was version ODS 6.00 which was an interim release that began to implement Informix's now famous Dynamic Server Architecture (DSA) which was a fully multiprocessed, multi-threaded server architecture which could take advantage of SMP and MPP environments. ODS 6 was a internally fully parallel but did not extend parallelism to user requests. The Informix Dynamic Server (IDS) Version 7.00 was the first fully parallel database server on the market implementing multi-threaded queries which could fulfill various parts of a user's query in parallel speeding query results for complex queries significantly. IDS 7 also implemented table and index fragmentation, what Codd and Date called horizontal partitioning, whereby the rows of a table could reside on different disk structures and could be scanned or otherwise queried in parallel extending the parallel feature of IDS to more queries. IDS 8, which has become IDS with Extended Parallel/Decision Support Options (XPO/DSO), extended the IDS parallelism to multiple machines in a cluster with a unique shared nothing architecture that takes best advantage of each nodes power. IDS 8 further extends the horizontal partitioning feature of IDS by allowing a table to be spread across multiple nodes in the network so that records can be positioned globally closer to the sources and/or consumers of their data. You can keep the records of your Tokyo office on a node in Tokyo and the home office will still see the table as a single entity. IDS 9 Universal Server, which became IDS with Universal Data Option (UDO), added user defined data types and the ability to extend the server with DataBlades, which execute user developed code in specialized Virtual Processors in the IDS engine, to implement business logic in the engine. Now the latest new version IDS.2000, and Foundation.2000 which is basically IDS.2000 with the WEB DataBlade included (and more), brings the UDO features and the speed and newer features of the base IDS engine together and is now the standard IDS version. IDS.2000 is due for general release in about a week. Art S. Kagel