How to query the database


Quick guide:

Each object in the database has a short name and a definition text.
Every object is placed in a hierarchy, called specialization hierarchy or taxonomy.

You can query on short name or on definition.
In the query you can use wildcards.
Not case-sensitive. Wildcards are % (any character) and _ (one character)

Example: enter the query string:

%pump%

And press enter.
This will give a list of all short names having the word pump in it.

pump% will give all that starts with pump.
%pump will give all that ends with pump.

In the list you can click on a short name and this calls up the detailed view.

Explanation of the detailed view

IDThis is the system identifier in the context of the database. It is used for reference by external systems.
Specialized fromA superclass (parent) of the current object. An object can have multiple superclasses. For example a STEEL BOLT is specialized from STEEL and from BOLT, inheriting some aspects. Not all aspects are inherited, for instance it will inherit the relation to LENGTH from the BOLT, but not the registration status of that superclass).
SpecializationA subclass (child) in the hierarchy.
Member ofThe object complies with the criteria for membership of the given class, and therefore is considered to belong to that class.

Example: PUMP is member of the ROTATING MECHANICAL EQUIPMENT CLASS (a PUMP is a member of the PUMP class, PUMP is that PUMP class)

'Member of' also applies to reference_individuals.
Assembly partThe object can have (or has) this part. Example: a PRESSURE TRANSMITTER has a PRESSURE SENSING ELEMENT.