Today I completed the modeling for release 1.1. Now the list of object types is complete, Teradata import errors have been corrected and I am moving on to SQL Server importing.
I also made some decisions:
- The query feature will be based on QBE(Query-By-Example) to simplify the code, as I am the only programmer onboard and my graphical skills are not that good.
- The more sophisticated metadata validation processes will be left for V2. For now the core processes covered will be:
a) Metadata Capture(Teradata and SQL Server) ;
b) Metadata Edit with direct updates to the database (new feature) to keep sync with the sources;
c) Metadata Navigation (under coding and testing) with manual edit/insert for all objects; btw. any table or column created manually will be assigned as a conceptual object, unless updated in the database; the navigation tool will also allow table and column updates on both DBMSs.
d) Metadata reports - Object Index, Detailed information by object type and validation report;
e) Live query with QBE;
As far as the list of object types it will cover:
Reference Metadata:
- Data Domains - generic data types;
- Business Dimension Types - for custom metadata classification;
- Data Entities - additional classification for future conceptual data taxonomy;
Core Metadata:
- Data Source - One or more databases per source;
- Databases
- Schemas - Database schemas;
- Tables - all table types in a given database;
- Columns
- KPI - column extensions
- Applications - Any application using data - reports, charts, dashboards, etc.
- Project - Combination of the object types above included as a reference in the metadata object, plus project information;
The end of November will see the first full release for community tests. If interested to become a tester, please send a note at macr2011@gmail.com.
Comments
Post a Comment