I have got a normalized transactional database. I am setting up a data warehouse for reporting purposes. Are there any tools which will automatically make de-normalization suggestions? Or something to automate database changes in that manner?
我有一个规范化的事务数据库。我正在建立一个数据仓库用于报告目的。是否有任何工具可以自动进行去标准化建议?或者以这种方式自动化数据库更改的东西?
1 个解决方案
#1
Not that I know of. However, Kimball's design method is relatively straightforward, so it should be able to be suported with some kind of semi-automation if you identify the facts and have foreign key relationships defined in your database.
从来没听说过。但是,Kimball的设计方法相对简单,因此如果您确定事实并在数据库中定义了外键关系,它应该能够被某种半自动化支持。
I built a tool which flattens out Kimball stars based on the FK metadata in the database to build views which can be used in the application, so I image something similar could work on a normalized DB - it just wouldn't be as simple as starting from the fact table and starring out based on the FK relationships.
我构建了一个工具,它根据数据库中的FK元数据来展平Kimball星,以构建可以在应用程序中使用的视图,因此我想象一些类似的东西可以在规范化的数据库上工作 - 它就像开始一样简单来自事实表并根据FK关系主演。
#1
Not that I know of. However, Kimball's design method is relatively straightforward, so it should be able to be suported with some kind of semi-automation if you identify the facts and have foreign key relationships defined in your database.
从来没听说过。但是,Kimball的设计方法相对简单,因此如果您确定事实并在数据库中定义了外键关系,它应该能够被某种半自动化支持。
I built a tool which flattens out Kimball stars based on the FK metadata in the database to build views which can be used in the application, so I image something similar could work on a normalized DB - it just wouldn't be as simple as starting from the fact table and starring out based on the FK relationships.
我构建了一个工具,它根据数据库中的FK元数据来展平Kimball星,以构建可以在应用程序中使用的视图,因此我想象一些类似的东西可以在规范化的数据库上工作 - 它就像开始一样简单来自事实表并根据FK关系主演。