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
Customer Expectations Jonathan Poland

Customer Expectations

Customer expectations refer to the base assumptions that customers make about a brand, its products and services, and the overall…

Efficiency Jonathan Poland

Efficiency

Efficiency is a measure of how well resources are used to produce goods and services. It is typically calculated by…

Conformance Quality Jonathan Poland

Conformance Quality

Conformance quality refers to the production of products and delivery of services that meet specified standards or requirements. It is…

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…

Management by Exception Jonathan Poland

Management by Exception

Management by exception is a management technique that involves automating standard processes and empowering teams to handle routine business conditions.…

Algorithmic Pricing Jonathan Poland

Algorithmic Pricing

Algorithmic pricing involves using automation to set prices dynamically based on a variety of factors, such as customer behavior, market…

Decision Framing Jonathan Poland

Decision Framing

Decision framing refers to the way in which a choice or dilemma is presented or structured. This includes the language…

Calculated Risk Jonathan Poland

Calculated Risk

Calculated risk is an essential concept in the field of risk management. It refers to the process of carefully assessing…

Is Greed Good? Jonathan Poland

Is Greed Good?

Greed is good is a paraphrased quote that originates with the 1987 film Wall Street. It is important to note…

Content Database

Competitive Threats Jonathan Poland

Competitive Threats

A competitive threat is a potential source of competition that has not yet materialized, but has the potential to do…

Brand Awareness Jonathan Poland

Brand Awareness

Brand awareness refers to the extent to which consumers are familiar with and able to recognize a brand. It is…

Cross Sellilng Jonathan Poland

Cross Sellilng

Cross-selling is the practice of selling additional products or services to existing customers. In a single transaction, this might involve…

Ecotax Jonathan Poland

Ecotax

An ecotax is a tax levied on activities that have a negative impact on the environment. It is intended to…

Employee Benefits Jonathan Poland

Employee Benefits

Employee benefits are additional forms of compensation offered to employees as part of their overall remuneration package. These benefits can…

Procurement Risk Jonathan Poland

Procurement Risk

Procurement risk is the risk of financial loss or other negative consequences that may arise from the process of procuring…

Infrastructure Risk Jonathan Poland

Infrastructure Risk

Infrastructure risk refers to the potential negative consequences that a business may face as a result of failures in core…

What is a Trade Show? Jonathan Poland

What is a Trade Show?

A trade show is an industry-specific event where businesses in a particular sector showcase their products, services, and innovations to…

What is a thought experiment? Jonathan Poland

What is a thought experiment?

A thought experiment is a mental exercise that involves exploring the implications or consequences of a hypothetical idea, story, or…