DW Administration, Mgmt., Performance
Business Intelligence: The IBM Solution: Data Warehousing and OLAP
Data warehousing and data mining allow decision-makers to leverage information and organizational knowledge to gain competitive advantage. These pages take a non-intimidating look at IBM's Business Intelligence Applications, in particular the Visual Warehouse and the OLAP Server.
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.
Interactive Data Warehousing
From start to finish, data warehousing expert Harry Singh walks you through creating a Web-based data warehouse architecture for maximum growth and flexibility. Step by step, you'll learn how to choose the best platforms, technologies, and strategies for your organization-and implement them.
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.
Machine Learning and Data Mining; Methods & Applications
Master the new computational tools to get the most out of your information system. This practical guide, the first to clearly outline the situation for the benefit of engineers and scientists, provides a straightforward introduction to basic machine learning and data mining methods, covering the analysis of numerical, text, and sound data.
Web Farming for the Data Warehouse
Data warehouses are usually based upon the contents of internal operations databases. With Web Farming, the focus can be balanced with external business factors, dealing moment by moment with global changes in the business environment.
Data Warehouse Performance
Create low-cost, high-performance data marts and data warehouses. It is imperative that data warehouse designers and developers learn the right techniques to improve performance of existing systems and build in performance when designing new data marts and warehouses.
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.
Data Warehouse Design Solutions
The authors of Data Warehouse Design Solutions share their expertise in designing successful data warehouses and concentrate on understanding business processes within a variety of industries.
Mining Very Large Databases With Parallel Processing
It is assumed that the reader has a knowledge roughly equivalent to a first degree (B.Sc.) in accurate sciences, so that (s)he is reasonably familiar with basic concepts of statistics and computer science. The primary audience of Mining Very Large Databases with Parallel Processing is industry data miners and practitioners in general, who would like to apply intelligent data mining techniques to large amounts of data. The book will also be of interest to academic researchers and post-graduate students, particularly database researchers interested in advanced, intelligent database applications and artificial intelligence researchers interested in industrial, real-world applications of machine learning.
Oracle8 Data Warehousing
Gary Dodge covers the basics of data warehousing and then moves into technical instructions on how to select the appropriate hardware architecture, design the warehouse for optimum performance, build the database, and run it. He covers advanced techniques for distributing and mining data.
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.
Managing the Data Warehouse
This book is written for those charged with the job of managing and administering their companies' data warehouses. Managing the Data Warehouse is a complete guide to everything information systems managers need to know to keep a data warehouse running smoothly, efficiently, and securely, now and in the years ahead.
Data Warehouse: From Architecture to Implementation
Devlin helps organize all of the bits and pieces into a (his) well architected view of the subject. The book provides an excellent, well organized overview of DW while providing enough detail to be useful to almost anyone involved in the process of building or maintaining a DW.
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.
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.
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.
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.
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.
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.
Improving Data Warehouse and Business Information Quality: Methods for Reducing Costs and Increasing Profits
Comprehensive guide to measuring and improving information quality both data warehouses, operational databases and source business processes. Provides checklists for quality data definition and information architecture. Describes how to implement an effective information quality environment with data defect prevention. Author provides a money back warranty (page xxvi). Also available in Japanese.
Data Preparation for Data Mining
Data Preparation for Data Mining addresses an issue unfortunately ignored by most authorities on data mining: data preparation.
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.
Oracle Database Administration: The Essential Reference
The Oracle database administrator (DBA) performs a vitally important set of tasks at an Oracle site: database monitoring, backup and recovery, troubleshooting, and tuning for reliability and performance. The DBA also plays a role in initial database design, system configuration, installation, and security planning. This book provides a quick reference to the myriad details an Oracle DBA needs on a day-to-day basis to help do his or her job well.
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.
Multimedia Data Management: Using Metadata to Integrate and Apply Digital Media
Here is the authoritative handbook on multimedia metadata and data management. In one volume, it gathers a wealth of information from the field's leading international experts in this emerging specialty.
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.
Microsoft Data Warehousing: Building Distributed Decision Support
Helps map the process for you, particularly if you're planning to build your warehouse around Microsoft SQL Server 7 and its related technologies.
Official Sybase: Data Warehousing on the Internet
Information systems professionals are taking advantage of the Internet to enhance business intellegence functions in their enterprise. Employees, customers and others can use the Internet to gather self-service information from the corporate data warehouse. Let this guide show you how.
Web Warehousing and Knowledge Management
Rob Mattison cuts through the hype that surrounds data warehousing and data analysis; he explores the software tools that provide the ability--IQ and Aperio--and he reviews IBM's various data mining tools. This book--particularly the section on Online Analytical Processing [OLAP] reports--cries out for information on putting Extensible Markup Language (XML) to work in data warehouse applications.
PeopleSoft Application Development Tools
This book assumes no prior knowledge of PeopleSoft. It works with the end user from an introduction to the concepts and the look and feel of PeopleSoft applications all the way through to completing custom applications.
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.
Oracle8i for Windows NT Starter Kit
Learn to configure, administer, and tune a database system and master the fundamental skills necessary to build SQL, PL/SQL, and Java applications that interact with Oracle8i.
Oracle8i SQLJ Programming
Explains in detail how to implement SQLJ - the new standard for embedding static SQL directly into Java programs. This authoritative guide shows you how to create cross-platform, distributed, and Web-enabled applications designed specifically for Oracle8i.
Oracle 24x7 Tips & Techniques
This book highlights innovative solutions that are either hidden, undocumented, or can only be discovered through many years of experience or through extensive trial and error.
Oracle DBA 101
Learn the ins-and-outs of Oracle database administration from the experts. Oracle DBA 101 describes in detail the day-to-day duties of a database administrator - and how to accomplish them.
Oracle Developer Advanced Forms and Reports
This guide contains an invaluable resource - a discussion of actual Forms and Reports standards used by the authors to create production systems. Included are standards for the use of SQL and PL/SQL in the development tools, naming conventions, and GUI design.
Oracle8i Web Development Handbook
Cutting-edge Oracle data warehousing from people creating the software Oracle8i Data Warehousing explains how to design, develop, and administer powerful data warehouses and data marts on Windows NT using Oracle's major new industry-leading database. This authoritative guide helps database developers, administrators, and designers master the major new data warehousing and Internet capabilities in Oracle8i and specifically plan and implement affordable and successful data warehouses and data marts. In one exciting package, this book brings together three hot computing topics: new Oracle databases, Windows NT, and Internet technologies.
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.
Object-Oriented Data Warehouse Design: A Star Schema
Designed to help build a complete star schema data model-from initial analysis through implementation, make better decisions about granularity and precision, master dimensioning, hierarchies, and sizing.
Oracle Certified Professional Database Administrator Certification Exam Guide
The main content of each DBO Exam Guide chapters will include figures, tables, tips, and other content in the same format as its predecessors, the OCP DBA and Developer Exam Guides. Following the main content will be: short chapter review; two- minute drill; 10-15 multiple choice questions modeled after the OCP exam questions and answers to chapter questions along with explanations. CD-ROM includes electronic, full searchable version of the Exam Guide hyperlinked to over 300 practice exam questions.
Oracle8i Data Warehousing
Explains how to design, develop and administer powerful data warehouses and data marts on Windows NT using Oracle's database. This authoritative guide helps database developers, administrators, and designers master the major new data warehousing and Internet capabilities in Oracle8i and specifically plan and implement affordable and successful data warehouses and data marts.
Data Warehousing With Microsoft SQL Server 7 Technical Reference
This guide simplifies this process by showing you how to use the features of SQL Server 7.0 to design, build, and manage a data warehouse.
The Data Webhouse Toolkit: Building the Web-Enabled Data Warehouse
Today's most popular commercial Web sites receive more than 100 million hits a day—each hit, a potential source of valuable customer information. Unfortunately, many companies fail to take advantage of this intelligence gold mine for lack of a means of managing the torrent of data streaming into their Web sites.
Business Information Warehouse for SAP
Business Information Warehouse is the core information hub of all modules in SAP. This book shows you how to implement a data warehouse that can support reporting and analysis needs across diverse organizations and business functions.
The Official Guide to Informix/Red Brick Data Warehousing
The RedBrick Data Warehousing Bible is the comprehensive tutorial and reference to Informix RedBrick Data Warehouses. The book covers all the features of RedBrick in the process of building a data warehouse through its complete lifecycle, beginning with planning the project, designing the database, building and loading the database, deploying the database to business users and maintaining the data warehouse in the future. Each of the topics is presented in a straightforward fashion by discussing in detail the objective, concepts, and implementation techniques and briefly touching on the more advanced components. One ongoing case study used throughout the book allows the reader to build upon it with each major area to create a sample data warehouse. Sample forms and documents as well as completed exercises are provided on the CD-ROM.
Distributed Data Warehousing Using Web Technology : How to Build a More Cost-Effective and Flexible Warehouse
Internet technology has changed all that forever! In this insightful book, managers and information technology professionals get a clear-eyed overview of what's required to set up and use distributed data warehouses--which utilize multiple computers (networked together via Internet technology) to store and access data as needed. The book takes a look at: * Basic functions and benefits of a distributed data warehouse and what's required to set one up * Many of the complex technical issues involved, such as placement of functions and data, web-enabled computing technologies, object technologies, and more * The full spectrum of what a data warehouse can deliver--and how to exploit it * How to present and justify a business case for creating a data warehouse.
Data Warehouse Project Management
Data warehouse development projects present a unique set of management challenges that can confound even the most experienced project manager. Data Warehouse Project Management addresses these challenges and provides a comprehensive roadmap to managing every aspect of data warehouse design, development, and implementation. Drawing on their extensive experience in the field, Sid Adelman and Larissa Moss point to critical success factors, reveal the many pitfalls to watch out for, and offer proven solutions that will enable you to put a successful data warehouse project into place.
Fuzzy Modeling Tools for Data Mining and Knowledge Discovery
Intelligent Data Engineering and Automated Learning - Ideal 2000
Proceedings of the 2nd International Conference on Intelligent Data Engineering and Automated Learning: IDEAL 2000, Data Mining, Financial Engineering, and Intelligent Agents, held in Hong Kong, China, December 13-15, 2000. Softcover.
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
Dimensional modeling has become the most widely accepted approach for data warehouse design. Greatly expanded to cover both basic and advanced techniques for optimizing data warehouse design, this second edition to Ralph Kimball’s classic guide is more than sixty percent updated.The authors begin with fundamental design recommendations and gradually progress step- by-step through increasingly complex scenarios. Clear-cut guidelines for designing dimensional models are illustrated using real-world data warehouse case studies drawn from a variety of business application areas and industries.
Common Warehouse Metamodel: An Introduction to the Standard for Data Warehouse Integration
The Common Warehouse Metamodel (CWM) is the new OMG standard that makes the sharing of data seamless. The CWM standard development team provides developers with a complete overview of what CWM is and how it works. After acquainting readers with the CWM architecture and how each CWM component fits into existing database and data warehouse architectures, the authors provide expert guidance on how to plan for, implement, and deploy CWM technologies. Companion Web site features updates on CWM technologies, descriptions of tools, and links to vendor sites.
Rapidly Building Enterprise Data Warehouse Solutions with Sybase
Discover how companies can develop an enterprise data warehousing strategy that delivers immediate business value through data marts while ensuring corporate-wide data integrity and consistency. Many companies have found that data marts, which are focused, subject-specific data warehouses, are easier, faster and cheaper to build than centralized data warehouses that span the entire enterprise.
Mobile Data Management : 2nd International Conference, Mdm 2001
Proceedings of the Second International Conference on Mobile Data Management, MDM, held in Hong Kong, China, January 8-10, 2001. The papers focused on six main areas of study, including coping with movement, catching and hoarding, content delivery, data broadcasting, data management architectures, and networks and systems issues.
Database Systems: Design, Implementation, and Management, Fifth Edition
This book takes you clearly and effectively through the entire process of database development and implementation. The most comprehensive and detailed coverage of database basics is complemented with ample exercises and problems at the end of each chapter to encourage hands-on learning, and a two-chapter step-by-step running case. Because the Internet has become so firmly established as an extension of the everyday business data environment, this revised edition contains two new chapters, "Databases in Electronic Commerce" and "Web Database Development," that stress the need for solid planning and management in order to maximize the resources that the Internet provides.
The TOAD Handbook
TOAD Handbook is a guide for developing Oracle applications and administering Oracle databases with TOAD. Starting with installation and configuration, the book covers the TOAD SQL editors in depth, including dozens of helpful, undocumented features. Later chapters discuss reporting and exporting data and using several add-on tools designed to enhance TOAD development. Along the way, the authors provide critical insights into the workings of TOAD and how developers can use it to make the most of their applications. Includes a foreword by Jim McDaniel, the inventor of TOAD.
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.
Unix/Linux Survival Guide
All Unix/Linux systems, regardless of manufacturer, have inherent similarities for administrators. The Unix/Linux Survival Guide details these similarities and teaches systems administrators how to tackle jobs on all systems. Mixing administrator knowledge and best practices, the book walks admins step-by-step through installing, setting up and configuring a new system. It also teaches them learn how to administer systems they didn't set up originally. Intended as a quick and dirty reference for administrators to use in their daily work, the book contains numerous hints on where to look and what to look for to get a Unix/Linux system up to speed and running smoothly. Admins will also learn preventive maintenance techniques to extract and evaluate baseline data and create a warning system that allows them to react to problems before users even notice. Daily task checklists are provided, and other key topics such as backup security, and documentation are covered in det
IT Manager's Handbook, Second Edition: Getting Your New Job Done
Many technical professionals are tossed into their new position of
managing an IT department without enough training or experience let
alone a clear idea of what is expected of them. Other technicians are
trying to decide if they should join the ranks of management, and want
the real facts about managing and managing other technical pros before
they decide.
To
compound the issue, most companies have become highly dependent on
their IT departments for their day-to-day business operations often
including revenue generation so the tasks are critical and the learning
curve is steep.
The IT Managers Handbook, 2nd edition provides
essential information needed to manage the new responsibilities thrust
on you (or the ones you would like to have): vital tasks such as
creating budgets, evaluating technologies, administering compliance,
and managing staff.
Microsoft SQL Server 2005 Analysis Services (SQL Server Series)
Microsoft SQL Server 2005 Analysis Services is definitive guide to programming Analysis Services 2005. It will give you unparalleled insight into the ways in which Analysis Services functions straight from the members of the Analysis Services team at Microsoft . It not only explains ways to use Analysis Services 2005 to design and create multidimensional objects, databases, dimensions, cubes, but it also provides invaluable information about the reasons behind design decision taken by the development team.
Chapters include:
- Introduction to Analysis Services
- Creating Multidimensional Models using Analysis Services
- Security
- High availability
- Localization and Globalization
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.
Seven Steps to Strategy Execution
Seven Steps to Strategy Execution gives organizations a logical framework to help them communicate strategy to the people and processes that make it a reality. And it further builds organizational capability by continually measuring performance against the organization's selected strategy performance metrics.
The collaborative work of J. Kent Crawford, founder and CEO of PM Solutions, Jeannette Cabanis-Brewin, editor-in-chief of the CBP, and Jim Pennypacker, director of the CBP, "Seven Steps to Strategy Execution" is a 316-page paperback offering practical advice for organizations struggling to effectively execute their corporate strategies. The book introduces an approach called Strategy Performance Management (SPM), which advocates the integration of governance and performance management in seven key areas: Strategy Management, Project Portfolio Management, Program and Project Management, Information Technology, Structure, Cultureand People.
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.
