微觀經(jīng)濟(jì)學(xué)mis_ch(7)(編輯修改稿)
2025-01-30 02:38 本頁面
【文章內(nèi)容簡介】 abase Management Systems Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management 169。 2022 by Prentice Hall ? Join: – Combines relational tables to present the user with more information than is available from individual tables ? Project: – Creates a subset consisting of columns in a table – Permits user to create new tables containing only desired information 169。 2022 by Prentice Hall The Three Basic Operations of a Relational DBMS Figure 58 The select, project, and join operations enable data from two different tables to be bined and only selected attributes to be displayed. Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management Database Management Systems 169。 2022 by Prentice Hall Capabilities of Database Management Systems ? Data definition capabilities ? Specify structure of content of database ? Data dictionary (數(shù)據(jù)字典） ? Automated or manual file storing definitions of data elements and their characteristics ? Querying and reporting ? Data manipulation language ? Structured query language (SQL) ? Microsoft Access querybuilding tools ? Report generation, . Crystal Reports Database Management Systems Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management 169。 2022 by Prentice Hall 字段名稱 數(shù)據(jù)類型 字段大小 說明 Bookid 自動(dòng)編號(hào) 長整型 Bookname 文本型 50 Bookauthor 文本型 8 Bookprice 貨幣型 Bookpress 文本型 50 Bookdata 日期 /時(shí)間 169。 2022 by Prentice Hall Access Data Dictionary Features Figure 59 Microsoft Access has a rudimentary data dictionary capability that displays information about the size, format, and other characteristics of each field in a database. Displayed here is the information maintained in the SUPPLIER table. The small key icon to the left of Supplier_Number indicates that it is a key field. Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management Database Management Systems 169。 2022 by Prentice Hall ObjectOriented DBMS (OODBMS) ? Stores data and procedures that act on those data as objects to be retrieved and shared ? Better suited for storing graphic objects, drawings, video, than DMBS designed for structuring data only ? Used to manage multimedia ponents or Java applets in Web applications ? Relatively slow pared to relational DBMS ? Objectrelational DBMS: Provide capabilities of both types Database Management Systems Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management 169。 2022 by Prentice Hall Using Databases to Improve Business Performance and Decision Making ? Databases provide information to help the pany run the business more efficiently, and help managers and employees make better decisions ? Tools for analyzing, accessing vast quantities of data: ? Data warehousing （數(shù)據(jù)倉庫） ? Multidimensional data analysis ? Data mining（數(shù)據(jù)挖掘） ? Utilizing Web interfaces to databases Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management 169。 2022 by Prentice
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1