University of Passau, Germany
Chair of Scalable Database Systems
Michael Fruth, Kai Dauberschmidt,
Stefanie Scherzinger
ICDE 2021 - Demo
Josch: Managing Schemas
for NoSQL Document Stores
Josch is a cockpit application that combines schema extraction and checking for JSON Schema
containment of third-party-tools to exploit their interactions. It can be used for schema-less
NoSQL document stores, but is currently geared for MongoDB.
Josch.web is the web interface of Josch with its functionality being reduced to JSON Schema
containment using these third-party-tools.
The following features are available on the desktop version of Josch.
Extract a schema based on relative or absolute sampling with extraction tools.
Compare two JSON Schemas semantically using different containment tools.
Switch between both extraction and containment tools within the application.
Load, modify, or create JSON Schemas. Compare two JSON Schemas syntactically and highlight syntactical differences between them.
Store and browse historic JSON Schema versions. Add a personal note when storing and filter the JSON Schemas by the date of storing.
Validate all or individual JSON documents against a JSON Schema. Get the amount of valid documents and find those that do not validate. Furthermore, find out why the document fails validation.
Explore the available databases on a server and gain insight on the amount of collections each database has.
Explore the available collections per database and gain insight on the amount of present documents.
Show random document samples for a given collection. Edit and insert new documents into the collection.
Extract a MongoDB validator based on relative or absolute sampling.
Translate a given JSON Schema to a MongoDB validator.
Register a MongoDB validator at the database and use it for validation.