Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Create Data Dictionary from PDM

4 posts in General Discussion Last posting was on 2012-12-24 06:20:08.0Z
Murray Sobol Posted on 2012-12-05 19:31:24.0Z
Sender: 68e5.50bf9ed0.1804289383@sybase.com
From: Murray Sobol
Newsgroups: sybase.public.powerdesigner.general
Subject: Create Data Dictionary from PDM
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50bfa10c.69a1.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 5 Dec 2012 11:31:24 -0800
X-Trace: forums-1-dub 1354735884 172.20.134.41 (5 Dec 2012 11:31:24 -0800)
X-Original-Trace: 5 Dec 2012 11:31:24 -0800, 172.20.134.41
Lines: 15
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30963
Article PK: 1103475

I have been tasked with the responsibility of creating a
Data Dictionary for our application. From my perusing of
various documents, it appears that I MUST work from a
Conceptual Data Model or a Logical Data Model.
Unfortunately, we have ALWAYS worked from Physical Data
Models.
I have tried converting a Physical Data Model to a
Conceptual Data Model, but was unsure if I got the right
results.
Alos, I don't want to make changes to a Conceptual Data
Model and then somehow synchronize them with a Physical Data
Model.
Has anyone found a methodology to create a Data Dictionary
DIRECTLY from a Physical Data Model, even if third-party
products were required?


George McGeachie Posted on 2012-12-19 06:37:24.0Z
Sender: 5aed.50d15ae7.1804289383@sybase.com
From: George McGeachie
Newsgroups: sybase.public.powerdesigner.general
Subject: Re: Create Data Dictionary from PDM
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50d160a4.5bb5.1681692777@sybase.com>
References: <50bfa10c.69a1.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 18 Dec 2012 22:37:24 -0800
X-Trace: forums-1-dub 1355899044 172.20.134.41 (18 Dec 2012 22:37:24 -0800)
X-Original-Trace: 18 Dec 2012 22:37:24 -0800, 172.20.134.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30967
Article PK: 1158485

Crucial question - what do you mean by 'Data Dictionary'?

> I have been tasked with the responsibility of creating a
> Data Dictionary for our application. From my perusing of
> various documents, it appears that I MUST work from a
> Conceptual Data Model or a Logical Data Model.
> Unfortunately, we have ALWAYS worked from Physical Data
> Models.
> I have tried converting a Physical Data Model to a
> Conceptual Data Model, but was unsure if I got the right
> results.
> Alos, I don't want to make changes to a Conceptual Data
> Model and then somehow synchronize them with a Physical
> Data Model.
> Has anyone found a methodology to create a Data Dictionary
> DIRECTLY from a Physical Data Model, even if third-party
> products were required?


Hans Posted on 2012-12-24 06:20:08.0Z
Sender: 2d56.50d7f237.1804289383@sybase.com
From: Hans
Newsgroups: sybase.public.powerdesigner.general
Subject: Re: Create Data Dictionary from PDM
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50d7f418.2de1.1681692777@sybase.com>
References: <50d160a4.5bb5.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 23 Dec 2012 22:20:08 -0800
X-Trace: forums-1-dub 1356330008 172.20.134.41 (23 Dec 2012 22:20:08 -0800)
X-Original-Trace: 23 Dec 2012 22:20:08 -0800, 172.20.134.41
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30972
Article PK: 1158592

In the help of Powerdesigner 16.1 you may find a good
example how to build a data dictionary.

HTH
Hans

> Crucial question - what do you mean by 'Data Dictionary'?
>
> > I have been tasked with the responsibility of creating a
> > Data Dictionary for our application. From my perusing of
> > various documents, it appears that I MUST work from a
> > Conceptual Data Model or a Logical Data Model.
> > Unfortunately, we have ALWAYS worked from Physical Data
> > Models.
> > I have tried converting a Physical Data Model to a
> > Conceptual Data Model, but was unsure if I got the right
> > results.
> > Alos, I don't want to make changes to a Conceptual Data
> > Model and then somehow synchronize them with a Physical
> > Data Model.
> > Has anyone found a methodology to create a Data
> > Dictionary DIRECTLY from a Physical Data Model, even if
> > third-party products were required?


Randy Buchholz Posted on 2012-12-19 13:58:46.0Z
Sender: 6d63.50d1c16f.1804289383@sybase.com
From: Randy Buchholz
Newsgroups: sybase.public.powerdesigner.general
Subject: Re: Create Data Dictionary from PDM
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <50d1c816.6f78.1681692777@sybase.com>
References: <50bfa10c.69a1.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 19 Dec 2012 05:58:46 -0800
X-Trace: forums-1-dub 1355925526 172.20.134.41 (19 Dec 2012 05:58:46 -0800)
X-Original-Trace: 19 Dec 2012 05:58:46 -0800, 172.20.134.41
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30970
Article PK: 1158488

I use a couple of approaches. A simple one is to just go to
model>attributes show the columns you want and export. You
can also do the same type of thing generating a report.

The method I use most is using Domains, which really gives
you a lot of capabilities for analysis too. Make sure you
disable "user types" in the generation options so it doesn't
create user types in the DB (unless you want them)

You can also use the glossary. It's not as straight forward
but it does some cool things.

> I have been tasked with the responsibility of creating a
> Data Dictionary for our application. From my perusing of
> various documents, it appears that I MUST work from a
> Conceptual Data Model or a Logical Data Model.
> Unfortunately, we have ALWAYS worked from Physical Data
> Models.
> I have tried converting a Physical Data Model to a
> Conceptual Data Model, but was unsure if I got the right
> results.
> Alos, I don't want to make changes to a Conceptual Data
> Model and then somehow synchronize them with a Physical
> Data Model.
> Has anyone found a methodology to create a Data Dictionary
> DIRECTLY from a Physical Data Model, even if third-party
> products were required?