![]() |
Telelogic System Architect (steve huntington) | ![]() |
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 |
![]() |
![]()
|
![]() |
|
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. |
|
![]() |
|
![]() |
|
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. |
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.