Misplaced Pages

DataEase: Difference between revisions

Article snapshot taken from Wikipedia with creative commons attribution-sharealike license. Give it a read and then ask your questions in the chat. We can research this topic together.
Browse history interactively← Previous editContent deleted Content addedVisualWikitext
Revision as of 22:51, 1 December 2007 editFirsfron (talk | contribs)Administrators76,983 edits propose deletion using AWB← Previous edit Latest revision as of 02:59, 17 December 2024 edit undoMd69 (talk | contribs)144 editsm →DataEase for DOS 
(114 intermediate revisions by 61 users not shown)
Line 1: Line 1:
{{Short description|Relational database management system (RDBMS)}}
{{dated prod|concern = {{{concern|{{{1|}}}}}}|month = December|day = 1|year = 2007|time = 22:51|timestamp = 20071201225156}}
{{More citations needed|date=December 2007}}
<!-- Do not use the "dated prod" template directly; the above line is generated by "subst:prod|reason" -->
'''DataEase''' is a ] (RDBMS), and is considered a rapid application development tool for developing relationally-organized, data-intensive ] applications for personal computers. DataEase was created in the early 1980s by software developers Arun Gupta<ref>{{cite web|title=An End to Web Coding: Toolmaker Aims for Discipline in App Engineering|website=Internet World Magazine|first=David|last=Carr|date=2000-09-15|access-date=2024-01-03|url=http://www.iw.com/magazine.php?inc=091500/9.15.00fastforward1.html|archive-url=https://web.archive.org/web/20060315192633/http://www.iw.com/magazine.php?inc=091500/9.15.00fastforward1.html|archive-date=2006-03-15|url-status=dead}}</ref> 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'''.


As of September 2024, LegEasy9 (DataEase for Window version 9) available for purchase online at DataEase . LegEasy9 comes with 100's of new functions and improvements in the printing area.
'''DataEase''' is 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 and Joseph Busch. The first version of the software was released in 1981. 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' history: '''DataEase for DOS''' and '''DataEase for Windows'''.

----


== DataEase for DOS == == DataEase for DOS ==
Originally called Datamaster,<ref>{{cite web|title=DataEase.com » History|website=www.dataease.com|access-date=2024-01-03|url=http://www.dataease.com/company/history.html|archive-url=https://web.archive.org/web/20081120230849/http://www.dataease.com/company/history.html|archive-date=2008-11-20|url-status=live}}</ref> 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 their application.<ref>{{cite web|title=Science and Technology|website=Probert Encyclopedia|access-date=2024-01-03|url=http://www.probertencyclopaedia.com/browse/GD.HTM|archive-url=https://web.archive.org/web/20140907032919/http://www.probertencyclopaedia.com/browse/GD.HTM|archive-date=2014-09-07|url-status=live}}</ref> 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.
DataEase' early hallmark was the ease with which non-programmers found they could rapidly develop useful software applications. DataEase' 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. 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' 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 ==== === Sample DQL Script ===


For Employees with (Salary < 50000 and YearsOfService > 4 and LastReviewGrade>85)<br /> For Employees with (Salary < 50000 and YearsOfService > 4 and LastReviewGrade > 85)<br />
List Records<br /> List Records<br />
LastName in order;<br /> LastName in order;<br />
Line 25: Line 23:
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. 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.


'''<big>DataEase on Unix</big>'''
==== From Nothing To An Application ====


A group in ] around 1991 came up with a product they named XDOS.
The following sequence of images depict the steps required by DataEase for DOS to construct and deploy a minimal data application.


It was binary-level conversion software that would transfer executable ] files onto a prescribed ] 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.
===== Main Menu =====
]


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.
===== Create a Data Form =====


Some of the XDOS compatible applications included DataEase, ], ] (spreadsheet) and others.
The first step is to create a form. Forms and tables are one and the same. When a form's design is altered, the changes to the underlying structures and data occur transparently.
]


XDOS was provided for specific nominated variants of the UNIX system. Not for ] 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/] variants.
====== Defining a Form's Fields ======


The XDOS developers went on to develop the ] 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
====== The Form Design Canvas ======


=== 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 ], ], Citimortgage (FKA Lomas Financial Corporation), and the American Automobile Club.
===== Create a Report Procedure =====


'''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.
After one has constructed the screen forms that will be used to manage the data in the application, the next natural step is to create a number of reports to list and analyze the data. The following depicts the basic steps performed to create a new report.


=== Awards ===
]


'''DataEase for DOS''' was recognized with a number of prestigious industry awards,<ref>{{cite web|title=History of DataEase|language=en|website=www.plmconsulting.com|access-date=2024-01-03|first=Phil|last=Winkler|url=http://www.plmconsulting.com/plmforum/showthread.php?t=6466&highlight=history+DataEase|archive-url=https://web.archive.org/web/20120308203918/http://www.plmconsulting.com/plmforum/showthread.php?t=6466&highlight=history+DataEase|archive-date=2012-03-08}}</ref> including:
====== The Interactive DQL Script Editor ======

The next several screens depict the steps required to construct a report procedure with the interactive script editor. Using DataEase' interactive mode, it is impossible to make a syntactic mistake. This permits even non-programmers to rapidly construct useful applications.

]

]

]

]

]

====== The Report Layout Editor ======

The layout is automatically generated from one of several templates.
]

===== Create a Menu =====

]

===== Create Your Users =====

]

]

===== Put Your Application To Work =====
====== Main Menu ======

]

====== Enter Data ======

]

====== Print A Report ======

]

==== DataEase at Work ====

DataEase for DOS gained an eccentric following among application developers and those responsible for managing proprietary business processes in the corporate world. The DataEase Resource Guide, published by Sapphire 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 2007.

==== Awards ====

'''DataEase for DOS''' was recognized with a number of prestigious industry awards


* '''PC Magazine''' Editor's Choice: 1986, 1988, 1989 * '''PC Magazine''' Editor's Choice: 1986, 1988, 1989
* '''PC Magazine''' Best of Award: 1988, 1990 * '''PC Magazine''' Best of Award: 1988, 1990
* '''PC Week Labs''' Shootout: Winner 1990 * '''PC Week Labs''' Database Challenge development Shootout - Olympia PC User show: Winner 1989 (Julian Brearley & Gary Cowan), 1990 (Julian Brearley & Simon Irwin)


== DataEase for Windows == == 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''' (DFW) is a ] tool for constructing ] 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 ]-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 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. 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 1990's. 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|date=July 2009}}


Since DataEase version 7 (2006) interoperability has been abandoned as being too restrictive for the product's development to be a good 'Windows citizen'. Furthermore, in ten years of availability it was rarely taken advantage of. 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|date=July 2009}}


== Present Day (2007) == == 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.
Since Sapphire is a privately-held company, market data for DataEase sales and Sapphire's overall vitality is difficult to obtain. One can only draw subjective conclusions from anecdotal evidence from diffuse sources. The facts are that the longtime director of DataEase software development, Pete Tabord, left Sapphire in the fall of 2006 and formed a company called Database City. Database City has announced the availability of an application-building product called Ffenics that seems to share many of DataEase for Windows features. Ffenics offers automated migration of DFW systems.


DataEase 7.2 was officially launched on July 1, 2009. This version is the first to use the ] ] and was extensively reworked to contain more than 1,000 improvements and fixes <ref>{{Dead link|date=July 2019 |bot=InternetArchiveBot |fix-attempted=yes }}.</ref>
Sapphire continues to offer DataEase for Windows, but they have also recently announced a service offering to assist DataEase users in the conversion of their DataEase applications to Microsoft .NET.


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.
Surprisingly, there are a significant number of DataEase for DOS applications still solving process problems around the world. However, like all legacy DOS programs, the costs and risks associated with continued support of these applications continue to grow. Microsoft has stated its intent to abandon all support for MS-DOS and it is only a matter of time before one will be unable to run legacy DOS programs within the Windows operating system, further threatening otherwise satisfied DataEase for DOS users.


==References==
Some third-parties have stepped in to help address this problem with automated migration tools and services that greatly reduce the effort required to migrate DataEase DOS applications to contemporary software platforms. An example of such a provider is the line of software tools for DataEase developers, who supplies a software workbench that automatically recreates existing DataEase for DOS applications in a number of target environments including Microsoft Access, SQL Server, Oracle, and web-based deployments.
{{reflist}}


== External links == == External links ==

*
* *
* [http://www.plmconsulting.com/plmforum A DataEase User's Forum/BBS * {{Webarchive|url=https://web.archive.org/web/20110715093438/http://www.plmconsulting.com/plmforum/ |date=2011-07-15 }}
*

]]


{{DEFAULTSORT:Dataease}}
]
]
] ]

Latest revision as of 02:59, 17 December 2024

Relational database management system (RDBMS)
This article needs additional citations for verification. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.
Find sources: "DataEase" – news · newspapers · books · scholar · JSTOR (December 2007) (Learn how and when to remove this message)

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 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.

As of September 2024, LegEasy9 (DataEase for Window version 9) available for purchase online at DataEase . LegEasy9 comes with 100's of new functions and improvements in the printing area.

DataEase for DOS

Originally called Datamaster, 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 their application. 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 the X Window System 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, including:

  • PC Magazine Editor's Choice: 1986, 1988, 1989
  • PC Magazine Best of Award: 1988, 1990
  • PC Week Labs Database Challenge development Shootout - Olympia PC User show: Winner 1989 (Julian Brearley & Gary Cowan), 1990 (Julian Brearley & Simon Irwin)

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.

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

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

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.

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.

External links

Categories: