Simple and practical techniques to manage small databases, illustrated by a case study: bibliographic data from the " Fossil Cnidaria & Porifera " newsletter (1972-2010)
Author(s) -
Katarzyna ZALECKA
Publication year - 2015
Publication title -
carnets de géologie (notebooks on geology)
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.263
H-Index - 15
eISSN - 1765-2553
pISSN - 1634-0744
DOI - 10.4267/2042/56249
Subject(s) - cnidaria , simple (philosophy) , computer science , anthozoa , data science , database , world wide web , coral , oceanography , geology , philosophy , epistemology
Small databases, i.e., with less than 15,000 entries, are sometimes handled using inappropriate, complex, and often expensive data management systems. We present and briefly discuss a few types of proprietary and open-source, relational and non-relational, server-based versus portable databases and specific tools to handle the latter. With a collection of nearly 7,000 bibliographic notes during its 40-year history "Fossil Cnidaria & Porifera (FCP accordingly, the concern about the data representativeness is addressed in our interpretation. Besides the classical database management systems and spreadsheet software, which were originally used with the FC&P case study, we present two discrete, open-source, flat and portable options where data can be displayed using any widely available Internet browser, and that are suitable to handle most small databases (XML or JS files) as documented herein.
Accelerating Research
Robert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom
Address
John Eccles HouseRobert Robinson Avenue,
Oxford Science Park, Oxford
OX4 4GP, United Kingdom