International Geologiical Congress - Oslo 2008


Search Abstracts

Author Index

Symposia Programmes





IEI-06 Data models and architectures


A relational data model for active fault database of Japan and its reconstruction to an object oriented model for XML schema


Yuichiro Fusejima, Geological Survey of Japan, AIST (Japan)


Active Fault Database of Japan ( contains information of active faults in Japan. Faults shown on the index map are linked to a database, which contains information of geologic and paleo-seismic parameters including slip rate, slip per event, recurrence interval, and calculated rupture probability in the future. All those data are compiled from journal articles, theses, and other documents on a well discussed relational data model.
The database keeps be constructed from 2002 by the Active Fault Research Center, Geological Survey of Japan / AIST. The first edition of the database was launched to the Internet at March 2005, as a part of Research Information Database (RIO-DB), which is managed by National Institute of Advanced Industrial Science and Technology (AIST). By its relational database management system (RDBMS). ORACLE 10g, and on various web browsers, many users could gat easily many information.
The constructing of the relational data model is based on general structure of journal articles that describing active faults, since the titles of constitutive entities / tables are, Survey, Locality, Horizon, Displacement, Event, Discussion , Figure and References. Totally 65 tables are defined, then many attributes and there data types, domains and other specifications are defined. For appending code numbers of legend on these attributes, we constructed many other tables. Another attributes describing meta-data are also defined. There all tables are connected by relationships, and they were normalized.
Based on the data model, we constructed a data input user interface system on a RDBMS, MS-Access. Then many data were inputted stepwise by the input system on the system. The database is implemented the flexible searching functions, which provide searching on composite key words, advanced search and changing order of data by composite attributes.
Coincidentally, into the database of the Japanese edition, many field data are collected from over a million number of research locality. Furthermore on the Japanese edition, we show meta data, bibliographies, figures, chronostratigraphies and more detail information. I am currently translating the Japanese edition into English besides developing further revised edition which is subjoined data analytical functions, GIS functions and more.
On recent technologies, the subjoining of a function is not only by an implementation to the own system, but also a web service from other inter-operative systems, such as Service Oriented Architecture (SOA). The SOA requires automatically exchanging of data on some XML Schemas, constructed on object oriented models. From the reason, I am currently constructing an object oriented model for active fault data through an R-O mapping of the active fault relational data model. Then the model will be reconstructed to conjoin with GML, GeoSciML, QuakeML and other relative XML Schemas.


CD-ROM Produced by X-CD Technologies