About Wisdombase
WISDOMERA / WISDOMBASE

About Wisdombase

A document-oriented data platform that stores and manages project and layer data for WisdomEra applications.

Example: Patient, encounter, and operation data can be managed in separate layers.
Document-oriented database
WISDOMERA / WISDOMBASE

Document-oriented database

Each record is an independent document carrying its fields and nested lists together. Related information can therefore be read and updated as one unit.

Example: A patient document can store identity, status, and contact fields together.
Layer-based database
WISDOMERA / WISDOMBASE

Layer-based database

Similar documents are grouped in table-like layers. Layer parameters define fields, options, and queryable values.

Example: A Patient layer can hold unique patients while an Encounter layer stores multiple encounters.
SQL-like operations
WISDOMERA / WISDOMBASE

SQL-like operations

An SQL-like language selects fields, filters by conditions, counts, orders, and pages records in the selected layer.

Example: SELECT * FROM usr WHERE usr.[Status] = '1' LIMIT 25
Parameter indexing
WISDOMERA / WISDOMBASE

Parameter indexing

Queryable parameter values are indexed in the background. New or changed records may pass through a queue, so very recent changes can take a short time to appear in queries.

Example: Check ready layers, pending WDMRs, and last indexed time together in the performance report.
Project-based data management
WISDOMERA / WISDOMBASE

Project-based data management

Database units, domains, and visible applications are configured within project boundaries. Users operate only on authorized units and layers.

Example: Production and test data can be kept in separate database units.
Database units
WISDOMERA / WISDOMBASE

Database units

A database unit is the management boundary for related layers and documents. Expand it to view and select a target layer.

Example: Expand Production and select the User layer.
Layer structure
WISDOMERA / WISDOMBASE

Layer structure

The layer code is the technical identifier and the layer name is the display label. After selection, all tabs operate on the same target.

Example: After selecting the User layer with code usr, every tab works on usr.
Data list
WISDOMERA / WISDOMBASE

Data list

Shows layer records in pages. Locate records by key, label, client ID, or update time.

Example: Use Next for the next page and the edit icon to open a record.
WDMR list
WISDOMERA / WISDOMBASE

WDMR list

Displays WDMR documents and details; create, update, and rule-based listing actions depend on authorization.

Example: Select a record to inspect parameter values in the detail panel.
Parameters
WISDOMERA / WISDOMBASE

Parameters

Shows field definitions, data types, and options. Changes affect the data contract used to write and query this layer.

Example: Add active and passive options to Status and use their values in queries.
SQL query
WISDOMERA / WISDOMBASE

SQL query

Runs an SQL-like query on the selected layer. Codes can be used directly; names are enclosed in square brackets. LIMIT defaults to 100 and the server returns at most 500 results.

Example: SELECT usr.[Name] FROM usr WHERE usr.[Status] = '1' LIMIT 50
Settings
WISDOMERA / WISDOMBASE

Settings

Contains data and backup maintenance actions. Verify the selected unit and layer before clearing data or removing backups.

Example: Recheck the layer name and code before clearing a test layer.
Performance reports
WISDOMERA / WISDOMBASE

Performance reports

Combines request traffic, disk and RAM usage, compaction state, and parameter-index readiness for the selected server.

Example: Select a server first; all tabs refresh for that server.
Dashboard
WISDOMERA / WISDOMBASE

Dashboard

Provides a quick overview of disk usage, index RAM, cached rows, compaction, recent requests, and the index queue.

Example: Inspect the queue when pending jobs and oldest-pending age both increase.
Overview
WISDOMERA / WISDOMBASE

Overview

Shows the most requested services and state, layer, start time, and segments of active compaction.

Example: Compare a high-traffic service with concurrent compaction activity.
Parameter indexes
WISDOMERA / WISDOMBASE

Parameter indexes

Shows pending, ready, processing, writing, and failed queue jobs together with ready-layer and indexed-record totals.

Example: If failed jobs are non-zero, check last-indexed and queue timestamps.
Layer indexes
WISDOMERA / WISDOMBASE

Layer indexes

Shows engine, readiness, record and parameter counts, progress, disk size, and last indexed time per layer. Rebuild can target one or all layers.

Example: Use Rebuild on only the affected layer to leave other ready indexes untouched.
Layers
WISDOMERA / WISDOMBASE

Layers

Compares disk, RAM-index rows, request count, and compaction metrics by layer. Outside index cache means unavailable measurement, not zero records.

Example: Check whether high disk size and request count occur on the same layer.
Data query
WISDOMERA / WISDOMBASE

Data query

Opens the SQL-like editor after selecting a database unit and layer. Results appear in a table and wide tables can be viewed fullscreen.

Example: After selecting Production and User, run SELECT * FROM usr LIMIT 25.
Selecting a database unit
WISDOMERA / WISDOMBASE

Selecting a database unit

Determines the data boundary for the query. Changing the unit resets layer selection to prevent querying a layer from the previous unit.

Example: Select the Test unit before querying test data.
Selecting a layer
WISDOMERA / WISDOMBASE

Selecting a layer

Selects the target layer through a searchable control. The editor opens only when both unit and layer are selected.

Example: Search by layer name or code and select usr.
Query area
WISDOMERA / WISDOMBASE

Query area

Used to write, validate, and run queries, view results, and reuse browser-local query history. Clause order is SELECT, FROM, WHERE, ORDER BY, LIMIT, OFFSET. LIMIT defaults to 100 and is capped at 500. Large text values can be output-only and unavailable for filtering.

Example: SELECT usr.[Name] FROM usr WHERE usr.[Status] IN ('1','2') ORDER BY usr.[Name] ASC LIMIT 50