RE: Data Modelling Tools for a DBAs Job
Hi I have used S-Designer and ERWin in the past - both in development DBA roles. Don't recall exact features of S-Designer (was about 5 to 6 years ago) but remember it to be very useful. Have more recent experiences of ERWin and found it very useful. It is expensive but well worth the investment. I used ERWin in a product development environment where, due to the development cycle, we had numerous versions of our product's data model e.g. development, test, production etc. and multiple releases of our product. In this environment ERWin was used to maintain each data model and promote changes between physical databases. E.g. Development environment may have new tables, new columns, different data types etc. to the test environment. ERWin can maintain these differences by connecting to the databases and comparing the two physical databases and reporting on and generating scripts to synchronise the databases. We also used ERWin to maintain our storage parameters (tablespaces, index tablespaces) as well as the indexes themselves. Both ERWin and S-Designer will generate the scripts required to create your database objects - prerequisite is that database, schemas and optionally tablespaces already exist. Clear case, MS Visual Source Safe , RCS, SCCS etc. can be used to maintain versioning of each ERWin/S-Designer model for each build/release to label each data model version with same label as source code of rest of product. Hope this helps. Regards, Mark. -Original Message- Sent: 14 October 2003 11:10 To: Multiple recipients of list ORACLE-L How essential the following tools to a DBAs job? (viz) Rational Rose, Clear case for Versioning etc. What are Data Modelling tools avbl. in the market and which are widely used (other than Oracle Designer)?. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Patterson, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Modelling Tools for a DBAs Job
There is a nice tool for Linux...DBDesigner4... -Original Message- Sent: Tuesday, October 14, 2003 11:14 AM To: Multiple recipients of list ORACLE-L Hi I have used S-Designer and ERWin in the past - both in development DBA roles. Don't recall exact features of S-Designer (was about 5 to 6 years ago) but remember it to be very useful. Have more recent experiences of ERWin and found it very useful. It is expensive but well worth the investment. I used ERWin in a product development environment where, due to the development cycle, we had numerous versions of our product's data model e.g. development, test, production etc. and multiple releases of our product. In this environment ERWin was used to maintain each data model and promote changes between physical databases. E.g. Development environment may have new tables, new columns, different data types etc. to the test environment. ERWin can maintain these differences by connecting to the databases and comparing the two physical databases and reporting on and generating scripts to synchronise the databases. We also used ERWin to maintain our storage parameters (tablespaces, index tablespaces) as well as the indexes themselves. Both ERWin and S-Designer will generate the scripts required to create your database objects - prerequisite is that database, schemas and optionally tablespaces already exist. Clear case, MS Visual Source Safe , RCS, SCCS etc. can be used to maintain versioning of each ERWin/S-Designer model for each build/release to label each data model version with same label as source code of rest of product. Hope this helps. Regards, Mark. -Original Message- Sent: 14 October 2003 11:10 To: Multiple recipients of list ORACLE-L How essential the following tools to a DBAs job? (viz) Rational Rose, Clear case for Versioning etc. What are Data Modelling tools avbl. in the market and which are widely used (other than Oracle Designer)?. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Patterson, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Modelling Tools for a DBAs Job
I use Oracle Designer. Works great - I'm very happy with it. It does have w to much functionality for Database Design. But I ignore those parts of the product and use just what I need. Works for me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, October 14, 2003 12:24 PM To: Multiple recipients of list ORACLE-L There is a nice tool for Linux...DBDesigner4... -Original Message- Sent: Tuesday, October 14, 2003 11:14 AM To: Multiple recipients of list ORACLE-L Hi I have used S-Designer and ERWin in the past - both in development DBA roles. Don't recall exact features of S-Designer (was about 5 to 6 years ago) but remember it to be very useful. Have more recent experiences of ERWin and found it very useful. It is expensive but well worth the investment. I used ERWin in a product development environment where, due to the development cycle, we had numerous versions of our product's data model e.g. development, test, production etc. and multiple releases of our product. In this environment ERWin was used to maintain each data model and promote changes between physical databases. E.g. Development environment may have new tables, new columns, different data types etc. to the test environment. ERWin can maintain these differences by connecting to the databases and comparing the two physical databases and reporting on and generating scripts to synchronise the databases. We also used ERWin to maintain our storage parameters (tablespaces, index tablespaces) as well as the indexes themselves. Both ERWin and S-Designer will generate the scripts required to create your database objects - prerequisite is that database, schemas and optionally tablespaces already exist. Clear case, MS Visual Source Safe , RCS, SCCS etc. can be used to maintain versioning of each ERWin/S-Designer model for each build/release to label each data model version with same label as source code of rest of product. Hope this helps. Regards, Mark. -Original Message- Sent: 14 October 2003 11:10 To: Multiple recipients of list ORACLE-L How essential the following tools to a DBAs job? (viz) Rational Rose, Clear case for Versioning etc. What are Data Modelling tools avbl. in the market and which are widely used (other than Oracle Designer)?. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Patterson, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Modelling Tools for a DBAs Job
Oracle designer is a full fledged CASE tool, so it does quite a bit more than design a database. I've checked out other DB design tools, even bougth Embarcadero. None of them are nearly as capable as Oracle Designer for designing Oracle databases. None of them seem to be as good at separating the logical from the physical either. Jared Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/14/2003 09:44 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Data Modelling Tools for a DBAs Job I use Oracle Designer. Works great - I'm very happy with it. It does have w to much functionality for Database Design. But I ignore those parts of the product and use just what I need. Works for me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, October 14, 2003 12:24 PM To: Multiple recipients of list ORACLE-L There is a nice tool for Linux...DBDesigner4... -Original Message- Sent: Tuesday, October 14, 2003 11:14 AM To: Multiple recipients of list ORACLE-L Hi I have used S-Designer and ERWin in the past - both in development DBA roles. Don't recall exact features of S-Designer (was about 5 to 6 years ago) but remember it to be very useful. Have more recent experiences of ERWin and found it very useful. It is expensive but well worth the investment. I used ERWin in a product development environment where, due to the development cycle, we had numerous versions of our product's data model e.g. development, test, production etc. and multiple releases of our product. In this environment ERWin was used to maintain each data model and promote changes between physical databases. E.g. Development environment may have new tables, new columns, different data types etc. to the test environment. ERWin can maintain these differences by connecting to the databases and comparing the two physical databases and reporting on and generating scripts to synchronise the databases. We also used ERWin to maintain our storage parameters (tablespaces, index tablespaces) as well as the indexes themselves. Both ERWin and S-Designer will generate the scripts required to create your database objects - prerequisite is that database, schemas and optionally tablespaces already exist. Clear case, MS Visual Source Safe , RCS, SCCS etc. can be used to maintain versioning of each ERWin/S-Designer model for each build/release to label each data model version with same label as source code of rest of product. Hope this helps. Regards, Mark. -Original Message- Sent: 14 October 2003 11:10 To: Multiple recipients of list ORACLE-L How essential the following tools to a DBAs job? (viz) Rational Rose, Clear case for Versioning etc. What are Data Modelling tools avbl. in the market and which are widely used (other than Oracle Designer)?. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Patterson, Mark INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Modelling Tools for a DBAs Job
I'm using it as well -- a bit quirky, and I don't particularly like its PL/SQL development interface, but for schema design-to-generation, it's decent. I still prefer ERwin. Adam Mercadante, Thomas F [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/14/2003 10:44 AM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject RE: Data Modelling Tools for a DBAs Job I use Oracle Designer. Works great - I'm very happy with it. It does have w to much functionality for Database Design. But I ignore those parts of the product and use just what I need. Works for me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, October 14, 2003 12:24 PM To: Multiple recipients of list ORACLE-L There is a nice tool for Linux...DBDesigner4... -Original Message- Sent: Tuesday, October 14, 2003 11:14 AM To: Multiple recipients of list ORACLE-L Hi I have used S-Designer and ERWin in the past - both in development DBA roles. Don't recall exact features of S-Designer (was about 5 to 6 years ago) but remember it to be very useful. Have more recent experiences of ERWin and found it very useful. It is expensive but well worth the investment. I used ERWin in a product development environment where, due to the development cycle, we had numerous versions of our product's data model e.g. development, test, production etc. and multiple releases of our product. In this environment ERWin was used to maintain each data model and promote changes between physical databases. E.g. Development environment may have new tables, new columns, different data types etc. to the test environment. ERWin can maintain these differences by connecting to the databases and comparing the two physical databases and reporting on and generating scripts to synchronise the databases. We also used ERWin to maintain our storage parameters (tablespaces, index tablespaces) as well as the indexes themselves. Both ERWin and S-Designer will generate the scripts required to create your database objects - prerequisite is that database, schemas and optionally tablespaces already exist. Clear case, MS Visual Source Safe , RCS, SCCS etc. can be used to maintain versioning of each ERWin/S-Designer model for each build/release to label each data model version with same label as source code of rest of product. Hope this helps. Regards, Mark. -Original Message- Sent: 14 October 2003 11:10 To: Multiple recipients of list ORACLE-L How essential the following tools to a DBAs job? (viz) Rational Rose, Clear case for Versioning etc. What are Data Modelling tools avbl. in the market and which are widely used (other than Oracle Designer)?. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Patterson, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Data Modelling Tools for a DBAs Job
I couldn't agree more! It also has the Oracle Software Configuration Management (SCM) to rigorously version all those Repository objects. Maggie Respectfully, Maggie Tompkins - CAD SQA Corporate Applications Division Technology Services Organization - Kansas City Defense Finance and Accounting Service 816-926-1117 (DSN 465); [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, October 14, 2003 12:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Data Modelling Tools for a DBAs JobOracle designer is a full fledged CASE tool, so it does quite a bit more than design a database. I've checked out other DB design tools, even bougth Embarcadero. None of them are nearly as capable as Oracle Designer for designing Oracle databases. None of them seem to be as good at separating the logical from the physical either. Jared "Mercadante, Thomas F" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/14/2003 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: Data Modelling Tools for a DBAs JobI use Oracle Designer. Works great - I'm very happy with it. It does havew to much functionality for Database Design. But I ignore thoseparts of the product and use just what I need. Works for me.Tom MercadanteOracle Certified Professional-Original Message-Sent: Tuesday, October 14, 2003 12:24 PMTo: Multiple recipients of list ORACLE-LThere is a nice tool for Linux...DBDesigner4...-Original Message-Sent: Tuesday, October 14, 2003 11:14 AMTo: Multiple recipients of list ORACLE-LHiI have used S-Designer and ERWin in the past - both in development DBAroles.Don't recall exact features of S-Designer (was about 5 to 6 years ago) butremember it to be very useful. Have more recent experiences of ERWin and found it very useful. It isexpensive but well worth the investment.I used ERWin in a product development environment where, due to thedevelopment cycle, we had numerous versions of our product's data model e.g.development, test, production etc. and multiple releases of our product.In this environment ERWin was used to maintain each data model and promotechanges between physical databases. E.g. Development environment may havenew tables, new columns, different data types etc. to the test environment.ERWin can maintain these differences by connecting to the databases andcomparing the two physical databases and reporting on and generating scriptsto synchronise the databases.We also used ERWin to maintain our storage parameters (tablespaces, indextablespaces) as well as the indexes themselves.Both ERWin and S-Designer will generate the scripts required to create yourdatabase objects - prerequisite is that database, schemas and optionallytablespaces already exist.Clear case, MS Visual Source Safe , RCS, SCCS etc. can be used to maintainversioning of each ERWin/S-Designer model for each build/release to labeleach data model version with same label as source code of rest of product.Hope this helps.Regards,Mark. -Original Message-Sent: 14 October 2003 11:10To: Multiple recipients of list ORACLE-LHow essential the following tools to a DBAs job?(viz) Rational Rose, Clear case for Versioning etc. What are Data Modelling tools avbl. in the market and which are widely used(other than Oracle Designer)?.TIA-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Patterson, MarkINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Odland, BradINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Mercadante, Thomas FINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan
Re: Data Modelling Tools for a DBAs Job
You forgot perl. On 2003.10.13 20:34, quriyat wrote: How essential the following tools to a DBAs job? (viz) Rational Rose, Clear case for Versioning etc. What are Data Modelling tools avbl. in the market and which are widely used (other than Oracle Designer)?. TIA ___ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: quriyat INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Data Modelling Tools for a DBAs Job
If you're using Rational Rose, are you interested in UML modeling? For if so, you might want to check out a tool created by Dulcian, Inc. called BRIM. http://www.dulcian.com It's a free tool, but I do believe that you must contact them for an initial consultation. I am not sure about all of the specifics involved in what your relationship with this company would need to be. It's worth a look, though. One of the tool's designers demo-ed this for me at ODTUG last June and it looks pretty good. HTH, Melanie -Original Message- quriyat Sent: Monday, October 13, 2003 8:34 PM To: Multiple recipients of list ORACLE-L How essential the following tools to a DBAs job? (viz) Rational Rose, Clear case for Versioning etc. What are Data Modelling tools avbl. in the market and which are widely used (other than Oracle Designer)?. TIA ___ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: quriyat INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Modelling Tools for a DBAs Job
I guess how important depends on what type of DBA role you are filling. If it's a system type DBA role where your only real task is to keep the database running and perform some basic backup / recovery type work then understanding the intricacies of table relationships isn't very important. If your role includes understanding table relationships, perhaps supporting development of the application sitting on the database, perhaps generating reports from the data, helping users write ad-hoc queries, etc then a good data modelling tool becomes essential... Unless of course there is already a data architect performing this role for you! Where I am currently the tool of choice is Rational Rose. This was chosen largely because the application is OO based and Rational is a very good OO modelling tool. In my opinion though the data modelling side of the product leaves a lot to be desired. A couple of examples: The product cannot define a foreign key on an existing column without using a semi-official plugin. The product cannot reverse engineer UNIQUE indexes from Oracle 8i databases. These are both what I would consider fundamental requirements of a data modelling tool. In defence we are using version 2002 on an NT platform - perhaps things are better in the latest release. The last person to work on our model then brought the data across to Visio to produce a much cleaner diagram but I have no idea if this was a trivial or complex exercise. Previously I had used ERwin and my memories of it are much better although I believe it's not the cheapest data modelling tool in existence. I think even the latest version of TOAD can build data model diagrams. Regards, Mark. quriyat [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] m cc: Sent by: Subject: Data Modelling Tools for a DBAs Job [EMAIL PROTECTED] .com 14/10/2003 10:34 Please respond to ORACLE-L How essential the following tools to a DBAs job? (viz) Rational Rose, Clear case for Versioning etc. What are Data Modelling tools avbl. in the market and which are widely used (other than Oracle Designer)?. TIA ___ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: quriyat INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on
Re: Data Modelling Tools for a DBAs Job
I'd say having some sort of data modelling tool at your disposal is pretty much essential to understanding the table layouts and relationships for anything but the most trivial model. If you do any sort of data modeling or database design, or if you interface with developers, having a nice ERD is key. Major ERD Tools out there: - S-Designer/PowerDesigner Data Architect - LogicWorks (now Platinum) ERwin - Cast db-builder - Embarcadero's ER/Studio - Microsoft Visio (now has an ERD module) Others that i'm not as familiar with: - DeZign - Silverrun's RDM - Rational Rose 2000E - Oracle Designer 2000 - Popkin's System Architect - Select Enterprise - RevSQL: http://www.sqlworkshop.com/ - Clear Case hope this helps. boss - How essential the following tools to a DBAs job? (viz) Rational Rose, Clear case for Versioning etc. What are Data Modelling tools avbl. in the market and which are widely used (other than Oracle Designer)?. TIA ___ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: quriyat INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Boss INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Modelling Tools for a DBAs Job
quriyat wrote: How essential the following tools to a DBAs job? (viz) Rational Rose, Clear case for Versioning etc. What are Data Modelling tools avbl. in the market and which are widely used (other than Oracle Designer)?. TIA The only essential DBA tool is sqlplus. Modelling tools can be useful if you are involved in design (in which many DBAs are not); they can help getting a grasp of an existing application but how much they bring you depends on you. I have also seen AMC Designer (this is the old name, a tool now sold by Sybase as, I think, PowerDesigner or something like that) much used - and with Oracle more than Sybase. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
