Tuesday, February 25, 2014

Databases

______________________________________________________

Database is used by programmers together with the programming languages that they are using to store data or information which are typically organized for the user of the program to make it easy for them to retrieve such information about a specific entity, for example, data of every student in a particular school. Data inside a database can either be updated, added or deleted depending on the database operator or a specific user of the program. Database are commonly used by programmers who develops Information Systems such as enrollment system, library system, attendance record system and other system which needs saving of records and transactions. See below for example of commonly used databases:

a). Oracle Database

                - Often called as Oracle RDBMS, a database management system developed by Oracle Corporation that is written in assembly language, C and C++. Oracle database stores data in the form of data and tablespaces which contains data dictionaries.



b). MySQL

                - One of the most commonly used database today which  ranked as top 2 among the other databases. MySQL is an open-source relational database management system, meaning it is free of charge when used by the developer/programmer because it is available under the terms of the General Public License. MySQL  has a lot of features that has user friendly interface such as their Query browsers, Workbench and Migration tools which help the user to transfer data from supported database into MySQL.




c). Microsoft SQL Server

                 - A relational web hosting database developed by Microsoft Corporation which is merely the same as other database management system which has the ability to hold and store large amount of data. MySQL is widely used as data storage of different websites. Although unlike MySQL, this product is not free but it has a lot of advance features that will suite the needs of every developer who prefer to used this product.




d.) Microsoft Acess

                - A relational database by Microsoft that commonly uses by standalone programs or programs which doesn't rely on another server while retrieving data. Lots of object oriented programming may suite on using this kind of database for creating application softwares which can also referenced different objects such as Data Access Objects (DAO). Its own format on storing data is based on the Access Jet Database Engine. Access may also came in handy in by direct linking data which is stored on other databases and applications.








Image Source(s): computertrainingcenterscom; computertrainingcenters.com; objcsharp.wordpress.com; softicons.com
\

______________________________________________________

No comments:

Post a Comment