Database Design

Designed for scale and performance.

Overview


Databases are the storage mechanism used for most technology that stores data. They used different designs, called schemas, based on the end product such as an application, website or data product. Databases I design always have a heavy focus on both scalability and data quality.

Solutions


Database Design

I design database with the end product in mind and scalability. Most apps and websites utilize normalization, which used more tables that are smaller, utilizes relationships and join data together to prevent redundancy on apps.

Data Quality

Data quality starts with enforcing the correct data type so you don't get text in a field designed for currency. I design databases using the correct data type for the field and add constraints that limit what the user can add to ensure that data is of high quality.

Data Import / Export

It is quite common for a database to need data from other source or vice versa. This can easily be automated and can be moved using flat files (Excel, CSV), data pipelines and APIs.

Data Cleaning

Borrowing a tool for the analytics world data cleaning ensures data consistency, ensures that all data is within acceptable ranges and deals with missing values to ensure the highest quality of data in the database.

Use Cases


Common use cases for databases

Apps

Apps use sophisticated databases to run on the backend. It is typical that and app uses a database with many different tables to capture and store data.

Data Warehouse

A specialized database designed for analytics containing historical archive data. Data warehouses are utilized for reporting, business intelligence and machine learning.

Websites

Most websites have a database on the backend. From a blog to an online store for E-Commerce anything with dynamic content is using a database.