Data Access Language: Difference between revisions

Content deleted Content added
Moving out of category "Failed"; that category has never been given a neutral, verifiable definition
mNo edit summary
Line 13:
==Description==
 
Like Oracle's [[PL/SQL]] or Microsoft's [[Transact-SQL]], DAL is essentially an extended version of SQL supporting basic query functionality butand adding clean syntax for cursor operations, logic, and loops. A number of vendor specific standards exist for this side of SQL programming.
 
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 more network bandwidth is used up to pull the "raw data" to the client machine for processing.