Timeline for Data Warehouse: How can i query daily snapshots?
Current License: CC BY-SA 3.0
22 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 15, 2016 at 16:00 | vote | accept | Federico Ponzi | ||
| Jun 15, 2016 at 15:59 | answer | added | Federico Ponzi | timeline score: 2 | |
| S Feb 7, 2016 at 19:08 | history | bounty ended | CommunityBot | ||
| S Feb 7, 2016 at 19:08 | history | notice removed | CommunityBot | ||
| S Feb 5, 2016 at 12:30 | history | suggested | H. Pauwelyn | CC BY-SA 3.0 |
outline code
|
| Feb 5, 2016 at 12:10 | review | Suggested edits | |||
| S Feb 5, 2016 at 12:30 | |||||
| Feb 4, 2016 at 23:32 | answer | added | Rick James | timeline score: 2 | |
| Feb 3, 2016 at 18:56 | comment | added | RLF | Have you considered using UNION (or UNION ALL) to merge the individual SELECTs from each Snapshot? Of course, be sure that each snapshot has the needed indexes. | |
| Feb 3, 2016 at 17:04 | history | edited | RLF |
added mysql to tags
|
|
| Feb 3, 2016 at 13:05 | history | edited | Federico Ponzi | CC BY-SA 3.0 |
added 802 characters in body
|
| Feb 1, 2016 at 9:38 | history | edited | Federico Ponzi | CC BY-SA 3.0 |
Updated the overall question
|
| Feb 1, 2016 at 9:26 | comment | added | Federico Ponzi | Please don't think this problem in terms of data warehousing, but in terms of how to query and/or big data. I have different daily snapshots of my database, and I would like a way to query them effectively. | |
| Jan 30, 2016 at 23:00 | comment | added | dnoeth | Why daily snapshots? How much of the 250 GB changes a day? What's wrong with a Slowly Changing Dimensions approach? | |
| Jan 30, 2016 at 17:38 | comment | added | Tom V | Daily snapshots of 250GB? With those requirements? How? | |
| S Jan 30, 2016 at 17:12 | history | bounty started | Federico Ponzi | ||
| S Jan 30, 2016 at 17:12 | history | notice added | Federico Ponzi | Authoritative reference needed | |
| Jan 29, 2016 at 18:55 | history | tweeted | twitter.com/StackDBAs/status/693145518504071170 | ||
| Jan 29, 2016 at 11:37 | history | edited | Federico Ponzi | CC BY-SA 3.0 |
added 688 characters in body
|
| Jan 29, 2016 at 8:39 | comment | added | Federico Ponzi | Because I don't want to define new tables before loading my datasets. Sure if there is a solution that can handle this problem but needs table to be defined ahead I would choose it anyway. | |
| Jan 29, 2016 at 8:37 | history | edited | Federico Ponzi | CC BY-SA 3.0 |
added 54 characters in body
|
| Jan 28, 2016 at 22:23 | comment | added | vmachan |
It seems you have a decent structure to your data.. is there any specific reason why you are looking for a scheme-free solution? By scheme I am assuming table definitions/structures
|
|
| Jan 28, 2016 at 14:46 | history | asked | Federico Ponzi | CC BY-SA 3.0 |