Online Database of Industrial Noise Sources
169
Fig. 1 EER diagram of the
database of industrial noise
sources
5 Implementation
The database was created using MySQL database engine, and it is running under
Linux operating system on the Web server of the Faculty of Mechanical and Civil
Engineering in Kraljevo. The user interface to the database is developed using PHP
programming language which enables generation of HTML pages. The graphical
user interface has been developed in order to provide a user-friendly solution for
interaction with the database and data manipulation. The designed user interface
enables data insertion, modification, and deletion, as well as a preview of already
submitted information. Collected data are publicly available on the Internet address
www.mfkv.kg.ac.rs/urbanoise/measurements. Due to safety and security reasons,
data manipulation is granted only to the developer team and project participants.
Data exchange between the database and the third-party software tools may be
realized through SQL query. Structured Query Language (SQL) is a domain-specific
language designed for accessing and manipulating databases. SQL queries perform
data retrieval, submitting and updating, as well as creation of data objects such as
SQL databases and SQL tables. As submitted data should be publicly accessible,
SQL query will be the basic tool for obtaining data from developed database.
On the next figure is given example of input data about noise sources (Fig. 2).
If input of information about spectral content of the sound is selected, a new form
for input of sound level data for each of the frequency ranges is opened.
The entered data may be sorted and searched, and an example of the noise spectrum
of noise source is shown in Fig. 3.
169
Fig. 1 EER diagram of the
database of industrial noise
sources
5 Implementation
The database was created using MySQL database engine, and it is running under
Linux operating system on the Web server of the Faculty of Mechanical and Civil
Engineering in Kraljevo. The user interface to the database is developed using PHP
programming language which enables generation of HTML pages. The graphical
user interface has been developed in order to provide a user-friendly solution for
interaction with the database and data manipulation. The designed user interface
enables data insertion, modification, and deletion, as well as a preview of already
submitted information. Collected data are publicly available on the Internet address
www.mfkv.kg.ac.rs/urbanoise/measurements. Due to safety and security reasons,
data manipulation is granted only to the developer team and project participants.
Data exchange between the database and the third-party software tools may be
realized through SQL query. Structured Query Language (SQL) is a domain-specific
language designed for accessing and manipulating databases. SQL queries perform
data retrieval, submitting and updating, as well as creation of data objects such as
SQL databases and SQL tables. As submitted data should be publicly accessible,
SQL query will be the basic tool for obtaining data from developed database.
On the next figure is given example of input data about noise sources (Fig. 2).
If input of information about spectral content of the sound is selected, a new form
for input of sound level data for each of the frequency ranges is opened.
The entered data may be sorted and searched, and an example of the noise spectrum
of noise source is shown in Fig. 3.