Information about Dbase

dBase was the first widely used database management system (DBMS) for microcomputers, published by Ashton-Tate for CP/M, and later on the Apple II, Apple Macintosh, UNIX^[1], VMS^[2], and IBM PC under DOS where it became one of the best-selling software titles for a number of years. dBase was slow to transition successfully to Microsoft Windows and gradually lost market share to competitors such as Paradox, Clipper, FoxPro, and Microsoft Access. dBase was sold to Borland in 1991, which sold the rights to the product line in 1999 to the newly-formed dBase Inc. In 2004, dBase Inc. changed its name to dataBased Intelligence, Inc.

Starting in the mid 1980s many other companies produced their own dialects or variations on the product and language. These included FoxPro (now Visual FoxPro), Arago, Force, dbFast, dbXL, Quicksilver, Clipper, Xbase++, FlagShip, Recital Terminal Developer, CodeBase, MultiBase and Harbour/XHarbour. Together these are informally referred to as xBase.

dBase's underlying file format, the .dbf file, is widely used in many other applications needing a simple format to store structured data.

Recent History

dBase has evolved into a modern object oriented language that runs on 32 bit Windows. It can be used to build a wide variety of applications including web apps hosted on a Windows server, Windows rich client applications, and middleware applications. dBase can access most modern database engines via ODBC drivers.

dBase features an IDE with a Command Window and Navigator, a just in time compiler, a preprocessor, a virtual machine interpreter, a linker for creating dBase application .exe's, a freely available runtime engine, and numerous two-way GUI design tools including a Form Designer, Report Designer, Menu Designer, Label Designer, Datamodule Designer, SQL Query Designer, and Table Designer. Two-way Tools refers to the ability to switch back and forth between using a GUI design tool and the Source Code Editor. Other tools include a Source Code Editor, a Project Manager that simplifies building and deploying a dBase application, and an integrated Debugger. dBase features structured exception handling and has many built-in classes that can be subclassed via single inheritance. There are visual classes, data classes, and many other supporting classes. Visual classes include Form, SubForm, Notebook, Container, Entryfield, RadioButton, SpinBox, ComboBox, ListBox, PushButton, Image, Grid, ScrollBar, ActiveX, Report, ReportViewer, Text, TextLabel and many others. Database classes include Session, Database, Query, Rowset, Field, StoredProc and Datamodule classes. Other classes include File, String, Math, Array, Date, Exception, Object and others. dBase objects can be dynamically subclassed by adding new properties to them at runtime.

Origins

The original developer of dBase was Wayne Ratliff.^[3] In 1978, while at the Jet Propulsion Laboratory, Ratliff wrote a database program in assembly language for CP/M based microcomputers to help him win the football pool at the office. He based it on Jeb Long's JPLDIS (Jet Propulsion Laboratory Display Information System) and called it "Vulcan," after Mr. Spock of Star Trek. According to Ratliff, the language in JPLDIS was a simple, command-driven language intended for interactive use on printing terminals. There is some evidence that JPLDIS was influenced by a mainframe database product called RETRIEVE.

In early 1980, George Tate, of Ashton-Tate, entered into a marketing agreement with Ratliff. Vulcan was renamed to dBase, and the software quickly became a huge success.

dBase programming language

After porting Vulcan to the IMSAI 8080 and later to CP/M and MS-DOS (as dBase), Ratliff added commands to accommodate the video screen interface as well as commands for improved control of flow (such as DO WHILE/ENDDO) and conditional logic (such as IF/ENDIF).

For handling data, dBase provided detailed procedural commands and functions to open and traverse records in data files (e.g., USE, SKIP, GO TOP, GO BOTTOM, and GO recno), manipulate field values (REPLACE and STORE), and manipulate text strings (e.g., STR() and SUBSTR()), numbers, and dates. Its ability to simultaneously open and manipulate multiple files containing related data led Ashton-Tate to label dBase a "relational database," even though it did not meet the criteria defined by Dr. Edgar F. Codd's relational model. (It could be characterized as a hybrid relational and navigational database).

dBase used a runtime interpreter architecture, which allowed the user to execute commands by typing them in a command line "dot prompt." Upon typing a command or function and pressing the return key, the interpreter would immediately execute or evaluate it. Similarly, program scripts (text files with PRG extensions) ran in the interpreter (with the DO command), where each command and variable was evaluated at runtime. This made dBase programs quick and easy to write and test because programmers didn't have to first compile and link them before running them. (For other languages, these steps were tedious in the days of single- and double-digit megahertz CPUs.) The interpreter also handled automatically and dynamically all memory management (i.e., no preallocating memory and no hexadecimal notation), which more than any other feature made it possible for a business person with no programming experience to develop applications.

Conversely, the ease and simplicity of dBase presented a challenge as its users became more expert and as professional programmers were drawn to it. More complex and more critical applications demanded professional programming features for greater reliability and performance, as well as greater developer productivity.

Over time, Ashton-Tate's competitors introduced so-called clone products and compilers that introduced more robust programming features such as user-defined functions (UDFs) to supplement the built-in function set, scoped variables for writing routines and functions that were less likely to be affected by external processes, arrays for complex data handling, packaging features for delivering applications as executable files without external runtime interpreters, object-oriented syntax, and interfaces for accessing data in remote database management systems. Ashton-Tate also implemented many of these features with varying degrees of success. Ashton-Tate and its competitors also began to incorporate SQL, the ANSI/ISO standard language for creating, modifying, and retrieving data stored in relational database management systems.

In the late 1980s, developer groups sought to create a dBase language standard (IEEE 1192). It was then that the language started being referred to as "Xbase" to distinguish it from the Ashton-Tate product. Hundreds of books have been written on dBase and Xbase programming. For a couple of years in the late 1980s, author Joseph Carrabis, who penned several dBase texts^[4], was one of the ten top selling authors worldwide.

Today, implementations of the dBase language have expanded to include many features targeted for business applications, including the manipulation of the graphical user interface, manipulation of remote and distributed data, Internet functionality, and interaction with modern devices. Despite its functionality and ease of use, the dBase language's legacy of being "embedded" in a popular commercial product is one of the reasons it is not a dominant standard today.

Programming example

The following example opens an employee table ("empl"), gives every manager who supervises 1 or more employees a 10-percent raise, and then prints the names and salaries.

USE empl REPLACE ALL salary WITH salary * 1.1 FOR supervises > 0 LIST ALL fname, lname, salary TO PRINT

• (comment: reserved words shown in CAPITALS for illustration purposes)

Note how one does not have to keep mentioning the table name. The assumed ("current") table stays the same until told otherwise. This is in contrast to SQL which almost always needs explicit tables. dBase used a lot of similar "context" based techniques to reduce the volume of typing needed and facilitate incremental, interactive development. However, one had to be careful about porting (borrowing) programming code that assumed a certain context and it would make writing larger-scale modular code difficult. Work-area-specific references were still possible using the arrow notation ("B->customer") so that multiple tables could be manipulated at the same time.

Another notable feature is the re-use of the same clauses for different commands. For example, the FOR clause limits the scope of a given command. (It is somewhat comparable to SQL's WHERE clause). Different commands such as LIST, DELETE, REPLACE, BROWSE, etc. could all accept a FOR clause to limit (filter) the scope of their activity. This simplifies the learning of the language.

dBase was also one of the first business-oriented languages to implement string evaluation (long before Perl)

i = 2 myMacro = "i + 10" i = &myMacro // i now has the value 12

Here the "&" tells the interpreter to evaluate the string stored in "myMacro" just like it was programming code. This is an example of a feature that made dBase programming flexible and dynamic, sometimes called "meta ability" in the profession. However, it could also be problematic for pre-compiling and for making programming code secure from hacking. However, dBase tended to target custom applications for small and medium companies where compile-based security was often less of an issue. For example, nobody would contemplate writing an operating system in the language.

Niches

Although the language has fallen out of favor as a primary business language, some find it an excellent interactive ad-hoc data transformation tool. Unlike SQL, one can easily break data transformations into small steps to analyze and visually inspect. (One can optionally disable such inspection using the PROTECT command. The PROTECT command is a proprietary encryption device designed for dBase.) dBase also allegedly makes it easy to incrementally collect existing interactive data manipulation commands into subroutines to become automated scripts, in contrast to competitors which can require starting from scratch to go from interactive mouse commands to program scripts. It could be described as a "keyboard-friendly" language, partly due to its being designed before the mouse became common.

It allegedly fills the gap between formal RDBMS and array programming languages such as APL's modern derivatives (J, K, etc.) It is also often used with bulk data file preparation for shipment to external (other vendor) sites via protocols such as FTP and email.

It remained a popular teaching tool even after sales slowed because the text-oriented commands were easier to present in printed training material than the mouse-oriented competitors. (Mouse-oriented commands were added to the product over time, but the command language remained a popular de-facto standard while mousing commands tended to be vendor-specific.)

File formats

A major legacy of dBase is its .dbf file format, which has been adopted in a number of other applications. For example, the shapefile format developed by ESRI for spatial data in a geographic information system uses .dbf files to store feature attribute data. The term XBase is often used for the group of applications.

dBase's database system was one of the first to provide a header section for describing the structure of the data in the file. This meant that the program no longer required advance knowledge of the data structure, but rather could ask the data file how it was structured.

A second filetype is the .dbt file format for memo fields. While character fields are limited to 254 characters each, a memo field is a 10-byte pointer into a .dbt file which can include a much larger text field. dBase was very limited in its ability to process memo fields, but some other xBase languages such as Clipper treat memo fields as strings just like character fields for all purposes except permanent storage.

dBase uses .ndx files for indexes. Some xBase languages include compatibility with .ndx files while others use different file formats such as .ntx used by Clipper and .idx/.cdx used by FoxPro.

References

External links

• dBase Inc.
• Xbase (and dBase) File Format Description
• DBF Viewer 2000
• GTK DBF Editor
• DBF Repair tool

Topics in database management systems (DBMS)  •  • [ edit]
Concepts Database  Database models  Database storage  Relational model  Distributed DBMS  ACID  Null Relational database  Relational algebra  Relational calculus  Database normalization  Referential integrity  Relational DBMS  Primary key, Foreign key, Surrogate key, Superkey, Candidate key
Objects Trigger  View  Table  Cursor  Log  Transaction  Index  Stored procedure  Partition	Topics in SQL Select  Insert  Update  Merge  Delete  Join  Union  Create  Drop Begin work  Commit  Rollback  Truncate  Alter
Implementations of database management systems
Types of implementations Relational  Flat file  Deductive  Dimensional  Hierarchical  Object oriented  Object relational  Temporal  XML data stores
Database products Object-oriented (comparison)  Relational (comparison)	Components Query language  Query optimizer  Query plan  ODBC  JDBC