data-warehouse

My MySql table is returning days instead of time. I need a minimum level of minutes in a day so 1440 records should be auto populated but i keep…

I am considering various technologies for data warehousing and business intelligence, and have come upon this radical tool called Hadoop. Hadoop…

All solutions I've seen so far involve duplication of data by using nosql or datawarehousing. Are there more efficient ways?

We're creating a historic archive for a world history database and we need a date lookup table which references all dates in AD. How to go about…

I am building an analytics database (I have a firm understanding of the data and the business objectives and only basic-to-moderate database…

In my data warehouse I got a dimension where each record can have one or several tags. Are there any straight forward ways to model a dimension with…

Is it conceptually feasible to have on a Postgresql Cluster a transactional database and at the same time a datawarehouse that would get feeded by…

I got a ton of samples in the following format: <timestamp> <dim1> <dim2> <dim3> 324 <timestamp> <dim1>…

I'm trying to fine tune a query and would like some feedback. I have a job_fact warehouse table with an unit of measure for the job's final event (…

I want to build a small warehousing application for my company. We have a central warehouse which distributes to 8 sales points across the country.…

Currently we warehouse our postgres db using SSIS, but there are certain things we can't do, for example with an ADO.Net provider it isn't possible…

I have several billion rows of data in CSV files. Each row can have anything from 10 to 20 columns. I want to use COPY FROM to load the data into a…

So I've got a MySQL database for an web community that is a potential stats goldmine. Currently I'm serving stats built via all sorts of nasty…

I have a user content website with some business functionality. All tables are in 1 database. Now I am adding analytic with in dept reporting based…

Can someone talk about details about HiveDB and GridSQL? Are they targeted to the same application (OLAP, Data Warehousing)? If my understanding…