Here’s what you will have access to as a Subscriber:
The Mechanics Blog – Words of wisdom from the original “Information Sherpa” himself with an occasional gem from his sidekick, the “Metadata Mechanic”.
Shop Manuals – Texts and Diagrams sharing wisdom derived from experienced , “busted knuckle , data wrench wrangling” authors.
- Abstracts
- “How To” Guides
- White Papers
- Books
Blueprints – Standards, precision diagrams and code to help you build your data repository “chassis” to make sure your structure can perform at speed.
- Modeling Standards – To help you make those data storage “racks” reliable, scalable, and high performing.
- Naming Standards in general
- Class Words and Data Types
- Abbreviations
- Data Models – Precision blueprints for your data repository “chassis” to ensuring your structure can perform at speed
- Logical Models – readable Entity & Attribute names
- Physical Models – standardized / abbreviated Table & Column names
- Data Dictionaries – Entity / Table and Attribute / Column descriptive definitions
- DDL Scripts – SQL Server Data Definition Language code to create the database objects shown in the Data Models section supporting:
- a Metadata Repository
- Data Lineage Tracking with ETL Logic for
- Transformation Rules
- Validation Rules
- Disposition Rules
- Data Profiling
- Data Quality Scoring
- Multi-Source Discrepancy Tracking
- Reference Data
- Load Scripts for Reference Data for
- Geography
- Healthcare Code Sets
The Tool Box – Discount priced, downloadable technical data “wrenches” as ready to execute code.
- Excel Templates
- Data Requirements Gathering – with non-compliance identification against your naming standards
- Data Quality Scoring – with configurable rules to calculate file summary and individual field scores, highlighting problem values
- SQL Functions
- Data Pattern – to generate a generic alpha-numeric pattern representation of actual data values
- Clean String – to “strip out” unwanted characters – you specify “What-to-Keep” with a Regular Expression
- MD5 HASH – to generate a HASH value for the contents of the columns you choose – BINARY , VARBINARY and IMAGE data type columns are not supported
- SQL Stored Procedures
- Data Profiling Utility – gathers a comprehensive set of metadata statistics on the data values stored in the specified Tables and Columns
- Data Profiling Add-on for Data Quality Scoring – by specifying which user defined “rule” to apply to a database Column, a Quality Score is calculated and stored for each value
- Multi-Source Data Discrepancy Reconciliation – when the same data elements are presented from multiple sources, this utility will identify, log and track Discrepancies for analysis and reporting
- AI Custom Language Model – Metadata Narrative Generation from your Data Profiling statistics, prepping high-octane fuel from your raw “crude oil” data so your AI models perform reliably “on the track”.
- Parameter Controlled Scripts
- T-SQL
- Data Profiling – calls the Stored Procs with parameter values to gather and store the profiling statistics
- Data Quality Scoring – calls the Stored Procs with parameter values to calculate the DQ Scores
- Discrepancy Tracking – calls the Stored Procs with parameter values to log new or update existing discrepancies in values from any two sources
- Metadata Narrative Generation – creates a textual narrative from your Data Profiling statistics
- PowerShell
- Metadata Narrative Splitter – breaks your Metadata textual narrative (a.k.a. “Chilton Manual” into Chapters that your AI engine can consume
- Metadata Narrative Splitter – breaks your Metadata textual narrative (a.k.a. “Chilton Manual” into Chapters that your AI engine can consume
- T-SQL
Subscriber’s Posts – A page where you get to share your *** constructive *** Suggestions / Questions / Complaints
— REMEMBER —
“In a world where you can be anything, choose to be kind”
How to Subscribe
Put on your coveralls and
step inside the Metadata Garage
where two veterans with eighty plus years of
“grease under their data wrangling fingernails”
have gathered instructions, diagrams and code
while overhauling misfiring enterprise data engines.
Click the button below.