Need help with activewarehouse?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

activewarehouse
198 Stars 40 Forks MIT License 205 Commits 2 Opened issues

Description

ActiveWarehouse for Rails - Implement data warehouses with Rails

Services available

!
?

Need anything else?

Contributors list

# 156,576
Ruby
Clojure
reagent
Elixir
60 commits
# 100,725
Ruby
Erlang
Shell
remote-...
51 commits
# 232,738
Ruby
Shell
Rails
aws-sqs
33 commits
# 61,189
sidekiq
imagema...
rubydat...
XML
12 commits
# 169,130
Ruby
Shell
Rails
JavaScr...
10 commits
# 393,948
JavaScr...
HTML
Shell
3 commits
# 432,540
Ruby
HTML
Shell
2 commits
# 712,796
Ruby
1 commit

ActiveWarehouse

The ActiveWarehouse library provides classes and functions which help with building Data Warehouses using Rails.

Installation

To install ActiveWarehouse, add the gem to your Gemfile:

gem 'activewarehouse'

Generators

ActiveWarehouse comes with several generators. In the examples below, you can use either example and the results will be the same.

Facts

Creates a SalesFact class and a sales_facts table.

script/generate fact Sales
script/generate fact sales

Dimensions

Creates a RegionDimension class and a region_dimension table.

script/generate dimension Region
script/generate dimension region

Cubes

Creates a RegionalSalesCube class.

script/generate cube RegionalSales
script/generate cube regional_sales

Bridge

Creates a CustomerHierarchyBridge class.

script/generate bridge CustomerHierarchy
script/generate bridge customer_hierarchy

Dimension View

Creates an OrderDateDimension class which is represented by a view on top of the DateDimension.

script/generate dimension_view OrderDate Date
script/generate dimension_view order_date date

Model Naming

The rules for naming are as follows:

Facts:

  • Fact classes and tables follow the typical Rails rules: classes are singular and tables are pluralized.
  • Both the class and table name are suffixed by "_fact".

Dimensions:

  • Dimension classes and tables are both singular.
  • Both the class name and the table name are suffixed by "_dimension".

Cube:

  • Cube class is singular. If a cube table is created it will also be singular.

Bridge:

  • Bridge classes and tables are both singular.
  • Both the class name and the table name are suffixed by "_bridge".

Dimension View:

  • Dimension View classes are singular. The underlying data structure is a view
  • on top of an existing dimension.
  • Both the class name and the view name are suffixed by "_dimension"

ETL

The ActiveWarehouse plugin does not directly handle Extract-Transform-Load processes, however the ActiveWarehouse ETL gem (installed separately) can help. To install it use:

gem install activewarehouse-etl

More information on the ETL process can be found at http://activewarehouse.rubyforge.org/etl

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.