DataEase

Last updated

DataEase is a relational database management system (RDBMS), and is considered a rapid application development tool for developing relationally-organized, data-intensive software applications for personal computers. DataEase was created in the early 1980s by software developers Arun Gupta [1] and Joseph Busch. The first version of the software was released in 1981 by Software Solutions Inc. The principals sold the company to Sapphire International Corporation of the United Kingdom in 1991. Sapphire continues to develop and market the product. There are two distinct product arcs in DataEase's history: DataEase for DOS and DataEase for Windows.

Contents

As of October 2023, DataEase appears to have disappeared. Its website and that of its last owner, Sapphire Groups, could not be found.

DataEase for DOS

Originally called Datamaster, [2] DataEase's early hallmark was the ease with which non-programmers found they could rapidly develop useful software applications. DataEase's design emphasized the visual design of screen forms and reports while hiding almost all of the arcane details such as properties of the underlying data structure. In addition, complex data management processes that would typically require a multitude of complex steps to complete with traditional programming tools were handled automatically and transparently as a user made changes to his/her application. [3] For example, when editing an existing form, if the user removed a field, added another, indexed another and changed the data type of yet another, the necessary steps required to reflect those changes in the data structure underlying the form were automatically and non-destructively applied when the form was saved.

Report writing was similarly streamlined. The user simply defined access to the desired data using a simple procedural language known as DataEase Query Language (DQL). A prompting script editor, which permitted any user to instantly create DQL script with no prior knowledge of DQL syntax, remains one of DataEase's most overlooked and beneficial features. One was not required to memorize details about the application's components or DQL syntactical construction prior to writing a valid DQL script.

Sample DQL Script

 For Employees with (Salary < 50000 and YearsOfService > 4 and LastReviewGrade > 85)
List Records
LastName in order;
FirstName ;
CurrentSalary : item sum ;
CurrentSalary * data-entry EnterRaiseAmount : item sum .
Modify Records
CurrentSalary := CurrentSalary * data-entry EnterRaiseAmount .

In addition to simplified definition of data forms, reports and procedures, DataEase for DOS provided facilities for defining an application's user access, navigational menus, multi-format importing of data from other sources, data exporting, data backup and restoration, system documentation and user help, backing up and restoring data and integrating external programs into the application. DataEase for DOS applications provided record-level locking meaning they could be accessed simultaneously by many other users.

DataEase on Unix

A group in Palo Alto around 1991 came up with a product they named XDOS.

It was binary-level conversion software that would transfer executable DOS files onto a prescribed Unix version and thereby DataEase for DOS became DataEase for Unix. Everything was transported so that the application made under DataEase for DOS would be ported to the UNIX environment - everything, including data.

XDOS was able to be applied against an array of popular applications at the time (in the professional sense as PCs were, then, rarely seen outside of the IT Department or on desktops at work, in the library or occasionally in the home of an IT professional developer.

Some of the XDOS compatible applications included DataEase, MS Word, Lotus 123 (spreadsheet) and others.

XDOS was provided for specific nominated variants of the UNIX system. Not for HP but most others. The UNIX variant maker had to agree to hand over certain required technicals that HP, in the day, found impossible to agree with. Just about all variants of UNIX had no such trouble or met the criteria due to compatibility between UNIX/XENIX variants.

The XDOS developers went on to develop XWindows for UNIX.

When the decision eventually came that the DataEase for DOS would not be able to port to DataEase for Windows, the arse fell from the massive worldwide user base, in 13 languages including Russian and Japanese

DataEase at Work

DataEase for DOS gained an eclectic following among application developers and those responsible for managing proprietary business processes in the corporate world. The DataEase Resource Guide, published by DataEase International in the late 1980s lists approximately two hundred commercially available applications spanning specialized domains from Waste Management to Law Enforcement. Indeed, many corporate users deployed business-critical applications using DataEase including organizations such as NASA, Ford Motor Co., Citimortgage (FKA Lomas Financial Corporation), and the American Automobile Club.

DataEase for DOS was distributed worldwide and, according to information provided by Sapphire International, peaked at an installed base of approximately 2 million seats. Despite the fact that Sapphire ceased distribution of DataEase for DOS in 2003, a significant number of DataEase for DOS applications remained in active use worldwide as of 2008.

Awards

DataEase for DOS was recognized with a number of prestigious industry awards, [4] including:

DataEase for Windows

DataEase for Windows (DFW) is a rapid application development tool for constructing Windows database applications. DataEase for Windows abandoned many of the intuitive features of its DataEase for DOS ancestor. The DataEase for Windows product was designed and positioned to address the needs of the more technical programmer. This was due to the belief at the time that soon all data would be stored in SQL-based client-server platforms, and that DataEase itself would evolve into a SQL development tool.

DataEase for Windows was initially released in 1994, as a follow up to DataEase Express, which lacked the DQL procedural language. The user interface was overhauled and the automatic creation of data structures along with screens (Forms) was abandoned. Despite the fact that DataEase for Windows incorporated both an automated migration tool (from DE DOS 4.53) and the ability to directly acquire tables and data from DFD5, many long-time DataEase for DOS users found it difficult to break out from the hierarchical CUI paradigm and make best use of the new tools in the Windows product.

DataEase for Windows' acceptance by existing DataEase for DOS users was therefore significantly hindered, and those who delayed the decision to move and instead upgraded to more recent DOS versions found that while they could share data with Windows versions, to achieve a full Windows application, forms and report layouts all had to be re-created from scratch in DFW. Even though business rules could be imported with the tables, and DQL's could be imported also either by cutting and pasting or by the 'DOS report' facility in DFW version 5.5 on, the difficulty still remained that an application designed with a work-flow for the single-tasking DOS environment was frequently unsuited for the multi-session Windows environment. The difficulty and the considerable expense posed by the task of re-writing their applications forced many otherwise-satisfied DataEase users to reconsider their choice of the DataEase platform.

Conversely, new users of DataEase for Windows with no previous experience found it an effective tool, and some important systems were written using it during the second half of the 1990s.[ citation needed ]

Since DataEase version 7 (2006) interoperability has been abandoned as being too restrictive for the product's development to be a good 'Windows citizen'.[ citation needed ]

DataEase 7.2

In 2008 a new DataEase development team was appointed under the leadership of Ulrik Krohn to take DataEase into a new era which will eventually culminate in a completely web based product.

DataEase 7.2 was officially launched on July 1, 2009. This version is the first to use the 64 bit operating system and was extensively reworked to contain more than 1,000 improvements and fixes [5]

The release of 7.2 also marked the time when DataEase International Ltd. became once again an independent product company solely focused on the product and its development.

Related Research Articles

<span class="mw-page-title-main">Microsoft Access</span> Database manager part of the Microsoft 365 package

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools. It is a member of the Microsoft 365 suite of applications, included in the Professional and higher editions or sold separately.

<span class="mw-page-title-main">OS/2</span> Operating system from IBM

OS/2 is a series of computer operating systems, initially created by Microsoft and IBM under the leadership of IBM software designer Ed Iacobucci. As a result of a feud between the two companies over how to position OS/2 relative to Microsoft's new Windows 3.1 operating environment, the two companies severed the relationship in 1992 and OS/2 development fell to IBM exclusively. The name stands for "Operating System/2", because it was introduced as part of the same generation change release as IBM's "Personal System/2 (PS/2)" line of second-generation personal computers. The first version of OS/2 was initially released in December 1987, and newer versions were released until December 2001.

In computing, cross-platform software is computer software that is designed to work in several computing platforms. Some cross-platform software requires a separate build for each platform, but some can be directly run on any platform without special preparation, being written in an interpreted language or compiled to portable bytecode for which the interpreters or run-time packages are common or standard components of all supported platforms.

<span class="mw-page-title-main">Xenix</span> Discontinued Unix version published by Microsoft

Xenix is a discontinued version of the Unix operating system for various microcomputer platforms, licensed by Microsoft from AT&T Corporation in the late 1970s. The Santa Cruz Operation (SCO) later acquired exclusive rights to the software, and eventually replaced it with SCO UNIX.

<span class="mw-page-title-main">IBM Db2</span> Relational model database server

Db2 is a family of data management products, including database servers, developed by IBM. It initially supported the relational model, but was extended to support object–relational features and non-relational structures like JSON and XML. The brand name was originally styled as DB2 until 2017, when it changed to its present form.

dBase was one of the first database management systems for microcomputers and the most successful in its day. The dBase system included the core database engine, a query system, a forms engine, and a programming language that tied all of these components together.

FileMaker is a cross-platform relational database application developed by Claris International, a subsidiary of Apple Inc. It integrates a database engine with a graphical user interface (GUI) and security features, allowing users to visually modify a database. Versions for desktops, servers, iOS and web-delivery have been released.

Adabas, a contraction of “adaptable database system," is a database package that was developed by Software AG to run on IBM mainframes. It was launched in 1971 as a non-relational database. As of 2019, Adabas is marketed for use on a wider range of platforms, including Linux, Unix, and Windows.

The Pick Operating System, also known as the Pick System or simply Pick, is a demand-paged, multi-user, virtual memory, time-sharing computer operating system based around a MultiValue database. Pick is used primarily for business data processing. It is named after one of its developers, Dick Pick.

<span class="mw-page-title-main">NewWave</span>

NewWave is a discontinued object-oriented graphical desktop environment and office productivity tool for PCs running early versions of Microsoft Windows. It was developed by Hewlett-Packard and introduced commercially in 1988. It was used on the HP Vectras and other IBM compatible PCs running Windows.

Oracle Forms is a software product for creating screens that interact with an Oracle database. It has an IDE that includes an object navigator, property sheet, and code editor that uses PL/SQL. It was originally developed to run server-side in character-mode terminal sessions. It was ported to other platforms, including Windows, to function in a client–server environment. Later versions were ported to Java where it runs in a Java EE container and can integrate with Java, and web services that can be launched from a URL. Recent versions provide a means to run the forms from a desktop computer without requiring a browser.

In computing, a named pipe is an extension to the traditional pipe concept on Unix and Unix-like systems, and is one of the methods of inter-process communication (IPC). The concept is also found in OS/2 and Microsoft Windows, although the semantics differ substantially. A traditional pipe is "unnamed" and lasts only as long as the process. A named pipe, however, can last as long as the system is up, beyond the life of the process. It can be deleted if no longer used. Usually a named pipe appears as a file, and generally processes attach to it for IPC.

DataFlex is an object-oriented high-level programming language and a fourth generation visual tool for developing Windows, web and mobile software applications on one framework-based platform. It was introduced and developed by Data Access Corporation beginning in 1982.

<span class="mw-page-title-main">OpenEdge Advanced Business Language</span> Business application development language

OpenEdge Advanced Business Language, or OpenEdge ABL for short, is a business application development language created and maintained by Progress Software Corporation (PSC). Typically classified as a fourth-generation programming language, it uses an English-like syntax to simplify software development. The language was called PROGRESS or Progress 4GL up until version 9, but in 2006 PSC changed the name to OpenEdge Advanced Business Language in order to overcome a presumed industry perception that 4GLs were less capable than other languages. A subset of the language, called SpeedScript, is used in the development of web applications.

<span class="mw-page-title-main">R:Base</span> Computer software program

R:BASE is a relational database program for the PC created by Wayne Erickson in 1981. Erickson and his brother, Ron Erickson, incorporated the company, MicroRim, Inc. to sell the database, MicroRIM, on November 13, 1981.

<span class="mw-page-title-main">Oracle Designer</span>

Oracle Designer was Oracle's CASE tool for designing an information system and generating it. After generating the information system one is able to edit the generated code with Oracle Developer Suite.

Vinzant Software is a privately held company that is based in Hobart, IN. Vinzant Software develops and markets enterprise job scheduling products for platforms including Windows, Unix, Linux, IBM i, and MPE/ix. It was founded in 1988 by David Vinzant and has focused solely on job scheduling since 1995.

Rocket U2 is a suite of database management (DBMS) and supporting software now owned by Rocket Software. It includes two MultiValue database platforms: UniData and UniVerse. Both of these products are operating environments which run on current Unix, Linux and Windows operating systems. They are both derivatives of the Pick operating system. The family also includes developer and web-enabling technologies including SB/XA, U2 Web Development Environment (WebDE), UniObjects connectivity API and wIntegrate terminal emulation software.

Visionware Ltd was a British software company that developed and marketed products that helped integration of Microsoft Windows clients to Unix-based server applications. It was based in Leeds in West Yorkshire. The three products it was most known for were PC-Connect, XVision, and SQL-Retriever.

References

  1. Carr, David (2000-09-15). "An End to Web Coding: Toolmaker Aims for Discipline in App Engineering". Internet World Magazine. Archived from the original on 2006-03-15. Retrieved 2024-01-03.
  2. "DataEase.com » History". www.dataease.com. Archived from the original on 2008-11-20. Retrieved 2024-01-03.
  3. "Science and Technology". Probert Encyclopedia. Archived from the original on 2014-09-07. Retrieved 2024-01-03.
  4. Winkler, Phil. "History of DataEase". www.plmconsulting.com. Archived from the original on 2012-03-08. Retrieved 2024-01-03.
  5. DataEase 7.2: The first step on the way forward, and the last of an era [ permanent dead link ].