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:
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).
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:
Copyright (C) 2001-2010 Binary Brilliant Inc. All Rights Reserved.