data resource management
DESCRIPTION
Data Resource Management. Lecture 9. Database Structures. Hierarchical Structure Network Structure Relational Structure Multidimensional Structure Object-Oriented Structure. 3 – Relational Structure. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/1.jpg)
Data Resource Management
Lecture 9
![Page 2: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/2.jpg)
Database Structures
1. Hierarchical Structure
2. Network Structure
3. Relational Structure
4. Multidimensional Structure
5. Object-Oriented Structure
![Page 3: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/3.jpg)
3 – Relational Structure
All data elements within the database are viewed as being stored in the form of simple tables
Represents data as two-dimensional tables called relations
Relates data across tables based on common data element
Relation is described as a table
![Page 4: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/4.jpg)
Relational Structure
Table Relation Row Tuple Column Attribute
![Page 5: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/5.jpg)
Three basic operations in Relational Database Select
Creates subset of rows that meet specific criteria Join
Combines relational tables to provide users with information
ProjectEnables users to create new tables containing only relevant information
![Page 6: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/6.jpg)
Relational Database
![Page 7: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/7.jpg)
Relational Database
![Page 8: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/8.jpg)
Three basic operations in RDBMS
![Page 9: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/9.jpg)
4 – Multidimensional Data Model
Multidimensional databases combine data from a multitude of data sources.
Multi-dimensional databases are especially useful in sales and marketing applications that involve time series.
Large volumes of sales and inventory data can be stored to ultimately be used for logistics and executive planning.
For example, data can be more readily segregated by sales region, product, or time period.
![Page 10: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/10.jpg)
Multidimensional Data Model
The data cube is a conceptual representation of database which can be implemented in a variety of ways, including top-down, bottom-up, and arrays.
![Page 11: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/11.jpg)
![Page 12: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/12.jpg)
5 – Object-Oriented Databases
Object-oriented DBMS: Stores data and procedures as objects that can be retrieved and shared automatically
Object-relational DBMS: Provides capabilities of both object-oriented and relational DBMS
![Page 13: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/13.jpg)
Object-Oriented Databases
Can accommodate more complex data types including graphics, pictures, voice and text
Encapsulation – data values and operations that can be performed on them are stored as a unit
Inheritance – automatically creating new objects by replicating some or all of the characteristics of one or more existing objects
![Page 14: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/14.jpg)
![Page 15: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/15.jpg)
Object-Relational DBMS
An object-relational database (ORD) or object-relational database management system (ORDBMS) is a database management system (DBMS) similar to a relational database, but with an object-oriented database model: objects, classes and inheritance
In addition, it supports extension of the data model with custom data-types and methods.
![Page 16: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/16.jpg)
Evaluation of Database Structures
Hierarchical data structure is best for structured, routine types of transaction processing.
Network data structure is best when many-to-many relationships are needed.
Relational data structure is best when ad hoc reporting is required.
![Page 17: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/17.jpg)
Types of Databases
Conceptual categories of databases1. Operational Databases
2. Distributed Databases
3. External Databases
4. Hypermedia Databases
![Page 18: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/18.jpg)
1 – Operational Databases
Store detailed data needed to support the business processes and operations of a company
Also called Subject Area Databases (SADB), Transaction Databases, Production Databases
![Page 19: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/19.jpg)
2 – Distributed Databases
Many organizations replicate and distribute copies or parts of databases to network servers at variety of sites
Distributed databases can reside on network servers on world wide web, corporate intranets or extranets, or on any other company network
Distributed databases may be copies of operational or any other type of databases.
Replication and distribution is done to improve database performance at end user worksites
![Page 20: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/20.jpg)
Distributed Databases
Centralized DatabaseUsed by single central processor or multiple
processors in client/server network
Distributed DatabaseStored in more than one physical location
Partitioned database Duplicated database
![Page 21: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/21.jpg)
Distributed Databases
![Page 22: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/22.jpg)
3 – External Databases
Contain a wealth of information available from commercial online services and from many sources on the World Wide Web
![Page 23: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/23.jpg)
4 – Hypermedia Databases
Hypermedia database consists of hyperlinked pages of multimedia (text, graphic, and images, video clips etc.)
![Page 24: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/24.jpg)
Data WarehouseDefinition: Large database that stores data that has been
extracted from the various operational, external, and other databases of an organization
Central source of data that has been Cleaned Transformed Cataloged
![Page 25: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/25.jpg)
Data Warehouse Stored data is used for
Data Mining Online Analytical Processing Market Research Decision Support
Data Warehouses are subdivided into: Data Marts
Databases that hold subsets of data from a data warehouse that focus on specific aspects of a company, such as a department or a business process
![Page 26: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/26.jpg)
Data Warehouse
Supports reporting and query tools
Stores current and historical data
Consolidates data for management analysis and decision making
Improved and easy accessibility to information
Ability to model and remodel the data
![Page 27: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/27.jpg)
Data Warehouse & Data Marts
![Page 28: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/28.jpg)
Data Warehouse & Data Marts
![Page 29: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/29.jpg)
Retrieving Information from Data Warehouse
![Page 30: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/30.jpg)
Database Management Software (DBMS)Definition: Software that controls the creation,
maintenance, and use of databases
Use of DBMS
![Page 31: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/31.jpg)
Database Maintenance
Updating a database continually to reflect new business transactions and other events
Updating a database to correct data and ensure accuracy of the data
![Page 32: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/32.jpg)
Database Interrogation
Definition: Capability of a DBMS to report information from
the database in response to end users’ requests
Query Language – allows easy, immediate access to ad hoc data requests
Report Generator - allows quick, easy specification of a report format for information users have requested
![Page 33: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/33.jpg)
Database Query vs. Report
![Page 34: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/34.jpg)
Management Information Systems, 7th Edition, James A. O’Brien, George M. Marakas. Chapter 5
References
![Page 35: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/35.jpg)
Data Mining
Definition: Analyzing the data in a data warehouse to reveal
hidden patterns and trends in historical business activity
![Page 36: Data Resource Management](https://reader036.vdocuments.us/reader036/viewer/2022062309/5681351d550346895d9c7ba1/html5/thumbnails/36.jpg)
Data Mining Uses
Perform “market-basket analysis” to identify new product bundles.
Find root causes to quality or manufacturing problems.
Prevent customer attrition and acquire new customers.
Cross-sell to existing customers. Profile customers with more accuracy.
Back