使用 Semantic MediaWiki 处理表格数据

发布于 2024-08-09 15:02:35 字数 262 浏览 14 评论 0原文

我是否完全偏离了轨道来考虑使用 Semantic MediaWiki 来存储(以及组织、报告等)? )“表格”数据,例如通常存在于电子表格或数据库中的金融交易或天气读数?

似乎每个元组都需要一个单独的、很小的页面;但那是设计使然,也许完全没问题。

我问这个问题,只是因为 SMW 看起来是一种快速、简单的方式来启动和运行协作数据存储库。

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.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(3

羁拥 2024-08-16 15:02:35

Semantic MediaWiki 更适合跟踪事实或百科全书数据,您可以在其中包含有关某个主题所需了解的所有内容的页面。

对于表格或数字数据(例如测量数据、财务数据、传感器数据),您确实需要创建有关每个数据点的小页面,这在许多情况下并不实用。

但是,Media Wiki 有一些扩展,允许您将外部数据源(在 MySQL 数据库或某处的 CSV 文件中)与 MediaWiki 页面集成。这可以让您两全其美 - 动态访问和查询表格数据及其周围页面的语义注释。

看一下:

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

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

倥絔 2024-08-16 15:02:35

不,我不认为这是一个坏主意。

使用 SemanticForms,您可以快速轻松地输入大量小数据页面(例如,发票可能会每个行项目都需要额外的页面,但可以使用 for template 表单标记的“多个”功能从一个表单输入它们。因此,虽然我从未尝试过在 SMW 中记录天气数据,但我认为这会非常容易。我不明白跨这么多页面存储数据会出现什么问题;可以很容易地将其组合成您需要的任何格式。

尝试一下,让我们知道进展如何!

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!

记忆之渊 2024-08-16 15:02:35

您可以使用语义内部对象扩展 (SIO),或SMW 的内置子对象(前者与已经提到的外部数据扩展配合良好),用于存储一页中包含多个语义对象(可能是电子表格的行)。

然而,除非您确实在寻找具有语义功能的协作工具,否则我怀疑 SMW 是否是最适合您任务的软件。

编辑(2015 年 11 月):自 SMW 1.9 版以来,SIO 没有什么是内置子对象不能做的,所以我推荐后者。

You can use either the Semantic Internal Objects extension (SIO), or SMW's built in subobjects (the former works well with the already mentioned External Data extension), to store multiple semantic objects (could be the rows of your spreadsheet) in one page.

However, unless you are really looking for a collaborative tool with semantic capabilities, I doubt SMW is the best suited piece of software for your task.

edit (november 2015): Since SMW version 1.9, there nothing that SIO can do that the built-in subobjects can't, so I would recommend the latter.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文