For this application, we will consider IBM DB2 catalog data (i.e., metadata) for IBM's enterprise-class servers running the z/OS (formerly OS/390 or MVS) operating system.  One of the outcomes of this question is to give you some experience in actually exploring the contents of what's in an RDBMS catalog.  This will also  give us a head start in thinking about query optimization-a major part of this course.

Go to this Web site: 

SYSIBM.SYSCOLUMNS

SYSIBM.SYSCOPY

SYSIBM.SYSDATABASE

SYSIBM.SYSDBRM

SYSIBM.SYSINDEXES

SYSIBM.SYSINDEXPART

SYSIBM.SYSPLAN

SYSIBM.SYSTABLEPART

SYSIBM.SYSTABLES

SYSIBM.SYSTABLESPACE

SYSIBM.SYSTABLESPACESTATS

In this course, we will frequently encounter a program that is a crucial component of an RDBMS.  That program is called an optimizer.  It tries to determine the optimal access path when accessing (e.g., retrieving) data in a database.  An optimizer obtains statistics or metadata (i.e., data about data) from a data repository in the DBMS called a catalog.  The catalog will have information about the columns of tables and indices; the number of rows in a table; the numbers, types, and (possibly) distribution of values for columns in  the tables; and literally hundreds of other pieces of information.

Posted Date: 3/7/2013 4:40:36 AM | Location : United States

Ask an Expert

Related Discussions:- Relational database management, Assignment Help, Ask Question on Relational database management, Get Answer, Expert's Help, Relational database management Discussions

Write discussion on Relational database management
Your posts are moderated

Write your message here..

Related Questions

Normalisation, explain normalisation explain normalisation

What is candidate key, What is candidate key? Candidate Key - A candi... What is candidate key? Candidate Key - A candidate key of an entity set is a minimal superkey, which uniquely identifies each row in the relation.

Describe sequential file organization, Describe sequential file organizatio... Describe sequential file organization.  Explain the rules for (i)  Inserting a new record. (ii)  Deleting an existing record.          Ans:A sequential f

What is a project operation, What is a PROJECT operation? The project o... What is a PROJECT operation? The project operation is a unary operation that returns its argument relation with particular attributes left out. Projection is shown by pie (π).

Ddl compiler-database management system, DDL Compiler The DDL compile... DDL Compiler The DDL compiler changes the data definition statements (such as CREATE TABLE .... in SQL) into a set of tables having metadata tables. These tables have infor

Create a database, Project: Microsoft Access You have been asked by the ... Project: Microsoft Access You have been asked by the ABC Tanning Salon to create a database that can be used to track the salon's customers.  You are to create a table in Access

Define redo logs, Redo Logs: Any database must have minimum two redo logs.... Redo Logs: Any database must have minimum two redo logs. These are the rules for the database; the redo logs record all modifies to the system objects or user objects. If any type

Explain the term- query, Explain the term- Query. Queries are used to re... Explain the term- Query. Queries are used to repossess and show specific records in a table. They can also be used to show specific fields of specific records, which meet the co

Express the queries in relational algebra, Question: This question refe... Question: This question refers to the database schema. a) Express the following queries in SQL: (i) Write the SQL code that will create the table Company. Your answer sh

Related fields in a database are grouped in which form, Related fields in a... Related fields in a database are grouped in which form? Related data fields in a database are grouped to form a data record. (A record is a collection of related fields)