Database Diagram?

Yahoo Archive
1
Mike there is a Dataset Relationship view, same place where the Data
Dictionary is located, but it is not completely what you want. But it
does help identify intermediary tables.



HTH,





M. Manasa Reddy

manasa@...

P: 630-806-2000

F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael Adams
Sent: Friday, August 10, 2007 5:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Database Diagram??



I'm just wondering if anyone has access to a full database diagram for
vantage 8.00.809, something with all indexes etc. I know I can use the
data dictionary viewer to lookup indexes, but this is not always
completely useful and won't tell me which tables I should include when
building a crystal report. A simple example being where you need data
from two linked tables, without a diagram or something similar, it's
difficult to create a query that I can be sure is completely efficient -
correct me if I'm wrong but in some instances it may be more efficient
to include a third intermediary table to improve linking via the
indexes. A diagram would make life a lot more simple when having to
create larger data structures - which is usually the norm.

Mike Adams

---------------------------------
Yahoo! Answers - Get better answers from someone who knows. Tryit now.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
I’m just wondering if anyone has access to a full database diagram for vantage 8.00.809, something with all indexes etc. I know I can use the data dictionary viewer to lookup indexes, but this is not always completely useful and won’t tell me which tables I should include when building a crystal report. A simple example being where you need data from two linked tables, without a diagram or something similar, it’s difficult to create a query that I can be sure is completely efficient – correct me if I’m wrong but in some instances it may be more efficient to include a third intermediary table to improve linking via the indexes. A diagram would make life a lot more simple when having to create larger data structures – which is usually the norm.

Mike Adams


---------------------------------
Yahoo! Answers - Get better answers from someone who knows. Tryit now.

[Non-text portions of this message have been removed]
3
In Microsoft Visio, there is a tool to reverse engineer a database. I
believe it works better with SQL, as I think using it with a progress
database just gives tables and indexes and not links



Intermediary tables can sometimes make the reports faster. (i.e.) If
you was linking Jobhead and jobmtl, it may be worth placing the jobassem
table imbetween as this will then use the assembly index on the jobmtl
table



Lastly, always place a company index in your criteria filter as this
ensures all indexes are activated correctly. I have seen report speed
up 5 fold by doing this.



Ensure you use the company index is linked between all tables where the
company field is available,

Gary Parfrey

Dot Net IT Limited, Reg No 4412519

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael Adams
Sent: 10 August 2007 11:26
To: vantage@yahoogroups.com
Subject: [Vantage] Database Diagram??



I'm just wondering if anyone has access to a full database diagram for
vantage 8.00.809, something with all indexes etc. I know I can use the
data dictionary viewer to lookup indexes, but this is not always
completely useful and won't tell me which tables I should include when
building a crystal report. A simple example being where you need data
from two linked tables, without a diagram or something similar, it's
difficult to create a query that I can be sure is completely efficient -
correct me if I'm wrong but in some instances it may be more efficient
to include a third intermediary table to improve linking via the
indexes. A diagram would make life a lot more simple when having to
create larger data structures - which is usually the norm.

Mike Adams

---------------------------------
Yahoo! Answers - Get better answers from someone who knows. Tryit now.

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]