tailieunhanh - Database Modeling & Design Fourth Edition- P40

Database Modeling & Design Fourth Edition- P40: Database technology has evolved rapidly in the three decades since the rise and eventual dominance of relational database systems. While many specialized database systems (object-oriented, spatial, multimedia, etc.) have found substantial user communities in the science and engineering fields, relational systems remain the dominant database technology for business enterprises. | 182 CHAPTER 8 Business Intelligence Figure Triple exponential smoothing courtesy of Ubiquiti Inc. Figure Triple exponential smoothing with actual values overlaying forecast values based on five years of training data courtesy of Ubiquiti Inc. Data Mining 183 Figure Triple exponential smoothing with actual values overlaying forecast values based on four years of training data courtesy of Ubiquiti Inc. Let s look at a few of the possibilities for analyzing text and their potential impact. We ll take the area of automotive warranty claims as an example. When something goes wrong with your car you bring it to an automotive shop for repairs. You describe to a shop representative what you ve observed going wrong with your car. Your description is typed into a computer. A mechanic works on your car and then types in observations about your car and the actions taken to remedy the problem. This is valuable information for the automotive companies and the parts manufacturers. If the information can be analyzed they can catch problems early and build better cars. They can reduce breakdowns saving themselves money and saving their customers frustration. The data typed into the computer is often entered in a hurry. The language includes abbreviations jargon misspelled words and incorrect grammar. Figure shows an example entry from an actual warranty claim database. As you can see the raw information entered on the shop floor is barely English. Figure shows a cleaned up version of the same text. 184 CHAPTER 8 Business Intelligence 7 DD40 BASC 54566 CK OUT AC INOP PREFORM PID CK CK PCM PID ACC CK OK OPERATING ON AND OFF PREFORM POWER AND GRONED CK AT COMPRESOR FONED NO GRONED PREFORM PINPONT DIAG AND TRACE GRONED FONED BAD CO NECTION AT S778 REPAIR AND RETEST OK CK AC OPERATION Figure Example of a verbatim description in a warranty claim courtesy of Ubiquiti Inc. 7 DD40 Basic 54566 Check Out Air Conditioning Inoperable Perform PID Check Check .