Free Articles, Free Web Content, Reprint Articles
Saturday, November 18, 2017
 
Free Articles, Free Web Content, Reprint ArticlesRegisterAll CategoriesTop AuthorsSubmit Article (Article Submission)ContactSubscribe Free Articles, Free Web Content, Reprint Articles
 

Role of Data Dictionary in SAP Training Courses

As we all know that SAP has introduced a complete ERP system in the business world and business oriented software can’t run with database. Data dictionary explains the logical structure of database. It is also repository that is store of information. It accommodates record types, data item types and data aggregation etc.It assists in excellent way in communication as it is designed to store the exact meaning of data. Data items that are stored in the data dictionary are defined exactly.

As we all know that SAP has introduced a complete ERP system in the business world and business oriented software can’t run with database. So there is core role of database in SAP software. In database data dictionary plays vital role. Here in this article we will share the knowledge of data dictionary and what are its uses.

Data dictionary explains the logical structure of database. It is also repository that is store of information. It accommodates record typesFree Articles, data item types and data aggregation etc. In some cases data dictionary stores the schema and is use to create and process the database. Metadata is also stored in the data dictionary.

Uses of Data Dictionary

Different uses of data dictionary are given below

Information about Data

The information is collected and finally stored at central location. Data as resource is managed by the data dictionary that is very helpful for the management.

Communication with the User

It assists in excellent way in communication as it is designed to store the exact meaning of data. Data items that are stored in the data dictionary are defined exactly. This stored information is used in case of problem and for cure of problem.

Record of Change in Database Structure

It maintains the track of all those changes in structure that is happened with time. These changes can be creation of new data items or changing of data item description.

Finds the Effects of Change

Data dictionary keeps the record of each item that is stored in the database. Also record of relationships is kept in it. DBA is the person in the database environment that can monitor the effect of this change.

Keep track of Access Control Information

A detail of all authorized users are stored in the data dictionary. All types of access are also stored in the data dictionary.

Audit Information

Record of each access of database is maintained in the data dictionary. This information is later on for audit purpose.

Types of Data Dictionary

There are two types of data dictionary that are given below

Integrated Data Dictionary

This type of data dictionary is part of DBMS and is further classified into Active Data Dictionary and Passive Data Dictionary. In active data dictionary the record of each access is maintained by the DBMS whereas in passive data dictionary day to day processing is not maintained by the data dictionary

Freestanding Data Dictionary

A type of data dictionary that is not part of the DBMS is called freestanding data dictionary.

 

Source: Free Articles from ArticlesFactory.com

ABOUT THE AUTHOR


According my professional experience data dictionary SAP Security software and SAP bw software so we should go for SAP Security Training and SAP bw training at Tekvdo



Health
Business
Finance
Travel
Technology
Home Repair
Computers
Marketing
Autos
Family
Entertainment
Education
Law
Communication
Other
Sports
ECommerce
Home Business
Self Help
Internet
Partners


Page loaded in 0.048 seconds