Redgate Blog

Posts by
Redgate Data Modeler

12 July 2016

What Information Does An EU Invoice Need?

Have you written an application that issues invoices? Then you’ve probably struggled with PDF generation, for a start! (Headers don’t need to align, do they?) But there is much more to generating invoices than a pretty PDF. What information has to be on an invoice? How long should you keep… Read more

Redgate Data Modeler

7 July 2016

Redgate Data Modeler

7 July 2016

Facts about Facts: Organizing Fact Tables in Data Warehouse Systems

The process of defining your data warehousing system (DWH) has started. You’ve outlined the relevant dimension tables, which tie to the business requirements. These tables define what we weigh, observe and scale. Now we need to define how we measure. Read more

Redgate Data Modeler

30 June 2016

Redgate Data Modeler

30 June 2016

Flexible and Manageable Bill of Materials (BOM) Designs

The bill of materials design pattern is deceptively simple, yet incredibly powerful. This article will introduce an example, familiar to IT professionals, that you may not have thought fits the BOM pattern. It will also introduce concepts to show you how to make your BOM structures more flexible and much… Read more

Redgate Data Modeler

28 June 2016

Redgate Data Modeler

28 June 2016

Database Modeling Tips

When you were learning database concepts, data modeling looked pretty easy, didn’t it? You knew all the rules, and modeling seemed like a game: get a challenge, do your best, and eventually solve it. Job well done! Moving up to the next level – and so on. Read more

Redgate Data Modeler

16 June 2016

Redgate Data Modeler

16 June 2016

Improve Your Financial Reporting With Data Warehousing

Financial institutions, especially banks, usually have really large datasets. To use that data, it must be stored in such a way that it is easily available for generating reports. The trend now is to use a data warehouse to store all your relevant data, and to use smaller data marts… Read more

Redgate Data Modeler

14 June 2016

Redgate Data Modeler

14 June 2016

MMO Games and Database Design

Let’s be honest: we all love to play games, especially on our computers. Until the Internet became widespread, most of us played computer games by ourselves, usually against AI opponents. It was fun, but as soon as you realized how the gameplay mechanics worked, the game lost most of its… Read more

Redgate Data Modeler

9 June 2016

Redgate Data Modeler

9 June 2016

Identifying the Bill of Materials (BOM) Structure in Databases

The bill of materials (BOM) design pattern is deceptively simple, yet incredibly powerful. Historically, it’s been employed to model product structures, but the pattern can be used to do much more than simply define a hierarchy. This article will introduce three very different examples to help you to recognize the… Read more

Redgate Data Modeler

7 June 2016

Redgate Data Modeler

7 June 2016

A Simple Online Store Model: Sell, Ship, and Get Paid

A lot has changed over the last 30 years, especially in IT-related domains, but few things have changed as much as how we shop. We still mostly buy milk and groceries at physical stores, but widespread online stores have led most of us to try some form of e-shopping.… Read more

Redgate Data Modeler

2 June 2016

Redgate Data Modeler

2 June 2016

Beverly Hills 90210 and ZIP+4: Handling Addresses in Data Models

In my last post, I wrote about ensuring that your data model properly handles global information: numbers, currencies, phone numbers, addresses, dates, and time zones, among other things. However, I’ve realized that many example data models have exactly the “self-centric” or “Amero-centric” approach that I cautioned against. Read more

Redgate Data Modeler

24 May 2016

Redgate Data Modeler

24 May 2016

Merging Multiple User Accounts

Social media surrounds us, so it’s not unusual for applications to require some kind of social media integration. The most common is signing in with Facebook, Twitter, or another service. Users expect to be able to log in with different social accounts. So, applications meet these expectations by offering… Read more

Previous Next

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Redgate Blog

Posts by
Redgate Data Modeler

What Information Does An EU Invoice Need?

Facts about Facts: Organizing Fact Tables in Data Warehouse Systems

Flexible and Manageable Bill of Materials (BOM) Designs

Database Modeling Tips

Improve Your Financial Reporting With Data Warehousing

MMO Games and Database Design

Identifying the Bill of Materials (BOM) Structure in Databases

A Simple Online Store Model: Sell, Ship, and Get Paid

Beverly Hills 90210 and ZIP+4: Handling Addresses in Data Models

Merging Multiple User Accounts

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Posts byRedgate Data Modeler

Cookies on red-gate.com

Posts by
Redgate Data Modeler