Technologies

Database systems

Most applications are supposed to collect and store various forms of data received from the owner, making the cooperation with a database a very important aspect of program creation. Applications we have been creating require that we are able to deal with databases ranging from the smallest ones, like MS Access, to those which can store enormous amount of data, like Oracle.

MS SQL Server

A database management system supported and distributed by Microsoft, it is that company’s main database product (besides Microsoft Jet, applied in MS Access by default, but intended for smaller tasks).

Oracle

A relational data base which uses a standard SQL query language. It also has a built-in inner language to create stored procedures PL/SQL. Since Oracle ver 8i it is possible to utilize Java language for developing stored procedures

MySQL

A freely available system of managing relational databases, it enjoys the reputation as one of the quickest database servers, which makes it an excellent server for frequently visited websites. It supports database replication (in a master->slave mode), as well as for multilingualism – every table and even every cell can have separate localization.

PostgreSQL

One of the most popular freely available systems of managing relational databases. It allows developing stored procedures in a wide range of programming languages, including script and high level languages like C, C++ and Java (PL/Java).

You cannot copy content of this page