Katowice Jankego Plackarnia

I principali DBMS presenti sul mercato

The following is a list of the top Data Base Management System :

ACCESS , produced by Microsoft, is the most common management system database for the environment Microsoft Windows. Access can be used in two ways: 1

- as manager of the database independently on personal computers (in this case reflects the limitations of the architecture of personal computers provides a transactional product limited, with security mechanisms, data protection and management of competition rather simple and incomplete. On the other hand has a very low cost that justifies these limitations. The system interface provides a user-friendly environment for both the user application is for the designer of the database.

2 - as an interface to other systems, Access can be viewed as a tool to avoid writing SQL code, as it captures patterns and simple queries using a graphical representation easily understandable, these inputs are translated into appropriate SQL commands so transparent.

ORACLE is currently one of the world's leading manufacturers of software, and its product offering has the key management system for Oracle database server. Oracle Server is available for a large number of systems. A major strength of Oracle's own product availability on different platforms (including personal computers, local area network server, workstations, mini computers, mainframes and supercomputers, parallel) which makes it easier to integrate base data at different levels in the organization. It is not based on an archaic language understandable only to specialists, thereby changing the nature of the relationship between users and developers. The information is easily accessible by anyone, simply by entering a query in English. In this way, Oracle is used by more groups. The companies' information technology that produces it is the Oracle Corporation in 1977 and fonadata sede in California. ORACLE è stato il primo DBMS commerciale che utilizza il linguaggio di interrogazione strutturato SQL (Structured Query Language), basato sulla lingua inglese.

MySQL è il più diffuso database Open Source basato sul linguaggio SQL. Questo prodotto viene fornito dall'azienda MySQL AB che sviluppa il proprio business erogando servizi basati su MySQL stesso. Anche MySQL è un RDBMS (' Relational DataBase Management System'), ossia un sistema di gestione per database relazionali che offre la possibilità di conservare i dati in diverse tabelle. MySQL si occupa della strutturazione e della gestione a basso livello dei dati stessi in modo da velocizzarne l'accesso, la modifica e the inclusion of new items.
Why use MySQL?
is fast,
is reliable as it was designed to handle lots of data,
is scalable: it can work by using 2 megabytes of RAM to 4GigaByte,
is versatile: its open source nature ensures a version for each platform.

POSTGRESQL is a complete object-relational database is freely licensed, is an excellent alternative to be compared to other free products like MySQL, which in those closed-source like Oracle. E 'was developed by a large community of programmers and supported by various companies and making it free from the corporate policies and market. The programmability of PostgreSQL is its greatest strength and its primary advantage over its competitors.

SQL Server is a relational DBMS from Microsoft. In early versions were used for medium-sized databases, but from the 2000 version was also used to manage large data bases. It uses a variant of the standard SQL language called Transact-SQL T-SQL. SQL Server also supports Open Database Connectivity (ODBC).