Info > Data Mining > 3-1. DM and DW > Relational Database Management Systems(RDBMS)

¢¹¢º Relational Database Management Systems(RDBMS)

¡Ø The heart of the DW
¡Ø increasingly providing built-in support for more advanced access to the data than provided by SQL.
¡Ø For instance

OLAP ¡æ finds built-in support for data structures.

¢º Several forces driving the need for DW

¢¹ Acquisitions and mergers.

¡Ø ¿¹ : Larger banks, the same function, such as deposit and loan systems

¢¹ The automation of all parts of a business has left unmerged, unacquired companies with dozens of systems running differents parts of the business.

¢¹ Flexibility in the marketplace has replaced mass production.

¡Ø Mass marketing is out
¡Ø The trend is toward gathering and using information.
¡Ø Data residing in operation systems is often the cheapest way to gather knowledge about customers.

¢¹ The increased focus on service instead of product has created communication gaps.

¡Ø ¿¹ : "consumer loans"

¢¹ Technology can support data warehousing.

¢¹ Tools are becoming more versatile and user-friendly.

¡Ø available and ready to use
¡Ø data cleansing tools, relation databases, metadata tools, statistical packages, OLAP engines, query generation tools, and data mining packages.

¡à This chapter tries to focus on data warehousing as part of the virtuous cycle of DM

¢¹ The architecture of data and its different forms inside an organization are discussed.
¢¹ The important elements of this architecture from the perspective of DM and data analysis.
¢¹ The important considerations are summarized into a list.

Info > Data Mining > 3-1. DM and DW > Relational Database Management Systems(RDBMS)