Thursday, April 26, 2012

Ch.11-File and Database Concepts-Aaron York


Databases are used in almost every single aspect of our lives whether we know it or not. When you people say database, most would think of something involving school, like the databases used to research a topic for a paper or for a project. But it is not just schools and random information sites that use databases. We see it every day that we go to the store or even when we move to a different house. What happens at stores is a point-of-sale system that has every single item that is in stock at that location, then when someone buys an item it will automatically subtract or decrease the quantity of the item bought from the inventory database. This point-of-sale system then allows for restocking and ordering of the item. Databases make our lives easier by allowing easy access to almost anything you are looking for, whether it be at the library looking for a book, or a mechanic looking for a part to a car.
            Data mining is the process of taking information from databases and analyzing it to discover unknown and possibly useful information, which includes patterns. There are several techniques behind data mining which are stored in a data warehouse. The data warehouse is composed of several databases. Among the several databases are: Hierarchical, Network, relational, dimensional, object, and object relational. Hierarchical databases allow a one-to-one and one-to-many relationships, linked in a hierarchical structure. A network database uses mesh-like structure to offer additional capacity many-to-many relationships. A relational database stores data in collections of tables. A dimensional database, also known as the multidimensional database, organizes relationships over three or more dimensions. Object databases store data as objects which allows for grouping into classes. Object-relational databases is used to describe a variety of technologies that combine object-oriented and relational concepts.

No comments:

Post a Comment