Data Organization Programming Worksheet

InstructionsCreate three sources of origination of where the data will originate from.
Example;
1. Hard copy file: CSV
2. Database Environment (another database resource)
3. API
You will need to create CSV files with real data, this should represent all of
the tables that you’ve created in Module 4.
Create 3 different Data Marts
1. Data Mart 1 will represent business intelligence reporting
2. Data Mart 2 will represent Data Science (Analytics)
3. Data Mart 3 will represent Big Data (Hadoop)
Data Warehouse: Identify the database organization that you want to use
for your data warehouse. Research what different data warehouses are
available, and why you are going to use the one that you chose.
Create a diagram of the blue print of the data architecture, and include in
your document the information around the data warehouse.
Database Management &
Applications
Author: Jeff Seaman
Data architecture
6/21/2022
Development Process| Point Park University
3
What is a data
architecture?
Describes the structure of an organization’s logical and
physical data assets and data management resources.
6/21/2022
Databases| Point Park University
4
What is a data
architect?
Technical experts who adapt dataflow management and
data storage strategy to a wide range of businesses and
solutions. In charge of continually improving the way
data is collected and stored.
6/21/2022
Databases| Point Park University
5
Responsibilities
In addition, responsibilities include design patterns, data
modeling, service-oriented integration, and business
intelligence domains.
6/21/2022
Databases| Point Park University
6
Responsibilities
Always looking for ways to seek out innovations to
provide improved data quality and reporting, and
eliminate redundancies, provide better data collection
sources, methods and tools
6/21/2022
Databases| Point Park University
7
Data Architecture Example
6/21/2022
Databases| Point Park University
8
Data Architecture Example
6/21/2022
Databases| Point Park University
9
Data Architecture Example
6/21/2022
Databases| Point Park University
10
Data Architecture Roles
6/21/2022
Databases| Point Park University
11
Data Architecture Process
SDLC – (System Development Life Cycle)
Process for planning, creating, testing, and deploying an information system
oPlanning
oCreating
oTesting
oDeploying
6/21/2022
Databases| Point Park University
12
Thank You!
6/21/2022
Database Management| Point Park University
13
QUESTIONS
6/21/2022
Database Management| Point Park University
14