DEV Community

dneutr0n
dneutr0n

Posted on

1

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

Qodo Takeover

Introducing Qodo Gen 1.0: Transform Your Workflow with Agentic AI

Rather than just generating snippets, our agents understand your entire project context, can make decisions, use tools, and carry out tasks autonomously.

Read full post