What’s Included:
Full Database Assessment
- Data Structure
- Data Quality & Health
- Data Ingestion
Solution Implementation
- Schema Organization
- Object Prefixing
- Data Cleaning
Schema Organization
The goal of schema organization is to utilize schemas to describe where the data is coming from. The following is an example of Schema Organization:
[FRED].[ConsumerPriceIndex]
[Salesforce].[Actions]
Object Prefixing
The goal of object prefixing is to easily identify database objects. The following illustrates the concept:
[sp_Employees] # Stored Procedures
[Employees] # Tables
[v_Employees] # Views