Data Access Language - Description

Description

Like Oracle's PL/SQL or Microsoft's Transact-SQL, DAL is essentially an extended version of SQL supporting basic query functionality and adding clean syntax for cursor operations, logic, and loops.

When sent a command, early versions of Apple's DAL interpreter broke down the statement and re-built it into subqueries for the underlying data sources. This translation took place on the server-side, just like PL/SQL and Transact-SQL, but required a fairly expensive "adaptor" program of often dubious performance. This adaptor made DAL considerably less appealing than later systems like ODBC, where the translation normally takes place on the client side and is typically included for free with the database engine. The downside to the ODBC approach is that, theoretically at least, more network bandwidth is used up to pull the "raw data" to the client machine for processing back into a standard format.

On the client end, DAL was originally accessed directly through a system extension, but DAL was later rolled into a single ODBC-like driver layer, the Data Access Manager (DAM). DAM was ODBC-like in concept, but did not include the SQL layers, it was strictly a system for sending "opaque" queries and receiving result sets. DAM also included the concept of a "query document" that allowed the DAL (or other) queries to be written in an authoring system and then easily used in any client application.

Read more about this topic:  Data Access Language

Famous quotes containing the word description:

    The Sage of Toronto ... spent several decades marveling at the numerous freedoms created by a “global village” instantly and effortlessly accessible to all. Villages, unlike towns, have always been ruled by conformism, isolation, petty surveillance, boredom and repetitive malicious gossip about the same families. Which is a precise enough description of the global spectacle’s present vulgarity.
    Guy Debord (b. 1931)

    I was here first introduced to Joe.... He was a good-looking Indian, twenty-four years old, apparently of unmixed blood, short and stout, with a broad face and reddish complexion, and eyes, methinks, narrower and more turned up at the outer corners than ours, answering to the description of his race. Besides his underclothing, he wore a red flannel shirt, woolen pants, and a black Kossuth hat, the ordinary dress of the lumberman, and, to a considerable extent, of the Penobscot Indian.
    Henry David Thoreau (1817–1862)

    It [Egypt] has more wonders in it than any other country in the world and provides more works that defy description than any other place.
    Herodotus (c. 484–424 B.C.)