Copyright 2011-2017 Hauser Olsson GmbH.
Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.
CrNiCKL (pronounced "chronicle") is a database for time series written in Java running on top of SQL and NoSQL systems. This package provides a few demos.
Version 2.0.0 tracks changes in the Time2 Library t2 2.0.0
The distribution consists of three archives
crnickl-demo-x.y.z.jar
crnickl-demo-x.y.z-javadoc.jar
crnickl-demo-x.y.z-sources.jar
with compiled classes, HTML documentation, and sources. The version number
x.y.z follows the maven convention. The distribution also includes .asc
files with detached cryptographic signatures.
The recommended way is to use git for accessing the source and maven for building. The procedure is easy, as maven takes care of locating and downloading dependencies:
$ git clone https://github.com/jpvetterli/crnickl-demo.git
$ cd crnickl-demo
$ mvn install
This builds and installs the distribution JARs in your local maven
repository. They can also be found in the target directory.
When building the software by other means, the following dependencies must be addressed:
hsqldb-x.y.z.jarHyperSQL Databasesqltool-x.y.z.jarHyperSQL Databasebatik-awt-util-x.y.z.jarBatikbatik-svggen-x.y.z.jarBatikbatik-util-x.y.z.jarBatikjcommon-x.y.z.jarJCommonjfreechart-x.y.z.jarJFreeChartt2-x.y.z.jarTime2 Library
Replace all x.y.z with the actual version numbers which can be found in the
POM
file included in the binary JAR:
/META-INF/maven/ch.agent/crnickl-demo/pom.xml
The following command executes the default
demo:
$ mvn -q exec:exec
Database : sa@jdbc:hsqldb:mem:demodb
Value types (with base type) :
+-- Currency (Currency)
| +--
| +-- CNY - Yuan renminbi
[... lots of output removed ...]
(Everything after the first line is the output of the command.) The same can be done with:
$ mvn -q -Ddemo.mainClass=ch.agent.crnickl.demo.stox.StocksAndForexDemo \
-Ddemo.args="file=stox-text.parm,file=jdbc.parm" exec:exec
[... output removed ...]
Note: this was executed in a Unix shell, which supports line continuation with a backslash. In case your shell or command window does not do this, write the command as one long line.
Another demo produces some graphics:
$ mvn -q -Ddemo.mainClass=ch.agent.crnickl.demo.stox.StocksAndForexDemo \
-Ddemo.args="file=stox-graphic.parm,file=jdbc.parm" exec:exec
[... most output removed ...]
/tmp/FBI_KGB_raw.svg
/tmp/FBI_KGB_in_USD.svg
/tmp/FBI_KGB_in_USD_adj.svg
A third demo deals with time series of geo locations:
$ mvn -q -Ddemo.mainClass=ch.agent.crnickl.demo.geocoord.GeoCoordDemo \
-Ddemo.args="file=geo.parm" exec:exec
2012-04-09 09:00:00 5044km (machin)
2012-04-09 15:11:00 5651km (machin)
2012-04-09 21:33:20 8607km (truc)
[... lots of output removed ...]
The source is available on GitHub.
More information on CrNiCKL is available at the project web site.
Updated: 2017-10-06/jpv