Creating databases allows defining a structure that groups together a set of resources with the same attributes.
Defining databases will facilitate search by filters or even restrict your users' access to the desired elements only thanks to consultation rights.
1. What is a database?
A database consists of a set of resources. All resources contained in a database will have the same attributes. Therefore, defining a database is defining a set of attributes. Attributes can be shared between multiple databases.
A database is thus characterized by a name and by the attributes defined in this database.
In databases, you can also define sub-databases. The "child" sub-database will inherit the attributes of the "parent" database.
2. In practice, how to create a database?
Context: Let's imagine a company having to inspect thousands of engines. It will thus have to create a database named "Engines".
All engines will be characterized by the following attributes:
- Power
- Torque
- Brand
We will thus create a "Engines" database that will contain the previously mentioned attributes.
a. In the Databases tab, click on Create a new Database.
b. Name it "Engines", then click on Create.
c. Add the following attributes in the Structure tab:
- Power (Number type attribute)
- Torque (Number type attribute)
- Brand (Text type attribute)
d. Your "Engines" database is now created. All resources created in this database will have the previously mentioned attributes.
3. Create database files:
To facilitate the management and consultation of your databases, you can now organize them using files or subfiles.
a. Once your databases are created, click on "New File".
b. Name your file and then click on "Create". You can also include this new file in an existing file.
You have the ability to create new databases directly from the blue "New Database" button.
It is also possible to move an existing database from the general database page or from one file to another.
- In a newly created database, resources can be integrated in bulk, by performing a resource import.
- Two databases cannot have the same name.