Wyniki wyszukiwania - BazTech

Ograniczanie wyników

1 New Trends in Production Engineering

1 2019

Znaleziono wyników: 1

Liczba wyników na stronie

Wyniki wyszukiwania

Wyszukiwano:
w słowach kluczowych: enterprise database

Sortuj według:

Ogranicz wyniki do:

Safety Mechanisms in Relational Database as Part of the IT System of the Enterprise

Berski Szymon, Bilau Martyna

New Trends in Production Engineering

2019

Vol. 2, Iss. 2

12-23

The work examines the effectiveness of the replication mechanism of the X production company database. In order to extend the functionality of the computer database of the enterprise, a model of its resource flow was created and an intensional and extensional part was created for a test database based on real enterprise resources. The model has been simplified to 3-rd normal form. The implementation was done in the MySQL database system. Two different operating systems were selected for testing: Windows and Linux. The database management system (DBMS) is working under the GPL license. MySQL DBMS offers many security mechanisms, and to secure the database, system of users permissions to objects have been selected and also an encryption of access passwords for users and connections to servers was used. A replication engine based on the binary log and the model "main server and backup server" was used to create a copy of the enterprise data.