
	Home > Ask the Oracle Experts > SOA and Integration Questions & Answers > Beginner data integration questions

Ask The Oracle Expert: Questions & Answers

EMAIL THIS

Beginner data integration questions

EXPERT RESPONSE FROM: Harish Harbham

		Pose a Question

		Other Oracle Categories

		Meet all Oracle Experts
		Become an Expert for this site

Digg This!

StumbleUpon

Del.icio.us

QUESTION POSED ON: 02 May 2006
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:

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?

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

EXPERT RESPONSE

There are a number of questions you need to ask:

Are the databases related in any way?
Do you carry out a lot of inter-database transactions?
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

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	SOA and Integration
	How to transfer data from Oracle to MS SQL Server
	How to convert a SQL Server 2005 database to Oracle 10g
	Using Oracle Streams
	How to use Oracle Heterogeneous Services
	How to create a mediated schema
	Oracle Transparent Gateway for Unix
	How to perform Oracle replication
	How to dump SQL Server database with Oracle data
	Setting up backups with data replication
	Oracle or SQL Server for developing social networking site?

Oracle data and application integration

Oracle to acquire application service management firm

Oracle updates its enterprise performance management system, details Hyperion integration

Podcast: Oracle outlines AIA vision

Oracle's 10 steps to get to Fusion rely on Oracle investments

Oracle Fusion Middleware: Top five headlines

Oracle adds Data Integration Suite to middleware family

Oracle-BEA deal means tough choices for middleware buyers

Oracle to buy BEA Systems

Oracle adds Enterprise 2.0 to Fusion Middleware 11g

Oracle scoffs at BEA's buyout proposal

Oracle database design

Oracle database in the cloud floated at Harvard lab

Oracle OpenWorld 2008 Special Report

Weighing remote database administration pros and cons takes care

Oracle Database 11g makes waves at Burlington Coat Factory

How to create a database link in Oracle

Data modeling tools no substitute for hard work

How do I do that in Oracle?

The Oracle Database user's guide to Oracle OpenWorld 2007

Oracle OpenWorld 2007 Special Report

How many redo log files?

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

extent (SearchOracle.com)

field (SearchOracle.com)

flexfield (SearchOracle.com)

foreign key (SearchOracle.com)

quad tree (SearchOracle.com)

record (SearchOracle.com)

row (SearchOracle.com)

splay tree (SearchOracle.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Reprints \| Site Map All Rights Reserved, Copyright 2003 - 2008, TechTarget \| Read our Privacy Policy