Let's take a closer look at one of these

[rakhirhif8963]

According to Denis Rozhkov, head of software development at Gazinformservice, many customers who used Western commercial DBMSs had long been asking about replacing them for one reason or another. Both the original (so-called vanilla) version of PostgreSQL with open source code and commercial forks were considered as alternatives. As it turned out, none of them fully met the corporate-level requirements of large customers for ensuring fault tolerance and providing full-fledged operational service at sites located in different, fairly remote regions. Therefore, a decision was made to develop our own DBMS.

Commercial versions of the DBMS (and Jatoba in particular) differ colombia whatsapp data vanilla PostgreSQL by extensions and additions that are either important for certain applications or are determined by regulatory requirements imposed on certain groups of customers. For example, Gazinformservice is currently developing a set of extensions that ensure compatibility with 1C business applications. In addition, Jatoba DBMS supports extended password policies and the ability to restrict DBMS administrator access to certain protected data. The product includes a number of system utilities for cluster management (JaManager), load balancing (JaPool), and DBMS security analysis (Jatoba Data Safe).

extensions, designed to hide the source codes of procedures and functions.

All modern DBMS support to some extent stored procedures and functions written in SQL language extensions, including logical constructs of high-level languages ​​and executed directly by the DB server. In particular, in PostgreSQL such languages ​​can be PL/pgSQL, PL/Tcl, PL/Perl, PL/PerlU, PL/Python. All of them are also supported in the Jatoba DBMS. Stored procedures have many advantages: they allow increasing the productivity of applications (including by reducing the exchange of information between the client and the server), expand the possibilities of programming complex logic and support data security functions, limiting or completely eliminating unregulated direct access of users to DB tables.