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