DBLP tables
From LiquidPubWiki
DBLP_ARTICLE (455096 records)
The columns are:
ARTICLE_ID NUMBER(10,0),
MDATE DATE,
KEY VARCHAR2(256 BYTE)
AUTHOR VARCHAR2(2048 BYTE),
BOOKTITLE VARCHAR2(2048 BYTE),
CDROM VARCHAR2(512 BYTE),
CITE VARCHAR2(4000 BYTE),
CROSSREF VARCHAR2(128 BYTE),
EDITOR VARCHAR2(1024 BYTE),
EE VARCHAR2(256 BYTE),
JOURNAL VARCHAR2(256 BYTE),
MONTH VARCHAR2(128 BYTE),
NOTE VARCHAR2(32 BYTE),
NUMBE VARCHAR2(32 BYTE),
PAGES VARCHAR2(48 BYTE),
PUBLISHER VARCHAR2(1024 BYTE),
TITLE VARCHAR2(2048 BYTE),
URL VARCHAR2(512 BYTE),
VOLUME VARCHAR2(256 BYTE),
YEAR NUMBER(4,0),
PRIMARY KEY ("ARTICLE_ID")
Here the field KEY is very important, this is unique code of any record regarding any contribution in DBLP For example journals/4or/AardalHKMS03 is the key, there are parts:
1. journals means that publication is in journal
2. 4or is the code of journal
3. AardalHKMS means the name of the first author (several first authors?)
4. 03 in the end means the year of publication,
despite we have all this information in the table explicitely just key field can tell us a lot.
DBLP_ARTICLES (1220276 records)
ARTICLE_ID NUMBER(10,0) KEY VARCHAR2(512 BYTE) PUBLISH_TYPE VARCHAR2(128 BYTE)
This is also synthetic table, summarizes all possible contributions, short representation of several tables. All contributions are here: journals, proceedings, whatever. Thats why we have field PUBLISH_TYPE which holds information about contribution. They are:
phdthesis book mastersthesis proceedings article www incollection inproceedings
DBLP_AUTHOR
AUTHOR_ID NUMBER(10,0) AUTHOR_NAME VARCHAR2(512 BYTE)
Simple one, synthetically created to link table about contributions and authors
Questions
- no
DBLP_ARTICLE_AUTHOR_L (3057711)
KEY VARCHAR2(512 BYTE) AUTHOR VARCHAR2(1024 BYTE)
KEY means the key of an article (or contribution) AUTHOR means name of an author, unique name
DBLP_ARTICLE_ARTICLE_L (just 109938 records, one million in ACM)
KEY VARCHAR2(512 BYTE) KEY_CITE VARCHAR2(512 BYTE)
Citation link table
DBLP_BOOK (1427)
BOOK_ID NUMBER(10,0) MDATE DATE KEY VARCHAR2(512 BYTE) AUTHOR VARCHAR2(2048 BYTE) BOOKTITLE VARCHAR2(2048 BYTE) CDROM VARCHAR2(512 BYTE) CITE VARCHAR2(4000 BYTE) EDITOR VARCHAR2(2048 BYTE) EE VARCHAR2(256 BYTE) ISBN VARCHAR2(64 BYTE) MONTH VARCHAR2(64 BYTE) PUBLISHER VARCHAR2(1024 BYTE) SERIES VARCHAR2(256 BYTE) TITLE VARCHAR2(2048 BYTE) URL VARCHAR2(1024 BYTE) VOLUME VARCHAR2(32 BYTE) YEAR NUMBER(4,0)
DBLP_INCOLLECTION (8957)
INCOLLECTION_ID NUMBER(10,0) MDATE DATE KEY VARCHAR2(256 BYTE) AUTHOR VARCHAR2(2048 BYTE) BOOKTITLE VARCHAR2(512 BYTE) CDROM VARCHAR2(128 BYTE) CHAPTER VARCHAR2(4 BYTE) CITE VARCHAR2(2048 BYTE) CROSSREF VARCHAR2(128 BYTE) EE VARCHAR2(128 BYTE) ISBN VARCHAR2(64 BYTE) PAGES VARCHAR2(32 BYTE) PUBLISHER VARCHAR2(512 BYTE) TITLE VARCHAR2(2048 BYTE) URL VARCHAR2(512 BYTE) YEAR NUMBER(4,0)
DBLP_INPROCEEDINGS (729686)
INPROCEEDINGS_ID NUMBER(10,0) MDATE DATE KEY VARCHAR2(512 BYTE) AUTHOR VARCHAR2(1024 BYTE) BOOKTITLE VARCHAR2(512 BYTE) CDROM VARCHAR2(128 BYTE) CITE VARCHAR2(2048 BYTE) CROSSREF VARCHAR2(128 BYTE) EDITOR VARCHAR2(1024 BYTE) EE VARCHAR2(512 BYTE) MONTH VARCHAR2(64 BYTE) NOTE VARCHAR2(128 BYTE) NUMBE VARCHAR2(32 BYTE) PAGES VARCHAR2(64 BYTE) TITLE VARCHAR2(1024 BYTE) URL VARCHAR2(2048 BYTE) YEAR NUMBER(4,0) ==
DBLP_MASTERSTHESIS (8)
MASTERSTHESIS_ID NUMBER(10,0) MDATE DATE KEY VARCHAR2(1024 BYTE) AUTHOR VARCHAR2(512 BYTE) SCHOOL VARCHAR2(128 BYTE) TITLE VARCHAR2(256 BYTE) URL VARCHAR2(256 BYTE) YEAR NUMBER(4,0)
DBLP_PHDTHESIS (90)
PHDTHESIS_ID NUMBER(10,0) MDATE DATE KEY VARCHAR2(1024 BYTE) AUTHOR VARCHAR2(512 BYTE) EE VARCHAR2(128 BYTE) ISBN VARCHAR2(128 BYTE) MONTH VARCHAR2(32 BYTE) NUMBE VARCHAR2(32 BYTE) PUBLISHER VARCHAR2(1024 BYTE) SCHOOL VARCHAR2(128 BYTE) SERIES VARCHAR2(32 BYTE) TITLE VARCHAR2(1024 BYTE) URL VARCHAR2(512 BYTE) VOLUME VARCHAR2(8 BYTE) YEAR NUMBER(4,0)
DBLP_PROCEEDING (11940)
PROCEEDINGS_ID NUMBER(10,0) MDATE DATE KEY VARCHAR2(512 BYTE) ADDRESS VARCHAR2(32 BYTE) AUTHOR VARCHAR2(512 BYTE) BOOKTITLE VARCHAR2(256 BYTE) CITE VARCHAR2(1024 BYTE) CROSSREF VARCHAR2(32 BYTE) EDITOR VARCHAR2(512 BYTE) EE VARCHAR2(128 BYTE) ISBN VARCHAR2(64 BYTE) JOURNAL VARCHAR2(32 BYTE) MONTH VARCHAR2(24 BYTE) NOTE VARCHAR2(512 BYTE) NUMBE VARCHAR2(16 BYTE) PUBLISHER VARCHAR2(512 BYTE) SERIES VARCHAR2(128 BYTE) TITLE VARCHAR2(2048 BYTE) URL VARCHAR2(512 BYTE) VOLUME VARCHAR2(64 BYTE) YEAR NUMBER(4,0)
DBLP_WWW (13183)
WWW_ID NUMBER(10,0) MDATE DATE KEY VARCHAR2(512 BYTE) AUTHOR VARCHAR2(512 BYTE) BOOKTITLE VARCHAR2(32 BYTE) CITE VARCHAR2(1024 BYTE) EDITOR VARCHAR2(256 BYTE) NOTE VARCHAR2(256 BYTE) TITLE VARCHAR2(256 BYTE) URL VARCHAR2(256 BYTE) YEAR NUMBER(4,0)
This are authors homepages/web resources.
KEY - ex: homepages/a/ShoshanaAnily - if you add http://dblp.uni-trier.de/rec/bibtex/ before the key, you will get bibtex with the data about the person, like at http://dblp.uni-trier.de/rec/bibtex/homepages/a/ShoshanaAnily.
Questions
- Why Author is null in select * from Krapivinm.DBLP_WWW where EDITOR is not null; ?
- These guys are probably not authors?
select * from Krapivinm.DBLP_WWW where TITLE!='Home Page';
