Databases Come In Many Variations
- Date: 2007-11-05 - Word Count: 544
Share This!
There are literally an unlimited number of database variations available these days. They can, however, be separated into some general categories to help understand their function better. Every group has its fans and critics, but here we go.
When you think of the databases, the sheer volume of variations possible boggles the mind. Databases can be designed for just about any purpose and any time you have another variable, you could design a database to store and display it. The types of databases and their use range from sports statistics to the number of widgets stored in your various warehouses. They may be concerned with the collections of books in a library or the temperatures in your city for the last fifty years.
If you get away from the purpose or the nature of the data itself, you can divide databases into a couple of easy to understand types. One way to separate them is to consider manipulation of data. Two common types of data bases based on manipulation are the Analytic Data Base and the Operational Data Base. The Analytic Data Base stores the data in a form that is permanent and unchanging. The data is the data. An example would be the temperatures in your city for the last fifty years mentioned above. This data is fixed. The temperature on a given day two years ago is not going to change now. So, this data is not manipulated at all. It is accessed and displayed.
The Operational Data Base is concerned with data that does change. The number of widgets in your warehouse is an example of this. This data is constantly changing. When it is accessed and displayed, it is like a snapshot of the conditions at that very moment. An Operational Data Base may be changing constantly. It is possible to not only view the data frozen at the moment of access, but also to generate information about the change to the database itself. In other words a graph that shows widget sales could be generated by looking at the changes in warehouse levels over a given time frame.
Another way of looking at the different types of databases is to consider how they are organized. There are three types. The Flat File database is the older form and still is quite common. Data is stored in separate files and each file represents a separate entity and information is connected in any logical form. This means data could be repeated in several different files creating redundancy. The Hierarchical Data Base creates an organized structure to the data. It uses a concept of parent files broken down into "child" files, or sub-files
The Network File Database is the most complex and completely eliminates the problem of redundancy of information that plagues Flat File databases and was not completely eliminated by the development of hierarchical data bases. The problem with Network File Databases is they are very complex to establish and difficult to operate. At the present time, the general public is mostly unable to operate these systems and database professionals are needed. Work is going on to develop even better and easier to use database models and the future is bright for database design.
Find database design companies in your geographic area at DatabaseDesignCompanies.com.
When you think of the databases, the sheer volume of variations possible boggles the mind. Databases can be designed for just about any purpose and any time you have another variable, you could design a database to store and display it. The types of databases and their use range from sports statistics to the number of widgets stored in your various warehouses. They may be concerned with the collections of books in a library or the temperatures in your city for the last fifty years.
If you get away from the purpose or the nature of the data itself, you can divide databases into a couple of easy to understand types. One way to separate them is to consider manipulation of data. Two common types of data bases based on manipulation are the Analytic Data Base and the Operational Data Base. The Analytic Data Base stores the data in a form that is permanent and unchanging. The data is the data. An example would be the temperatures in your city for the last fifty years mentioned above. This data is fixed. The temperature on a given day two years ago is not going to change now. So, this data is not manipulated at all. It is accessed and displayed.
The Operational Data Base is concerned with data that does change. The number of widgets in your warehouse is an example of this. This data is constantly changing. When it is accessed and displayed, it is like a snapshot of the conditions at that very moment. An Operational Data Base may be changing constantly. It is possible to not only view the data frozen at the moment of access, but also to generate information about the change to the database itself. In other words a graph that shows widget sales could be generated by looking at the changes in warehouse levels over a given time frame.
Another way of looking at the different types of databases is to consider how they are organized. There are three types. The Flat File database is the older form and still is quite common. Data is stored in separate files and each file represents a separate entity and information is connected in any logical form. This means data could be repeated in several different files creating redundancy. The Hierarchical Data Base creates an organized structure to the data. It uses a concept of parent files broken down into "child" files, or sub-files
The Network File Database is the most complex and completely eliminates the problem of redundancy of information that plagues Flat File databases and was not completely eliminated by the development of hierarchical data bases. The problem with Network File Databases is they are very complex to establish and difficult to operate. At the present time, the general public is mostly unable to operate these systems and database professionals are needed. Work is going on to develop even better and easier to use database models and the future is bright for database design.
Find database design companies in your geographic area at DatabaseDesignCompanies.com.
Related Tags: information, network, data, file, complex, database, organized, operational, redundancy, variations
Your Article Search Directory : Find in Articles
Recent articles in this category:
- Improper Way Of Marketing Reflects Poorly On A Company.
New business, product or service everything requires visibility, awareness in order to come into the - Replacing Paper Prints With Online Versions
Nowadays saving out on resources and being additionally informative are both aspects that are in. In - Stop Smoking Effectively
If I told you of a way that you could stop smoking harmful tobacco would you believe it? Most people - What Is Runtime Error 182? And How To Fix It
Are you finding an effective way to fix runtime error 182? Do you think fixing runtime error 182 is - Do You Know How To Fix Runtime Error 87 In Minutes?
Are you finding an effective way to fix runtime error 87? Do you think fixing runtime error 87 is to - Knowledge About Avi, Avi Player, Avi Converter On Mac
Knowledge about AVI, AVI player, AVI Converter on MacWhat is an AVI?AVI, an acronym for Audio Video - Buy Your Highly Successful Email Survey Software Today
Email Survey Software- Boost Your Business and Increase ProfitsAn email survey software could be one - Xrm - The Anything Relationship Management Solution
I recently attended the Microsoft Dynamics West Region FY11 Sales Planning Retreat. This year's meet - What Are The Benefits Of Working With Electronic Medical Records
Recording medical information is a vital part of health care services. These records are necessary f - Basic Factor To Make Website Business Oriented
Internet is home for millions of websites. The online business is becoming more and more competitive
Most viewed articles in this category:
- Parental Control Software
Parental control software is software that can help parents protect their children when they are onl - Digital Asset Management Software
Managing and organizing your organization's documents is a critical component to your business's suc - AdobeRGB vs. sRGB
Understanding color spaces I'll try to explain it very simplified, but understandable for everyone - Confessions of a Prankster
I wanted to get a jump on April Fool's Day, partially because of the long, cold winter blues, and pa - Malicious Thoughts About The Spyware Ills Of My PC
Who would think I was capable of such revengeful thoughts about the parties responsible for inflicti - Recover File and Recover Deleted File Tools
Data recovery software is a very effective way of retrieving data from a worn or damaged hard disk d - Life without Windows
Ubuntu, a user-friendly version of Linux, has been running so nicely on my home PC that I decided to - What Benefit Does an Online Software Download Site Offer You?
Are you having a problem that where you find a good softeware when you consider to have a try or wan - Maintaining A Website
There was an era when people were talking about how to create a website using html coding or some ea - Benefits Of Proper Time Tracking
Have you ever written down time when you have started and finished your work? Maybe you have had mul