wikipedia

wikipedia有用namespace：

-2 Media

-1 Special

0

1 Talk

2 User

3 User Talk

4 Wikipedia

5 Wikipedia Talk

6 Image

7 Image Talk

8 Media Wiki

9 Media Wiki Talk

10 Template

11 Template Talk

12 Help

13 Help Talk

14 Category

15 Category Talk

16 Portal

17 Portal Talk

 

page table, page_id (key), including all the entries, page_namespage indicates the page types.

eg

| page_id | page_namespace | page_title               | page_restrictions | page_counter | page_is_redirect | page_is_new | page_random       | page_touched   | page_latest | page_len |
+---------+----------------+--------------------------+-------------------+--------------+------------------+-------------+-------------------+----------------+-------------+----------+
|   25101 |              0 | Pittsburgh,_Pennsylvania |                   |         1179 |                0 |           0 | 0.183557130567317 | 20070526024520 |   133493804 |    57931 |
|  280181 |              1 | Pittsburgh,_Pennsylvania |                   |            0 |                0 |           0 |  0.57362315644213 | 20070525171236 |   132711590 |    39152 |
|  947640 |             14 | Pittsburgh,_Pennsylvania |                   |            0 |                0 |           0 |    0.898700017901 | 20070526031551 |   130417018 |      306 |
| 7042559 |             15 | Pittsburgh,_Pennsylvania |                   |            0 |                0 |           1 |    0.457399262441 | 20070504164432 |    76361065 |       25 |
+---------+----------------+--------------------------+-------------------+--------------+------------------+----

 

mysql> select * from categorylinks where cl_from = '25101';
| cl_from | cl_to                                                  | cl_sortkey               | cl_timestamp        |
|   25101 | All_articles_lacking_sources                           | Pittsburgh, Pennsylvania | 2007-05-09 02:15:48 |
|   25101 | All_articles_with_unsourced_statements                 | Pittsburgh, Pennsylvania | 2007-04-30 02:49:27 |
|   25101 | Allegheny_County,_Pennsylvania                         | Pittsburgh, Pennsylvania | 2007-05-04 21:34:43 |
|   25101 | Articles_lacking_sources_from_May_2007                 | Pittsburgh, Pennsylvania | 2007-05-09 07:47:46 |
|   25101 | Articles_which_may_contain_original_research           | Pittsburgh, Pennsylvania | 2007-05-09 02:15:48 |
|   25101 | Articles_with_unsourced_statements_since_February_2007 | Pittsburgh, Pennsylvania | 2007-04-30 02:49:27 |
|   25101 | Articles_with_unsourced_statements_since_May_2007      | Pittsburgh, Pennsylvania | 2007-05-09 07:47:46 |
|   25101 | Cities_in_Pennsylvania                                 | Pittsburgh, Pennsylvania | 2007-05-04 21:34:43 |
|   25101 | County_seats_in_Pennsylvania                           | Pittsburgh, Pennsylvania | 2007-05-04 21:34:43 |
|   25101 | Pittsburgh,_Pennsylvania                               |                          | 2007-05-26 03:15:51 |
|   25101 | Settlements_established_in_1758                        | Pittsburgh, Pennsylvania | 2007-05-04 21:34:43 |
|   25101 | Towns_and_cities_with_limited_zero-fare_transport      | Pittsburgh, Pennsylvania | 2007-05-11 01:52:51 |
+---------+--------------------------------------------------------+--------------------------+---------------------+
12 rows in set (0.01 sec)

这些是出现在wiki下面category里面的类。

mysql> select * from categorylinks where cl_from = '947640';  //http://en.wikipedia.org/wiki/Category:Pittsburgh%2C_Pennsylvania
+---------+--------------------------------+--------------------------+---------------------+
| cl_from | cl_to                          | cl_sortkey               | cl_timestamp        |
+---------+--------------------------------+--------------------------+---------------------+
|  947640 | Allegheny_County,_Pennsylvania | Pittsburgh, Pennsylvania | 2004-09-08 05:59:48 |
|  947640 | Cities_in_Pennsylvania         | Pittsburgh, Pennsylvania | 2004-09-08 05:59:48 |
|  947640 | Cities_on_the_Ohio_River       | Pittsburgh, Pennsylvania | 2006-12-08 11:25:56 |
+---------+--------------------------------+--------------------------+---------------------+
3 rows in set (0.00 sec)

具体category：Pittsburgh, Pennsylvania的子类要在网页中查到。

 

mysql> select * from redirect where rd_title = 'Pittsburgh,_Pennsylvania';
+----------+--------------+--------------------------+
| rd_from  | rd_namespace | rd_title                 |
+----------+--------------+--------------------------+
|  8338954 |            0 | Pittsburgh,_Pennsylvania |   对应 Shitsburgh
| 10627030 |            0 | Pittsburgh,_Pennsylvania |   对应 Shittsburgh
+----------+--------------+--------------------------+
2 rows in set (0.49 sec)

 

但是却没有找到Pittsburgh？？？

mysql> select * from page where page_title='Cities_in_Pennsylvania';
+---------+----------------+------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
| page_id | page_namespace | page_title             | page_restrictions | page_counter | page_is_redirect | page_is_new | page_random    | page_touched   | page_latest | page_len |
+---------+----------------+------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+
|  707237 |             14 | Cities_in_Pennsylvania |                   |            0 |                0 |           0 | 0.514342080576 | 20070521034959 |   132042138 |     1239 |
+---------+----------------+------------------------+-------------------+--------------+------------------+-------------+----------------+----------------+-------------+----------+

mysql> select * from categorylinks where cl_to='Cities_in_Pennsylvania';
+---------+------------------------+--------------------------------------------+---------------------+
| cl_from | cl_to                  | cl_sortkey                                 | cl_timestamp        |
+---------+------------------------+--------------------------------------------+---------------------+
|  538004 | Cities_in_Pennsylvania |                                            | 2007-05-21 03:49:59 |
| 2618882 | Cities_in_Pennsylvania |                                            | 2007-05-15 04:57:27 |
|  131244 | Cities_in_Pennsylvania | Aliquippa, Pennsylvania                    | 2006-02-28 23:47:36 |
| 8135179 | Cities_in_Pennsylvania | Allentown                                  | 2006-11-26 21:13:29 |
|  131425 | Cities_in_Pennsylvania | Altoona, Pennsylvania                      | 2007-02-24 07:35:34 |
| 5681826 | Cities_in_Pennsylvania | Altoona, Pennsylvania                      | 2006-06-23 16:52:53 |
|  134126 | Cities_in_Pennsylvania | Arnold, Pennsylvania                       | 2005-03-20 23:28:21 |
|  131248 | Cities_in_Pennsylvania | Beaver Falls, Pennsylvania                 | 2007-02-23 05:02:29 |
|  151010 | Cities_in_Pennsylvania | Bethlehem, Pennsylvania                    | 2005-10-26 07:17:58 |
|  133178 | Cities_in_Pennsylvania | Bradford, Pennsylvania                     | 2006-12-12 16:02:47 |
|  131577 | Cities_in_Pennsylvania | Butler, Pennsylvania                       | 2005-04-17 15:07:37 |
|  132828 | Cities_in_Pennsylvania | Carbondale, Pennsylvania                   | 2007-03-14 04:33:59 |

mysql> select * from categorylinks where cl_from='707237';
+---------+--------------------------------------+------------------------+---------------------+
| cl_from | cl_to                                | cl_sortkey             | cl_timestamp        |
+---------+--------------------------------------+------------------------+---------------------+
|  707237 | Cities_in_the_United_States_by_state | Pennsylvania           | 2006-04-28 16:30:04 |
|  707237 | Settlements_in_Pennsylvania          | Cities in Pennsylvania | 2007-01-14 04:07:19 |
+---------+--------------------------------------+------------------------+---------------------+
2 rows in set (0.00 sec)

wiki还有portal，就是感觉门户网站的感觉，网罗所有这个topic相关的东西，

不太明白：portal跟category的作用区别！！！