Data warehousing for e-business
Author(s)
Bibliographic Information
Data warehousing for e-business
(Wiley computer publishing)
J. Wiley, c2001
Available at / 6 libraries
-
No Libraries matched.
- Remove all filters.
Note
Includes bibliographical references and index
Description and Table of Contents
Description
As huge volumes of data, 24/7 performance requirements, and the need to integrate customer information are outstripping the capacity of many existing data warehouses, the question of how to support this explosive growth of e-business is becoming the hottest topic in data warehousing. Building upon Bill Inmon's proven corporate information factory (CIF) architecture, this team of experts show data warehouse managers and developers how to architect the data warehouse environment to meet the high-performance requirements of data-intensive Web sites as well as the needs of users across the enterprise. Readers will get detailed guidance on how to build the data warehouse or improve existing capabilities in order to: o Capture clickstream data that customers enter at the Webhouse o Interface with HTML, XML, and other Web applications o Integrate clickstream data with legacy database systems o Design the data warehouse for optimum performance and scalability o Store and archive high volumes of data at reasonable costs o Analyze e-business data to spot new marketing and sales opportunities
Table of Contents
Acknowledgments. Preface. Chapter 1: The Opportunities and Challenges of E-Business. From Physical to Electronic Markets. The Three Vs: Volume, Velocity, and Variety. Data Volumes. Data Velocity. Variety of Data Formats. E-Business Channels. Business-to-Business (B2B): Centralized Exchanges and Emerging Marketplaces. Business-to-Consumer (B2C): The Context of Consumption. Business-to-Employee (B2E). The Impact of E-Tailing. Connecting Customers with Their Transactions. Economics of E-Business. Old versus New Economy. Impact of E-Business on Economic Cycles. Distinguishing Transaction Cycles from Customer Life Cycles. Supporting Partner Relationship Management. Registries. Meeting the Challenge of the Current E-Business Infrastructure. Infrastructure Opportunity: Warehouse to Web, and Back. Infrastructure Challenge: Web to Warehouse. The Financial View of Information. Project Spending, Corporate Investment. Summary. Chapter 2: The Corporate Information Factory and E-Business. Components of the Corporate Information Factory. Defining the Web Environment. Putting It All Together. Defining E-Business Architectural Requirements. Building the E-Business Infrastructure. Understanding Clickstream Data. Using Prior Site Information. Working with Operational Data Stores. Interpreting Information Using Metadata Transfer Languages. Enterprise Application Integration. Summarizing Languages. Understanding the CIF and E-business Interface. Sending Transactions to the Operational Environment. Data Passing through the Granularity Manager. Data Passing through the ODS. Summary. Chapter 3: Building an Iterative E-Business Infrastructure. Taking the Iterative Approach to Development. The Importance of Meta Data. Creating an Iterative Cycle. Implementing Your System Using a Methodology. Project Planning. Process Design. Deployment. Administration and Operation. Summary. Chapter 4: Identifying E-Business Users. Identifying Internal User Groups. Analytical Users. End User Groups. Identifying External Users. Business Partners. Consumers. Communities. Procurement. Partnerships in the Supply Chain. Supporting All Users. Knowledge Management and the CIF. Summary. Chapter 5: Integrating E-business and Corporate Data. Levels of Granularity. The Role of Data Models. Defining Data Models. Corporate Logical Data Model (Enterprise Data Model). Data Warehouse and Data Mart Model. Web Site ODS Model. Corporate ODS Model. Relationship among the Models. Summary. Chapter 6: Performance in the E-Business Environment. Building Performance from Day One. The Fundamentals of Performance. Transaction Processing and Performance. Simple Transactions. More Complex Transactions. Transaction Summary. Managing Web Site Performance. The ODS and Performance. Monitoring the Web Environment. High-Performance Database Design Techniques. Indexing Data. Using Data Arrays. Merging Tables. Instituting Redundant Data. Aggregating Data. Splitting Transactions to Minimize I/O. Managing the Web Site Workday. Capacity Planning and Management. Managing High Volumes of Data. Data Marts and Performance. Network Performance. DBMS Technology and Performance. ETL Efficiency and Performance. Using the Granularity Manager and Snapshots to Improve Performance. Other Performance-Enhancing Techniques. Moving Small Amounts of Data. Using Log Files. Generating Online Reports. Creating Rolling Summary Data Structures. Physically Collocating Data. Off-Hours Processing. Repeat Queries. Presequence Transactions. Educating End Users to Improve Performance. Summary. Chapter 7: Data Storage Technologies for E-Business. The Nature of Data Storage. Discrete versus Continuous Information. Persistence. Latency. Access. Storage Capacity and Performance. Caching. Conventional Disks. Ultra-Dense Disks. Optical Storage. Near-Line Storage. The Fast Pace of Innovation in Storage Technology. The Storage Hierarchy. Building Storage Infrastructure. The Wireless Matrix. Summary. Chapter 8: Applications for E-Business. Defining Analytical Applications. Classic Financial and Operational Reporting. Customer-Centric Reporting. Product-Centric Reporting. Transactional Analysis. Analyzing Information-Only Web Sites. Internal Site Navigational Analysis. Site Hang Time: Establishing Site Efficiency Baseline. Content-Based Internal Site Analysis. Visit versus Buy Analysis. Summary. Chapter 9: Exploration in E-Commerce. Time. Operational Exploration. Classical Business Value and Exploration. The Importance of Approach. Constructing the Model. Defining the Target of Exploration. Defining the Approach Pattern. Initial Contacts and Linkage. Inferential Linkage. Ascertaining Customer Value in Exploration. Householding in e-Business. Differential Address Linkage in Exploration. Summary. Chapter 10: Adapting to Changes in Your E-Business. Branding Dilution and Loss. Requirements for E-Business Agility. Mobilization. Responsiveness. Challenges to E-Business Agility. The Incalculable Advantages of E-Business Agility. Hallmarks of E-Business Initiatives. Old Economy versus New Economy.Corporate Performance: Levels of Profitability. Relational Profitability. Enterprise Profitability. Managing Information Assets for Corporate Performance. Valuing Corporate Information Assets: The CIF Scorecard. Summary. Where Do We Go from Here. Glossary. Recommended Reading. Index.
by "Nielsen BookData"