Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
Topic Title: Flat file mapping to logical model.
Topic Summary: Building csv formats in SA.
Created On: 8-Nov-2007 12:28
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
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.
 8-Nov-2007 12:28
User is offline View Users Profile Print this message


Jeremy Gooch

Posts: 14
Joined: 10-Nov-2006

Hi,

We have an enterprise data model in System Architect (an ERD), representing data available via our middleware Hub.  We'd like to show the mapping back to the sources.  Where these sources are databases or XML documents, this is easy (via physical data models and class diagrams respectively).  What I can't seem to find is the best way to represent data sources that are flat files (csv or fixed width).

How are others achieving this?  Should we model these flat files and their structure as additional physical data model diagrams, data stores or something else?

Advice gratefully received.

Thanks,

J.

Report this to a Moderator Report this to a Moderator
 14-Dec-2007 15:39
User is offline View Users Profile Print this message


Peter Crabb-Wyke

Posts: 73
Joined: 3-May-2007

A flat file structure can be viewed as a simple implementation of an entity - there is a list of attributes which have data types and qualifiers but of course no referential constraints or primary keys.

Logically there should be no issue here as the implementation artifacts are distinct from the logical data structures. I suspect that you have been mixing them in the same model which gives you downstream problems as you try to expand the scope.

Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 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.