views:

235

answers:

2

Am I completely off-track to think about using Semantic MediaWiki to store (and organise, report on, etc.) 'tabular' data such as financial transactions or weather readings that would usually live in a spreadsheet or database?

It seems that one would need a separate, tiny, page for each tuple; but then, that's by design and perhaps it's perfectly okay.

I ask, simply because SMW seems like such a quick and easy way to get a collaborative data repository up and running.

+2  A: 

Semantic MediaWiki is better suited for keeping track of Factual or Encyclopedic data, where you can have pages about everything you need to know about a certain topic.

For tabular or numerical data such as measurements, financial, sensor data, you would indeed need to create little pages about each data point, which is not practical in many cases.

However, there are extensions to Media Wiki that allow you to integrate external data sources (in MySQL databases or CSV files somewhere) with MediaWiki pages. This can allow you to have the best of both worlds - dynamic access and queries of tabular data and semantic annotations of pages around them.

Take a look at :

http://www.mediawiki.org/wiki/Extension:External_Data

Laurent Alquier
Does the External Data extension let users write to the external repository? I guess that would be one of the OP's desiderata.
Sam
External Data is perfect for this.
Matt G
+1  A: 

No, I don't think it's such a bad idea.

Using SemanticForms you could enter lots of little data pages quickly and easily (for example, an invoice might require additional pages for each line item, but they could all be entered from one form using the 'multiple' feature of the for template form tag). So although I've never tried logging weather data in SMW, I think it would be pretty easy. I don't see what the problem would be with storing data across so many pages; it's easy enough to combine it in whatever formats you require.

Give it a go and let us know how it goes!

Sam
Semantic forms are essential to Semantic MediaWiki. In this situation, you can also set them up to create pages with automated titles, based on dates or other patterns, so they can definitely help. I agree the best thing to do is give them a try.
Laurent Alquier