Ch.6 Foundation of business intelligence Databases and information management

Ch.6 Foundation of business intelligence Databases and information management

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Ch.6 Foundation of business intelligence Databases and information management HP is a good example of the important of data management and database system for business. HP s data had been stored in a number of different databases where they could not easily retrieved and analyzed. However, they chose to develop its own data warehousing technology for integrating the data from all of its disparate (diff) sources into a single database, storing the data, organizing the data and providing tools for making the data easily accessible to large numbers of employees for querying and reporting . HP has become much more efficient and its managers are making better decisions because of the above reason. 6.1 Organization data in a traditional file environment Poorly organized and maintained IS may result in business don’t have timely, accurate, relevant information. So data management is so essential. So how IS arrange data in computer files and traditional method of file mgmt. File organization terms and concepts P.221 Bit represents the smallest unit of data Byte represents a single character (letter, number or symbol) Field a grouping of characters into a word, a group of words or complete number (person name or age) Record a group of related fields (student s name, course taken, the date, the grade) File a group of records of the same type (a group of record) Database a group of related files makes up a database See diagram 6-1 p.222 Entity is a person, place, thing or event on which we store and maintain information. Attribute is describing a particular entity such as student_ID, Course, Date, Grade Problems with the traditional file environment Different department has their own different system and data files. So that they use different application in their own files and own computer program to operate. See diagram 6-2 P.222 e.g. human resources may have a personnel master(staff) file, payroll file, etc of hundred of files and programs existed. This process led to multiple master files master files created, maintained and operated by separate divisions or departments. Business with hundreds of programs and applications that are difficult to maintain
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Ch.6 Foundation of business intelligence Databases and information management and manage. It will result in follow, Data redundancy and inconsistency Data redundancy means same data are stored in more than one place because different groups in an organization independently collect the same data and store it independently of each other. Data redundancy wastes storage resourced and also lead to data inconsistency , where the same attribute may have different values . E.g. some data may be
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 7

Ch.6 Foundation of business intelligence Databases and information management

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online