Paradox (database)
From Wikipedia, the free encyclopedia
Paradox is a relational database management system currently published by Corel Corporation. It was originally designed for DOS but a Windows version was released by Borland in 1992.
Contents |
[edit] Paradox for DOS
Paradox for DOS was a relational database management system originally released by Ansa-Software. In September 1987, Borland purchased Ansa-Software, including their Paradox/DOS 2.0 software. Notable classic versions were 3.5 and 4.5. Versions up to 3.5 were evolutions from 1.0. Version 4.0 and 4.5 were retooled in the Borland C++ windowing toolkit and used a different extended memory access scheme.
Paradox/DOS was a successful DOS-based database of the late eighties and early nineties. At that time, dBase and its xBase clones (Foxpro, dbFast, Clipper programming language, dbXL) had the lion's share of the market. Other notable competitors were Clarion, Alpha Four (pre-dated Alpha Five), DataEase, R:Base, Dataflex, MDBS Knowledgeman.
The features that distinguished Paradox/DOS were:
- a visual Query By Example implementation that was supported by an AI engine.
- effective use of memory (conventional as well as extended / expanded) - caching data tables and particularly, indexes which caused Paradox to execute tasks very quickly in contrast to the explicit skills required for xBase performance optimisation.
- an innovative programming language the Paradox Application Language (PAL) that was readable, powerful, and could be recorded from keyboard actions (rather like Lotus 1-2-3 macro recording). Although not object oriented, PAL was called object based.
- Lotus-like text menus and windows which was the native interface (in contrast to dBase which had a command line interface on top of which cumbersome menus were layered).
- Particularly in Paradox 1.0 and 2.0, the user and programming manuals won readability awards - they were copiously illustrated, well laid out and explanations were written in common English. In contrast, xBase and other manuals were text heavy, sometimes even typed in plain Courier with no attempt at professional page layout.
[edit] Paradox for Windows
Paradox for Windows was a distinctly different product produced by a different team of programmers. Borland had, by this time, acquired Ashton-Tate and was preoccupied with proving the worth of the Object-Oriented Programming paradigm, by designing Paradox/Windows and dBase/Windows in such a way that both would share a common database engine called the Borland IDAPI engine. This shift in focus caused delivery datelines for Paradox/Windows and dBase/Windows to be significantly delayed, allowing Microsoft to score well with a pre-Christmas release of their Microsoft Access database program. Microsoft Access was sold for a fraction of the price of Paradox/Windows and bundled with Word, Excel and PowerPoint in Microsoft Office Professional. Furthermore, Access performance was good thanks to team contributions from FoxPro programmers.
[edit] Corel Paradox
Corel acquired certain rights to develop and market Paradox in the mid-90's and released Corel Paradox 8 in 1997. It also bundled Paradox in the professional version of its WordPerfect Office suite. It has released versions 9, 10, 11, 12 and the latest version Office X3 since then.
[edit] Paradox Users
There is a strong Paradox user base, mainly centered around the Paradox Community and its associated newsgroups. Many feel let down by Borland and Corel because they believe that Paradox is superior to all the other desktop DBMS's around. Although there are many fans of ObjectPAL, the programming language for Paradox/Windows, PAL/DOS scripts could not easily be migrated; the object and event models were completely different forcing developers using PAL to completely rewrite their database applications.
