Hello,
A page such as: http://en.wikipedia.org/wiki/Die_Hard, you can see a movie template which contains many useful information such as director name, starring etc.
Is this information stored as just as a form of wiki markup in the article table, or any more meaningful structure stored in the database?
Thanks.
Howard.
A page such as: http://en.wikipedia.org/wiki/Die_Hard, you can see a movie template which contains many useful information such as director name, starring etc.
Is this information stored as just as a form of wiki markup in the article table, or any more meaningful structure stored in the database?
It's stored in the templatelinks table, see: http://www.mediawiki.org/wiki/Templatelinks_table
On Nov 10, 2007 9:13 PM, Thomas Dalton thomas.dalton@gmail.com wrote:
A page such as: http://en.wikipedia.org/wiki/Die_Hard, you can see a movie template which contains many useful information such as director name, starring etc.
Is this information stored as just as a form of wiki markup in the article table, or any more meaningful structure stored in the database?
It's stored in the templatelinks table, see: http://www.mediawiki.org/wiki/Templatelinks_table
Great thanks.
By the way, I found a schema image: http://upload.wikimedia.org/wikipedia/commons/4/41/Mediawiki-database-schema...
May I know which tool was being used to generate this?
Thanks again.
On Sat, Nov 10, 2007 at 09:25:19PM +0800, howard chen wrote:
On Nov 10, 2007 9:13 PM, Thomas Dalton thomas.dalton@gmail.com wrote:
A page such as: http://en.wikipedia.org/wiki/Die_Hard, you can see a movie template which contains many useful information such as director name, starring etc.
Is this information stored as just as a form of wiki markup in the article table, or any more meaningful structure stored in the database?
It's stored in the templatelinks table, see: http://www.mediawiki.org/wiki/Templatelinks_table
Great thanks.
By the way, I found a schema image: http://upload.wikimedia.org/wikipedia/commons/4/41/Mediawiki-database-schema...
May I know which tool was being used to generate this?
According to the image description on
http://commons.wikimedia.org/wiki/Image:Mediawiki-database-schema.png
it was made with DB Designer.
jens
2007/11/10, howard chen howachen@gmail.com:
By the way, I found a schema image: http://upload.wikimedia.org/wikipedia/commons/4/41/Mediawiki-database-schema...
May I know which tool was being used to generate this?
The image description page[1] says:
"Created by me, using DB designer 4.0.5.6 Beta on windows, but also containing information from MediaWiki's tables.sql file and from the table descriptions at MediaWiki.org (see: mw:Manual:Database layout)."
1. http://commons.wikimedia.org/wiki/Image:Mediawiki-database-schema.png
On Nov 10, 2007 9:40 PM, Schneelocke schneelocke@gmail.com wrote:
2007/11/10, howard chen howachen@gmail.com:
By the way, I found a schema image: http://upload.wikimedia.org/wikipedia/commons/4/41/Mediawiki-database-schema...
May I know which tool was being used to generate this?
The image description page[1] says:
"Created by me, using DB designer 4.0.5.6 Beta on windows, but also containing information from MediaWiki's tables.sql file and from the table descriptions at MediaWiki.org (see: mw:Manual:Database layout)."
-- schnee
Nice.
Thanks.
Howard
On Nov 10, 2007 9:50 PM, howard chen howachen@gmail.com wrote:
On Nov 10, 2007 9:40 PM, Schneelocke schneelocke@gmail.com wrote:
2007/11/10, howard chen howachen@gmail.com:
By the way, I found a schema image: http://upload.wikimedia.org/wikipedia/commons/4/41/Mediawiki-database-schema...
May I know which tool was being used to generate this?
The image description page[1] says:
"Created by me, using DB designer 4.0.5.6 Beta on windows, but also containing information from MediaWiki's tables.sql file and from the table descriptions at MediaWiki.org (see: mw:Manual:Database layout)."
-- schnee
Nice.
Thanks.
Howard
One more follow up, how the inter table `links` in your schema was draw using DB Designer, or it is using external program?
Howard
One more follow up, how the inter table `links` in your schema was draw using DB Designer, or it is using external program?
It was entirely drawn using DB designer.
If you'd like, you can get the raw data file used to generate the image from http://files.nickj.org/MediaWiki/mediawiki-dbdesigner-schema-data.xml (I tried uploading this data file Commons, but '".xml" is an unwanted file type List of allowed file types: png, gif, jpg, jpeg, xcf, pdf, mid, sxw, sxi, sxc, sxd, ogg, svg, djvu' http://commons.wikimedia.org/wiki/Commons:File_types )
Then install DB designer, run it, go File -> Open, point it at this XML file, and what you see when it loads should match the image.
-- All the best, Nick.
On 11/10/07, Thomas Dalton thomas.dalton@gmail.com wrote:
A page such as: http://en.wikipedia.org/wiki/Die_Hard, you can see a movie template which contains many useful information such as director name, starring etc.
Is this information stored as just as a form of wiki markup in the article table, or any more meaningful structure stored in the database?
It's stored in the templatelinks table, see: http://www.mediawiki.org/wiki/Templatelinks_table
Templatelinks only stores the fact that Die Hard includes the movie template, not what its parameters are. To figure out the latter you need to parse the page.
howard chen wrote:
A page such as: http://en.wikipedia.org/wiki/Die_Hard, you can see a movie template which contains many useful information such as director name, starring etc.
Is this information stored as just as a form of wiki markup in the article table, or any more meaningful structure stored in the database?
You will be interested in these projects:
http://meta.wikimedia.org/wiki/User:LA/Extraktor
I'm user:LA2 who created the first of these.
On Nov 13, 2007 8:42 AM, Lars Aronsson lars@aronsson.se wrote:
howard chen wrote:
A page such as: http://en.wikipedia.org/wiki/Die_Hard, you can see a movie template which contains many useful information such as director name, starring etc.
Is this information stored as just as a form of wiki markup in the article table, or any more meaningful structure stored in the database?
You will be interested in these projects:
Hello,
Can't find any information on the above link.
Howard
howard chen wrote:
Can't find any information on the above link.
The correct link should be http://meta.wikimedia.org/wiki/User:LA2/Extraktor
wikitech-l@lists.wikimedia.org