In another post I have covered data warehousing books in the world of Oracle. We've also had a look at data warehousing and business intelligence books for project management and business analysis. Today we will look at data warehousing and business intelligence books that look at the technical design and architecture of a data warehouse solution. Must Have DW 2.0: ...
n AS time_id,
TO_CHAR(to_date(n,'SSSSS'),'HH24') AS hour,
TO_CHAR(to_date(n,'SSSSS'),'MI') AS minute,
TO_CHAR(to_date(n,'SSSSS'),'SS') AS second
CONNECT BY LEVEL <= 86400
Greenplum This is no joke. Greenplum on 19 October announced a free single node edition of its analytical database. For those of you who haven't heard about Greenplum, they are a provider of an MPP database software that runs on commodity hardware (unlike some its competitors such as Teradata, Netezza, or recently Oracle with Exadata). The database is based on ...