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.

Upselling Jonathan Poland

Upselling

Upselling is a sales technique that involves encouraging customers to purchase higher-priced, add-ons, or upgraded versions of products or services…

Sales and Operations Planning Jonathan Poland

Sales and Operations Planning

Sales and operations planning (S&OP) is a process used by companies to effectively align their sales plans with their operational…

Durable Competitive Advantage Jonathan Poland

Durable Competitive Advantage

The most important aspect of durability is market fit. Unique super simple products or services that does change much if…

Project Goals Jonathan Poland

Project Goals

Project goals refer to the desired business outcomes that a project aims to achieve. These goals are typically outlined in…

Price Optimization Jonathan Poland

Price Optimization

Price optimization is the process of using data and analytical methods to determine the optimal price for a product or…

Camping Strategy Jonathan Poland

Camping Strategy

Camping strategy is the practice of a using a geographical location as a competitive advantage. It has several common applications:…

Product Category Jonathan Poland

Product Category

A product category is a classification of similar or related products or services. These categories are often created by a…

Payback Theory Jonathan Poland

Payback Theory

Let’s say you live in a town with two bakeries for sale at $1 million each. Both offer similar products…

Employee Retention Jonathan Poland

Employee Retention

Employee retention refers to the success of a company in keeping its talented employees from leaving. High employee turnover can…

Learn More

Foot in the Door Jonathan Poland

Foot in the Door

The foot-in-the-door technique is a persuasion strategy that involves asking for a small favor or agreement first, before making a…

Business Constraints Jonathan Poland

Business Constraints

Business constraints are limitations or factors that can impact an organization’s ability to achieve its goals and objectives. These constraints…

Waste is Food Jonathan Poland

Waste is Food

The concept of “waste is food” is based on the idea that an industrial economy should not produce any waste except for biological nutrients that can be safely returned to the environment.

Diversified Real Estate Jonathan Poland

Diversified Real Estate

Real Estate Investment Trusts that acquire, develop, manage, and dispose of diversified property holdings that have no specific portfolio composition.…

Channel Structure Jonathan Poland

Channel Structure

Market penetration is the percentage of a target market that purchased a company’s product or service over a period of time.

Product Rationalization Jonathan Poland

Product Rationalization

Product rationalization is the process of reviewing and optimizing a company’s product portfolio in order to streamline operations and reduce…

Loss Leader Jonathan Poland

Loss Leader

A loss leader is a product or service that is sold at a price below its cost in order to…

Business Equipment Jonathan Poland

Business Equipment

Business equipment refers to the tools, machines, and other physical assets that a company uses to conduct its operations. This…

Top-down vs Bottom-up Jonathan Poland

Top-down vs Bottom-up

Top-down and bottom-up are opposing approaches to thinking, analysis, design, decision-making, strategy, management, and communication. The top-down approach begins with…