Functions | JACAMAR - In-Memory Database

The Meta Model

Graphical Meta Model

The Meta Model is not visible to the business users but serves the IT department or the administrators as an overview of the database and business model that has been created. It is here you can attach simple relationships between individual data sets. Each “barrel” represents an object type, such as a product or a supplier of a company and the properties are mapped within it. You can quickly create the structure of a database, however many options are available for individual design.

View-Design

Working with Multiple Tables Simultaneously

Views are used for creating, processing and presentation of data.

There are different types of views, simple views which look like flat lists. Then there are cascaded views which can fold out in a tree structure and thus clearly represent relationships in a tabular form. There are also subviews that can display detailed information on data elements in a separate window, and all views can be divided according to their function in sections.

Colour

Colour Coding

In JACAMAR colour can be used to highlight or to differentiate between lines in a view, for individual cells or cell ranges and also in the Meta Model. That is to say that multiple lines of data elements can be coloured differently and the individual user can decide and display each view to their requirements.

Column Functions

Filtered and Sorted View

The filter function allows the flexible display of records for each user. The quick filter picks out individual records using a proposal list and complex filters can be created with multiple conditions across various branches in a cascaded view. Parametric filters can also be stored centrally and this enables the selection of relevant records in an initial view and can be included in any views.

The column sort function can be easily activated and sorts the records into ascending or descending order.

Importing and Exporting of Data

Import
Data can be easily copied and pasted from one table and inserted into a view.
An intelligent import function automates repetitive tasks and parameters such as column titles can be imported together with the table of data.

Export
Views and their structures can be edited on the screen and exported as you see them, resulting in a comma separated value (csv) file being created.

In addition, the entire repository can be exported as a *.zip file and used on other devices again.

Concept of Roles

Roles and Privileges

The role concept allows you to assign edit, read and no read privileges to different users and user groups within a project, thus managing protected and public data with a uniformed structure in a single repository. The privileges can be applied separately to a view and to the lines, columns and cells within a view and also to the specific elements of the business Meta Model such as the object types, properties and relations.

Multiple user roles also enables administrators to switch roles to carry out their daily work without affecting other users.