CS 3430 Lecture Notes - Lecture 5: Oracle Database, Microsoft Sql Server, Mysql
Document Summary
Used by the dba and database designers to specify the conceptual schema of a database. In many dbmss, the ddl is also used to define internal and external schemas (views). Dml commands can be embedded in a general-purpose programming language, such as c, c++, User-friendly interfaces: web-based; such as phpmyadmin, you will use it during chapters 6 and 7, form based; uses mouse and do drag/drop, better for general users. Restoring database from a backup or checkpoint. Importing and exporting data from/to files (xml, excel, csv, mdb, etc. What catalog file stores: catalog files are machine and human readable. Data dictionary is a file similar to catalog file and having all catalog file information. It is for humans and it could include comments and descriptions as well. Client; user machine which provides the user interface and local processing. Server; a strong machine having hardware and software to provide different services to clients.