DEV Community

dneutr0n
dneutr0n

Posted on

can anyone please explain the relationship between page table and category table in Wikipedia database?

Top comments (5)

Collapse
 
dmfay profile image
Dian Fay

I don't know what the Wikipedia schema looks like firsthand but I strongly suspect a disambiguation or category page is nothing more than a page whose content is oriented towards listing other pages. There's no need for it to be a special case; databases store information, they don't care about meaning.

Collapse
 
dneutr0n profile image
dneutr0n

Sorry I meant like

Computing

*Java (programming language), an object-oriented high-level programming language
*Java (software platform), software and specifications developed by Sun, acquired by Oracle
*Java virtual machine, an abstract computing machine enabling a computer to run a Java program
*JavaScript, an interpreted programming language

Entertainment

  • (band), a French band *Java (board game), a board game set

they could categorize them like computing ,entertainment ........
below is the link of schema
commons.wikimedia.org/wiki/File:Me...

Collapse
 
dmfay profile image
Dian Fay

Yeah, I got what you meant. There isn't a category table in the schema you posted. What makes a category page a category is its content. It's just a special case of a regular page.

Thread Thread
 
dneutr0n profile image
dneutr0n

Thank you
But above version shows realtionships
below one is the latest it doesn't show the relationships between entities
but here i could find category table :( . It's confusing me
mediawiki.org/wiki/Manual:Database...

upload.wikimedia.org/wikipedia/com...

Collapse
 
dneutr0n profile image
dneutr0n

en.wikipedia.org/wiki/Java_(disamb...
so like above we can group according to category