PDBj Mine: design and implementation of relational database interface for Protein Data Bank Japan.
This article is a tutorial for PDBj Mine, a new database and its interface for Protein Data Bank Japan (PDBj). In PDBj Mine, data are loaded from files in the PDBMLplus format (an extension of PDBML, PDB's canonical XML format, enriched with annotations), which are then served for the user of PDBj via the worldwide web (WWW). We describe the basic design of the relational database (RDB) and web interfaces of PDBj Mine. The contents of PDBMLplus files are first broken into XPath entities, and these paths and data are indexed in the way that reflects the hierarchical structure of the XML files. The data for each XPath type are saved into the corresponding relational table that is named as the XPath itself. The generation of table definitions from the PDBMLplus XML schema is fully automated. For efficient search, frequently queried terms are compiled into a brief summary table. Casual users can perform simple keyword search, and 'Advanced Search' which can specify various conditions on the entries. More experienced users can query the database using SQL statements which can be constructed in a uniform manner. Thus, PDBj Mine achieves a combination of the flexibility of XML documents and the robustness of the RDB. Database URL: http://www.pdbj.org/
Kinjo
Akira R
AR
Protein Data Bank Japan, Institute for Protein Research, Osaka University, 3-2 Yamadaoka, Suita, Osaka 565-0871, Japan. akinjo@protein.osaka-u.ac.jp
Yamashita
Reiko
R
Nakamura
Haruki
H
D030562:Databases, Protein; D020407:Internet; D007564:Japan; D011381:Programming Languages; D014584:User-Computer Interface
Nat Biotechnol. 2007 Aug;25(8):845-6; author reply 846
17687352
Nucleic Acids Res. 2004 Jan 1;32(Database issue):D129-33
14681376
Bioinformatics. 2004 May 22;20(8):1329-30
14871866
Nucleic Acids Res. 2005 Jan 1;33(Database issue):D154-9
15608167
Bioinformatics. 2000 Feb;16(2):159-68
10842738
Bioinformatics. 2005 Apr 1;21(7):988-92
15509603
Nucleic Acids Res. 2007 Jan;35(Database issue):D301-3
17142228
Nucleic Acids Res. 1997 Sep 1;25(17):3389-402
9254694