RelaX-db About Facts Model Patterns Contact
rapid application development

build your database app within minutes

build your db app within minutes

build your db app within minutes
Impressum
RelaX means Relational eXtension and is a new data model based on Complex Objects
to enable Rapid Application Development & Rapid Prototyping
fast, efficient and user friendly
generate a database application with only structure definition.
no programming- or html-knowledge required

Rapid Application Development with RelaX-db

Rapid Application Development with RelaX-db

RelaX-db is a set of tools & libraries for the RelaX data model to enable Rapid Application Development and Rapid Prototyping

Components:

define

Define the tables and complex objects and generate the sql-ddl statements for various database systems with the "rxmodel"-tool.

generate

define the form based on the model and generate the html-code for further refinement with the "rxgenerate"-tool

operate

operate the final html-form with a comprehensive set of functions bundled in the "rxclient"-library

serve

support the database functions and the file services for the AJAX-calls with the "rxserver"-components

See more on wikipedia

Facts

Facts

state of the art design and slim implementation come to a powerful system

fast

RelaX-db generates a single page application with slim AJAX-calls. Users experience fast responses with a minimum of server interaction

efficient

The app-designer specifies the structure of the database, the complex objects for the functions and the structure of the form. After these steps the app is running and can be tested

user friendly

The system features numerous comfort features like master-detail-interaction, lookups, calculated fields, schema trekking and arbitrary query parameters

compatible

RelaX-db supports major browsers like Chrome, Firefox and IE. It interacts with ORACLE, SQL-Server and MySQL on the database side. You only need a Node-JS-installation for the server components

RelaX Data Model

RelaX Data Model

RelaX means Relational eXtension

The RelaX data model combines multiple tables of a relational model into a complex object. The following picture lists 4 complex objects:
ordr, article, cust and agr

complex objects

Edit Tables are tables, that can be updated. They form a tree in a master-detail-form like order-items

Complex objects are divided into two sections:

edit

Edit Tables are tables, that can be updated. They form a tree in a master-detail-form like order-items

lookup

Each of the Edit Tables can have Lookup Tables in the form of a tree. Aliases allow lookups from different source tables

Rapid Application Development

Rapid Application Development

Supported Patterns

The structure of Complex Objects and corresponding User Interface Patterns enable Rapid Application Development with a minimum of declaration effort

master-detail

Master detail operation is served for search results and edit pages. Object binding via keys is automatically done by the system.

expand/collapse

Expand/Collapse functions enable user friendly administration of deeply structured master-detail objects.

navbar

A navigation bar is automatically generated from the list of complex object. Each complex object defines a navbar function.

search

Search and join logic of for the select statements is automatically generated from the structure of the relevant complex object.

lookup

Lookups enable comfort search options and key binding for alternative key fields. Lookups can be triggered by simple html-attributes.

resolve

Binding of an object to a lookup table can be achieved through lookups attributes. Attributes, which depends on the master are resolved automatically on change.

calculate

Calculated attributes can be used like singular database attributes. caculated attributes can be composed from different tables.

execute

The system can execute user defined procedures for special attributes on client. Order and cardinality of operation is handled by the system.

schema trekking

Navigation between the objects/functions can be achieved through simple calls, e.g. from an order to the associated customer.

file upload/download

Files can be treated as normal attributes and can be uploaded, downloaded and displayed in the web page.

inactive

The system sets master objects with active details to inactive on delete. After setting a customer to inactive, no more orders can be bound to this customer.

log

Changes on specific tables can be logged to a log table; this includes changes on file attributes.

user authentication

User authentication is supported and secured against XSS- and CSRF-attacs. External authentication systems can be integrated.

user authorization

Admins can assign roles for various RelaX-apps to the users. External authorization systems can be integrated.

role definition

Role permissions can be defined for each complex object. Users cannot see or exucute functions they are not assigned to.

Videos

Videos

Introduction

Introduction and Overview of the main characteristics
 

Sample Application

Description of the sample application "Order Management"
 

Navigation Bar & Search

Demo of Navigation Bar and Search Functions
 

Lookups, Resolve & Calculate

Demo of Lookups, Resolved and Calculated Attributes
 

Data Entry

Demo of Data Entry features
 

Schema Trekking

Schema Trekking enables navigation through the model
 

File Upload & Download

Demo of File Upload and Download functions
 

Inactive & Change Log

Demo of Inactive Objects and Change Log
 

becoming curious?

Contact Us

  +43 660 610 1789

  office@relax-db.com



Impressum:
Dipl. Ing. Franz Grandits
Schulgasse 24
A 7411 Markt Allhau