Data

Article • 29.12.2018 • 4 minute(s) to read

This article and its entire content are awaiting approval and will be released soon. You can get support for custom app development by asking questions in the forum; most questions get answered fairly quickly. Please do not use the contact form or private messages for technical support questions about building custom apps with the Novunex Platform.

The purpose of this page is to provide information of the data management and data infratructure capabilities of the Novunex Platform.

Relational Data

Entities, Attributes and Entity Types

The Novunex Platform organizes and stores relational data in Entities, Attributes and Entity Types.

  • Entity Types can be referred to as a tables
  • Columns of the table are called Attributes of the Entity Type
  • Attributes of an Entity Type can be freely configured
  • An Attribute is always assigned one Data Types (e.g. integer, decimals, texts)
  • An Entity as as a row in the Entity Types table
Relational Infrastructure

The Novunex Platform facilitates one SQL Database for all Entities and Data Records per Account. The platform handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. The Novunex Platform is always running on the latest stable version of the SQL Server database engine and patched OS.

In general, this is a highly available and high-performance data storage layer for all Process and data requirements. Novunex handles all patching and updating of the SQL and operating system code. You don’t have to manage the underlying infrastructure.

SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes. It provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options. These capabilities allow you to focus on rapid app development and accelerating your time-to-market, rather than on managing virtual machines and infrastructure.

Data Performance and Data Isolation of Relational Data

Each database is isolated from others and therefore relational customer data is always isolated. Each database has its own amount of compute, memory, and storage resources. The amount of the resources assigned to the database is based on the service tier dedicated to that database.

Databases can dynamically scale resources up and down. Dynamic scalability enables your database to transparently respond to rapidly changing resource requirements. You pay for only the resources that you need when you need them.

Relational Data Availability

Novunex Platform SQL Databases enable your business to continue operating during disruptions. In a traditional SQL Server environment, you generally have at least two machines locally set up. These machines have exact, synchronously maintained, copies of the data to protect against a failure of a single machine or component. This environment provides high availability, but it doesn’t protect against a natural disaster destroying your datacenter.


In fact, our service level agreements (SLA) with our hosting partners help to keep your Novunex app running 24/7 - in multiple co-hosting locations. We manage every database reducing the risk of data loss to a minimum and percentage of data availability to a maximum. Novunex and with its hosting locations automatically handles patching, backups, replication, failure detection, underlying potential hardware, software or network failures, deploying bug fixes, failovers, database upgrades, and other maintenance tasks. Availability is achieved by a separation of compute and storage layers.

Files and Binary Data

Files or binary data is stored in isolated, customer specific storage containers. Durable and highly available. Redundancy ensures that files are safe in the event of transient hardware failures. Data replicated remains highly available in the event of an unexpected outage.

  • All data written to an storage container is encrypted by the service (by default).
  • Novunex Platform has a fine-grained control over who has access to your data
  • The storage is designed to be scalable to meet the data storage and performance needs of today’s applications
  • Novunex and its hosting partners handle hardware maintenance, updates, and critical issues for you
  • Data in Novunex storage is accessible from anywhere in the world over HTTPS and the Novunex Platform

More information

  • General Reference on Entity Types
  • About Serial Numbers
  • General Reference on Data Queries
  • About the Data Editor
  • About the Data Explorer
  • About the File Explorer

  • An Entity Type defines the data representation in Novunex. For different data, different Entity Types need to be defined.

    Learn more

    Serial Numbers provide unique identifiers specified by a Definition or from a pre-defined list.

    Learn more

    SQL based Data Queries to access the database directly or to create reports based on templates.

    Learn more

    The Data Editor allows the viewing and editing of Entities via the Administration interface. General reference of the Data Editor

    Learn more

    The Data Explorer allows the viewing of Entities and Data Records in a read-only mode.

    Learn more

    The File Explorer provides an administrator or priviliged user a backend interface to view files without the need for Dashboards or Processes

    Learn more