Q

Beginner data integration questions

We have multiple Oracle databases, and we are looking at different options that will help to make things more organized and provide the same level of service to users. When to consolidate data sets into a single database? What are the advantages and disadvantages of integrating at the database, application and presentation layers? When is each appropriate?

Hello. I am a novice in the data integration field. We have multiple Oracle databases, and we are looking at different

options that will help to make things more organized and provide the same level of service to users.

I have a few questions:

  1. When to consolidate data sets into a single database?
  2. What are the advantages and disadvantages of integrating at the database, application and presentation layers? When is each appropriate?

I would really appreciate any help on the matter. Thanks.

There are a number of questions you need to ask:

  1. Are the databases related in any way?
  2. Do you carry out a lot of inter-database transactions?
  3. What are the databases used for (i.e., are they DSS or OLTP or a mix)?

If the answer to (1) and/or (2) is yes and the workload is similar(ish) then it may be better to consolidate databases. Even if the workload is different then you can look into the "resource manager" to segregate resources. At one site I had five separate but related databases for a very large data warehouse. I combined all five databases into one large one with data still separated out using different schemas. The resultant database, although large, was easy to manage, and the query + load time for the majority of the processes improved.

Regards,
Harish Harbham

This was first published in May 2006

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

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

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close