Relational database metadata is known in database terminology as the catalog. Good examples of this are tables of all tables in database including names, sizes and number or rows in each table. It can also be tables of columns in each database including the type of data in each column and what tables they are used in.
Various uses and benefits
There are many relational database metadata systems that are being offered on the Internet. There are relational database metadata systems that are designed for the following:
1. It can be used to manage a large amount of various technical and business metadata that provides different end-to-end views depending on the user.
2. It can be used to update and manage information especially for future planning. It can be utilized for the formulation of different scenarios and time scales, which eventually can aid in future decisions.
3.It can be used to create visualizations from any point may it be origin, immediate point of final report. This reports can be also be customized in whatever is suitable for the user.
Using relational database metadata means that data storage and redundancy are minimized. There is also independence in terms of data storage and logical database structure, data is easily accessible and there is flexibility in database design.
Relational database metadata can be used in accordance to what data is needed for the moment and who would be the user. It can also be used for making future decisions or in planning.