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:
JOURNAL | C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/ROOT/bind/journal_table.txt |
ARTICLE | C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/ROOT/bind/articel_table.txt |
ART_AUT | C:/Program Files/Apache Software Foundation/Tomcat 6.0/webapps/ROOT/bind/art_aut_table.txt |
PERSON | C:/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.