July 12, 2012 at 3:31 am
difference between master database and staging database
Sagar Sonawane
** Every DBA has his day!!:cool:
July 12, 2012 at 5:20 am
The Master contains all of the SQL system items ect:
http://msdn.microsoft.com/en-us/library/ms187837.aspx
A the term Staging DB is normally applied to Data Warehousing and it is the area where you clean and transform data in preparation for the move to the main reporting Data Warehouse..
Edit: The reason I use the term area for staging and not Database is because opinion is divided as to whether it should be stored in a separate Database or tables within the warehouse (I for one prefer the former)
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 12, 2012 at 7:44 am
I mean for e.g I have database HP561CT and HP561CTstg.
As per this demo names, i have reffered master means main HP561CT and HP561CTstg as staging database.
Just wanted to know difference between Main database abd its staging database.....
Sagar Sonawane
** Every DBA has his day!!:cool:
July 12, 2012 at 7:48 am
Define what you mean as difference?
Difference in schema?
Difference in data?
Difference in purpose?
My definition of a staging database is somewhere to temporarly load data into in an ETL process before loading it into the main db.
But it all depends what you use it for, you will need to tell us that.
July 12, 2012 at 7:51 am
Saga... (7/12/2012)
I mean for e.g I have database HP561CT and HP561CTstg.As per this demo names, i have reffered master means main HP561CT and HP561CTstg as staging database.
Just wanted to know difference between Main database abd its staging database.....
Those will be differences in your particular environment. Those are standard SQL Server databases. They'll be something built specifically for whatever they support. You'll have to find local documentation on them. Unless they're part of a third-party application, in which case you'd get documentation on them from the provider of the application.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 12, 2012 at 10:15 am
Yes I am asking in terms of application.... that application needs staging database, with main database to start some services.
just want to know generic terminology for staging.
Sagar Sonawane
** Every DBA has his day!!:cool:
July 12, 2012 at 10:18 am
Saga... (7/12/2012)
Yes I am asking in terms of application.... that application needs staging database, with main database to start some services.just want to know generic terminology for staging.
Not knowing anything about your environment or the application involved, you really expect an good solid answer regarding your two databases? I'm not even going to try taking a shot in the dark on this one.
July 12, 2012 at 10:48 am
I am not asking about my environment .... I just gave that example...in fact my environment is not like this... I raed in some papers.... so want to clarify my thoughts.....
Sagar Sonawane
** Every DBA has his day!!:cool:
July 12, 2012 at 10:55 am
Saga... (7/12/2012)
I am not asking about my environment .... I just gave that example...in fact my environment is not like this... I raed in some papers.... so want to clarify my thoughts.....
Bottom line, there isn't enough information in your original question to really give you an answer, other than the obvious: one is a master or main datbase and the other is some form of staging database simply based on the naming.
July 12, 2012 at 11:35 am
Generically, a "staging" database is one that's used as a part-way step for loading data from one format into another format. For example, I've used staging databases to load data from flat-file sources into flat tables, then done complex operations on the tables to load the data in them into their final destinations. They can be used for staging data going into a database, coming out of a database, or both. The data in them is formatted for further processing.
An operational database (what you are calling a "master" database), is one where the data is in a format that is actually consumed by applications, reports, services, etc. The data in them is formatted for active use, as opposed to staging databases formatting data for further processing and loading.
That's the generic terminology. May or may not help in what you're trying to do here.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 13, 2012 at 6:38 am
GSquared (7/12/2012)
Generically, a "staging" database is one that's used as a part-way step for loading data from one format into another format. For example, I've used staging databases to load data from flat-file sources into flat tables, then done complex operations on the tables to load the data in them into their final destinations. They can be used for staging data going into a database, coming out of a database, or both. The data in them is formatted for further processing.An operational database (what you are calling a "master" database), is one where the data is in a format that is actually consumed by applications, reports, services, etc. The data in them is formatted for active use, as opposed to staging databases formatting data for further processing and loading.
That's the generic terminology. May or may not help in what you're trying to do here.
I guess I got perfect generic answer..... Thank you 🙂
Sagar Sonawane
** Every DBA has his day!!:cool:
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply