title: PDBj Mine: design and implementation of relational database interface for Protein Data Bank Japan.
abstract: 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/
authors.affiliation: Protein Data Bank Japan, Institute for Protein Research, Osaka University, 3-2 Yamadaoka, Suita, Osaka 565-0871, Japan. akinjo@protein.osaka-u.ac.jp
authors.forename: Akira R
authors.initials: AR
authors.lastname: Kinjo
authors.forename: Reiko
authors.initials: R
authors.lastname: Yamashita
authors.forename: Haruki
authors.initials: H
authors.lastname: Nakamura
mesh_terms: D030562:Databases, Protein; D020407:Internet; D007564:Japan; D011381:Programming Languages; D014584:User-Computer Interface
references.citation: Nat Biotechnol. 2007 Aug;25(8):845-6; author reply 846
references.pmid: 17687352
references.citation: Nucleic Acids Res. 2004 Jan 1;32(Database issue):D129-33
references.pmid: 14681376
references.citation: Bioinformatics. 2004 May 22;20(8):1329-30
references.pmid: 14871866
references.citation: Nucleic Acids Res. 2005 Jan 1;33(Database issue):D154-9
references.pmid: 15608167
references.citation: Bioinformatics. 2000 Feb;16(2):159-68
references.pmid: 10842738
references.citation: Bioinformatics. 2005 Apr 1;21(7):988-92
references.pmid: 15509603
references.citation: Nucleic Acids Res. 2007 Jan;35(Database issue):D301-3
references.pmid: 17142228
references.citation: Nucleic Acids Res. 1997 Sep 1;25(17):3389-402
references.pmid: 9254694