-
as seen on Stack Overflow
- Search for 'Stack Overflow'
Background:
I have a PostgreSQL (v8.3) database that is heavily optimized for OLTP.
I need to extract data from it on a semi real-time basis (some-one is bound to ask what semi real-time means and the answer is as frequently as I reasonably can but I will be pragmatic, as a benchmark lets say we…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I'm buildind an data warehouse. Each fact has it's timestamp. I need to create reports by day, month, quater but by hours too. Loking at the examples I see that dates tend to be saved in dimension tabels.
But I think, that it makes no sense for time. The dimension table would grow and grow. On the…
>>> More
-
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
Since I joined Oracle I've been working on Oracle Healthcare Data Warehouse Foundations (OHDF). It was officially released earlier this month at HIMSS. But for over 2 months prior to that I had to keep it a secret. It was so tough; I didn't even tell my family when they asked me what I was working…
>>> More
-
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
BIWA Wednesday TechCast Series - 19th Event!
Opposition to Data Warehouse Initiatives
Please join us for this webcast on Wednesday, March 24, 12 noon Eastern or check your local area's time
Webcast is open to clients, prospects and partners.
No matter how good your technology and technical skills…
>>> More
-
as seen on Oracle Blogs
- Search for 'Oracle Blogs'
Most of you probably know that each year I publish a data warehouse guide for OpenWorld which contains links to the latest data warehouse videos, a calendar for the most important sessions and labs and a section that provides profiles and relevant links for all the most important data warehouse presenters…
>>> More
