Interactory Publicaties
Home
Onderwerpen
IDEA Addon voor Sparx
Web Publicatie Platform voor Sparx
Architectuur Repository
Sparx Enterprise Architect
Architectuur
Webvideo's
Whitepapers
Blog
Alle onderwerpen
Zoeken in repository
Trefwoorden zoeken in repository
ArchiMate zoeken in repository
Geavanceerd zoeken in repository
Packages in repository
Diagrammen in repository
Repository elementen
Extra
Repository verkenner
Matrix van Package
Matrix van Diagram
Begrippenlijst
Grafieken
Release notes
Participant
Inschrijven voor de webmailing
Login
Contact
Deze website is verplaatst naar
Data-docent.nl
Person
Copy from table to class by script
Package
Logical datamodel example
Author
Bert Dingemans
Alias
--
Stereotypes
--
Attributes
Name
Type
Cardinality
Description
BusinessEntityID
String
1 - 1
Primary key for Person records.
PersonType
String
1 - 1
Primary type of person: SC = Store Contact, IN = Individual (retail) customer, SP = Sales person, EM = Employee (non-sales), VC = Vendor contact, GC = General contact
NameStyle
Boolean
1 - 1
0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order.
Title
String
1 - 1
A courtesy title. For example, Mr. or Ms.
FirstName
String
1 - 1
First name of the person.
MiddleName
String
1 - 1
Middle name or middle initial of the person.
LastName
String
1 - 1
Last name of the person.
Suffix
String
1 - 1
Surname suffix. For example, Sr. or Jr.
EmailPromotion
String
1 - 1
0 = Contact does not wish to receive e-mail promotions, 1 = Contact does wish to receive e-mail promotions from AdventureWorks, 2 = Contact does wish to receive e-mail promotions from AdventureWorks and selected partners.
AdditionalContactInfo
String
1 - 1
Additional contact information about the person stored in xml format.
Demographics
String
1 - 1
Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.
rowguid
String
1 - 1
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate
String
1 - 1
Date and time the record was last updated.
Mappings
Name
Source
Source attribute
Target
Target attribute
BusinessEntityID
Person
BusinessEntityID
Person
BusinessEntityID
PersonType
Person
PersonType
Person
PersonType
NameStyle
Person
NameStyle
Person
NameStyle
Title
Person
Title
Person
Title
FirstName
Person
FirstName
Person
FirstName
MiddleName
Person
MiddleName
Person
MiddleName
LastName
Person
LastName
Person
LastName
Suffix
Person
Suffix
Person
Suffix
EmailPromotion
Person
EmailPromotion
Person
EmailPromotion
AdditionalContactInfo
Person
AdditionalContactInfo
Person
AdditionalContactInfo
Demographics
Person
Demographics
Person
Demographics
rowguid
Person
rowguid
Person
rowguid
ModifiedDate
Person
ModifiedDate
Person
ModifiedDate
BusinessEntityID
Lookup_Person
BusinessEntityID
Person
BusinessEntityID
PersonType
Lookup_Person
PersonType
Person
PersonType
NameStyle
Lookup_Person
NameStyle
Person
NameStyle
Title
Lookup_Person
Title
Person
Title
FirstName
Lookup_Person
FirstName
Person
FirstName
LastName
Lookup_Person
LastName
Person
LastName
Suffix
Lookup_Person
Suffix
Person
Suffix
AdditionalContactInfo
Person Destination
AdditionalContactInfo
Person
AdditionalContactInfo
BusinessEntityID
Person Destination
BusinessEntityID
Person
BusinessEntityID
Demographics
Person Destination
Demographics
Person
Demographics
EmailPromotion
Person Destination
EmailPromotion
Person
EmailPromotion
NameStyle
Person Destination
NameStyle
Person
NameStyle
PersonType
Person Destination
PersonType
Person
PersonType
FirstName
Merger FullName
FirstName
Person
FirstName
LastName
Merger FullName
LastName
Person
LastName
MiddleName
Merger FullName
MiddleName
Person
MiddleName
Diagrams
Data Mapping
Data mapping is an example diagram of a data mapping in the IDEA implementation This implementation can be used in for example an ETL process but also for documenting the data flows and transformations in message transformation process or component.
FormFactory
Mapping example of formfactory entities connected via mappings to the logical entities in the example repository
Data modeling overview example
This diagram shows the associations via traces over the three modeling layers. It is thus an overview for the data modeling.
Logical model example project
--
Person User Interface
Example of a simple user interface generated by an IDEA script including the relevant mappings from the logical data model.
Data Mapper and Merger example
--
Gekoppelde elementen
Conceptual datamodel example
Person trace
Example FormFactory entities
Lookup_Person
Example of a User Interface
BusinessEntityID
PersonType
NameStyle
Title
FirstName
MiddleName
LastName
Suffix
EmailPromotion
AdditionalContactInfo
Demographics
rowguid
ModifiedDate
Logical datamodel example
BusinessEntity FK
EmailAddress FK
PersonPhone FK
Person Destination
Merger FullName
Physical datamodel example
Person
Person trace
Links 2 Tags
Archimate
Architect
Architectuur
Architectuur document
Architectuur repository
Big data
Bouwblokken en patronen
Criteria
Data
Data architectuur
Data governance
Data kwaliteit
Data management
Data modelleren
Enterprise architectuur
Idea
Image library
Master data
Matrix
Mdg
Meta data
Metafoor
Modelleren
Open source
Principes
Register
Repository
Simulator
Software
Sparx enterprise architect
Sql
Stakeholders
Time aware modelleren
Tips en tricks
Training
Webvideo
Wpp