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.

Soft Sales vs Hard Sale Jonathan Poland

Soft Sales vs Hard Sale

A soft sell is an approach to sales and promotion that emphasizes building a relationship and reputation with customers, rather…

Net Nuetrality Jonathan Poland

Net Nuetrality

Net neutrality is the principle that all internet traffic should be treated equally, without discrimination or preference given to certain…

What are End Goals? Jonathan Poland

What are End Goals?

End-goals, also known as long-term goals or ultimate goals, are the desired outcomes or results that an organization or individual…

Business Experience Jonathan Poland

Business Experience

Business experience refers to any work experience, including paid employment, freelance work, and contributions to family businesses or personal entrepreneurial…

Joint Ventures Jonathan Poland

Joint Ventures

A joint venture is a business venture or partnership between two or more parties. It is a collaborative effort in…

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…

Dismissing Employees Jonathan Poland

Dismissing Employees

Letting go (aka firing) employees is a difficult and sensitive task, and it’s important to handle it with care and…

Capability Analysis Jonathan Poland

Capability Analysis

Capability analysis is the process of evaluating the capabilities of an organization, system, or process in order to identify its…

Data Infrastructure Jonathan Poland

Data Infrastructure

Data infrastructure refers to the hardware, software, and network resources that support the collection, storage, processing, and analysis of data.…

Learn More

Needs Analysis Jonathan Poland

Needs Analysis

Needs analysis is the process of identifying the valuable requirements for a product, service, experience, process, machine, facility, or infrastructure…

Customer is Always Right Jonathan Poland

Customer is Always Right

The principle that “the customer is always right” is a widely used guideline in the business world to guide customer…

Change Resistance Jonathan Poland

Change Resistance

Change resistance is the act of derailing, slowing down, or preventing a change that is underway. This can often cause…

External Risk Jonathan Poland

External Risk

An external risk is a type of risk that is outside of your control and cannot be influenced or managed…

Customer Research Jonathan Poland

Customer Research

Customer research involves gathering information and insights about customers in order to build a deeper understanding of their needs, preferences,…

Customer Relationships Jonathan Poland

Customer Relationships

Customer relationships refer to the interactions between a business and its potential, current, and former customers. These interactions can take…

Implementation Risk Jonathan Poland

Implementation Risk

Implementation risk refers to the potential negative consequences that a business may face as a result of difficulties or failures…

Cost Variance Jonathan Poland

Cost Variance

Cost variance (CV) is a project management metric that measures the difference between the budgeted cost of a project and…

Customer Dissatisfaction Jonathan Poland

Customer Dissatisfaction

Customer dissatisfaction refers to a customer’s negative evaluation of a product or service. It can be measured by asking customers…