Database Software
CentriQS is multiuser database software which lets you create relational databases for any kind of business information and provides comprehensive data management solution that enables users to access and update the data simultaneously and manage large amounts of data efficiently.
- Make database software work the way your business works without adjusting your workflow to out-of-the-box solutions.
- Create your own CRM, CMS, HR, BPM, ERP software or any other custom application for your small business needs.
- Build your company database to record, store, manage, analyze and report any or many aspects of your business.
Database Structure
CentriQS Configurator lets you configure database structure in two modes. In entity configuration mode you can create custom entities (including their properties, tables and workflow), custom enums and custom OLAP cubes. In views configuration mode users can design the layout of main, detail, analytics and dashboard views of database entities.
Learn how to create custom database
Database Entity
Capture and store data of things, people, places, units, items, or any other business objects
Entity Properties
Add custom fields which let input data manually or calculate data automatically by expressions
Entity Workflow
Set entity states, transitions and reasons that describe entity life-cycle from creation to closing
Entity Tables
Build entity tables for storing sub-entity information in table format displayed in entity detail view
Database Enums
Create enumerated lists that can be used as pick-lists for properties of one or multiple entities
Database OLAP Cube
Configure OLAP cubes that can extract, transform and load data from entities to show in analytic views
Entity Main View
Set layout and save presets of single-row or multi-row spreadsheet view for entity data
Entity Detail View
Design custom forms with fields and tables for quick and easy inputting or updating required entity data
Related View
Set entity relationships and display main view of entities on detail view of related entities
Analytics View
Use OLAP cubes measures and dimensions to set layout and save presets of Pivot grid view
Chart View
Use chart wizard to design charts of various types for analytic data visualization
Dashboard View
Combine entity main views with analytic views and charts to show data in dashboard format
Prev.: Database Entity || Next: Database Entity
Next steps
{
Check out CentriQS FEATURES & SCREENSHOTS
Watch 7-minute CentriQS VIDEO OVERVIEW
Learn how to use CentriQS in KNOWLEDGE BASE
DOWNLOAD CentriQS 30-day Free Trial Version
CONTACT US to get help with CentriQS Database Design & Configuration