Custom Database Creation

CentriQS allows users to create and design custom databases for any kind of business functions: inventory, financials, sales, customers, etc. Custom databases can include custom entities with custom properties that support all available data types including texts, numbers, images, select lists, check boxes, date pickers, etc. Also users can create custom OLAP cubes for extracting, transforming and loading data from custom entities.

When you want to organize your specific business data in a kind of computerized repository, you need to create a custom database. Creating a custom database is not so difficult but can be difficult because you should carefully consider a number of aspects including user needs, data types, database components, test needs, deployment requirements, etc.

Ideally, the process of building a custom database should be managed by two groups of specialists. The first group would include IT personnel responsible for database design, test and deployment, while the second group would comprise business analysts responsible for user-needs analysis, database concept, and overall supervision.

So if you want to build a custom database that meets your company's specific business requirements, you need to involve IT guys and business analysis experts in your project. Besides, you need to develop a plan that the teams will follow up. For example, in your project plan there can be the following phases:

Carry out a user-needs analysis to figure out what information users want to keep and manage in the database.
Map out database components (tables, records, fields, workflows) and their interrelationships to create a conceptual model of how information will be organized and structured in the database.
Develop an implementation plan to describe how to deploy the database in the business environment.
Test the database to check if users can efficiently access, enter and update required information in the database.
Deploy the database after all tests have been successfully passed.

Database customization software lets you build custom databases according to your business needs. For instance, after you complete your user-needs analysis, you can use CentriQS Configurator customization solution to create your custom database and align it with the results of your analysis. You can add such custom components to your CentriQS database as entities, properties, workflows, OLAP cubes, enums.