A database system optimised for reporting, particularly in aggregate. Often, but not always implemented using a star schema.
2
votes
2answers
1k views
Reindexing a large database
I have a very large database (millions of rows) which has been indexed.
I receive a diff of rows from another source that I need to update in my database.
The problem I am facing is that is it ...
2
votes
2answers
199 views
Data warehouse: using day number in Epoch in a date dimension
In Chapter 2 Retail Sales of Ralph Kimball's The Data Warehouse Toolkit, the author describes a date dimension with three fields which appear totally alien to me:
Date Key (PK)
Date
Full Date ...
2
votes
1answer
378 views
Does surrogate key assignment for a fact table require that the source data has natural keys?
Let's say I have a simple OLTP database with orders, products, and customers:
And from it, I am building a data mart with an orders fact table, product dimension, customer dimension, and date ...
2
votes
2answers
1k views
Datawarehouse Design: Combined Date Time dimension vs. Separate Day and Time dimensions and timezones
We are just starting design for a new data warehouse and we're trying to design how our date and time dimensions will work. We need to be able to support multiple timezones (probably at least GMT, ...
2
votes
1answer
214 views
In star schemas, what should I do when a dimension has a date attribute?
I'm trying to learn about dimensional models and star schemas. Say I have a Sales fact table recording the total sales at retail stores, with, say, four dimensions, Date, Customers, Stores, and ...
2
votes
1answer
173 views
Is dimensional modelling useful for modelling tables of calculations?
I have a set of tables that look a bit like this:
Key 1 | Key 2 | Key 3 | Var 1 | Var 2 | Var 3 | ... | Var 200
-------------------------------------------------------------
X | Y | Z | ...
2
votes
1answer
970 views
Tips for Optimizing Oracle Warehouse Builder 11.1 with Oracle DB 10.2
Are there any tips for improving performance of Control Center and Design Center in Oracle Warehouse Builder? At the client side it is very slow to open and refresh Design center and control center ...
2
votes
1answer
744 views
ALTER TABLE SWITCH statement failed
ALTER TABLE SWITCH statement failed because column does not have the same ANSI trimming semantics in tables...
Does anyone knows how to fix that on already existing table full of data?
Well, I've ...
1
vote
1answer
96 views
Modeling staff dimension in data warehouse
I need to write a data warehouse diagram. I've got a problem with staff area. I have to store a information about workers details like name, age etc., and workers job time and agreement details like ...
1
vote
2answers
152 views
Data warehouse support tickets
I'm starting to design a data warehouse for a company. The first questions we're trying to resolve are regarding their support ticketing system. My initial schema is as follows
Now one of the ...
1
vote
1answer
835 views
How to move data from Primary Data File to other data file without destroying replication
I have one Database which is replicated using transactional replication. Now, I want do spare some data of that database to another partition, because my server running out of disk space.
I was ...
1
vote
2answers
261 views
Indexing of Data Warehouse tables?
Maybe I have misunderstood something but I can recall reading an article which said that there is no reason to create non-clustered indexes on very large data warehousing tables? That is because ...
1
vote
1answer
80 views
Conceptual Design of a data warehouse (declaring the grain)
I am trying to design a data warehouse using this example scrubbed data. I need to declare the "grain". I know its the lowest level of detail in the fact table, but I am having a hard time determining ...
1
vote
2answers
143 views
XML Large DataBase is the best? [closed]
Is the best way to implement a large database is XML? Or is there a better way?
1 - reduce the time complexity
2 - Reduce the amount of traffic between the tables
And other factors ...
Which ...
1
vote
1answer
106 views
Force chain to start immediately after completion instead of on a timer
Is it possible to force an Oracle chain to restart immediately after it finishes executing, instead of on a timer? I have only found ways to do a temporal restart, which doesn't really work for me as ...
1
vote
2answers
100 views
Designing an Accumulating Snapshot with Repeated Groups, need advise
Situation
I need to create a pie chart that has to be able to be represented at the following levels: District, Region, and School.
At the student level it has to show the trend of the student over ...
1
vote
1answer
559 views
Design of fact table(s) and dimensions tables for data warehouse
Hi i'm newbie in Datawarehousing, how would you model this in a Data Warehouse:
i wish design the Data Warehouse which give the answers of statistics relating to a baseball league
For players
in ...
1
vote
1answer
80 views
Open source tools to manage Data Quality [closed]
Are there open source (or commercial) tools that can report data quality issues in a data warehouse using the Kimball star schema model? It doesn't have to be the silver bullet. I'm just looking for ...
1
vote
1answer
227 views
Oracle Change Data Capture: Unsubscribed column results in change set record
I am using Oracle 11g's Change Data Capture to track changes on a database table. I am using synchronous mode to minimize latency. Here's an example to illustrate my problem:
Published_Table
...
1
vote
1answer
461 views
An advice to design a fact table with a scd as a dimension
I have a problem of conception and I would like to get your ideas on how I'll be able to do what I am aiming.
My goal is to create a datawarehouse, with three dimensions and one fact table so far.
...
1
vote
0answers
40 views
How to handle “many columns” in OLAP RDBMS
I have a fact that has around 1K different numerical attributes (i.e. columns). I would like to store this in to a column-oriented DB and perform cube analysis on it.
I tried to design a star ...
1
vote
0answers
115 views
sql server 2008 execution plan different on two production servers [closed]
We have two servers running SQL server 2008 R2, with identical databases, where we implemented a datawarehousing solution. The cube processing operation was taking a VERY long time in one of the ...
1
vote
0answers
56 views
Advices for modeling facts, time hierarchies based on two conditions
Sorry if my question does not belong to that SE but I tried to find the best place and it ended up here.
My problem is this :
I've got a table modeled as this in our datawarehouse env. :
MYTABLE ...
1
vote
0answers
24 views
Monoblock, Multiblock queries?
What exactly mean the terms monoblock / multiblock queries in data warehouses when talking about materialized views? Does a monoblock query just use one data source (a normal table) while a multiblock ...
0
votes
2answers
1k views
Possible career paths for Oracle Certified Associate (OCA) [closed]
In order to be confident in databases as a entry level job candidate, I completed the OCA certification. Now I want to know what career paths follow this. Can one go into data-mining, BI, or ...
0
votes
2answers
44 views
Teradata performance statistics
I need some statistics regarding the performance of Teradata, something like with a given hardware, given nodes and given AMPs - a table which has thousands of rows can be read in 't' secs.
I need ...
0
votes
1answer
140 views
What are good resources on data modelling for business intelligence? [closed]
We are a SaaS startup offering purchase & procurement solutions. The data model for operational transactions has been created (relational DB). We also want to offer analytics on those transactions ...
0
votes
2answers
72 views
Can a surrogate key and a primary key be in the same table?
For example we have:
Surrogate key: ABC123
Primary key: 1
Name: James
Is this legit in a Data Warehouse table?
0
votes
2answers
120 views
SQL Server 2005 replication for a data warehouse
We are trying to implement some kind of Data Warehouse at my current employer.
Most of our data is in a SQL Server 2005, but we might also integrate some Access databases and some databases in a SQL ...
0
votes
1answer
30 views
Oracle scheduler chain priority in data warehouse applications
The scenario is as follows:
We have a data warehouse type application that relies on the Oracle job scheduler and a Chain. This chain is responsible for generating materialized views (caches) that ...
0
votes
2answers
280 views
SQL Server 2012 Data Warehousing Overall Flow [closed]
I am studying Data Warehousing in SQL Server 2012
I am attempting to learn the various tools included by practicing on the different tools separately.
I have practiced with:
AdventureWorks ...
0
votes
1answer
78 views
SSIS convert DT_WSTR to date
I'm new to SSIS trying to covert data types. I'm pulling data from Google Analytics and loading data into a SQL 2008 database. The date column from Google analytics appears as "DT_WSTR" and the values ...
0
votes
1answer
136 views
How to simplify schema for multi database / hundreds of millions of rows data set
We currently have a MySQL data set that was started about 10 years ago that aggregates a log of data, and accumulates millions of rows each month. The people that developed our system started ...
0
votes
1answer
139 views
Using N-Tier in Business Intelligence
I have read that you also can apply N-Tier for Businesss Intelligence
based on these criteria:
*Presentation
*Functional logic
*Data
What is your experience when you are using N-Tier?
// ...
0
votes
1answer
38 views
SQL Server cube - count distinct of dimension key [closed]
I have a fact table which has a lot of records with the same person ID. I would like to create a calculated member that count them, but without duplicates of the ID.
I tried to use just ...
0
votes
1answer
10 views
creating a report on the mysql jasperReport server
I have mysql local database, in it I have sample data mart. I have installed jasperReport server to my computer. Just using this tool, I want connect to the local mysql database and just create a pdf ...
0
votes
0answers
37 views
Suggested Database and Web Application Framework for Enterprise, “Big-Data” App? [closed]
I have a web application that I have been developing for a small group within my company over the past few years, using Pipeline Pilot (plus jQuery and Python scripting) for web development and ...
0
votes
0answers
27 views
SAP Business Warehouse 0APO_LOCNO_ATTR datasource extraction
We are currently importing 0APO_LOCNO_ATTR from several different source systems. I want to be able to import the field PRECISID into BW from this datasource. Here is what I have discovered/tried so ...
0
votes
0answers
460 views
oracle database project ideas [closed]
I have to prepare three project ideas for my final year undergraduate project module. I like to work with databases and i want any challenging database design and implementation with various ...
0
votes
0answers
71 views
Oracle Change Data Control - how to use SOURCE_COLMAP$ and TARGET_COLMAP$
Has anyone successfully used the TARGET_COLMAP$ column in Oracle Change Data Control to identify which columns have changed? I'm trying to produce audit reports for users and identify for the user ...
0
votes
1answer
43 views
Can't Find Meta data tool [closed]
I having problem to find a Meta data tool that should be used for data warehouse or data mart in order to make documentation.
0
votes
0answers
57 views
Biztalk + BI = where? [closed]
I have heard that you can use Biztalk in to transfer data to the Business intelligence.
Exactly where do you put the Biztalk's integration in relation to the architecture of Business Intelligence?
-1
votes
1answer
37 views
data warehouse construction from mdf and ldf file via etl
I have sample data warehouse stored in the form of mdf and ldf format. I want to use any ETL tool to extract data and then load datawarehouse on the specified database with username, password and ...
-7
votes
3answers
189 views
Business Intelligence = Technical OR Business Project? [closed]
Do you consider a project of Business Intelligence to be a technical or business project?
