The foundational pillars

Data Management Concepts

Sharon Omwega

Data Scientist

Architecting excellence in system design

  • Data architecture includes models, policies, rules and standards for data assets
  • Frameworks guide development and implementation e.g. TOGAF
  • Scalability
  • Adaptability
  • Flexibility
  • Adherence to policies
  • Effective metadata management
  • Robust security

Architectural plans on a table with a compass, protractor, reading glasses, a pen and a ruler on top of them.

1 Images in this lesson were created using Freepik
Data Management Concepts

Unified information flow

Multiple laptops arranged, with cloud logos above them and a database image with dotted lines showing connectedness.

  • Data integration unifies diverse data sources
  • This reduces redundancy, complexity and destroys silos
  • Activities include ETL processes, data replication, real-time integration
Data Management Concepts

Real-time data integration

People sitting or standing next to a magnified laptop, clock and mobile phone looking at their digital devices.

  • Real-time integration uses streaming data sources, middleware solutions, and specialized integration tools
  • Important to track data quality, latency, volume and system uptime
  • Data retrieval time should be minimal
Data Management Concepts

Modeling with precision

A blue screen with a blue background and a blue diagram representing a sample data model.

  • Involves definition of data requirements and creation of data models
  • Data model types: conceptual, logical, physical
  • Models usually have entities and attributes
  • Data modeling is iterative evolving with requirements
Data Management Concepts

Elevating data storage

  • Database and storage management includes organization, optimization and safeguarding of data repositories
  • Involves implementing DBMS
  • Activities include effective indexing, data compression, and archiving strategies

  A man lounging with a laptop and databases in his background with a cloud image hovering over them, representing data storage.

Data Management Concepts

Let's practice!

Data Management Concepts

Preparing Video For Download...