Almost everything that people want to do on computers involves the storage and retrieval of information or data. In this series, we are going to discuss databases and their role in communication. The content is aimed at people who may have heard the relevant terms but don’t necessarily understand them.
An application can be designed to handle data in a proprietary way, or it can use one of the commercially available tools designed for the purpose. In either case, it must address the issues of speed, security, accuracy and maintenance.
In a world of increasingly large and diverse enterprises, security and flexibility are of proportionately greater importance.
The second option has a number of advantages, because commercial database management systems (dbms) come with these complex issues resolved.
The intent here is to cover, in a general way, what is offered by commercial dbms providers and how it can be used effectively.You are invited to comment or ask questions of a general nature, but if you have a specific or technical question, please write to me personally, and I will attempt to answer it James@SustainableSystems.com.au
There are three basic types of dbms:
- Relational ~ the “simplest”
- Object-oriented ~ the “smartest”
- Object-relational ~ a blend of the two
Each has its role and, of course, it is important to choose the right tool for the job.