Entity Relationship Diagram

The diagramm uses an extensions for spatial datatypes. Point, line and polygon describe entities which have spatial information.

User

A user has a name, password and e-mail. He can record position logs and points of interest. He belongs to a certain group of users. He defines some private areas in which no position logs will be recorded when he is inside using the navigation. A users has a relationship to other users.

Group (Profile)

A group consist of users and is used to categorize the information needed for different kind od users, e.g. wheelchair, biker, pedestrian, roller blades,...

Position-Log

A spatial information abaout a position recorded by an user. There is a timestamp, a spatial point value and also relationship to the user group. This position log is valid for all users of that group and therefore we create a trail for all users in that group.

Point of Interest

A point of interest is provided by an user for an entire group. There are information about name, description, tags, picture, timestamp and a category, e.g. barrier in case group 'wheelchair'. A point of interest is a spatial point.

Private Area

The private area is defined for a single user. It is a spatial polygon.

Advertisement

Advertisement will be presented to the user when he enters its spatial polygon. The advertisemnt provides a name, a URL, an expire date and a picture. Advertisement is defined for one or more groups of users.

Trail

A trail is a spatial line created from the collected position logs. A trail is suitable for a certain group of user. The trails are the input data for the routing algorithms in the navigation use case.

Geo Refrence Frame

Current geographic frame of reference is UTM for latitude and longitude provided by WSG84 / NMEA GPS devices.

ER-Modell.png

Object Relational Diagram

We use MsSqlSpatial and a SQL Server 2005 to implent the corresponding object-relation database design.

DatenbankEntwurf.png

Last edited Nov 2, 2007 at 2:44 PM by JackSmith, version 5

Comments

No comments yet.