Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with data-warehouse
Search options answers only
not deleted
user 34007
A database system optimised for reporting, particularly in aggregate. Often, but not always implemented using a star schema.
1
vote
Beginning Data Warehouse Design
Your question is too vague and general to get a good response here. What you need is a text (El Masri or Garcia-Molina or Connolly) to explain the basics of RDBMSs and of data warehousing.
Forums l …
- 30.6k
4
votes
Accepted
Have a separate database for data warehousing?
In response to your reply to my comment, I mentioned some of the areas in which PostgreSQL shines for DW work - notably CTEs (Common Table Expressions - AKA the WITH clause) and Window functions (AKA …
- 30.6k
17
votes
Accepted
Compare two similar Postgres databases for differences
Have a look at the Stack Overflow Q & A, How to check difference between two databases in PostgreSQL?; in particular Another PostgreSQL Diff Tool (apgdiff) (schema comparison only). Apgdiff is recomme …
- 30.6k
2
votes
Accepted
What's the term that describes our data processes
For advertising purposes, you could use the term "Business data enhancement engineering"? :-) Personally, I would call what you do "[complex] [business] data processing".
Thanks. Any suggestion o …
- 30.6k
10
votes
Accepted
What are the main reasons to split a Data Warehouse into multiple databases?
You are definitely on the right track! 320GB is not huge for a database, particularly a DW.
1) Current db is poorly optimized, little documentation, sub-optimal
datatypes, sub-optimal indices.
…
- 30.6k
1
vote
Accepted
Is data warehouse monitoring same as database monitoring?
"On what parameters can we monitor data warehouse?".
Exactly the same ones that you use for monitoring an OLTP database. You might want to pay more attention to things like slow query log (MySQL) …
- 30.6k
12
votes
Accepted
Is Data Warehousing possible in MySQL and PostgresSQL
You can certainly use MySQL or PostgreSQL for this requirement using Python as your database access language. I've never used Python cubes so I can't speak to that.
I would recommend that you use Po …
- 30.6k
1
vote
Best practices for transferring data across long, wide tables
Generally speaking, I find that it is infinitely preferable to go with the solution proposed by your database system vendor. The situation with respect to implementing RI (Referential Integrity) on th …
- 30.6k
1
vote
Should a Fact table contain a column with a single unique value?
What I recommend is that you have a fact_source table:
CREATE TABLE fact_source
(
fact_source_id INTEGER, -- auto-increment.
fact_source_name VARCHAR (50)
);
Use your own RDBMS's (you didn't s …
- 30.6k
2
votes
Accepted
Best way to capture changes on OLTP for Data Warehouse: Create/Update column or CDC
You've answered your own question!
It's ALWAYS better to go with your vendor's solution rather than "rolling your own"... How many people will test your "home-cooked solution"? How many edge cases …
- 30.6k
2
votes
How to change a web application that now needs to become OLTP and OLAP application?
OK - I'm going to slightly revise my advice in the previous thread.
If you have only 1 physical server, you're always going to have problems with OLTP conflicting with OLAP - i.e. disk bottleneck. …
- 30.6k