Skip to main content
padlock icon - secure page this page is secure

An Implementation of a Database Management System for Real-Time Large-Lake Observations

Buy Article:

$21.72 + tax (Refund Policy)


Real-time environmental observations have typically been stored in relatively inaccessible flat text files. In this publication, we present an instance of a PostgreSQL database management system to ingest real-time observations from four buoys in North America's western Lake Erie. Data are transmitted via a cellular data modem, initially archived as text data, and then ingested into the database for further analysis and retrieval. The database utilizes two tables with parallel structure to archive data in a consistent manner. We assign unique keys to instrumentation configurations as they change within and between monitoring seasons. Daily sets of data are linked to their configurations by key and thus are documented, allowing for efficient browsing of user desired data. In addition, we quality check data and archive the findings in a corresponding matrix. With assistance from server-side processing, we produce a web interface for the database. We hope the design of this database allows for relatively simple deployment in domains other than western Lake Erie.
No Reference information available - sign in for access.
No Citation information available - sign in for access.
No Supplementary Data.
No Article Media
No Metrics

Keywords: PostgreSQL; database; management; remote sensing

Document Type: Research Article

Publication date: November 1, 2017

More about this publication?
  • The Marine Technology Society Journal is the flagship publication of the Marine Technology Society. It publishes the highest caliber, peer-reviewed papers on subjects of interest to the society: marine technology, ocean science, marine policy and education. The Journal is dedicated to publishing timely special issues on emerging ocean community concerns while also showcasing general interest and student-authored works.
  • Editorial Board
  • Submit a Paper
  • Membership Information
  • Information for Advertisers
  • Ingenta Connect is not responsible for the content or availability of external websites
  • Access Key
  • Free content
  • Partial Free content
  • New content
  • Open access content
  • Partial Open access content
  • Subscribed content
  • Partial Subscribed content
  • Free trial content
Cookie Policy
Cookie Policy
Ingenta Connect website makes use of cookies so as to keep track of data that you have filled in. I am Happy with this Find out more