Differences
This shows you the differences between two versions of the page.
|
projs:clans:docs:dataset_db_company_rank [2014/01/27 10:56] yoyoliliu |
projs:clans:docs:dataset_db_company_rank [2014/01/27 23:07] (current) yoyoliliu |
||
|---|---|---|---|
| Line 2: | Line 2: | ||
| Table: company_rank stores the PageRank of listed companies. | Table: company_rank stores the PageRank of listed companies. | ||
| ====== Data Schema ====== | ====== Data Schema ====== | ||
| - | ^ Field ^ Type ^ NULL ^Key ^Default ^Description ^ | + | ^ Field ^ Type ^ NULL ^Key ^Default ^Extra^ |
| | id | INT(11)| | | | the unique identifier of every record in this table| | | id | INT(11)| | | | the unique identifier of every record in this table| | ||
| - | | stock_id | INT(20) | | | | | | + | | stock_id | INT(20) | | | | foreign key from companyinfor| |
| - | | out | DOUBLE(20,10) | | | | | | + | | out | DOUBLE(20,10) | | | | the total weight of all the edge the stock_id link| |
| - | | pr| DOUBLE(20,10) | | | | | | + | | pr| DOUBLE(20,10) | | | | the pagerank value| |
| - | | sn | DOUBLE(20,10) | | | | | | + | | sn | DOUBLE(20,10) | | | | the pagerank value of last iteration| |
| | year | INT(11) | | | | | | | year | INT(11) | | | | | | ||
| ====== Record Example ====== | ====== Record Example ====== | ||
| + | ^id ^stock_id ^out ^pr ^sn ^year ^ | ||
| + | | 1 | 1 | 275.227338 | 0.0023965758 | 0.0023962873 | 2011 | | ||
| + | | 2 | 2 | 896.491072 | 0.0027156872 | 0.0027146824 | 2011 | | ||
| + | | 3 | 3 | 0.002334 | 6.2175e-05 | 6.2175e-05 | 2011 | | ||
| + | | 4 | 4 | 188.033596 | 0.0010019374 | 0.0010016491 | 2011 | | ||
| + | | 5 | 5 | 23.891249 | 0.0003777211 | 0.0003779822 | 2011 | | ||
| + | | 6 | 6 | 57.78583 | 0.0005844488 | 0.0005847818 | 2011 | | ||
| + | | 7 | 7 | 21.882441 | 0.0005939521 | 0.0005940207 | 2011 | | ||
| + | | 8 | 8 | 1.878604 | 0.0002534733 | 0.0002534821 | 2011 | | ||
| + | | 9 | 9 | 80.179004 | 0.0006854677 | 0.00068579 | 2011 | | ||
| + | | 10 | 10 | 51.704216 | 0.0010034586 | 0.0010035409 | 2011 | | ||
| + | |||
| ====== Change Log ====== | ====== Change Log ====== | ||
