Technical Information

GONIAT online is meant as a reference implementation of a paleontological database system. In this context GONIAT online is available as open source. The GONIAT online system is written in PHP5 and uses MySQL as database backend. The frontend makes use of the mootool JavaScript library. The system core is designed according to the Model-View-Controller paradigm. GONIAT has also be carefully designed to achieve the desired performance goals to be suitable as online research tools. Hierarchical structures such as the taxa and locations are organized according to the 'nested set' model (see here).

Data model


GONIAT online data model

Main entity types are tax,lit and loc, representing taxa, references and localities, respectively. The hierarchical structure of taxa is represented through the cat entitiy type, geographic structure of localities through geo. The three association entity types taxloc,taxlit and litloc connect the three main entity types. Taxa, which have morphological descriptions are associated with entities from morpha and optionally morphb. For more detailed information, please contact info-at-goniat-dot-org.