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.

The Fundamentals of Business Mastery Jonathan Poland

The Fundamentals of Business Mastery

Overview Business comes down to just two areas: investments and deliverables. Leaders make investments in people, products that are delivered…

Information Security Jonathan Poland

Information Security

Information security is the practice of protecting information from unauthorized access, use, disclosure, disruption, modification, or destruction. It is a…

Customary Pricing Jonathan Poland

Customary Pricing

Customary pricing refers to the pricing practices that are considered typical or normal in a particular industry or market. This…

Continuous Process Jonathan Poland

Continuous Process

A continuous process is a series of steps that are designed to be executed concurrently, meaning that all the steps…

Market Saturation Jonathan Poland

Market Saturation

Market saturation refers to a state in which a particular market is filled with a high number of similar products…

Segregation of Duties Jonathan Poland

Segregation of Duties

Segregation of duties is a principle in internal control that aims to reduce the risk of fraud or errors by…

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…

Rationalism vs Empiricism Jonathan Poland

Rationalism vs Empiricism

Rationalism and empiricism are two philosophical approaches to understanding the world and acquiring knowledge. While they share some similarities, they…

Selling Points Jonathan Poland

Selling Points

Selling points are the key features or benefits of a product that make it attractive to potential customers. These selling…

Learn More

Overthinking Jonathan Poland

Overthinking

Overthinking, also known as rumination, is a thought process that involves excessive and prolonged contemplation of a problem or situation.…

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…

First Principles Thinking Jonathan Poland

First Principles Thinking

Overview First principles thinking is a method of reasoning that involves breaking down complex problems into their most basic and…

Yield Management Jonathan Poland

Yield Management

Yield management is a pricing strategy used by businesses that offer access to fixed-capacity assets, such as airline seats and…

Job Orientation Jonathan Poland

Job Orientation

Job orientation, also known as onboarding, is the process of introducing new employees to the company and their role. It…

Strategic Direction Jonathan Poland

Strategic Direction

Strategic direction refers to the long-term vision and direction of an organization, and it serves as a guiding principle for…

Value Added Reseller Jonathan Poland

Value Added Reseller

A value added reseller (VAR) is a company that buys products from manufacturers or distributors and then resells them to…

Sales Objections Jonathan Poland

Sales Objections

A sales objection is a concern or hesitation that a customer has about making a purchase. Identifying and addressing these…

What is an Agent? Jonathan Poland

What is an Agent?

An agent is a person or organization that has been granted the authority to act on behalf of another person…