- eBook ISBN 9780124095267
- Print ISBN 9780124080560
Information Management: Gaining a Competitive Advantage with Data is about making smart decisions to make the most of company information. Expert author William McKnight develops the value proposition for information in the enterprise and succinctly outlines the numerous forms of data storage. Information Management will enlighten you, challenge your preconceived notions, and help activate information in the enterprise. Get the big picture on managing data so that your team can make smart decisions by understanding how everything from workload allocation to data stores fits together.
The practical, hands-on guidance in this book includes:
Read the book cover-to-cover, or keep it within reach for a quick and useful resource. Either way, this book will enable you to master all of the possibilities for data or the broadest view across the enterprise.
IT organizations/ vendors/consultants, DBAs, information architects, managers/directors of information management.
In praise of Information Management
Chapter One. You’re in the Business of Information
An Architecture for Information Success
The Glue is Architecture
Information in Action
Judgment Still Necessary
Chapter Two. Relational Theory In Practice
Chapter Three. You’re in the Business of Analytics
What Distinguishes Analytics?
Building Predictive Analytic Models
Analytics and Information Architecture
Analytics Requires Analysts
Chapter Four. Data Quality: Passing the Standard
Data Quality Defect Categories
Sources of Poor Data Quality
Cures for Poor Data Quality
Chapter Five. Columnar Databases
Chapter Six. Data Warehouses and Appliances
The Data Warehouse Appliance
Data Appliances and the Use of Memory
Chapter Seven. Master Data Management: One Chapter Here, but Ramifications Everywhere
A Subject-Area Culture
The Architecture of MDM
Data Quality and MDM
MDM Roles and Responsibilities
Chapter Eight. Data Stream Processing: When Storing the Data Happens Later
Uses of Data Stream Processing
Data Stream Processing Brings Power
Stream SQL Extensions
Chapter Nine. Data Virtualization: The Perpetual Short-Term Solution
The History of Data Virtua
From the Author: The Information Architecture To Pursue
A top priority of CIOs and organizations everywhere is how to best adapt the environment to manage the information asset. There is a plethora of available systems to throw into that equation. The possibilities can be daunting.
For such an important asset, the barometer cannot be a competitor’s environment. Early adopters of good practices will reap the most rewards. Following are several key actions to take to improve a company’s information architecture.
Move Key Operational Systems To In-Memory
In-memory for operational systems is appropriate wherever SQL is used operationally and the performance gains of in-memory can be utilized.
Configurations differ. Products like VoltDB are NewSQL systems purpose-built for storing data and throughput of transactional systems. NewSQL is used today for traditional high performance applications such as capital markets data feeds, financial trade, telco record streams, sensor-based distribution systems, wireless, online gaming, fraud detection, digital ad exchanges, and micro transaction systems.
NewSQL systems are in-memory, schema-based DBMS systems that scale out in a cluster. They have high availability architectures that use synchronous, multi-master, active-active replication. As the name implies, NewSQL supports full SQL – aggregate functions, LIKE, UNION, materialized views, indexes, etc.
In-memory also is found in DBMS environments that primarily scale-up like SAP HANA, Teradata, and IBM Pu