Logical Data Modeling - Data dictionary

Data System Architecture


A data dictionary is a metadata repository which gives the ability to share them.

This is in its simple form, a file but you will find it more in a database form.

The key concept is that this is data that can bue queried to retrieve data information about metadata.

Discover More
Probabilistic Script Pclean
Data Quality - Data (cleaning|scrubbing|wrangling)

Data cleansing or data scrubbing is the act of: detecting (ie data validation) and correcting (or removing) corrupt or inaccurate records from a record set, table, or database. Used mainly in...
Data System Architecture
Logical Data Modeling

A data model in software engineering is a graph of entity that try to represent the reality and describes how data are represented and accessed. the real world consists of entities and relationships....
Data System Architecture
Logical Data Modeling - (Metadata|Descriptor)

Metadata are data data. They are data that describes other data. Metadata is also known as: Descriptor. Ancillary data Metadata is information stored in the data dictionary components of the...
Card Puncher Data Processing
Oracle Database - Data Dictionary

A data dictionary is a repository of metadata. The data dictionary of Oracle is stored in the SYS schema. Each Oracle database has a data dictionary, which is a set of tables and views that serve as...
Data System Architecture
SQL - Data Definition / Data Dictionary Language (DDL)

Data definition language (DDL) is a category of statement that manipulate the data dictionary of a database. The three principal commands are: CREATE, ALTER, and DROP but you can also find:...
Oracle Database Sql Processing
SQL Engine - Optimizer Statistics

In order to make the best execution plan, the optimizer uses statistics on the database objects and the computer system. data dictionary Optimizer statistics are always treated as estimates and can become...

Share this page:
Follow us:
Task Runner