Information management is vital for today’s businesses. It requires significant investment and supports critical business processes. With the proliferation of the information economy and information systems, effective information management determines success of virtually every business operation. The aim of this book is to assist managers in becoming knowledgeable decision makers in the field of information management and analysis.

Click here to see the database files used in this book

Goals and Philosophy:

Information management is vital for today’s businesses. It requires significant investment and supports critical business processes. With the proliferation of the information economy and information systems, effective information management determines success of virtually every business operation. Obtaining business value from vast amount of information collected by businesses is no longer only a technological challenge. The choice of decision making tools and information solutions rests with the business, as well as with IT managers.

The aim of this book is to assist managers in becoming knowledgeable decision makers in the field of information management and analysis. Why do managers need to understand and participate in forging information strategy of their business? Do they need to be aware of what tools are available to transform information into business intelligence for decision making? After all, it is possible to completely outsource information management processes to a third party. Managers who choose to hand over information analysis solely to technical professionals jeopardise the foundation of their business decisions. Managers today need to be aware of current information analysis methods as well as the latest technology in the information management field to enhance productivity and stay ahead of competitors. This textbook covers methods of information analysis using relational databases written for current and future managers. The text finishes with an overview of current threats to business information assets and approaches to their mitigation.

Key Features:

Each chapter provides a comprehensive coverage of relevant theory concepts followed by review questions, and/or case studies and worked examples. Many practical examples are included to illustrate the data analysis concepts. These exercises should help students acquire hands on skills, prepare for assessment and solve types of problems encountered in employment. The book is supported by:

- A downloadable versions of the database files used in this book

- Further exercises

- Solutions for instructors

1. Introduction to Information Management
   1. Data and Informat ion
   2. Organi sing Data
   3. Information Everywhere
   4. Strategy and Information Systems
   5. Data Processing Software in an Enterprise
   6. Summary
   7. Review Questions
   8. Case Study: Walmart Harnesses RFID Technology to Improve Efficiency
2. Relational Data Model and SQL
   1. Scenario - Dream Destinations
   2. The Relational Model
   3. The SELECT statement
   4. Exercises
   5. Summary
3. Data Defi nitio n in SQL
   1. Data Definition Language (DDL)
   2. Dina Manipulation Language (DML)
   3. Exercises - DDL and D.\tL activities
   4. Summary
4. Advanced Selection Queries
   1. Ordering results
   2. Selecting Specific Rows
   3. Exercises - Order As and Selection
   4. Summary
5. Joining Tallies
   1. Cartesian Product
   2. Exercises - Join. Selection and Projection
   3. Summary
6. Functions, Aggregate and Group-set Functions
   1. Functions
   2. Aggregate Functions
   3. Nested Sub-queries
   4. Exercises
   5. Summary
7. Information secorttv Management
   1. Introduction
   2. Internet Security Threats: Known, Unknown and Predicted
   3. Brand Protection on the Internet
   4. Compliance Issues
   5. Prameworks for Control and Security: COBIT, ITIL', and ISO 27002
   6. Exercises