Maintaining a company table in SQL

Tags:
SQL
SQL tables
I am not sure if I should mix budget data and sales data in one table in SQL or separate it. Also, if I add descriptors into the table, this will only increase record sizes and reduce the value of caching by padding each record out with repeated data. Is using small descriptor tables at run time better than adding them during the overnight data warehouse update? Our data warehouse is small. How should I go about maintenance of this table?
ASKED: September 9, 2008  7:56 PM
UPDATED: September 20, 2008  10:06 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

It really depends on how you are going to be querying the data. If you will be usually querying the budget and the sales information together then store it together. If you will to querying the data separately then overall performance will be improved by storing them separately.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    I am not a data warehouse expert, but it sounds to me that mixing budget and sales data in a same table is not a good idea. Let's hope someone else answer your other questions.
    65,110 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following