Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version. Compare with Current  |   View Page History

Produced by analysis of the Dashboard Spec (RS3.6)

Dashboard Data Model

There is no single data model, but 3 different models and queries to obtain information for the different sections of the dashboard.

History

This section shows Data Annotations and Image Annotations created in a given recent period of time. The corresponding data models are:

The needed fields are:

UI Field Property (path) Notes
Type a ?t {?t=rso:DataAnnotation or ?t=rso:ImageAnnotation}1

The needed query assuming parameter $DATE is:

select ?ann ?type ?title ?user ?date {
  ?ann a ?type; oac:hasBody ?body.
  ?body rso:P3_has_title ?title; dc:creator ?user; dc:created ?date.
  filter ((?type=rso:DataAnnotation or ?t=rso:ImageAnnotation)
           and (?date > $DATE))
}

Latest forum posts

This section shows a list of 10 latest jForum posts (latest on top).
The data is obtained with SQL from MySQL. See Forum Spec (RS3.6)#jForum Data Model for the jForum tables:

The result fields are as follows. "Type" comes from the Visio data model, not certain it's the same in MySQL

Field Type Description
Date DATETIME Date and time of the post
Title TEXT(100) Subject of the post
Description LONGTEXT Body of the post. Shows first 100 characters, if longer then a link "more" is shown. How to interpret the BB markup that can be here?
Forum TEXT(150) Name of forum the post was posted in
User TEXT(50) Author of the post. Unfortunately I can't find a "real name" field
Status SHORT Post status. Not sure how to interpret this integer, maybe in table jforum_config. Need to see a populated jForum instance

Project Announcements

These are simple messages in plain text. All the fields that we need are:

<http://www.researchspace.org/announcement/3> a rso:Announcement;
  dcterms:creator "username2";
  dcterms:created "2012-10-08T12:34:56"^^xsd:dateTime;
  rso:P3_has_title "Important project announcement".

Note: I considered storing them like a Bookmark of type "Text Snippet" (rdfs:Literal) (see Data Basket Model#Item Types).

Dashboard API

Labels:
None
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.