Managing Corporate Information Resources Chapter 7 Information Systems

  • Slides: 55
Download presentation
Managing Corporate Information Resources Chapter 7 Information Systems Management in Practice 8 th Edition

Managing Corporate Information Resources Chapter 7 Information Systems Management in Practice 8 th Edition © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -1

Chapter 7 Identifies problems in managing data and surveys evolution of DBMS l Explores

Chapter 7 Identifies problems in managing data and surveys evolution of DBMS l Explores various types of information that companies need to manage l Provides guidelines to management of knowledge (key organizational asset) l l Harbinger to Chapter 14 © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -2

Today’s Lecture l l Introduction Managing Data l l The Three-Level Database Model Four

Today’s Lecture l l Introduction Managing Data l l The Three-Level Database Model Four Data Models Getting Corporate Data into Shape Enterprise Resource Planning (ERP) © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -3

Today’s Lecture cont’d l Managing Information l l l Four Types of Information Data

Today’s Lecture cont’d l Managing Information l l l Four Types of Information Data Warehouses Document Management Content Management Managing Blogs Conclusion © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -4

Introduction l IS continually manages new forms of information resources l l Corporate databases

Introduction l IS continually manages new forms of information resources l l Corporate databases Documents (electronic or paper) and Web content Knowledge management Data—Information—Knowledge © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -5

Managing Data l Data management l l l Structured way data is represented, stored

Managing Data l Data management l l l Structured way data is represented, stored and retrieved for use. Database management systems (DBMS) are the main tool for managing corporate data Two principles of DBMS l l Three-level conceptual model Several alternative data models for organizing the data © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -6

The Three-Level Database Model l Level 1: External, conceptual or local level l Level

The Three-Level Database Model l Level 1: External, conceptual or local level l Level 2: Logical or enterprise data level l Various “user views” of corporate data Each application program has own view “Technical” (human) view of all corporate data Controlled by database administrators Level 3: Physical or storage level l l Specifies the way data is physically stored For use by database administrators © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -7

The Three-Level Database Model cont’d © 2009 Pearson Education, Inc. Publishing as Prentice Hall

The Three-Level Database Model cont’d © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -8

Four Data Models Alternative ways of defining relationships among types of data Hierarchical Model

Four Data Models Alternative ways of defining relationships among types of data Hierarchical Model l 1. l Structures data so that each element is subordinate to another in a distinct hierarchical manner l e. g. , Parent-child relationship © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -9

Four Data Models cont’d Network Model 2. l Allows each data item to have

Four Data Models cont’d Network Model 2. l Allows each data item to have more than one parent l Relationships stated by pointers stored with the data Relational Model 3. l Data stored in tables (intuitive for users) l “Key” uniquely defines each record l “Tuple-calculus” operations § Commands such as Select, Join, Match, etc. Data normalization (optimization) Not as efficient as hierarchical but more flexible l l § Database technology of choice (e. g. , SQL, MS Access) © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -10

Four Data Models cont’d Object-Oriented Database Model 4. l Extension of concept of data

Four Data Models cont’d Object-Oriented Database Model 4. l Extension of concept of data to objects: l l l Piece of data Methods that can perform work on data Attributes describing the data Relationships between objects Objects can be used to store any type of data l l e. g. , spreadsheet, video clip, photograph, music segment Object database © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -11

Four Data Models l Object-oriented models retain traditional DBMS features including l l l

Four Data Models l Object-oriented models retain traditional DBMS features including l l l End-user tools High-level query languages Concurrency control Recovery Ability to handle huge amounts of data Addition of two major concepts l l Object management Knowledge management © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -12

Four Data Models cont’d l Object-oriented models outperform relational systems for certain types of

Four Data Models cont’d l Object-oriented models outperform relational systems for certain types of database manipulation l l l Scientific and engineering applications Corporations slow to adopt due to legacy systems Tenets of objects have increasingly become important in world of computing l E. g. , Web Services because XML modules utilize object principles © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -13

Getting Corporate Data into Shape Inconsistent Data Definitions 1. l l Data definitions incompatible

Getting Corporate Data into Shape Inconsistent Data Definitions 1. l l Data definitions incompatible at many levels l Application, department, site, division System designers sought data from cheapest and/or politically expedient source to get systems up and running quickly Organizations end up with different files l Different names for same data l Same name for different data Management cannot get data consistency across the enterprise to make data-driven decisions l Products, markets, control structure © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -14

Getting Corporate Data into Shape cont’d Proliferation of heterogeneous database 2. l l DBMSs

Getting Corporate Data into Shape cont’d Proliferation of heterogeneous database 2. l l DBMSs used to meet a variety of specific tasks in many organizations Small databases in hundreds or thousands of microcomputers (PCs) across the organizations l l l Independent applications, different data structures, naming conventions, administrative procedures Difficult for IS to manage corporate data seamlessly. Imagine data management for interorganizational or global systems © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -15

Getting Corporate Data into Shape cont’d Data availability, integrity and security 3. l Availability

Getting Corporate Data into Shape cont’d Data availability, integrity and security 3. l Availability l l Integrity l l How to get the terabytes of data at the right place and right time? Data should be entered correctly once in the system Security l Data protection is a top concern in organizations today © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -16

Getting Corporate Data into Shape cont’d l Role of Data Administration l l Administering

Getting Corporate Data into Shape cont’d l Role of Data Administration l l Administering databases and software that manages them to provide accurate and timely information to users Determining what data is being used outside of originating organizational unit boundaries l l Definition and format must be standardized “Data dictionary” used as main tool § Data elements definition, schema, database structures, usernames, roles and privileges © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -17

Enterprise Resource Planning l l ERP provides the means to consolidate data to give

Enterprise Resource Planning l l ERP provides the means to consolidate data to give management a corporate-wide view of operations An important prerequisite to installing an ERP system is data consistency l l Data definitions cleaned up Shared data controlled Data distribution managed Data quality maintained © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -18

Managing Information l l l Once enterprises get their data into shape, that data

Managing Information l l l Once enterprises get their data into shape, that data can more easily be turned into information “Information is power” Managing information is a critical activity l l Technology = infrastructure Asset = information that runs on that infrastructure © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -19

Managing Information cont’d l Four Types of Information l Internal record-based information—original focus of

Managing Information cont’d l Four Types of Information l Internal record-based information—original focus of IS and most used in organizations l l Internal document-based information l l Reports, emails, proposals External record-based information l l Found in databases Acquisition from external databases External document-based information l World-Wide-Web © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -20

Four Types of Information © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7

Four Types of Information © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -21

Records versus Documents © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -22

Records versus Documents © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -22

Managing Information cont’d l Record-based information was IS focus l l Little attention to

Managing Information cont’d l Record-based information was IS focus l l Little attention to document-based information l l Difficult to manipulate Intranets and Internet (html) changed this l l Easy to generate and manage Documents integral part of information now IS is involved in all four areas of information today © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -23

Scope of Information Management © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7

Scope of Information Management © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -24

Data Warehouses l Data warehouse: Stores data used to make decisions l l Obtained

Data Warehouses l Data warehouse: Stores data used to make decisions l l Obtained periodically from transaction databases Snapshot of situation at specific time Different from operational databases Customer data is most common type of data housed l Corporate use transcends reporting internal data to business intelligence today © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -25

Data Warehouses cont’d l Metadata l The part of the warehouse that defines the

Data Warehouses cont’d l Metadata l The part of the warehouse that defines the data l Explains meaning of each data element and sets standards § l Quality data l l e. g. to reconcile data from legacy systems The cleaning process to adhere to metadata standards l The older the data the more suspect its quality Datamart l A subset of data pulled off the warehouse for a specific group of users l Faster search time and lower costs © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -26

Data Warehouses cont’d Five steps in a data warehousing project: l 1. 2. 3.

Data Warehouses cont’d Five steps in a data warehousing project: l 1. 2. 3. 4. 5. Define the business uses of the data Create the data model for the warehouse Cleanse the data Select the user tools Monitor usage and system performance © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -27

Data Warehouses cont’d l Data warehouses are seen as strategic assets that can yield

Data Warehouses cont’d l Data warehouses are seen as strategic assets that can yield business intelligence l l customer behavior, internal operations, product mixes, etc. Again, getting corporate data into shape is a key prerequisite l e. g. , reconciling data from legacy systems © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -28

Owens & Minor Case Example: Data Warehousing l O&M—a medical and surgical supplier l

Owens & Minor Case Example: Data Warehousing l O&M—a medical and surgical supplier l Illustrates how O&M is innovatively using its data to achieve competitive advantage l l ERP Data warehousing Web O&M employs these technologies to provide internal use of data (decision support) and also revenuegenerating services to customers and suppliers © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -29

Owens & Minor cont’d l Implemented ERP to automate order forecasting l l l

Owens & Minor cont’d l Implemented ERP to automate order forecasting l l l Improved inventory turns, lowered ordering rates Improved customer service Provided customers and suppliers access to its data warehouse (inventory data) through “Wisdom” (Web medium) l l l Predefined queries Interactive system (customers add external data) Mobile Web Services © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -30

Owens & Minor l l “Wisdom” was the first e-business intelligence application in the

Owens & Minor l l “Wisdom” was the first e-business intelligence application in the industry O&M’s role as an industry “infomediary” important and gave it a competitive edge l l l Strengthened relationships with partners, suppliers, customers Enticed new customers and created switching costs Generated new source of revenue © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -31

Document Management l Documents more pervasive and fundamental than anything else in an organization.

Document Management l Documents more pervasive and fundamental than anything else in an organization. l l l Paper still plays a major role in most enterprises Need to move seamlessly between digital and print Electronic document management (EDM) uses new technologies for document management to produce significant impacts l l Business process redesign Quality improvement © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -32

Document Management cont’d l Improve the publishing process l l l Traditional process has

Document Management cont’d l Improve the publishing process l l l Traditional process has inefficiencies l Infrequent long print runs require storing documents which become obsolete between runs l 60% of total cost of delivering these documents in storage and transportation EDM enables major restructuring of publishing and distribution process of print documents l Electronic storage l Mass distribution (over time/space) and print when needed EDM minimizes obsolescence, physical warehouse costs and delivery time © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -33

Traditional Publishing Process © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -34

Traditional Publishing Process © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -34

Electronic Document Management © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -35

Electronic Document Management © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -35

Document Management cont’d l Supporting communication among people and groups l The value of

Document Management cont’d l Supporting communication among people and groups l The value of documents is that they transfer information across time and space l l Internet can help but people often still rely on print documents EDM can be used to facilitate such communications among people and groups l Tapiola case study illustrates how © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -36

Tapiola Insurance Group Case Example: Supporting communications among people and groups l Tapiola Group

Tapiola Insurance Group Case Example: Supporting communications among people and groups l Tapiola Group offered 150 types of insurance policies with 300 different policy forms l l l All preprinted by outside print company Reprinting new forms often took weeks l Potential loss of revenue Investigate alternate ways for document publishing l l l Reduce costs Provide new ways of marketing insurance products Make Tapiola “the most personal insurance company in Finland” © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -37

Tapiola Insurance Group cont’d l Centralized Solution l l l Decentralized Expansion l l

Tapiola Insurance Group cont’d l Centralized Solution l l l Decentralized Expansion l l Reduced 300 preprinted forms to 4 standard-sized forms Used plain paper printers from Xerox to generate forms l Xerox electronic document processing products enables text, data, image and graphics in documents Moved much of printing of customer correspondence to their 62 branch offices to improve customer service through better communication with customers and partners l Mix of host computing with local EDM applications l Fast banking system (collaboration with Finnish banks) Mission accomplished © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -38

Document Management cont’d l Supporting organizational processes l l l Documents still the vehicle

Document Management cont’d l Supporting organizational processes l l l Documents still the vehicle for accomplishing most organizational processes Use of technology to support processes generates significant business value (transaction) l Reducing physical space l Faster routing l Managing and tracking work flow and load Use of technology to improve management processes l Decision support l Problem solving l Control © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -39

Tennessee Valley Authority Case Example: Supporting Organizational Processes l l Largest supplier of power

Tennessee Valley Authority Case Example: Supporting Organizational Processes l l Largest supplier of power in U. S. Revamped maintenance management system l l l System relies on documents such as manuals, drawings and instructions that are regulated by government Analyzed and charted existing work processes to determine where improvements were most needed Discerned that document workflow was inextricably linked to work orders and therefore key to significant improvements © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -40

Tennessee Valley Authority cont’d l Revamped maintenance management l l l Collapsed all disparate

Tennessee Valley Authority cont’d l Revamped maintenance management l l l Collapsed all disparate systems into two main integrated electronic systems l Maintenance work orders l Procedural management documents Redesigned entire process l Data diagramming techniques to map out workflow l Testing retrieval times, routing efficiencies, transmission rates Work orders generated electronically and then routed for approval with most current drawings and procedures l Workers can easily access documentation on equipment parts, records and instructions etc. § Enables work efficiency and planning for future © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -41

Tennessee Valley Authority cont’d l New system an overall success l l l Productivity

Tennessee Valley Authority cont’d l New system an overall success l l l Productivity and efficiency increases ( errors) Significant cost reductions (labor) and cycle time savings Work operations made transparent to public Team underestimated change management effort Improved document management system contributed to knowledge management © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -42

Content Management l Corporate intranets (Web content) now replace print documents l l Necessary

Content Management l Corporate intranets (Web content) now replace print documents l l Necessary to support scale of e-business operations Automation of content l Computer-readable and interchangeable format § l e. g. , XML Content is no longer static, but interactive © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -43

Content Management cont’d To create a content management strategy, companies need to understand the

Content Management cont’d To create a content management strategy, companies need to understand the three phases of content l 1. 2. 3. Managing content creation and acquisition Content administration and safeguarding Content deployment and presentation © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -44

Content Management cont’d Managing content creation and acquisition 1. l Focus on creating content

Content Management cont’d Managing content creation and acquisition 1. l Focus on creating content quality Content can be purchased from external specialists l § l syndicated content Decentralized organizational structure for content creation and maintenance to content-expert employees is best approach l l Central direction for dispersed experts however required Standardized organization-wide formats to integrate content into overall workflow also needed © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -45

Content Management cont’d Source: Adapted from Chuck, Tueber, Dealing in Web Currency, Gartner EXP,

Content Management cont’d Source: Adapted from Chuck, Tueber, Dealing in Web Currency, Gartner EXP, 56 Top Gallant, Stamford, CT, June 2001. © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -46

Content Management cont’d Content Administration and Safeguarding 2. l l l Efficiency is key

Content Management cont’d Content Administration and Safeguarding 2. l l l Efficiency is key in this phase Content management tools can be used to identify types of content and the business rules that apply to each type Content administration should be centralized Organizational workflow l § How content fits into overall organization process Content approval l § e. g. , foreign language translation © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -47

Content Management cont’d Content Deployment and Presentation 3. l Effectiveness is the emphasis in

Content Management cont’d Content Deployment and Presentation 3. l Effectiveness is the emphasis in this phase— maximize effect of Web content presentation Attract visitors and gain desired outcomes l § l l Easy site navigation, pertinent and accurate information This phase is crucial to success of e-commerce effort and so Web site design should start here Most Web sites today require certain features to attract and retain visitors l l Personalization Localization © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -48

Content Management cont’d l Selecting Web Content Management tools l l Wide range of

Content Management cont’d l Selecting Web Content Management tools l l Wide range of COTS available today Some important selection criteria l l l Digital asset management Information rights management Ability to handle full range of digital content types Versioning Workflow and approval routing Web publishing platform © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -49

Eastman Chemical Company Case Example: Content Management l Redesigned Web site in 1999 l

Eastman Chemical Company Case Example: Content Management l Redesigned Web site in 1999 l l Goal to become more customer-oriented and launch ecommerce initiative l Outside-in view (process starts from customer markets) Upgraded content management software for seamless process to l l Create pre-approved templates for employees to use (distributed), and Forward content pages for approval (centralized) © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -50

Eastman Chemical Company cont’d l Benefits of site redesign l Web traffic growth far

Eastman Chemical Company cont’d l Benefits of site redesign l Web traffic growth far greater than expected l l l Overall traffic tripled 50 percent outside of U. S. 70 percent in market sectors where Eastman sells its products Customers report that online availability of technical data significantly improved their internal decision-making processes Eastman now working on globalizing and personalizing the site even further © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -51

Managing Blogs l Blog = Web log l l Originally intended as personal electronic

Managing Blogs l Blog = Web log l l Originally intended as personal electronic journal Increasingly used in lieu of traditional Web site today Competes with mainstream media Opportunities and challenges for organizations posed by this immediate form of publishing and communication l l Used for crisis management, knowledge management Information security l Careless or deliberate leak of confidential information l Company reputation vulnerable © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -52

Groove Networks l l Company views personal Web sites and blogs positively Established employee

Groove Networks l l Company views personal Web sites and blogs positively Established employee guidelines for personal Website and blogs however l l l Clarify to readers that personal views expressed are separate from those of the company Take care not to disclose confidential information Generally, exercise good discretion and be respectful to l Company l Employees l Customers © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -53

Conclusion l IS job of managing information resources is widening significantly l l l

Conclusion l IS job of managing information resources is widening significantly l l l Get corporate data in shape Create and build infrastructure to manage full spectrum of information types Internet provides an easily accessible place to store and retrieve information ad hoc. Issues include, but are not limited to: l l Information glut Security © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -54

All rights reserved. No part of this publication may be reproduced, stored in a

All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior written permission of the publisher. Printed in the United States of America. Copyright © 2009 Pearson Education, Inc. Publishing as Prentice Hall © 2009 Pearson Education, Inc. Publishing as Prentice Hall 7 -55