November 23rd, 2014
In Technology
No Comments
If you enjoy this article, see the other most popular articles
If you enjoy this article, see the other most popular articles
If you enjoy this article, see the other most popular articles
You don’t need to normalize a reporting database, because it’s read-only
(written by lawrence krubner, however indented passages are often quotes). You can contact lawrence at: lawrence@krubner.com, or follow me on Twitter.
I am about to create a reporting database, so this is a healthy reminder to myself:
A reporting database has a number of advantages:
The structure of the reporting database can be specifically designed to make it easier to write reports.
You don’t need to normalize a reporting database, because it’s read-only. Feel free to duplicate data as much as needed to make queries and reporting easier.
The development team can refactor the operational database without needing to change the reporting database.
Queries run against the reporting database don’t add to the load on the operational database.
You can store derived data in the database, making it easier to write reports that use the derived data without having to introduce a separate set of derivation logic.
You may have multiple reporting databases for different reporting needs.
Post external references
- 1
http://martinfowler.com/bliki/ReportingDatabase.html
February 8, 2022 9:33 am
From Michael S on How I recovered from Lyme Disease: I fasted for two weeks, no food, just water
"Did you have Bartonella, too? Seems it uses autogenesis..."