Nikita Noark 5 Core - H2 Console on http://localhost:8082/

[Ole Aamot]

I got a short introduction by Thomas Sødring to the Nikita Noark 5 Core
H2 Console today.

The H2 Console is available on Nikita Noark5 Core servers at

http://localhost:8082/

It is possible to do SQL queries on the console from a web browser.

The Noark 5 standard relations and the corresponding H2 tables are:

             Arkivdel  SERIES
                Arkiv  FONDS
          Arkivskaper  FONDS_CREATOR
          Avskrivning  SIGN_OFF
    Basisregistrering  BASIC_RECORD
  Dokumentbeskrivelse  DOCUMENT_DESCRIPTION
         Dokumentflyt  DOCUMENT_FLOW
       Dokumentobjekt  DOCUMENT_OBJECT
            Gradering  CLASSIFIED
          Journalpost  REGISTRY_ENTRY
            Kassasjon  DISPOSAL
     Kassasjonsvedtak  DISPOSAL_DECISION
               Klasse  CLASS
Klassifikasjonssystem  CLASSIFICATION_SYSTEM
                 Kode  CODE (missing table?)
         Konvertering  CONVERSION
   Korrespondansepart  CORRESPONDENCE_PART
       Kryssreferanse  CROSS_REFERENCE 
                Mappe  FILE
            Mappetype  FILE_TYPE
              Merknad  COMMENT
            Nøkkelord  KEYWORD
     Oppbevaringssted  STORAGE_LOCATION
            Presedens  PRECEDENCE
         Registrering  RECORD
            Saksmappe  CASE_FILE
             Sakspart  CASE_PARTY
            Skjerming  SCREENING
             Sletting  DELETION
               Tittel  TITLE (missing table?)

Why are CODE and TITLE not implemented as H2 database tables in Nikita?

They are mentioned in the dictionary in https://github.com/HiOA-ABI/nik
ita-noark5-core/blob/master/docs/general/dictionary.md

You can run SQL queries from the H2 Console on http://localhost:8082/
by launching Nikita Noark5 Core and after running the noark5-parser or
entering data in the web GUI at http://localhost:3000/

See https://lists.nuug.no/pipermail/nikita-noark/2017-June/000312.html
for details about how to install Nikita Noark5 Core and noark5-parser
and https://lists.nuug.no/pipermail/nikita-noark/2017-June/000306.html
for details about how to access the web GUI.

Example queries in the H2 Console on http://localhost:8082/

SELECT * FROM FONDS;
SELECT * FROM SERIES;

As we implement parsing of mappe, registrering, dokumentbeskrivelse,
dokumentobjekt and korrespondansepart in noark5-parser, it should be
possible to query the following H2 tables as well:

SELECT * FROM FILE;
SELECT * FROM DOCUMENT_DESCRIPTION;
SELECT * FROM CASE_FILE;

Happy hacking,
Ole
-- 
____/|
\ o.O|  Ole Aamot, oka at oka.no, http://oka.no/
 =(_)=
   U    "Meow!"