7.1 7 7 managing data dataresources chapter. 7.2 file organization terms and concepts bit: smallest...
TRANSCRIPT
![Page 1: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/1.jpg)
7.1
77
MANAGINGMANAGING
DATA DATA
RESOURCESRESOURCES
Chapter
![Page 2: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/2.jpg)
7.2
File Organization Terms and Concepts
• Bit:Bit: Smallest unit of data; binary digit (0,1) Smallest unit of data; binary digit (0,1)
• Byte:Byte: Group of bits that represents a single Group of bits that represents a single charactercharacter
• Field:Field: Group of words or a complete Group of words or a complete numbernumber
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT
![Page 3: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/3.jpg)
7.3
• Record:Record: Group of related fieldsGroup of related fields
• File:File: Group of records of same typeGroup of records of same type
• Database:Database: Group of related filesGroup of related files
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
File Organization Terms and Concepts
ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT
![Page 4: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/4.jpg)
7.4
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
Data Hierarchy in a Computer System
Figure 7-1
ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT
![Page 5: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/5.jpg)
7.5
• Entity:Entity: Person, place, thing, event about Person, place, thing, event about which information is maintainedwhich information is maintained
• Attribute:Attribute: Description of a particular entity Description of a particular entity
• Key field:Key field: Identifier field used to retrieve, Identifier field used to retrieve, update, sort a recordupdate, sort a record
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
File Organization Terms and Concepts
ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT
![Page 6: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/6.jpg)
7.6
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
Figure 7-2
Entitities and Attributes
ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT
![Page 7: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/7.jpg)
7.7
ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT
• Data redundancyData redundancy
• Program-Data dependenceProgram-Data dependence
• Lack of flexibilityLack of flexibility
• Poor securityPoor security
• Lack of data-sharing and availabilityLack of data-sharing and availability
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
Problems with the Traditional File Environment
![Page 8: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/8.jpg)
7.8
Traditional File Processing
Figure 7-3
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
ORGANIZING DATA IN A TRADITIONAL FILE ENVIRONMENT
![Page 9: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/9.jpg)
7.9
The Contemporary Database Environment
Figure 7-4
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
THE DATABASE APPROACH TO DATA MANAGEMENT
![Page 10: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/10.jpg)
7.10
Components of DBMS
• Data definition language: Data definition language: Specifies Specifies content and structure of database and content and structure of database and defines each data elementdefines each data element
• Data manipulation language:Data manipulation language:Manipulates data in a databaseManipulates data in a database
• Data dictionary:Data dictionary: Stores definitions of Stores definitions of data elements, and data characteristicsdata elements, and data characteristics
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
THE DATABASE APPROACH TO DATA MANAGEMENT
![Page 11: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/11.jpg)
7.11
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
Sample Data Dictionary Report
THE DATABASE APPROACH TO DATA MANAGEMENT
Figure 7-5
![Page 12: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/12.jpg)
7.12
Types of Databases
• Relational DBMSRelational DBMS
• Hierarchical and Network DBMSHierarchical and Network DBMS
• Object-Oriented DatabasesObject-Oriented Databases
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
THE DATABASE APPROACH TO DATA MANAGEMENT
![Page 13: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/13.jpg)
7.13
Relational DBMS
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
• Represents data as two-dimensional tables Represents data as two-dimensional tables called relationscalled relations
• Relates data across tables based on common Relates data across tables based on common data elementdata element
• Examples: DB2, Oracle, MS SQL ServerExamples: DB2, Oracle, MS SQL Server
THE DATABASE APPROACH TO DATA MANAGEMENT
![Page 14: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/14.jpg)
7.14 Figure 7-6
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
Relational Data Model
THE DATABASE APPROACH TO DATA MANAGEMENT
![Page 15: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/15.jpg)
7.15
Three Basic Operations in a Relational Database
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
• Select:Select: Creates subset of rows that meet Creates subset of rows that meet specific criteriaspecific criteria
• Join:Join: Combines relational tables to provide Combines relational tables to provide users with informationusers with information
• Project:Project: Enables users to create new tables Enables users to create new tables containing only relevant informationcontaining only relevant information
THE DATABASE APPROACH TO DATA MANAGEMENT
![Page 16: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/16.jpg)
7.16 Figure 7-7
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
THE DATABASE APPROACH TO DATA MANAGEMENT
Three Basic Operations in a Relational Database
![Page 17: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/17.jpg)
7.17
Hierarchical and Network DBMS
Hierarchical DBMSHierarchical DBMS
• Organizes data in a tree-like structureOrganizes data in a tree-like structure
• Supports one-to-many parent-child Supports one-to-many parent-child relationshipsrelationships
• Prevalent in large legacy systemsPrevalent in large legacy systems
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
THE DATABASE APPROACH TO DATA MANAGEMENT
![Page 18: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/18.jpg)
7.18
Hierarchical DBMS
Figure 7-8
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
THE DATABASE APPROACH TO DATA MANAGEMENT
![Page 19: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/19.jpg)
7.19
DisadvantagesDisadvantages
• OutdatedOutdated
• Less flexible compared to RDBMSLess flexible compared to RDBMS
• Lack support for ad-hoc and English Lack support for ad-hoc and English language-like querieslanguage-like queries
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
Hierarchical and Network DBMS
THE DATABASE APPROACH TO DATA MANAGEMENT
![Page 20: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/20.jpg)
7.20
• Object-oriented DBMS:Object-oriented DBMS: Stores data and Stores data and procedures as objects that can be procedures as objects that can be retrieved and shared automatically retrieved and shared automatically
• Object-relational DBMS:Object-relational DBMS: Provides Provides capabilities of both object-oriented and capabilities of both object-oriented and relational DBMSrelational DBMS
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
Object-Oriented databases
THE DATABASE APPROACH TO DATA MANAGEMENT
![Page 21: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/21.jpg)
7.21
• Conceptual design:Conceptual design: Abstract model of Abstract model of database from a business perspectivedatabase from a business perspective
• Physical design:Physical design: Detailed description of Detailed description of business information needsbusiness information needs
CREATING A DATABASE ENVIRONMENT
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
Designing Databases
![Page 22: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/22.jpg)
7.22
• Entity-relationship diagram:Entity-relationship diagram: Methodology Methodology for documenting databases illustrating for documenting databases illustrating relationships between database entitiesrelationships between database entities
• Normalization:Normalization: Process of creating small Process of creating small stable data structures from complex groups stable data structures from complex groups of dataof data
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
CREATING A DATABASE ENVIRONMENT
Designing Databases
![Page 23: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/23.jpg)
7.23
An Entity-Relationship Diagram
Figure 7-10
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
CREATING A DATABASE ENVIRONMENT
![Page 24: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/24.jpg)
7.24
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
CREATING A DATABASE ENVIRONMENT
An Unnormalized Relation of ORDER
Figure 7-11
![Page 25: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/25.jpg)
7.25
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
CREATING A DATABASE ENVIRONMENT
An Normalized Relation of ORDER
Figure 7-12
![Page 26: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/26.jpg)
7.26
Centralized databaseCentralized database
• Used by single central processor or multiple Used by single central processor or multiple processors in client/server networkprocessors in client/server network
Distributing Databases
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
CREATING A DATABASE ENVIRONMENT
![Page 27: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/27.jpg)
7.27
Distributed databaseDistributed database
• Stored in more than one physical locationStored in more than one physical location
• Partitioned database Partitioned database
• Duplicated databaseDuplicated database
Distributing Databases
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
CREATING A DATABASE ENVIRONMENT
![Page 28: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/28.jpg)
7.28
Distributed Databases
Figure 7-13
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
CREATING A DATABASE ENVIRONMENT
![Page 29: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/29.jpg)
7.29 Figure 7-14
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
CREATING A DATABASE ENVIRONMENT
Management Requirements for Database Systems
![Page 30: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/30.jpg)
7.30
Multidimensional Data Analysis
On-line analytical processing (OLAP)On-line analytical processing (OLAP)
• Multidimensional data analysisMultidimensional data analysis
• Supports manipulation and analysis of Supports manipulation and analysis of large volumes of data from multiple large volumes of data from multiple dimensions/perspectivesdimensions/perspectives
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
DATABASE TRENDS
![Page 31: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/31.jpg)
7.31
Multidimensional Data Model
Figure 7-15
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
DATABASE TRENDS
![Page 32: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/32.jpg)
7.32
Data warehouseData warehouse
• Supports reporting and query toolsSupports reporting and query tools
• Stores current and historical data Stores current and historical data
• Consolidates data for management Consolidates data for management analysis and decision makinganalysis and decision making
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
Data Warehousing and Datamining
DATABASE TRENDS
![Page 33: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/33.jpg)
7.33
Components of a Data Warehouse
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
DATABASE TRENDS
Figure 7-16
![Page 34: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/34.jpg)
7.34
Data martData mart
• Subset of data warehouse Subset of data warehouse
• Contains summarized or highly focused Contains summarized or highly focused portion of data for a specified function or portion of data for a specified function or group of usersgroup of users
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
Data Warehousing and Datamining
DATABASE TRENDS
![Page 35: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/35.jpg)
7.35
DataminingDatamining
• Tools for analyzing large pools of data Tools for analyzing large pools of data
• Find hidden patterns and infer rules to Find hidden patterns and infer rules to predict trendspredict trends
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
Data Warehousing and Datamining
DATABASE TRENDS
![Page 36: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/36.jpg)
7.36
• Improved and easy accessibility to Improved and easy accessibility to informationinformation
• Ability to model and remodel the dataAbility to model and remodel the data
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
Benefits of Data Warehouses
DATABASE TRENDS
![Page 37: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/37.jpg)
7.37
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
Databases and the Web
The Web and Hypermedia databaseThe Web and Hypermedia database
• Organizes data as network of nodesOrganizes data as network of nodes
• Links nodes in pattern specified by userLinks nodes in pattern specified by user
• Supports text, graphic, sound, video and Supports text, graphic, sound, video and executable programsexecutable programs
DATABASE TRENDS
![Page 38: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/38.jpg)
7.38
A Hypermedia Database
Figure 7-17
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
DATABASE TRENDS
![Page 39: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/39.jpg)
7.39
Database serverDatabase server
• Computer in a client/server environment Computer in a client/server environment runs a DBMS to process SQL statements runs a DBMS to process SQL statements and perform database management tasksand perform database management tasks
Application serverApplication server
• Software handling all application Software handling all application operationsoperations
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
Databases and the Web
DATABASE TRENDS
![Page 40: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/40.jpg)
7.40
Linking Internal Databases to the Web
Figure 7-18
Essentials of Management Information SystemsEssentials of Management Information SystemsChapter 7 Managing Data ResourcesChapter 7 Managing Data Resources
DATABASE TRENDS
![Page 41: 7.1 7 7 MANAGING DATA DATARESOURCES Chapter. 7.2 File Organization Terms and Concepts Bit: Smallest unit of data; binary digit (0,1)Bit: Smallest unit](https://reader033.vdocuments.us/reader033/viewer/2022051315/56649eff5503460f94c144fa/html5/thumbnails/41.jpg)
7.41
77
MANAGINGMANAGING
DATA DATA
RESOURCESRESOURCES
Chapter