Cover image for Business intelligence with ColdFusion
Business intelligence with ColdFusion
Gosney, John.
Personal Author:
Publication Information:
Roseville, Calif. : Prima, 2000.
Physical Description:
xxii, 456 pages : illustrations ; 24 cm + 1 compute optical disc (4 3/4 in.)
General Note:
Includes index.
Title Subject:
Added Author:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.W43 G67 2000 Book and Software Set Central Closed Stacks

On Order



The volume's four sections describe the major phases of project management; present detailed information on the major functionality of the ColdFusion Markup Language (CFML); offers a case study providing a business-intelligence solution using the described project management methodology and development of a Web solution using ColdFusion; and demonstrate the capabilities of SQL Server 7.0. The included CD-ROM contains a 30-day trial version of Allaire's ColdFusion Server, ColdFusion Studio, and HomeSite. c. Book News Inc.

Table of Contents

Introductionp. xvii
Part I Project Management: A Business Intelligence Foundationp. 1
Chapter 1 Project Management: The Foundation for Business Intelligencep. 3
Realizing a Business-Intelligence Opportunityp. 4
What Items Are Considered in Project Management?p. 5
What Are the Benefits of Project Management?p. 7
How Is a Project Defined?p. 8
Conclusionp. 11
Chapter 2 The Conceptual Phase: Developing the Project Charterp. 12
Initiating the Projectp. 13
Understanding the Pieces of the Charter Documentp. 15
Defining the Scope Statementp. 15
Defining the Initial High-Level Schedule and High-Level Budgetp. 19
Determining an Initial Risk Analysisp. 19
Gathering the Project's Historical Informationp. 20
Assigning the Project Managerp. 21
Identifying and Analyzing Stakeholdersp. 21
Getting the Sponsors to Sign Off on the Charterp. 23
Documenting Lessons Learnedp. 23
Examining a Sample Charter Documentp. 23
Conclusionp. 26
Chapter 3 The Development and Design Phasep. 27
What Is the Development Phase?p. 28
Defining the Statement of Work (SOW)p. 29
Designating and Sequencing Tasksp. 32
Determining the Critical Pathp. 36
Calculating the Critical Pathp. 39
Determining Resource Assignmentp. 43
Determining the Update Formatp. 44
Finalizing the Development Phase: Documenting Lessons Learnedp. 46
Conclusionp. 46
Chapter 4 The Execution Phasep. 47
Understanding the Goals of the Execution Phasep. 48
Verifying the Project Scopep. 48
Performing Schedule Controlp. 50
Establishing Guidelines for Updating Project Schedule Informationp. 51
Maintaining the Project Baseline Schedulep. 56
Reviewing Project Performance to Costp. 56
Finalizing the Execution Phasep. 59
Conclusionp. 59
Part II Fundamentals of ColdFusion Developmentp. 61
Chapter 5 Introducing ColdFusionp. 63
Welcome to ColdFusionp. 64
Understanding the ColdFusion Templatep. 64
Enabling Your Data: SQL Basicsp. 69
Using the SELECT Statementp. 70
Using the INSERT Statementp. 75
Using the UPDATE Statementp. 76
Using the DELETE Statementp. 77
Conclusionp. 77
Chapter 6 Bringing Your Data to Life with [CFQUERY]p. 78
[CFQUERY]: The Doorway to Your Datap. 79
Establishing an ODBC Data Sourcep. 79
Understanding the Basics of [CFQUERY]p. 82
Returning a Simple Data Set with SELECTp. 83
Adding More Functionality to [CFQUERY]p. 87
Presenting Your [CFQUERY] Output in Table Formatp. 91
Implementing [CFQUERY] Results with JavaScriptp. 94
Understanding [CFLOOP] Functionalityp. 98
Conclusionp. 103
Chapter 7 Working with Formsp. 105
Creating Forms in ColdFusionp. 106
Processing Form Elementsp. 112
Working with ColdFusion Form-Specific Processing Functionsp. 120
Looking Forward: Advanced Form Functionalityp. 124
Conclusionp. 125
Chapter 8 Working with Filesp. 126
The Benefits of File Manipulationp. 127
Introducing [CFFILE]p. 127
Processing a File Uploadp. 129
Performing Local File Operations with [CFFILE]p. 132
Reading and Writing Filesp. 134
Conclusionp. 141
Chapter 9 E-Mail and ColdFusionp. 142
Adding E-Mail Functionality to Your Applicationsp. 143
Introducing the [CFMAIL] Tagp. 143
Examining a Simple [CFMAIL] Examplep. 143
Attaching E-Mail Messages with [CFMAIL]p. 146
Conclusionp. 150
Part III A Business Intelligence with ColdFusion Case Study: The ABC Companyp. 151
Chapter 10 Beginning the Projectp. 153
Setting Up the Case Studyp. 154
Introducing the ABC Companyp. 154
Utilizing ColdFusion as the Business-Intelligence Solutionp. 161
Conclusionp. 162
Chapter 11 Inventing and Endorsing the Projectp. 163
Introductionp. 164
Getting the Assignment: October 12,2000p. 164
Getting Project Sponsor's Comments: October 13,2000p. 166
Getting More Project Detail: October 13,2000p. 167
Documenting the Sponsor's Answers: October 16,2000p. 167
Defining the Communication Frequency with the Sponsor: October 17,2000p. 168
Developing the Project Charter and Assigning the Project Manager: October 18,2000p. 168
Official Project Manager Authorization and Project Team Definition: October 19,2000p. 169
Assigning the Project Team Members: October 20,2000p. 169
Defining the Scope Statement and Gathering Project Historical Information: October 23,2000p. 170
Defining the Statement of Work and Project Deliverables: October 25,2000p. 171
Implementing Project Communications: October 25,2000p. 172
Defining the Project Objectives, Constraints, and Assumptions: October 25,2000p. 172
Defining the Initial High-Level Schedule and High-Level Budget: October 26,2000p. 173
Commitment to Project by Team Members: October 27,2000p. 174
Determining the Initial Risk Analysis: October 30,2000p. 174
Sponsor and Stakeholder Identification and Analysis: October 31,2000p. 174
Completing the Stakeholder Analysis: November 6,2000p. 175
Moving Forward to the Development Phase: November 7,2000p. 176
Conclusionp. 179
Chapter 12 Developing the Project Planp. 180
System Development and Specification Document: November 8,2000p. 181
Holding the Offsite Meeting: November 16-17,2000p. 183
Developing the Statement of Work (SOW): November 16,2000p. 184
Defining Deliverables: November 16,2000p. 184
Breaking the WBS into Tasks and Durations: November 16,2000p. 185
Determining the Activity Sequence and Responsibilities: November 17,2000p. 187
Determining the Critical Path (CP): November 17,2000p. 188
Determining the Update Cycle: November 17,2000p. 189
Evaluating Lessons Learned: November 17,2000p. 189
The Scope Document: A Business-Intelligent Web Solution for ABC Companyp. 190
Conclusionp. 194
Chapter 13 Moving Through the Execution Phasep. 195
Project Culmination: Developing the Web Site: November 22,2000p. 196
Starting the Execution of the BI Web Solution: November 22,2000p. 196
Update 1: November 22 - December 22,2000p. 199
Developing the ABC Purchasing Department BI Web Solutionp. 199
Developing the Database Structure: December 27,2000p. 201
Designing and Developing Web Pagesp. 209
Update 2: December 22 - January 22,2001p. 221
Moving Forward with Testing, Training, and Implementationp. 221
Update 3: January 22 - March 28,2001p. 223
Update 4 and Wrap-Up: March 28 - April 7,2001p. 224
Conclusionp. 224
Part IV Essentials of SQL Server 7.0p. 225
Chapter 14 Installingp. 227
SQL Server Products, Releases, and Versionsp. 228
Planning a New Installationp. 231
Installing SQL Server 7.0 for the First Timep. 238
Changing Installation Options After Installationp. 252
Uninstalling SQL Serverp. 253
Unattended Installationp. 254
Installed Toolsp. 256
Tutorial: Inspecting an Installationp. 258
Troubleshooting Installationsp. 268
Installation Inspection Checklistp. 270
Conclusionp. 270
Chapter 15 Managing Databasesp. 271
Managing Serversp. 272
Managing Databasesp. 276
Creating a Databasep. 285
Copying, Renaming, and Dropping a Databasep. 294
Installing a Database from a Scriptp. 295
Detaching and Reattaching a Databasep. 295
The DBCC Commandp. 296
Conclusionp. 298
Chapter 16 Securityp. 300
Basic Concepts of SQL Server Securityp. 301
Authentication Modesp. 303
Loginsp. 304
Database Accessp. 309
Permissionsp. 317
Security Functionsp. 322
Conclusionp. 323
Chapter 17 Importing and Exporting Datap. 324
Data Transformation Services (DTS)p. 325
The DTS Import and Export Wizardsp. 326
The DTS Package Designerp. 340
The BCP Utilityp. 346
The BULK INSERT Commandp. 350
Conclusionp. 351
Chapter 18 Tuning Queriesp. 352
Preparing Some Data for Analysisp. 353
Graphical Showplanp. 356
Textual Showplanp. 363
Statistics I/Op. 367
Index Analysisp. 368
Index Distribution Statisticsp. 375
Conclusionp. 377
Chapter 19 Database Load Testingp. 378
Overviewp. 379
Generating Test Datap. 386
Using SQL Load Simulator 2p. 394
Using Benchmark Factoryp. 398
Conclusionp. 406
Chapter 20 OLAP Servicesp. 407
Microsoft SQL Server 7.0 OLAP Services Overviewp. 408
From Cross-Tabs to Cubesp. 413
Building an OLAP Data Cubep. 422
Inspecting the Foodmart Sample Cubep. 434
Conclusionp. 436
Appendix A Overview of ColdFusion Server Administratorp. 437
What Is the ColdFusion Server Administrator?p. 438
Indexp. 447