English 中文(简体)
Wiki Database, is there one?
原标题:

I was searching the net for something like a wiki database, just like wikipedia but instead stores structured content, editable by users. What I was looking for was an online database accessible by everyone where people can design the schema and data with proper versioning of both schema and data. I couldn t find any such site. I am not sure if it is my search skills or if there really is no wiki database as of now. Does anyone out there know anything like this?

I think there is a great potential for something like this. A possible example will be a website with a GUI for querying a MySQL DB where any website visitor can create DB objects and populate data.


UPDATE: I had registered the domain wikidatabase.org to get started on a tool but I didn t find enough time yet. If anyone is interested in spending some time and coding on this, please let me know at wikidatabase.org

最佳回答

This might be like what you re looking for: dbpedia.org. They re working on extracting data from Wikipedia, and encoding it in a structured format using RDF, so that it can be queried using SPARQL.

Linkeddata.org has a big list of RDF data sets.

问题回答

It s not quite what you re looking for, but Semantic Mediawiki adds database-like features to MediaWiki:

http://semantic-mediawiki.org/wiki/Semantic_MediaWiki

It s still fundamentally a Wiki, but you can add semantic tags to pages ([[foo::bar]] [[baz::1000]]) and then do database-type queries across them: SELECT baz FROM pages WHERE foo=bar would be {{#ask: [[foo::bar]] | ?baz}}. There is even an embryonic SPARQL implementation for pseudo-SQL queries.

OK this question is old, but Google led me here, so for anyone else out there looking for a wiki for structured data: Take a look at Foswiki.

Do you mean something like http://www.freebase.com?

You should check out https://www.wikidata.org/wiki/Wikidata:Main_Page which is a bit different but still may be of interest.

Something that might come close to your requirements is Google Docs.

What s offered is document editing roughly similar to MS Word, and spreadsheets roughly similar to Excel. I m thinking of the latter, of course.

In Google Docs, You can create spreadsheets for free; being spreadsheets, they naturally have a row-and-column structure similar to a database, and which you can define flexibly. You can also share these sheets with other people. This seems to be a by-invite-only process rather than open-to-all, but there may be other possibilities I m not aware of, or that level of sharing might be enough for you in any case.

mindtouch should be able to do it. It s rather easy to get data in / out. (for example: it s trivial to aggregate all the IP s for servers into one table).

I pretty much use it as a DB in the wiki itself (pages have tables, key/value..inheritance, templates, etc...) but you can also interface with the API, write dekiscript, grab the XML...

I like this idea. I have heard of some sites that are trying to pull together large datasets for various things for open consumption, but none that would allow a wiki feel.

You could start with something as simple as an installation of phpMyAdmin with a known password that would allow people to log in, create a database, edit data and query from any other site on the web.

It might suffer from more accuracy problems than wikipedia though.

OpenRecord, development of which seems to have halted in 2008, seems to approach this. It is a structured wiki in which pages are views on the data. Unlike RDBMSes it is loosely typed - the system tries to make a best guess about what data you entered, but defaults to text when it cannot guess. Schemas appear to have been implied.

http://openrecord.org

An example of the typing that is given is that of a date. If you enter 2008 in a record, the system interprets this as a date. If you enter unknown however, the system allows that as well.

Perhaps you might be interested in Couch DB:

Apache CouchDB is a document-oriented database that can be queried and indexed in a MapReduce fashion using JavaScript. CouchDB also offers incremental replication with bi-directional conflict detection and resolution.

I m working on an Open Source PHP / Symfony / PostgreSQL app that does this.

It allows multiple projects, each project can have multiple directories, each directory has a defined field structure. Admins set all this up.

Then members of the public can suggest new records, edit or report existing ones. All this is moderated and versioned.

It s early days yet but it basically works and is already in real world use in several projects.

Future plans already in progress include tools to help keep the data up to date, better searching/querying and field types that allow translations of content between languages.

There is more at http://www.directoki.org/

I m surprised that nobody has mentioned Wikibase yet, which is the software that powers Wikidata.





相关问题
what is wrong with this mysql code

$db_user="root"; $db_host="localhost"; $db_password="root"; $db_name = "fayer"; $conn = mysqli_connect($db_host,$db_user,$db_password,$db_name) or die ("couldn t connect to server"); // perform query ...

Users asking for denormalized database

I am in the early stages of developing a database-driven system and the largest part of the system revolves around an inheritance type of relationship. There is a parent entity with about 10 columns ...

Easiest way to deal with sample data in Java web apps?

I m writing a Java web app in my free time to learn more about development. I m using the Stripes framework and eventually intend to use hibernate and MySQL For the moment, whilst creating the pages ...

join across databases with nhibernate

I am trying to join two tables that reside in two different databases. Every time, I try to join I get the following error: An association from the table xxx refers to an unmapped class. If the ...

How can I know if such value exists in database? (ADO.NET)

For example, I have a table, and there is a column named Tags . I want to know if value programming exists in this column. How can I do this in ADO.NET? I did this: OleDbCommand cmd = new ...

Convert date to string upon saving a doctrine record

I m trying to migrate one of my PHP projects to Doctrine. I ve never used it before so there are a few things I don t understand. In my current code, I have a class similar to this: class ...

热门标签