Brilliant Database Software - Home
Database software - Online Help System

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index

Brilliant Database Differences

table border="0" width="100%" cellspacing="0" cellpadding="4" bgcolor="#00000077">
Brilliant Database Differences

This chapter will be useful for those who already have experience in working with databases: it contains description of main differences of Brilliant Database from other classic relational databases.

Tables and Forms

In case of a usual database, at first, tables are created. After that, entry forms for tables can be created.

In Brilliant Database, you first create a form in the visual editor by dragging fields of different types from the fields palette onto it. And only after that records created in this form can be displayed as a table.

Such approach allows fastening the process of a new database development.

No Tables, but Folders?

In a usual database, all records of one type are stored in one table.

In Brilliant Database, there are no tables in traditional understanding. There is representation of records in the form of a table, as it is common for usual databases. But records themselves are stored in folders. There can be records of one type, as well as records of different types in a folder. A folder can also have nested folders within.

This does not limit possibilities of Brilliant Database in comparison with usual databases, but allows you to:

  • Simply implement a tree-like structure of storing, displaying and working with data in the form of tree of folders;
  • Group different types of data in one folder. For example, make a separate folder for each project, in which there will be records of the Documents, Reports, Photos, Tasks types and so on.
  • Easily move and group records by folders. For example, you can store records on orders in three different folders: New, In Work and Completed.

Relational Fields

All you need to do in Brilliant Database to create a relational link between two types of records is to add a relational field on the form. The program will make all the rest by itself.

Relational fields can be of two types: simple (one-way single connection) and many-to-many (two-way multiple connection).

Multi-user work

In Brilliant Database, multi-user work is realized by the client-server technology. The main user opens a database on his or her computer as usual and selects the 'Share Database' option. Other users connect to the database by selecting not the 'Open Local Database' option, but the 'Open Networked Database' option and entering the address of the remote computer on which the database is opened. At that, computers can be in one local network, as well as at different points of the Earth.

When working with a remote database, the user has access to the same possibilities as when working with a local database. However, for every group of users you can set access to different parts of the database, for example:

  • Hide fields, buttons, reports and so on;
  • Prohibit editing of specific fields or the whole records;
  • Prohibit access to some folders or just hide system folders.

All topics in the "Brilliant Database Basics" section: