Categories: BI

Technical Metadata

Technical Metadata:

Technical metadata describes information about technology such as the ownership of the database, physical characteristics of a database (in oracle, table space, extents, segments, blocks, partitions etc), performance tuning (processors, indexing), table name, column name, data type, relationship between the tables,  constraints, abbreviations, derivation rules, glossary, data dictionary, etc., and is used by the technical team. In Technical metadata, derivation rules are important when formula or calculations are applied on a column.

Technical Metadata Example:

 

learndmdwbi

View Comments

  • Hi

    Can you share about metadata managment, what does a database developer work on metadata in real time
    where he will get the data, how a work load is assigned, how metadata management is related to agile or scrum.
    as a database develoeper how metadata is managed daily ??

Share
Published by
learndmdwbi

Recent Posts

Oracle’s Database Dictionary Views

These SQL commands are related with Oracle's data dictionary and can be used to get…

8 months ago

Oracle important DDL Statements

important DDL Statements from Oracle like Commit, Rollback, Grant, Revoke etc..

8 months ago

Oracle Database Data Definition Language(DDL Statements)- DROP Object Commands

In this section, we will try to explain about important database DROP commands that are…

8 months ago

Oracle Database Data Manipulation Language (DML) Commands

In this section, we will try to explain about important database DML commands that are…

8 months ago

Oracle Database Data Definition Language(DDL Statements) – ALTER Commands:

In this section, we will try to explain about important database ALTER commands that are…

8 months ago

Oracle DDL Statements – CREATE Commands

An Oracle database consists of DDL commands, which are useful to create, modify and drop…

8 months ago