DBMS Interaction (from Fraktal SAS Programming)
"Database management systems" (DBMS) found in today's professional or industry environment belong to the family of "relational DBMS" talking "Structured Query Language" (SQL). Over past decades since their appearance on the market only few products (and even fewer companies) have retained their independence or have survived at all. Again, only few of these lucky ones have established "their" markets in selected industries:
- IBM DB2 (Financial)
- IBM Informix Dynamic Server
- Ingres VectorWise
- Microsoft SQL Server
- Oracle Database (Pharma)
- Oracle mySQL (Web 2.0)
- SAP Sybase Adaptive Server Enterprise
To interact with the above mentioned family of database systems SAS Institute provides convenient read/write-engines as part of their "Multiple Engine Architecture" (MEA). This means, roughly speaking, that the ordinary SAS user is rarely bothered with specific properties of the particular database server used for data management in his company or working context in general:
From a SAS programmer's view data is data and (almost) nothing but.
Nevertheless, throughout this course, we will consistently refer to the particular DBMS when presenting examples and sample code.
