Databases need to be well written and optimized in order to allow for fast retrieval of information. Basically a question is asked of the database and the database must respond with all the required information almost instantly. Databases keep your information secured. Databases allow you to perform all kinds of activities on a day to day basis.
Types of Databases:
Text Database- The text database is simplicity personified. It is simply a file that has columns of text that are linked together. An example of a text database is If you were ranking your friends and had their first name in the first column, their last name in the second column and their rank in the third column.
Desktop Database - The desktop database took the text database and pumped it up another level. Desktop databases generally work via rows and columns of cells. Sounds familiar? Excel and Microsoft Access are the most common desktop databases and used commonly throughout business. These databases are much easier to use than text database and retrieve information or make calculations from the information so much faster.
RDMS (Relational Database Management Systems) - Relational databases are the most common databases used now. They have a much improved performance factor over desktop databases. RDMS can allow thousands of users to be connected and using the database all the time.
There are many options for database software.
Microsoft Access - Access comes with the Microsoft Office suite. That makes it easily available at a low price. Microsoft Access isn’t the most powerful of databases as it functions more as a desktop database than an RDMS but it can be integrated with some of Microsoft’s web applications to work as an RDMS as well.
MySQL - MySQL is one of the biggest and most commonly used RDMS out there. It’s used in the most online internet systems. It’s popularly used in commerce websites. MySQL is used by and in a lot of the world's biggest platforms by the world's biggest companies. People like Adobe, Google and Facebook all lean on MySQL in order to provide assistance with their websites and the extreme traffic they face every day. MySQL is open source and available for use by anyone.
Oracle RDBMS - Oracle is the industry leader. Their ever increasing database systems are now even better thanks to their expansion into cloud computing. Oracle runs on multiple platforms. Anyone who works in the field as a database administrator needs to learn how to work with the Oracle systems. This can allow you to work for almost any company.
Microsoft SQL Server - Microsoft has worked hard to catch up in databases and try to gain ground on the industry behemoth Oracle. The Microsoft SQL server attempts to produce the highest performance. Microsoft also offers discounts to people in public and education sectors. It was a smart decision as it gained Microsoft a lot of market share they didn’t otherwise have before.