Group items tagged

Common characteristics of a metadata registry A metadata registry typically has the following characteristics: Protected environment where only authorized individuals may make changes Stores data elements that include both semantics and representations Semantic areas of a metadata registry contain the meaning of a data element with precise definitions Representational areas of a metadata registry define how the data is represented in a specific format, such as in a database or a structured file format (e.g., XML)

ISO 11179

A metadata registry is a central location in an organization where metadata definitions are stored and maintained in a controlled method.

In metadata, a data steward is a person that is responsible for maintaining a data element in a metadata registry. A data steward may share some responsibilities with a data custodian.

The Data Warehouse Lifecycle Toolkit, by Ralph Kimball et. el., Wiley, 1998, also briefly mentions the role of data steward in the context of data warehouse project management on page 70.

A data dictionary, or metadata repository, as defined in the IBM Dictionary of Computing, is a "centralized repository of information about data such as meaning, relationships to other data, origin, usage, and format."[1]

A Schema crosswalk is a table that shows equivalent elements (or "fields") in more than one database schema. It maps the elements in one schema to the equivalent elements in another schema.

This type of "translating" from one format to another is often called "metadata mapping" or "field mapping," and is related to "data mapping," and "semantic mapping."

racle SQL Developer Data Modeler provides a model driven approach for database design and generation, implemented by integrated set of models – Logical, Data types, Dimensional, Relational, Data Flow diagrams and Physical models for supported Oracle Databases, Microsoft SQL Server 2000 and 2005

Cube Views metadata

Dimensional Models   Dedicated full featured Dimensional model – star and snowflake schema easily can be built and expressed on detailed and compact diagrams   Dimensions – support for merging (level can belongs to more than one dimension), shared, fact and role playing dimensions   Hierarchies – value based hierarchies (parent-child), and regular and ragged level based hierarchies   Measures – fully, semi and none additive; different aggregation functions on different dimensions ; fact dimension; calculated measures   Query wizard allows Select statements to be generated from the dimensional model   Support for Oracle OLAP. This includes specifics like cube partitioning, sparse dimensions, and compressed measures   Built-in wizards help to define all required object types and view definitions that enable SQL access to dimensional data in Oracle AW (using the OLAP_TABLE interface)   Bidirectional integration with Oracle physical model - Dimensional model can be created using SQL dimension definitions in physical model or the definitions can be created from the dimensional model

Sentry is a highly modular system for providing fine grained role based authorization to both data and metadata stored on an Apache Hadoop cluster.

We can collect the data when we run tests through Hudson, but that doesn’t make the output much more readable, doesn’t capture metadata (such as which environment configuration the tests ran against) and doesn’t even give useful historic snapshot data, as the jobs run different suites of tests based on parameters.

SchemaSpy is a Java-based tool (requires Java 5 or higher) that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams.

QLDoc Sharp is an interactive tool designed to generate the SQL Server 2005/2008 documentation. It allows you to export documentation to CHM format (Microsoft Compiled HTML Help).It is also easy and interactive, which allows multiple database documentation. For more details, please refer to http://www.amitchaudhary.com/. Background Finding the answer to, "Is there any free tool for generating documentation from SQL 2005/2008". Using the Code After running the application, the initial UI looks like below: Three steps required to generate the documentation. Step # 1 In the top section, provide the details about the SQL Server. It includes: Source: Instance Name of the SQL Server 2005/2008  If want to connect with SQL authentication then: User Name: Name of the user whose credentials you want to use Password: Password of the user whose credentials you want to use In case, to connect with Windows authentication then, only check the checkbox   (Integrated Security) and your current Windows credentials would be used to connect with the specified SQL Server Instance. Step # 2 Choose the database name from the Database dropdown list, whose documentation you want to generate and then click on the Fetch button. Meanwhile you can choose/change the File Name of the CHM file which would be generated. And also if required, you then choose to export the metadata/documentation in the XML format too. Step # 3 Click on the Generate button. And locate the CHM file at the path specified. After making the selection the SQLDoc Sharp, the UI should look like: Screen Shots of the Documentation Generated Index

SQLDoc Sharp is an interactive tool designed to generate the SQL Server 2005/2008 documentation.