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

I need automated trading engine for crypto currencies, Project Description:... Project Description: Looking to prepare automated trading engine for alternate cyprto currencies starting with Cryptsy, finally integrating into other exchanges. Need to work wi

What are the categories of sql command, What are the categories of SQL comm... What are the categories of SQL command? SQL commands are separated in to the following categories: 1. Data - Definitition Language 2. Data Manipulation language 3. Dat

Explain the five levels of capability maturity models, Question 1 What is ... Question 1 What is data mining? Write Data Mining applications Question 2 What is OLAP? Write the benefits of OLAP Question 3 What is Business Intelligence? Explai

What is a sub-query, (a) What is a Sub-Query? (b) What is the differen... (a) What is a Sub-Query? (b) What is the difference between a scalar sub-query and a tabular sub-query? (c) Write an equivalent SQL statement to get the Name of Product wh

Difference between sql and sql*plus, Difference between SQL and SQL*Plus ... Difference between SQL and SQL*Plus SQL SQL*Plus SQL is a language SQL *Plus is an environment It   is   bas

B2b business uk database, We have a new website where I need someone to 1: ... We have a new website where I need someone to 1: Inhabit the back end with all the recruitment agencies in the UK. I require someone who is not manually going to do this, but who w

What is deadlock, What is deadlock? Neither of the transaction can ever... What is deadlock? Neither of the transaction can ever proceed with its normal implementation. This situation is known as deadlock.

How many types of locks are there, Depending upon the rules we have found, ... Depending upon the rules we have found, we can classify the locks into two types. Shared Lock: A transaction might be acquiring shared lock on a data item in order to read it

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

BI, (a) Why did SAP introduce the extended star schema? (a) Why did SAP introduce the extended star schema?