Shop Catalog

---

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 representation of actual data values
  • Clean String – to “strip out” unwanted characters that you specify with a Regular Expression
  • MD5 HASH – to generate a HASH value for the combination of values found in the specified columns
• SQL Stored Procedures
  • Data Profiling – Table Statistics
  • Data Profiling – Column Statistics
  • Data Profiling – Domain Statistics
  • Data Profiling – Column Statistics Enhancements
  • Data Profiling Suite – all 4 of the above
  • Data Profiling – Data Quality Scoring Add-on
  • Multi-Source Data Discrepancy Reconciliation
  • 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

Subscriber’s Posts – A page where you get to share your Compliments / 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 fingernails” wrangling data
have gathered instructions, diagrams and code
while overhauling misfiring enterprise data engines.

Click the button below.