Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: Choice of DOORS DB Engine
Topic Summary:
Created On: 23-Apr-2003 04:46
Status: Post and Reply
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by Paul Miller, on Friday, March 11, 2005 4:48 PM

Answer:
Hi Everyone,

Lot's of interesting responses to my initial post - could I just refocus it a little - my main interest in having a choice of DB engine is not so much trying to have more open access to the data, but an interest in more cost efficient administration.

DB's like Oracle, Informix etc are highly sophisticated and often under-utilised. They also come equipped with some pretty decent management tools to assist with performance monitoring, performance tuning, disaster recovery etc. It makes some economical sense that if you have already invested in purchasing these DB's for other applications, acquired the IT Infrastructure to suport them and trained or acquired experienced staff, then there's a more efficient use of resources if you can get some wider re-use out of your investment. Telelogic's Synergy range of products use Informix as the DB engine, would be nice if DOORS could do the same.
 23-Apr-2003 04:46
User is offline View Users Profile Print this message


Paul Miller

Posts: 376
Joined: 2-Oct-2002

Does anyone know if it's planned for DOORS to eventually offer an open DB architecture so that you can choose which DB Engine you would like to use eg: Informix, Oracle, MS SQL Server etc? I would kind of like to think that some of the changes made to the DOORS DB architecture since V4.x are an iterative move towards an open DB architecture - but I could be wrong .

Apart from having more sophisticated admin level ctrl's on the DB, this would also help to free up the dependence on DXL for customisations.

I'm hopeing that perhaps Telelogic staff maybe browsing and that others who have a similiar interest could post to this thread and add their support for such a feature.

------------------------------------------
Paul Miller
Tenix Specification Practices Project,
Tenix Defence
Nelson House, Williamstown,
Victoria, Australia, 3016.
Desk Phone: +61 (0)3 9244 4078
Mobile: +61 (0)418 135 103
E-mail: paul.miller@tenix.com
------------------------------------------




-------------------------
Paul Miller
Specification Practices Specialist,
EuroCyber,
Melbourne, Australia.
Mobile: +61 (0)418 135 103
Web Site: http://www.eurocyber.biz
E-mail: miller@eurocyber.biz">pmiller@eurocyber.biz
Report this to a Moderator Report this to a Moderator
 19-Aug-2003 19:31
User is offline View Users Profile Print this message


Pete Kowalski

Posts: 301
Joined: 7-Feb-2003

Hi Paul:

Something related to this post but I have heard from Telelogic sources that they are in the development stage of devleoping DOORS XP ;-) that uses ORACLE as the database instead of the current FoxPro. Hopefully, using ORACLE will prevent a lot of problems with DOORS regarding the filesystem.

Pete

-------------------------
pete.kowalski(at)motorola.com
Report this to a Moderator Report this to a Moderator
 27-Aug-2003 10:13
User is offline View Users Profile Print this message


Mandy Livingstone

Posts: 15
Joined: 21-Jan-2003

Can I clarify that we dont use Foxpro as our current database - it is completely proprietary

If you are interested in information regarding any future versions of DOORS you should always make your sales person/account manager the first point of contact

Mandy
Report this to a Moderator Report this to a Moderator
 27-Aug-2003 15:01
User is offline View Users Profile Print this message


Pete Kowalski

Posts: 301
Joined: 7-Feb-2003

Mandy,

Was FoxPro ever the database engine? Last year I took a DXL scripting class run by Telelogic and the instructor stated that FoxPro was the engine used in DOORS 5.2.

Pete

-------------------------
pete.kowalski(at)motorola.com
Report this to a Moderator Report this to a Moderator
 27-Aug-2003 15:54
User is offline View Users Profile Print this message


Douglas Zawacki

Posts: 97
Joined: 14-Aug-2003

I have to agree that having a non-proprietary database is a HUGE benefit for the users. I am hoping that telelogic will someday open the db up. In fact the company that I am consulting for has a policy NOT to allow applications that use proprietary databases and that in itself may be a reason not to commit to making DOORs a company standard.

Telelogic...PLEASE consider standardizing the database !!!
Report this to a Moderator Report this to a Moderator
 2-Sep-2003 18:02
User is offline View Users Profile Print this message


Keith Collyer

Posts: 6
Joined: 20-May-2002

Douglas wrote:



<< I have to agree that having a non-proprietary database is a HUGE benefit for the users. I am hoping that telelogic will someday open the db up. In fact the company that I am consulting for has a policy NOT to allow applications that use proprietary databases and that in itself may be a reason not to commit to making DOORs a company standard. >>



I have never understood this attitude. So much on any PC these days is in proprietary databases. The whole darn thing runs from the Windows Registry, a proprietary can of worms if ever there was one. And what about Word? No organization can enforce "non-proprietary" and hope to work, unless they are prepared to write all their own software.

-------------------------
--

Cheers

Keith
Report this to a Moderator Report this to a Moderator
 2-Sep-2003 19:53
User is offline View Users Profile Print this message


Douglas Zawacki

Posts: 97
Joined: 14-Aug-2003

Keith,

Maybe I should have been a bit clearer in my statement. It's not the proprietary database that I'm concerned about it's the access to the data.

Thankfully, DXL provides the facilities to convert the data to a non-proprietary database. But the real issue is that telelogic hasn't provided automatic conversion utilities to do such a thing. Thus, requiring the user/programming to fend for themselves.

Why Telelogic doesn't provide conversion utilities to other database formats is what I don't understand.

Any organization that allows "proprietary databases" (without the ability for conversion to other database formats) is at the mercy of the vendor.



Edited: 2-Sep-2003 at 21:01 by Douglas Zawacki
Report this to a Moderator Report this to a Moderator
 2-Sep-2003 21:17
User is offline View Users Profile Print this message


Michael Sutherland

Posts: 248
Joined: 13-Sep-2002

Douglas,



<< Any organization that allows "proprietary databases" (without the ability for conversion to other database formats) is at the mercy of the vendor. >>



I'm glad you made the important distinction. One of the reasons people have been asking Telelogic to switch to an industry standard database such as Oracle as their DB engine is the assumption that they could get at the data that DOORS manages without using a DOORS client.

In practice, I believe this is a very faulty assumption. DOORS is a complicated proprietary application, and the database schema to support it on a database such as Oracle would be complicated and proprietary as well. Unless DOORS would agree to document and its database schema in full (highly unlikely), you would still need a DOORS client or a DOORS API to access the data. You may get lucky and figure out ways to read some of it in some coherent fashion, but even today DOORS doesn't store information in plain text in its proprietary database.

-------------------------
Michael Sutherland
michael@galactic-solutions.com
http://galactic-solutions.com
Report this to a Moderator Report this to a Moderator
 1-Oct-2003 17:06
User is offline View Users Profile Print this message


Louie Landale

Posts: 2070
Joined: 12-Sep-2002

And if they DID go to Oracle ... wouldn't they STILL need ..err.. allow DXL customizations?

- Louie
Report this to a Moderator Report this to a Moderator
 2-Oct-2003 11:43
User is offline View Users Profile Print this message


Paul Worrall

Posts: 87
Joined: 30-Sep-2003



<< Douglas wrote:

I have never understood this attitude. So much on any PC these days is in proprietary databases. The whole darn thing runs from the Windows Registry, a proprietary can of worms if ever there was one. And what about Word? No organization can enforce "non-proprietary" and hope to work, unless they are prepared to write all their own software.
>>



Can I put in a little plug here for the burgeoning Free and Open Software movements. There are a variety of alternatives to proprietary software and associated file formats.
Report this to a Moderator Report this to a Moderator
 6-Oct-2003 01:43
User is offline View Users Profile Print this message


Paul Miller

Posts: 376
Joined: 2-Oct-2002

Answer Answer
Hi Everyone,

Lot's of interesting responses to my initial post - could I just refocus it a little - my main interest in having a choice of DB engine is not so much trying to have more open access to the data, but an interest in more cost efficient administration.

DB's like Oracle, Informix etc are highly sophisticated and often under-utilised. They also come equipped with some pretty decent management tools to assist with performance monitoring, performance tuning, disaster recovery etc. It makes some economical sense that if you have already invested in purchasing these DB's for other applications, acquired the IT Infrastructure to suport them and trained or acquired experienced staff, then there's a more efficient use of resources if you can get some wider re-use out of your investment. Telelogic's Synergy range of products use Informix as the DB engine, would be nice if DOORS could do the same.

-------------------------
Paul Miller
Specification Practices Specialist,
EuroCyber,
Melbourne, Australia.
Mobile: +61 (0)418 135 103
Web Site: http://www.eurocyber.biz
E-mail: miller@eurocyber.biz">pmiller@eurocyber.biz
Report this to a Moderator Report this to a Moderator
 4-Oct-2004 18:04
User is offline View Users Profile Print this message


John Blessing

Posts: 1
Joined: 4-Oct-2004

I concur with Paul here. It's not the performance of a proprietary database that is an issue for us, its the lack of Admin tools. After reading all the other topics in the DOORS arena; I think that a company should get more tools from Telelogic to help maintain this system. I shouldn't have to lose links after a restore of data or have to spend countless hours creating band-aid scripts to fix problems. I don't mind this when I am working with the open systems of the world, but I have a problem when I pay for a product and not get the neccessary tools to support it.
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 0 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 0 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.