new BindingDB logo

Update TABLES: JOURNAL, ARTICLE, ART_AUT, and PERSON

This program will rebuild four tables: JOURNAL, ARTICLE, ART_AUT, and PERSON. Column articleids in TABLES ARTICLE and ART_AUT are inherited from old DB, on the other hand, column journalids in TABLES JOURNAL and ARTICLE are regenerated, and columns authorids in TABLE ART_AUT and personids in TABLE PERSON are also regenerated. Now the indexes for an article are deposited in a file in C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/ROOT/data/article/, and its prefix is "article_", its suffix is ".dat", and its body is articleid. For instance, C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/ROOT/data/article/article_603.dat is the file holding index information for articleid of 603. The content of an index file for each line is listed as following:

  1. jour_name
  2. articleid
  3. title
  4. pmid
  5. volume
  6. year
  7. month
  8. day
  9. firstpage
  10. lastpage
  11. abstract
  12. institution
  13. firstname
  14. lastname
  15. firstname
  16. lastname
  17. repeating for firstname and lastname

Table Name vs.File Location
JOURNALC:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/ROOT/bind/journal_table.txt
ARTICLEC:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/ROOT/bind/articel_table.txt
ART_AUTC:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/ROOT/bind/art_aut_table.txt
PERSONC:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/ROOT/bind/person_table.txt

The contents of some TABLEs ought to be deleted before these TABLEs are rebuilt. Some constraint of some TABLEs ought to be dropped before the contents of some TABLEs can be deleted.

Sorry, you can only access this page from the intranet of University of Maryland Biotechnology Institute