64 lines
2.8 KiB
Plaintext
64 lines
2.8 KiB
Plaintext
List of relations
|
|
Schema | Name | Type | Size
|
|
--------+--------------------------+-------+----------
|
|
public | acm98class | table | 0
|
|
public | acmclassview | view | 0
|
|
public | author | table | 0
|
|
public | citation | table | 1534842
|
|
public | conference | table | 0
|
|
public | dbpediaresource | table | 0
|
|
public | dbpediaresourceacronym | table | 0
|
|
public | dbpediaresourcecategory | table | 0
|
|
public | entitysimilarity | table | 0
|
|
public | entitytopicdistribution | table | 0
|
|
public | expdiagnostics | table | 0
|
|
public | experiment | table | 0
|
|
public | journal | table | 0
|
|
public | pprlinks | table | 0
|
|
public | pprpubcitationsimilarity | table | 0
|
|
public | project | table | 170478
|
|
public | pubacmcategory | table | 0
|
|
public | pubauthor | table | 0
|
|
public | pubcitation | table | 5422408
|
|
public | pubcitationppralias | table | 0
|
|
public | pubconference | table | 0
|
|
public | pubdbpediaresource | table | 0
|
|
public | pubfulltext | table | 418833
|
|
public | pubjournal | table | 0
|
|
public | pubkeyword | table | 2806149
|
|
public | publication | table | 448880
|
|
public | pubpdbcode | table | 39575
|
|
public | pubproject | table | 755064
|
|
public | pubtopic | table | 0
|
|
public | pubview | view | 448783
|
|
public | pubviewdbpedia | view | 0
|
|
public | pubviewfunding | view | 448783
|
|
public | pubviewsideinfo | view | 448783
|
|
public | pubviewtxt | view | 448880
|
|
public | topicanalysis | table | 0
|
|
public | topicdescription | table | 0
|
|
public | topicdescriptionview | view | 0
|
|
public | topicdetails | table | 0
|
|
public | topickeyphrase | table | 0
|
|
public | topicsimilarity | table | 0
|
|
public | topicvector | table | 0
|
|
public | wordvector | table | 0
|
|
(42 rows)
|
|
|
|
Not Empty TABLES : citation, project, pubcitation, pubfulltext, pubkeyword, publication, pubpdbcode, pubproject
|
|
|
|
Not Empty VIEWS : pubview, pubviewfunding, pubviewsideinfo, pubviewtxt
|
|
|
|
Entities : project, publication, citation
|
|
Rels between entities : pubcitation, pubproject
|
|
Other rels : pubfulltext, pubkeyword, pubpdbcode
|
|
|
|
|
|
|
|
|
|
for line in `gunzip -c pubmed.json.gz | head -n 1000 | jq '.body["$binary"]' | sed 's/"//g'`; do echo $line | base64 -d | gunzip -c ; done | less
|
|
|
|
|
|
|
|
|