I am trying to build a MDD from a relational Oracle Database using Oracle Express Server. Should I have the RDBMS and MDD on the same machine or on a separate machine? What are the pros and cons?


Chuck Kelley’s Answer: I have used them on the same machine and on separate machines, so it really depends on whether you have the required disk environment, memory and CPU available on the single machine. If so, then you should be OK, if not, a second machine would be preferred, since you can tune to the needs of each DBMS.

David Marco’s Answer: By MDD I assume you mean meta data dictionary, which is the same as a meta data repository. Also I assume that when you say RDBMS you are referring to the RDBMS in which your data warehouse or operational system resides and that you repository will support this system. In general I like to keep my repositories on the machine that 1. has the most available bandwidth (disk space and processing power), and 2. that is most easily accessible to our other systems. Typically this is the same machine as the data warehouse.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access