DW Basics
The Enterprise Data Warehouse: Planning, Building, and Implementation
This is an "in-the-trenches" guide to deploying data warehouses that align tightly with your business objectives. Sperley delivers a practical, business-focused methodology that's flexible enough for any enterprise.
Enterprise One to One: Tools for Competing in the Interactive Age
The authors of The One to One Future/I show any company how to implement their celebrated marketing approach--selling more products by targeting fewer customers individually--in order to increase productivity and competitiveness.
Data Warehousing Advice for Managers
Data Warehousing Advice for Managers/It helps readers: ** understand the benefits that data warehousing offers and convince upper management to take action ** coordinate the data warehouse with other technologies ** manage the implementation of the warehouse to ensure its compliance to specified requirements ** obtain the highest return on their investment.
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing, and Deploying Data Warehouses
In his bestselling book, "The Data Warehouse Toolkit", Ralph Kimball showed you how to use dimensional modeling to design effective and usable data warehouses. Now, he carries these techniques to the larger issues of delivering complete data marts and data warehouses.
90 Days to the Data Mart
After a brief overview of key concepts and terms, this resource provides a week-by-week action plan for creating a data mart. It guides readers through every phase of the project from planning and defining the project to writing specifications to building and testing the data mart.
Building the Operational Data Store, 2nd Edition
In Building the Data Warehouse, 2nd Edition, Inmon provides detailed discussion and analysis of all major issues related to the design and construction of the data warehouse. He shows how data warehouse solves the problem of getting information out of legacy systems and includes new techniques and applications of data warehouse technology.
Introduction to Data Mining and Knowledge Discovery
Excerpted from the Two Crows report Data Mining'98, Introduction to Data Mining and Knowledge Discovery, 2nd edition is a readable 31-page booklet aimed at business users who want a clear, non-technical overview of the techniques and capabilities of data mining. It's a valuable educational tool for prospective users.
Building a Better Data Warehouse
This book cuts through the hype and theory about data warehousing and gets down to the basics of walking every member of the team through design and implementation . Beyond "how to do it", this book is an implementation methodology that helps project teams identify who will be doing what and what tools each member will need.
Corporate Information Factory, 2nd Edition
The father of the data warehouse incorporates the latest technologies into his blueprint for integrated decision support systems Having invented the corporate information factory (CIF) to help IT and database managers cut through the jungle of information technologies out there, bestselling author Bill Inmon again teams up with experts Claudia Imhoff and Ryan Sousa to show you how to integrate all key components of the modern information system architecture in a way that meets your evolving business needs.
Decision Support in the Data Warehouse
The title includes a comprehensive survey of tools and technologies available today. This book explores decision support in a data warehousing environment. Focus is on building front-end decision support systems.
Planning and Designing the Data Warehouse
This is a comprehensive survey of key issues associated with planning and designing enterprise data warehouses. The text covers the process of implementing a data warehouse end-to-end, from planning to achieving management support, to implementing metadata repositories.
The Data Warehouse Challenge: Taming Data Chaos
Now, readers have to pull all data together in a single format that is compatible across the many different databases and software platforms used throughout the company. How? This resource shows them how.
Data Warehousing for Dummies
If you're looking for a slightly irreverent, humorous yet thorough discussion of data warehousing, then check out Data Warehousing for Dummies.
Building the Data Warehouse (3rd edition)
Since it was first published in 1990, W. H. Inmon’s Building the Data Warehouse has become the bible of data warehousing–– the first and best introduction to the subject. A lot has changed in data warehousing technology since the last edition appeared in 1996, and this latest volume is completely revised to reflect exciting new techniques and applications, update existing topics, and examine data marts, operational data stores, and the corporate information factory.
Data Warehousing, Data Mining, and OLAP
"Data Warehousing" is the nuts-and-bolts guide to designing a data management system using data warehousing, data mining, and online analytical processing (OLAP) and how successfully integrating these three technologies can give business a competitive edge.
The Data Warehouse Toolkit: Practical Techniques for Building Dimensional Data Warehouses
Employing many real-life case studies of data warehouses, Ralph Kimball provides clear-cut guidelines on how to model data and design data warehouses to support advanced multidimensional decision support systems.
Building a Data Warehouse for Decision Support
Completely revised, expanded, and updated, this second edition gives extensive new coverage of data integration, management, indexing, cleansing, and transformation.
Using the Data Warehouse
The data warehouse is a method of storing historical and integrated data for use in decision support systems (DSS). The data warehouse provides a source of integrated enterprise-wide historical data. This book describes how to use a data warehouse once it has been constructed. The authors discuss how to use information to capture and maintain a competitive advantage and how to migrate legacy systems to a data warehouse.
Discovering Data Mining from Concept to Implementation
Through extensive case studies and examples, this book provides practical guidance on all aspects of implementing data mining: technical, business, and social. The book also demonstrates IBM's powerful new intelligent Miner tool and shows how it can be applied.
Data Warehousing in the Real World: A Practical Guide for Building Decision Support Systems
Written in "cookbook" format, this book covers all stages of implementation from project planning and requirements analysis, through architecture and design, to administrative issues such as user access, security, and back-up/recovery.
Predictive Data Mining: A Practical Guide
The book begins by exploring the links between "big data"--the data warehouse built up of multiple databases--and traditional statistics. (The authors defend the methods of big data against traditional statistics, which has usually relied on smaller samples. However, they also look at the sources of error in both disciplines.)
Data Warehousing in Action
This book is a step-by-step guide to creating and managing a data warehouse from start to finish, reviewing marketing, technology, and design issues.
Data Warehouse: Practical Advice from the Experts
Intended as a practical handbook for the Data Warehouse. It is designed to help technical managers, project managers, and members of data warehouse project teams in all aspects of planning, designing, developing, implementing, and administering a data warehouse.
The Data Model Resource Book: A Library of Logical Data and Data Warehouse Designs
Proven data models that save companies' time and money developing databases and data warehouses. The Data Model Resource Book provides a common set of data models for specific functions common to most businesses, such as sales, marketing, order processing, budgeting, and accounting.
Building, Using, and Managing the Data Warehouse
Presents practical, real-world problems and solutions for a variety of issues related to information systems. Each separate issue is presented as an individual essay. They are all written by professionals representing both technological and user organizations.
Data Warehousing: Building the Corporate Knowledge
This book covers the fundamentals of successfully designing, modeling and delivering a data warehouse and details techniques and links readers to a comprehensive methodology that enables system professionals to build and deliver a data warehouse that meets both corporate and management needs.
Data Stores, Data Warehousing and the Zachman Framework: Managing Enterprise Knowledge
The Zachman Framework is a framework to organize and analyze data so it can be turned into a source of knowledge. Here is the first and last word on this hot topic from the inventors of the framework. The text explains how companies can apply this technology to their own data warehouses and stores.
Fundamentals of Database Systems
This book combines clear explanations of theory and real systems, broad coverage of modeling and design of databases, and excellent examples with up-to-date introductions to modern database technology.
Relational Database Design Clearly Explained
The book shows readers how to construct the SQL statements needed to install well-designed relational databases, and discusses other performance related database design issues, such as indexes and clustering.
Introduction to Metadata: Pathways to Digital Information
This book explains its importance and potential uses in the networked environment, and describes existing metadata standards in the field of cultural heritage information. A glossary of terms and expressions and a selected bibliography provide useful information for understanding this timely topic.
Data Warehousing: Architecture and Implementation
Provides an overview of solutions and step-by-step processes for building warehouses. Some of the topics covered include migration strategies and scenarios, warehouse management, maintenance and support, 12 steps for implementation, techniques for schema design and metadata, and criteria for selecting the right hardware, software, and platforms.
The Essential Guide to Data Warehousing
Lou Agosta shows how data warehousing can dramatically reduce business uncertainty by transforming a tidal wave of information into knowledge that can be acted upon. Agosta also teaches the best ways to design, implement, and optimize data warehouses-- and how to avoid failure.
Data Mining: Building Competitive Advantage
Provides the reader with a comprehensive understanding of data mining concepts as well as showing how to use and make the most of the data mining tools that exist on the market today.
Data Warehouse Management Handbook
Provides a practical hands-on source book that guides you through the daily process of building and maintaining a data warehousing environment. CD-ROM included.
Mastering Data Mining: Art and Science of Customer Relationship Management
A case study—based guide to best practices in commercial data mining. Focuses on achieving business results, placing particular emphasis on customer relationship management.
e-Data: Turning Data into Information with Data Warehousing
Reveals what business people should know about data warehouse implementation, as well as techniques for evaluating and justifying new data warehouses and data marts.
Exploration Warehousing
Bill Inmon introduces exploration warehousing, a revolutionary new method that helps users flush out business opportunities hidden in patterns of data. He explains the exploration process and identifies the types of data warehouse designs best suited for exploration. Using numerous case examples, he describes his original exploration techniques and demonstrates how IT and database managers can work together with business managers to identify patterns of data which, for example, indicate the existence of fertile new markets for products.
Data Warehousing: Using the Wal-Mart Model
At 70 terabytes and growing, Wal-Mart's data warehouse is still the world's largest, most ambitious, and arguably most successful commercial database. Written by one of the key figures in its design and construction, Data Warehousing: Using the Wal-Mart Model gives you an insider's view of this enormous project. Continuously drawing from this example, the author teaches you the general principles and specific techniques you need to understand to be a valuable part of your organization's own data warehouse project, however large or small. You'll emerge with a practical understanding of both the business and technical aspects of building a data warehouse for storing and accessing data in a strategically useful way.
Designing a Data Warehouse: Supporting Customer Relationship Management
For database developers, architects, consultants, project managers, and decision-makers Today's next-generation data warehouses are being built with a clear goal: to maximize the power of Customer Relationship Management. To make CRM-focused data warehousing work, you need new techniques, and new methodologies. In this book, Dr. Chris Todman—one of the world's leading data warehouse consultants—delivers the first start-to- finish methodology for defining, designing, and implementing CRM- focused data warehouses.
Data Warehousing and Business Intelligence for E-Commerce
Data Warehousing And Business Intelligence For E-Commerce provides the fresh orientation to data warehousing that you've been looking for. Written by data warehousing consultants who are leading the charge into the realm of e-commerce applications, this book-which focuses heavily on the special "customer intimacy" required by e-commerce-will help you discard outdated assumptions and plan and implement new solutions that support new business needs and models.
Practical Issues in Database Management: A Reference for the Thinking Practitioner
Written for database designers, programmers, managers, and users, it addresses the core, commonly recurring issues and problems that practitioners--even the most experienced database professionals--seem to systematically misunderstand.
Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design
The information revolution is in motion, and sound database design will drive the ease of data handling and, in turn, improve the results of business practices. A timely topic, then, is Object-Role Modeling (ORM), a way to design and query databases via an application written in lay terms. Halpin expertly explains ORM as well as other solid database design practices so that even seasoned pros will learn something new. Designers, programmers, systems analysts, and managers will discover everything they need to know about database design. Complete with a companion web site, this is highly recommended for libraries serving techies.
Data Warehouse Scorecard: Cost of Ownership and Successes in Application of Data Warehouse Technology (PDF download)
As is the case with many enterprise application initiatives, some companies are finding that data warehousing is not providing the originally expected business value or return on investment. META Group has identified a number of specific factors that can help determine whether a data warehousing strategy is headed for success or failure. This penetrating report documents these factors and provides a unique snapshot of real-world production data warehouse environments, giving insight into how others are—or aren't—achieving success in their current data warehousing efforts. This exhaustively researched publication not only reveals the industry's best practices, but also uncovers data warehousing pitfalls to help readers avoid repeating others' mistakes and set realistic, achievable objectives for their own data warehouse.
Data Warehouse Marketing Trends/Opportunities: 1999
Data warehousing is a hot topic, driven by mandates for customer- centric organizations and the need for robust reporting and business intelligence. With an avalanche of information—and misinformation—on the subject, this META Group publication sifts through the hype to deliver the first objective map of the business trends and technology drivers affecting this critical IT area. The publication offers an in-depth study of ten key industries that are exploiting data warehousing to its best effect, examining critical issues that drive spending on data warehouse hardware, software and services. The report shows trends within each industry segment and provides detailed case studies and recommendations. It also includes general data warehouse information, such as an analysis of leading concerns that impact data warehouse approaches and insight into obstacles that stand in the way of data warehouse success.
Impossible Data Warehouse Situations: Solutions from the Experts
A functional data warehouse is vital to an organization’s success, but building and maintaining any data warehouse is fraught with managerial and technical pitfalls. Impossible Data Warehouse Situations introduces possible solutions to ninety-one common crises that confront companies of all types, sizes, and structures. Nine leading data warehousing experts provide the thoughtful and detailed guidance corporate executives, IT managers and staff, and end-users need to prevent and survive seemingly impossible situations. This book serves both as a quick reference for resolving specific data warehouse problems and a practical introduction to realities of data warehousing not covered in basic texts.
Modern Data Warehousing, Mining, and Visualization: Core Concepts
Designed for undergraduate/graduate-level courses in Information Systems or Operations and Decision Technologies electives and taking a multidisciplinary user/manager approach, this text looks at data warehousing technologies necessary to support the business processes of the 21st century.
Healthcare Information Systems: Challenges of the New Millennium
Contributors report on the implementation of healthcare information systems, looking at both success stories and reasons for failure in the design, development, and implementation of these systems. They examine developments in fields of information security, methods for measuring success and failure of systems, telemedicine, methods for handling complexity in hospital information systems, artificial intelligence in medicine, and knowledge acquisition.
E-Healthcare Data Warehousing
Business Intelligence Roadmap: The Complete Project Lifecycle for Decision-Support Applications
Business Intelligence Roadmap is the visual guide to developing an effective business intelligence (BI) decision-support application. This book outlines a methodology that takes into account the complexity of developing applications in an integrated BI environment. The authors walk readers through every step of the process—from strategic planning to the selection of new technologies and the evaluation of application releases. The book also serves as a single-source guide to the best practices of BI projects.
Modern Database Management (6th Edition)
Designed for an introductory course in database management which is usually required as part of an information systems curriculum in business school, computer technology programs, and applied computer science departments.
IBM Data Warehousing: With IBM Business Intelligence Tools
In IBM Data Warehousing, Michael Gonzales shows how to exploit IBM technologies to get the most from your data warehousing investment. These technologies include everything from SMP and MPP technical architectures to DB2 Universal Database and DB2 OLAP Server. The author provides an in-depth look at the fundamentals of business intelligence (BI), the BI architecture, data management, and enhanced analytics. In addition, he presents expert tips, tricks, and workarounds to ensure maximum performance of your IBM data warehouse.
Database Management Systems: A Handbook for Managers and Their Advisors
Every operating manager has to deal with the problems and the opportunities afforded to them in controlling and managing data and data systems. Since management systems are absolutely essential for a successful enterprise, this book is designed to the aid the professional in the selection, implementation, and management of a database system. Learn how to make your system function at its optimal level and accomplish what it is designed to do! With coverage of web and traditional database management systems, applications, programming, and much more, this guide is an essential for any professional looking for the optimum performance from your company's databases.
Information Systems for Healthcare Management
This much-anticipated text will help future healthcare managers understand the prinicples of analysis, design, evaluation, selection, acquisition, and utilization of information systems in healthcare organization settings. Sufficient technical detail on computer hardware, software, networks, and telecommunications is included so that students can understand technology's role in healthcare. Written from a mangement perspective, this text emphasizes the intelligent use of information for strategic planning, decision support, program management, high quality patient care, and continuous quality improvement.
Healthcare Information Systems, Second Edition
Explains how technology interrelates and affects healthcare organizations. Includes an overview, tips on disaster planning, quality improvement, HIPAA regulations, the changing organization, and using IT to deal with government regulations. Features expanded coverage, the increasing role of the Internet, and much more.
Database Processing: Fundamentals, Design, and Implementation, Ninth Edition
This ninth edition provides a solid foundation in the fundamentals of database processing. It includes expanded and updated treatment of technologies like XML and ADO.NET as well as 30 pages of new exercises and problems.
Five Steps to an SAP Career: Your Guide to Getting into SAP
Prompt Connectivity Series: Data Warehousing
Datawarehousing is the manipulation of the data collected by your business. This manipulation of data provides your company with the information it needs in a timely manner, in the form it desires. This complex and emerging technology is fully addressed in this book. Author Amitesh Sinha explains datawarehousing in full detail, covering everything from set-up to operation to the definition of terms.
Intelligent Data Warehousing: From Data Preparation to Data Mining
This book presents state-of-the-art data warehousing research and practice from an integrated business and computer science perspective - the first monograph to do so - and broadens the scope of data mining by discussing it in terms of data warehousing. The material, rooted in database management systems and artificial intelligence, brings the intelligent techniques associated with AI to the entire process of data warehousing, from preparing data and building data warehousing to analyzing data.
Secrets of the Best Data Warehouses in the World
The Power of IT: Survival Guide for the CIO
Information Technology is not only about computers, software or services. IT is a combination of all these elements, capped by a vision on how technology can help an organization to reach its goals. Today, businesses are concentrating on their core activities in their struggle to survive. The information technology department has to do ever more with less. Under these circumstances, there is a growing need for well-informed IT professionals.
The Power of IT will reveal to you all the secrets of the successful IT manager or CIO. You will discover the "best practices" to align business and IT. You will learn to be a strategic thinker, how to measure the results of the information technology department, realize breakthrough IT projects, act as an "inside" IT consultant and develop a proven communication strategy between IT and the rest of the organization. Whether you are a veteran CIO, an experienced IT manager, an ambitious IT professional, or doing a Master in Business Administ
For more information visit http://www.the-power-of-it.com/
Oracle DBA: Guide to Data Warehousing and Star Schemas
This author hopes this book serves as the DBA's definitive and detailed reference regarding the successful design, construction, tuning and maintenance of star schema data warehouses in Oracle 8i and 9i.
The Microsoft Data Warehouse Toolkit
With this book, the authors share best practices for using SQL Server 2005 to build a successful DW/BI system. Covering the complete suite of data warehousing tools that accompanies SQL Server 2005, they focus on the full project lifecycle, including design, development, deployment, and maintenance. You'll learn how and when to use BI tools such as Analysis Services, Integration Services, and the SQL Server database to accomplish various data warehousing tasks. A helpful case study used throughout the book provides examples of the techniques presented. You'll find practical guidance for every member of the data warehouse team
Joe Celko's Analytics and OLAP in SQL (The Morgan Kaufmann Series in Data Manage
Before SQL programmers could begin working with OLTP (online transaction processing) systems, they had to unlearn procedural, record-oriented programming before moving on to SQLs declarative, set-oriented programming. This book covers the next step in your growth. OLAP (online analytical processing), data warehousing and analytics involve seeing data in the aggregate and over time, not as single transactions. Once more it is time to unlearn what you were previously taught.
This book is not an in-depth look at particular subjects, but an overview of many subjects that will give the working RDBMS programmers a map of the terra incognita they will faceif they want to grow.
Professional SQL Server 2005 Programming (Programmer to Programmer)
Professional SQL Server 2005 Programming shows experienced developers how to master the substantially revamped feature set of the latest release of Microsoft SQL Server. The book begins with a concise overview of the new features of SQL Server that is of interest to experienced developers. This is especially important given the substantial changes to SQL Server with this release. From there, the book quickly moves on to the "meat" of the title. Beginning-level material has been removed to provide more room for covering new features and more extensive code examples.
Implementing a Data Warehouse: A Methodology that Worked
The purpose of this book is to document the methodology and chronology of work activity used to successfully implement a data warehouse. Each step of the methodology is presented in the book, often using actual working documents as examples. The book contains lessons learned (both good and bad) as well as measures of success for each step. Again, the purpose of this book is to provide actual examples of processes, work papers, technical documentation, pitfalls and measures of success that led to a successful working data warehouse. This is not "The BEST and ONLY Book" for implementing a data warehouse and associated BI, but if a reader wants to see a methodology that worked - this book will provide that view.
Implementing Enterprise Data Warehousing
Designing complex analytical data structures is difficult enough, but to do it for an entire enterprise becomes a real challenge. This little primer provides a simple method of preparing your people for the complexity of this endeavor. This is just like opening a new restaurant where certain components have to be designed and thought out before you start to build the kitchen. You do not have to be an "expert" to build a data warehouse. A lot can be outsourced, but you do need to be able to create your own plan according to your culture's specific requirements. Some cultures take more 'informing' and 'training' than others. The pace and aggressiveness with which you unfold your plan is something that you understand best. This primer defines the data warehouse components and helps you decide when they can be done, in what order, and by how many people.
