Search results
1. Introduction: Basics of Database Administration 1-2 Objectives After completing this chapter, you should be able to: • enumerate tasks of the database administrator. • create users in Oracle. • explain the structure of the Oracle Data Dictionary. • formulate queries against data dictionary tables.
10 wrz 2010 · A database is a collection of structured data. A database captures an abstract representation of the domain of an application. Typically organized as “records” (traditionally, large numbers, on disk) and relationships between records. This class is about database management systems (DBMS): systems for cre ating, manipulating, accessing a database.
Data administration is concerned with the management of an organisation's meta-data, that is, data about data. It is a function which deals with the conceptual or business view of an organisation's data resource.
DATA DICTIONARY The relational database system needs to maintain data about relation. This information is called data dictionary. In other word, a data dictionary is a set of metadata (i.e. data about data) which contains the definition and representation of data elements.
sary for a good understanding of database models, systems, and languages. Chapters 1 and 2 introduce databases, typical users, and DBMS concepts, terminology, and architecture, as well as a discussion of the progression of database technologies over time and a brief history of data models. These
Data and Database Schema † Fundamental hypothesis of database modeling: the information contained in a database is represented on two levels: (1) data(large, frequently modifled) and (2) structure of data (small, stable in time) † Database schema: description of DB structure, accessible by programs Database = 8 ...
Database Management Systems, R. Ramakrishnan 16 Summary DBMS used to maintain, query large datasets. Benefits include recovery from system crashes, concurrent access, quick application development, data integrity and security. Levels of abstraction give data independence. A DBMS typically has a layered architecture.
