Data Architecture

Data Architecture

Data Architecture Jonathan Poland

Data architecture refers to the principles, structures, standards, controls, models, transformations, interfaces, and technologies that define how data is stored, secured, curated, managed, and used in an organization or system. This includes the systems and processes that allow an organization to efficiently and securely acquire, use, and manage data. Data architecture helps ensure that an organization can access the data it needs, when it needs it, in a way that is secure and compliant with any relevant regulations or standards.

Principles

Data architecture principles are foundational rules that guide the structure, use and management of data. For example, the principle that “data is a shared asset” can be useful for encouraging solution architects to use data repositories that already exist as opposed to replicating things.

Standards

Data architecture standards are structures, practices and technologies that an organization adopts to avoid reinventing things for every system, application or analysis. For example, an organization might adopt a standard way to publish and subscribe to data.

Structure

Data architecture is the structural design of information technologies for acquiring, storing, using, securing and managing data. A data architecture diagram captures the layers, interfaces, technologies and flows of data. These are typically produced at the organizational, system, application and solution level.

Models

A data model defines the structure of data itself. This includes data entities and relationships between entities.

Data Dictionary

A data dictionary is a reference that provides a user friendly overview of data entities, fields, formats, validations and business context. This can be used both by software developers and users. For example, a user who wants to build a report might reference a data dictionary to see what data is available.

Patterns

Patterns describe standard ways to acquire, store, transform, share, use, secure and manage data. For example, data architecture may include a sequence diagram that illustrates how to build a report from an organization’s data warehouse.

Controls

Data controls are roles, responsibilities, processes, procedures and systems for managing data. For example, a data architecture might define how data is encrypted in storage and the processes for managing encryption keys.

Integration

Data architecture may include structures and specifications for publishing, consuming, transferring and transforming data.

Master Data

Data architecture may define a single source of truth for data entities and methods for using and managing master data.

Technologies

The process of defining a data architecture often involves evaluation and selection of information technologies for data storage, analysis, integration, management, security and curation. For example, a data architect may perform a product evaluation as part of the procurement of a extract, transform and load tool. A data architecture document typically provides an overview of selected technologies including their capabilities, limitations and risks.

Deployment

A data architecture typically includes a diagram that captures how the architecture is physically deployed to infrastructure. This is similar to the logical data architecture diagram with details of machines, platforms, environments and technologies.

Learn More…

Fixed Assets Jonathan Poland

Fixed Assets

Fixed assets are long-term physical resources that are used in a business…

Risk 101 Jonathan Poland

Risk 101

Competitive advantages can spring from intellectual property, brand recognition, or even a…

Trade Secret Jonathan Poland

Trade Secret

A trade secret is a type of carefully guarded information that gives…

Data Architecture Jonathan Poland

Data Architecture

Data architecture refers to the principles, structures, standards, controls, models, transformations, interfaces,…

Business Efficiency Jonathan Poland

Business Efficiency

Business efficiency refers to the effectiveness with which a company or organization…

Rule of Three Jonathan Poland

Rule of Three

The rule of three is an economic theory that posits that large,…

Opportunity Cost Jonathan Poland

Opportunity Cost

Opportunity cost is the value of the next best alternative that is…

Restructuring Jonathan Poland

Restructuring

Restructuring is the process of reorganizing or reshaping an organization in order…

Dismissing Employees Jonathan Poland

Dismissing Employees

Letting go (aka firing) employees is a difficult and sensitive task, and…

Jonathan Poland © 2023

Search the Database

Over 1,000 posts on topics ranging from strategy to operations, innovation to finance, technology to risk and much more…

Price Sensitivity Jonathan Poland

Price Sensitivity

Price sensitivity is a measure of how much the demand for a…

Aftermarket Jonathan Poland

Aftermarket

The aftermarket refers to the market for products and services that are…

Pricing Techniques Jonathan Poland

Pricing Techniques

Pricing involves carefully considering various factors in order to determine a price…

Quality Objectives Jonathan Poland

Quality Objectives

Quality objectives are specific, measurable targets that organizations set in order to…

Examples of Tact Jonathan Poland

Examples of Tact

Tact is the ability to sensitively and skillfully handle a situation or…

Test Marketing Jonathan Poland

Test Marketing

Test marketing involves testing different marketing strategies or variations on customers in…

Business Process Reengineering Jonathan Poland

Business Process Reengineering

Business process reengineering, or BPR, involves examining and redesigning current business processes…

Risk Tolerance Jonathan Poland

Risk Tolerance

A risk is the possibility of an adverse event occurring, while a…

Market Value Jonathan Poland

Market Value

The value of an asset or good in a competitive market, where…