You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
248 lines
11 KiB
HTML
248 lines
11 KiB
HTML
2 years ago
|
<!DOCTYPE html>
|
||
|
|
|
||
|
|
<html >
|
||
|
|
<head>
|
||
|
|
<meta charset="utf-8" />
|
||
|
|
<title>Database — SeisComP Release documentation</title>
|
||
|
|
<link rel="stylesheet" href="../../_static/pygments.css" type="text/css" />
|
||
|
|
<link rel="stylesheet" href="../../_static/seiscomp.css" type="text/css" />
|
||
|
|
<link rel="stylesheet" type="text/css" href="../../_static/graphviz.css" />
|
||
|
|
<script type="text/javascript" src="../../_static/seiscomp.js"></script>
|
||
|
|
<script type="text/javascript" id="documentation_options" data-url_root="../../" src="../../_static/documentation_options.js"></script>
|
||
|
|
<script src="../../_static/jquery.js"></script>
|
||
|
|
<script src="../../_static/underscore.js"></script>
|
||
|
|
<script src="../../_static/doctools.js"></script>
|
||
|
|
<script src="../../_static/language_data.js"></script>
|
||
|
|
<link rel="shortcut icon" href="../../_static/favicon.ico"/>
|
||
|
|
<link rel="index" title="Index" href="../../genindex.html" />
|
||
|
|
<link rel="search" title="Search" href="../../search.html" />
|
||
|
|
<link rel="next" title="Waveform archives" href="waveformarchives.html" />
|
||
|
|
<link rel="prev" title="SeisComP plugins" href="plugins.html" />
|
||
|
|
</head>
|
||
|
|
<body>
|
||
|
|
<div class="header">
|
||
|
|
<div class="container">
|
||
|
|
<div class="brand">
|
||
|
|
<img class="logo" src="../../_static/brands/seiscomp/text/white.svg"/>
|
||
|
|
<!-- span class="title">SeisComP Release</span -->
|
||
|
|
<span class="version">5.3.0</span>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div class="nav">
|
||
|
|
<div class="container">
|
||
|
|
<div class="content"><a class="pull-right" id="sidebar-toggle">TOC</a>
|
||
|
|
|
||
|
|
<div class="related" role="navigation" aria-label="related navigation">
|
||
|
|
<ul>
|
||
|
|
<li class="right">
|
||
|
|
<a href="../../genindex.html" title="General Index"
|
||
|
|
accesskey="I">
|
||
|
|
index
|
||
|
|
</a>
|
||
|
|
</li>
|
||
|
|
<li class="right">
|
||
|
|
<a href="waveformarchives.html" title="Waveform archives"
|
||
|
|
accesskey="N">
|
||
|
|
next
|
||
|
|
</a>
|
||
|
|
</li>
|
||
|
|
<li class="right">
|
||
|
|
<a href="plugins.html" title="SeisComP plugins"
|
||
|
|
accesskey="P">
|
||
|
|
previous
|
||
|
|
</a>
|
||
|
|
</li>
|
||
|
|
<li class="nav-item nav-item-0">
|
||
|
|
<a href="../../index.html">Home</a>
|
||
|
|
</li>
|
||
|
|
<li class="nav-item nav-item-1">
|
||
|
|
<a href="../concepts.html" accesskey="U">Concepts</a>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div class="container">
|
||
|
|
<div class="fitted content" id="anchors-container">
|
||
|
|
<div class="body" role="main">
|
||
|
|
|
||
|
|
<div class="section" id="database">
|
||
|
|
<span id="concepts-database"></span><h1>Database<a class="headerlink" href="#database" title="Permalink to this headline">¶</a></h1>
|
||
|
|
<div class="section" id="scope">
|
||
|
|
<h2>Scope<a class="headerlink" href="#scope" title="Permalink to this headline">¶</a></h2>
|
||
|
|
<p>This chapter provides an overview over supported databases.</p>
|
||
|
|
</div>
|
||
|
|
<div class="section" id="overview">
|
||
|
|
<h2>Overview<a class="headerlink" href="#overview" title="Permalink to this headline">¶</a></h2>
|
||
|
|
<p><cite>SeisComP</cite> can store and read information from a relational database management
|
||
|
|
system (RDBMS). Supported are basically all existing RDBMS for which a plugin
|
||
|
|
can be written. Currently, <a class="reference internal" href="plugins.html#concepts-plugins"><span class="std std-ref">database plugins</span></a> are
|
||
|
|
provided for</p>
|
||
|
|
<table class="colwidths-given docutils align-left">
|
||
|
|
<colgroup>
|
||
|
|
<col style="width: 50%" />
|
||
|
|
<col style="width: 50%" />
|
||
|
|
</colgroup>
|
||
|
|
<thead>
|
||
|
|
<tr class="row-odd"><th class="head"><p>Database</p></th>
|
||
|
|
<th class="head"><p>Plugin Name</p></th>
|
||
|
|
</tr>
|
||
|
|
</thead>
|
||
|
|
<tbody>
|
||
|
|
<tr class="row-even"><td><p>MySQL / MariaDB</p></td>
|
||
|
|
<td><p><em>dbmysql</em></p></td>
|
||
|
|
</tr>
|
||
|
|
<tr class="row-odd"><td><p>PostgreSQL</p></td>
|
||
|
|
<td><p><em>dbpostgresql</em></p></td>
|
||
|
|
</tr>
|
||
|
|
<tr class="row-even"><td><p>SQLite3</p></td>
|
||
|
|
<td><p><em>dbsqlite</em></p></td>
|
||
|
|
</tr>
|
||
|
|
</tbody>
|
||
|
|
</table>
|
||
|
|
<p>The database used by the messaging for reading and writing is configured with
|
||
|
|
<a class="reference internal" href="../../apps/scmaster.html#scmaster"><span class="std std-ref">scmaster</span></a>. The read connection by <a class="reference internal" href="modules.html#concepts-modules"><span class="std std-ref">modules</span></a> may be
|
||
|
|
additionally set with <a class="reference internal" href="../../apps/global.html#confval-database"><code class="xref std std-confval docutils literal notranslate"><span class="pre">database</span></code></a> in
|
||
|
|
<a class="reference internal" href="../../apps/global.html#global-configuration"><span class="std std-ref">global configuration</span></a>.
|
||
|
|
Read the sections <a class="reference internal" href="../installation.html#installation"><span class="std std-ref">SeisComP Installation</span></a> and <a class="reference internal" href="../getting-started.html#getting-started"><span class="std std-ref">Getting Started with SeisComP</span></a> on the
|
||
|
|
installation and the configuration of the database backend and the initial setup
|
||
|
|
of the database itself, respectively.</p>
|
||
|
|
<p>The used database schema is well defined and respected by all modules which
|
||
|
|
access the database. It is similar to the SeisComML schema (<a class="reference internal" href="../glossary.html#term-scml"><span class="xref std std-term">SCML</span></a>,
|
||
|
|
a version of XML) and the C++ / Python class hierarchy of the datamodel
|
||
|
|
namespace / package.</p>
|
||
|
|
<p>Information of the following objects can be stored in the database as set out in
|
||
|
|
the <a class="reference internal" href="../api-python.html#api-datamodel-python"><span class="std std-ref">documentation of the data model</span></a>.</p>
|
||
|
|
<table class="colwidths-given docutils align-left">
|
||
|
|
<colgroup>
|
||
|
|
<col style="width: 25%" />
|
||
|
|
<col style="width: 75%" />
|
||
|
|
</colgroup>
|
||
|
|
<thead>
|
||
|
|
<tr class="row-odd"><th class="head"><p>Object</p></th>
|
||
|
|
<th class="head"><p>Description</p></th>
|
||
|
|
</tr>
|
||
|
|
</thead>
|
||
|
|
<tbody>
|
||
|
|
<tr class="row-even"><td><p><a class="reference internal" href="configuration.html#concepts-configuration"><span class="std std-ref">Config</span></a></p></td>
|
||
|
|
<td><p>station bindings</p></td>
|
||
|
|
</tr>
|
||
|
|
<tr class="row-odd"><td><p>DataAvailability</p></td>
|
||
|
|
<td><p>information on continuous data records</p></td>
|
||
|
|
</tr>
|
||
|
|
<tr class="row-even"><td><p>EventParameters</p></td>
|
||
|
|
<td><p>derived objects like picks, amplitudes, magnitudes origins, events, etc.</p></td>
|
||
|
|
</tr>
|
||
|
|
<tr class="row-odd"><td><p><a class="reference internal" href="inventory.html#concepts-inventory"><span class="std std-ref">Inventory</span></a></p></td>
|
||
|
|
<td><p>station meta data</p></td>
|
||
|
|
</tr>
|
||
|
|
<tr class="row-even"><td><p>Journaling</p></td>
|
||
|
|
<td><p>information on commands and actions e.g. by <a class="reference internal" href="../../apps/scevent.html#scevent-journals"><span class="std std-ref">scevent</span></a></p></td>
|
||
|
|
</tr>
|
||
|
|
<tr class="row-odd"><td><p>QualityControl</p></td>
|
||
|
|
<td><p>waveform quality control parameters</p></td>
|
||
|
|
</tr>
|
||
|
|
</tbody>
|
||
|
|
</table>
|
||
|
|
<div class="admonition note">
|
||
|
|
<p class="admonition-title">Note</p>
|
||
|
|
<p>The Config parameters just cover station bindings. Application/module specific
|
||
|
|
configurations (all .cfg files) are not stored in the database and only kept
|
||
|
|
in files.</p>
|
||
|
|
</div>
|
||
|
|
<p>The currently supported version of the database schema can be queried by any
|
||
|
|
module connecting to the data base using the option <code class="docutils literal notranslate"><span class="pre">-V</span></code>, e.g.:</p>
|
||
|
|
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>$ scolv -V
|
||
|
|
|
||
|
|
Framework: 5.0.0 Development
|
||
|
|
API version: 15.0.0
|
||
|
|
Data schema version: 0.12
|
||
|
|
GIT HEAD: 9f5c26cc4
|
||
|
|
Compiler: c++ (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0
|
||
|
|
Build system: Linux 4.15.0-163-generic
|
||
|
|
OS: Ubuntu 18.04.6 LTS / Linux
|
||
|
|
</pre></div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div class="section" id="related-modules">
|
||
|
|
<h2>Related Modules<a class="headerlink" href="#related-modules" title="Permalink to this headline">¶</a></h2>
|
||
|
|
<ul class="simple">
|
||
|
|
<li><p><a class="reference internal" href="../../apps/scardac.html#scardac"><span class="std std-ref">scardac</span></a></p></li>
|
||
|
|
<li><p><a class="reference internal" href="../../apps/scdb.html#scdb"><span class="std std-ref">scdb</span></a></p></li>
|
||
|
|
<li><p><a class="reference internal" href="../../apps/scdbstrip.html#scdbstrip"><span class="std std-ref">scdbstrip</span></a></p></li>
|
||
|
|
<li><p><a class="reference internal" href="../../apps/scdispatch.html#scdispatch"><span class="std std-ref">scdispatch</span></a></p></li>
|
||
|
|
<li><p><a class="reference internal" href="../../apps/scquery.html#scquery"><span class="std std-ref">scquery</span></a></p></li>
|
||
|
|
<li><p><a class="reference internal" href="../../apps/scqueryqc.html#scqueryqc"><span class="std std-ref">scqueryqc</span></a></p></li>
|
||
|
|
<li><p><a class="reference internal" href="../../apps/scxmldump.html#scxmldump"><span class="std std-ref">scxmldump</span></a></p></li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
|
||
|
|
<div id="anchors-bottom"></div>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<div class="sidebar" role="navigation" aria-label="main navigation">
|
||
|
|
<div id="anchors-top"></div>
|
||
|
|
<div id="anchors" class="content">
|
||
|
|
<div id="searchbox" style="display: none" role="search">
|
||
|
|
<h3 id="searchlabel">Quick search</h3>
|
||
|
|
<div class="searchformwrapper">
|
||
|
|
<form class="search" action="../../search.html" method="get">
|
||
|
|
<input type="text" name="q" aria-labelledby="searchlabel" />
|
||
|
|
<input type="submit" value="Go" />
|
||
|
|
</form>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<script>$('#searchbox').show(0);</script>
|
||
|
|
<h3><a href="../../index.html">Table of Contents</a></h3>
|
||
|
|
<ul>
|
||
|
|
<li><a class="reference internal" href="#">Database</a><ul>
|
||
|
|
<li><a class="reference internal" href="#scope">Scope</a></li>
|
||
|
|
<li><a class="reference internal" href="#overview">Overview</a></li>
|
||
|
|
<li><a class="reference internal" href="#related-modules">Related Modules</a></li>
|
||
|
|
</ul>
|
||
|
|
</li>
|
||
|
|
</ul>
|
||
|
|
|
||
|
|
<h4>Previous topic</h4>
|
||
|
|
<p class="topless"><a href="plugins.html"
|
||
|
|
title="previous chapter">SeisComP plugins</a></p>
|
||
|
|
<h4>Next topic</h4>
|
||
|
|
<p class="topless"><a href="waveformarchives.html"
|
||
|
|
title="next chapter">Waveform archives</a></p>
|
||
|
|
<div role="note" aria-label="source link">
|
||
|
|
<h3>This Page</h3>
|
||
|
|
<ul class="this-page-menu">
|
||
|
|
<li><a href="../../_sources/base/concepts/database.rst.txt"
|
||
|
|
rel="nofollow">Show Source</a></li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<div class="footer">
|
||
|
|
<div class="container">
|
||
|
|
<div class="horizontal layout content">
|
||
|
|
<a class="fade-in" href="https://www.gempa.de" target="_blank">
|
||
|
|
<img class="brand" src="../../_static/brands/gempa.svg"/>
|
||
|
|
</a>
|
||
|
|
<div class="stretched align-center fitted content">
|
||
|
|
<div>
|
||
|
|
Version <b>5.3.0</b> Release
|
||
|
|
</div>
|
||
|
|
<div class="copyright">
|
||
|
|
Copyright © gempa GmbH, GFZ Potsdam.
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
<a class="fade-in" href="https://www.gfz-potsdam.de" target="_blank">
|
||
|
|
<img class="brand" src="../../_static/brands/gfz.svg"/>
|
||
|
|
</a>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</div>
|
||
|
|
</body>
|
||
|
|
</html>
|