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
BATNA Jonathan Poland

BATNA

BATNA, or best alternative to a negotiated agreement, is the course of action that a party in a negotiation would…

Organizational Structure Jonathan Poland

Organizational Structure

Organizational structure refers to the formal systems that define how an organization is governed, directed, operated, and controlled. It is…

Workplace Issues Jonathan Poland

Workplace Issues

Workplace issues can negatively impact employee satisfaction and organizational performance. These issues often arise from cultural and systemic problems, and…

Conflicts of Interest Jonathan Poland

Conflicts of Interest

A conflict of interest exists when an individual or organization has incentives that contradict their responsibilities. This can occur when…

Price Promotion Strategy Jonathan Poland

Price Promotion Strategy

A price promotion is a marketing strategy that involves temporarily lowering the price of a product or service in order…

Innovation Principles Jonathan Poland

Innovation Principles

Innovation principles are guidelines that an organization adopts as a basis for innovation activities. They are typically considered foundational policy…

What is the Broken Window Fallacy? Jonathan Poland

What is the Broken Window Fallacy?

The broken window fallacy refers to the idea that the economic benefits of destructive events, such as wars and natural…

Over-positioning Jonathan Poland

Over-positioning

Over-positioning refers to the practice of positioning a brand in a way that is too narrow or limited, potentially limiting…

Sustainable Design Jonathan Poland

Sustainable Design

Designing for sustainability involves creating products, services, and processes that minimize environmental impact and enhance quality of life for the…

Content Database

Search over 1,000 posts on topics across
business, finance, and capital markets.

Abstraction Jonathan Poland

Abstraction

Abstraction is a problem-solving technique that involves looking at a problem in general, rather than specific, terms. It involves using…

Collective Intelligence Jonathan Poland

Collective Intelligence

Collective intelligence refers to the ability of a group to solve problems, make decisions, and generate new ideas more effectively…

Switching Barriers Jonathan Poland

Switching Barriers

Switching barriers are factors that make it difficult or inconvenient for customers to switch from one product or service to…

Local Marketing Jonathan Poland

Local Marketing

Local marketing refers to any marketing strategy that targets customers in a specific, finely-grained location, such as a city or…

Cost of Capital Jonathan Poland

Cost of Capital

The cost of capital is the required rate of return that a company must earn on its investments in order…

Team Manager Jonathan Poland

Team Manager

A team manager is responsible for directing and controlling an organizational unit. This leadership role involves authority and accountability for…

Management Challenges Jonathan Poland

Management Challenges

Management challenges are obstacles, difficulties, or inefficiencies that make it difficult for managers to achieve their goals and objectives. These…

Personal Selling Jonathan Poland

Personal Selling

Personal selling is a type of sales approach that involves face-to-face interaction with potential customers. Unlike other forms of sales,…

Growth Strategy Jonathan Poland

Growth Strategy

A growth strategy is a plan to increase or improve some KPI, like revenue, profit, subscribers, etc.