微觀經(jīng)濟(jì)學(xué)mis_ch(7)-預(yù)覽頁(yè)
【正文】 mns) store data representing an attribute ? Rows store data for separate records ? Key field: Uniquely identifies each record ? Primary key: ? One field in each table ? Cannot be duplicated ? Provides unique identifier for all information in any row Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management 169。 2022 by Prentice Hall Entityrelationship ONETOONE: CLASS MONITOR ONETOMANY: CLASS STUDENT A STUDENT B STUDENT C MANYTOMANY: STUDENT A STUDENT B STUDENT C COURSE 1 COURSE 2 169。 2022 by Prentice Hall The Final Database Design with Sample Records Figure 55 The final design of the database for suppliers, parts, and orders has four tables. The LINE_ITEM table is a join table that eliminates the manytomany relationship between ORDER and PART. The Database Approach to Data Management Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management 169。 2022 by Prentice Hall Operations of a Relational DBMS ? Select: ? Creates a subset of all records meeting stated criteria select * from SUPPLIER； select Supplier_Number, Supplier_Name from SUPPLIER。 Database Management Systems Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management 169。 2022 by Prentice Hall 字段名稱(chēng) 數(shù)據(jù)類(lèi)型 字段大小 說(shuō)明 Bookid 自動(dòng)編號(hào) 長(zhǎng)整型 Bookname 文本型 50 Bookauthor 文本型 8 Bookprice 貨幣型 Bookpress 文本型 50 Bookdata 日期 /時(shí)間 169。 2022 by Prentice Hall Data Warehouses Using Databases to Improve Business Performance and Decision Making ? Data warehouse ? Database that stores current and historical data that may be of interest to decision makers ? Consolidates and standardizes data from many systems, operational and transactional databases ? Data can be accessed but not altered ? Data mart（數(shù)據(jù)集市） ? Subset of data warehouses that is highly focused and isolated for a specific population of users Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management 169。數(shù)據(jù)集市可以在一定程度上緩解訪(fǎng)問(wèn)數(shù)據(jù)倉(cāng)庫(kù)的瓶頸。 2022 by Prentice Hall Using Databases to Improve Business Performance and Decision Making Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management Figure 513 A series of analytical tools works with data stored in databases to find patterns and insights for helping managers and employees make better decisions to improve anizational performance. Business Intelligence 169。 OLAP 工具能快速提供復(fù)雜數(shù)據(jù)庫(kù)查詢(xún)的答案，并幫助用戶(hù)分析多維數(shù)據(jù)中的各維情況。 2022 by Prentice Hall ? Firms use the Web to make information from their internal databases available to customers and partners ? Middleware and other software make this possible ? Web server ? Application servers or CGI ? Database server ? Web interfaces provide familiarity to users and savings over redesigning and rebuilding legacy systems Databases and the Web Using Databases to Improve Business Performance and Decision Making Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1