Building Sybase Web sites

목차 (Table of Contents)

• CONTENTS
• Introduction = xvii
• Section 1 PLANNING = 1
• Chapter 1 The Web Connection = 3
• Internet Background = 3
• A Chronological History of the Internet = 5
• The Internet Today = 7
• What Is the Web? = 7
• Intranets = 8
• Benefits of Intranets = 8
• What Is a Web Database and Why Have One? = 10
• What Is a Web Database? = 10
• Intranet Database Application Benefits to the Organization = 11
• Advantages of Web Database Applications for the User = 11
• Moving On = 12
• Chapter 2 Web Commerce = 13
• Today's Competitive Business Environment = 13
• Why Do Business on the Web? = 15
• Expand Reach = 15
• Enhance Corporate Image = 16
• Improve Customer Service = 16
• Generate Leads = 16
• Create a Product／Service Delivery Channel = 17
• Reduce Operating Expenses = 17
• Test Market = 17
• What to Consider When Doing Business on the Web = 17
• The Role of Databases in Web Applications = 19
• Moving On = 21
• Chapter 3 Choosing a Programming Language = 23
• Which Language to Use? = 23
• Skill Set of Developers = 24
• Scope of the Project = 25
• application Interfaces = 26
• Availability of Support Tools = 26
• Database Interfaces = 27
• Platforms Application Will Run On = 28
• What is this thing called Sybase? = 28
• Sybase SQL Anywhere = 29
• Sybase System 11 = 30
• Useful Sybase URLs = 32
• C = 33
• CGIHTML = 33
• LIBCGI = 34
• CGIC = 34
• Useful C Language URLs = 34
• C++ = 35
• Useful C++ Language URLs = 36
• PERL = 36
• Useful PERL Language URLs = 37
• Shell Script = 38
• Visual Basic = 39
• Useful Visual Basic Language URLs = 40
• PowerBuilder = 41
• Useful PowerBuilder Language URLs = 42
• Visual Basic Script = 43
• Useful VB Script Language URLs = 43
• COBOL = 44
• Useful COBOL Language URLs = 45
• Moving On = 46
• Chapter 4 Overview of Java and JavaScript = 47
• Introduction to Java = 47
• Benefits of Java = 50
• Java and Object-Orientation = 53
• The Java／Web Concept = 53
• Is It Java or Coffee? = 55
• Who Owns Java? = 57
• Introduction to Java Script = 58
• Uses for Java Script = 59
• Strengths and Weaknesses of JavaScript = 61
• Strengths of Java Script = 61
• Weaknesses of JavaScript = 61
• ODBC = 61
• JDBC = 62
• Moving On = 63
• Chapter 5 Application Development Suites = 65
• Sybase Corporation's Web Development Tools = 66
• Power Site = 66
• Net Impact Dynamo = 68
• web.sql = 68
• jConnect for JDBC = 68
• Jaguar = 68
• Amazon = 69
• Autobahn = 70
• Centura Web Data Publisher = 70
• dbWeb = 71
• Delphi = 71
• Delphi Desktop 3.3 = 72
• Delphi Developer 2.0 = 72
• Delphi Client／Server Suite 2.0 = 72
• DynaWeb = 73
• Edify Electronic Workforce = 74
• HAHTSite IDE = 75
• IQ Live Web = 76
• IQ／Live Web = 76
• Krakatoa = 78
• Live PAGE WebMaster = 79
• LiveWire and Live Wire Pro = 79
• Microsoft FrontPage 97 = 80
• Personal Web Site(PWS) Toolbox = 81
• PowerBuilder 5.0 = 81
• Sapphire／Web = 83
• SiteBase = 83
• Software Engine = 84
• Tango = 85
• WebHub = 85
• Webinator = 86
• WebObjects = 87
• Moving On = 88
• Chapter 6 Overview of HTML = 91
• Introduction to HTML = 92
• Benefits of HTML = 93
• Limitations of HTML = 94
• Tags = 94
• HTML Conformance = 95
• Structure of HTML = 95
• Header and Document Tags = 96
• Body Tags = 96
• URLs = 107
• Additional Resources = 108
• Advanced HTML Topics = 109
• Incorporating JavaScript into HTML = 109
• The (SCRIPI)...(SCRIPI) Tag Pair = 109
• Inline Images in HTML Files = 110
• Advanced Hypertext and Hypergraphics = 112
• Good HTML Practices = 113
• Use Standard HTML = 114
• Signing and Time-Stamping Pages = 114
• Make Your Pages Printable = 115
• Hypertext and Hypergraphics Links = 115
• Avoid Unnecessary and Meaningless Links = 115
• Headings and Organization = 116
• Page Size = 116
• The Future of HTML = 116
• Moving On = 117
• Chapter 7 Common Gateway Interface(CGI) = 119
• CGI Introduction = 119
• The CGI Expanded = 120
• CGI Architecture = 120
• CGI Process Flow = 120
• HTTP Server and CGI Program Communication Methods = 122
• CGI Input Data = 122
• CGI Output Data = 122
• CGI Environmental Variables = 123
• Passing CGI Data Streams = 125
• Reading User Data into CGI Programs = 126
• CGI Generation of HTML = 127
• CGI Programming Principles = 128
• CGI Program Architectures = 129
• Moving On = 132
• SECTION 2 INTERNET WEB DESIGN = 133
• Chapter 8 Web Application Design and Development = 135
• Advantages of Deploying an Application on Your Chosen Platform = 135
• Characteristics of a Web Database Application = 136
• Keys to Successfully Implementing a System = 136
• The Process = 137
• A Wish List for Development Tools = 137
• The Design Process Described = 138
• The Process of Design = 138
• The Design in Progress = 140
• Web Database Application Components = 140
• The Server = 140
• Application Server = 142
• Web Client = 143
• CGI Program = 144
• RDBMS = 144
• Web Application Design Primer = 145
• Database = 145
• Function = 145
• User Interface = 146
• Implementation = 147
• Web Database Application Design = 148
• The Web Database Application Development Methodology = 149
• The Web Database Application Environment = 149
• Web Database Application Security = 150
• Problem Management = 152
• Six Principles of Function Placement = 152
• Application Partitioning = 155
• Distributed Presentation = 155
• Remote Presentation = 155
• Distributed Function = 156
• Remote Data Management = 156
• Distributed Database = 157
• Application Partitioning Summary = 158
• Moving On = 159
• Chapter 9 Introduction to Sybase = 161
• What Is Sybase? = 161
• Sybase Web Database Application Development Tools = 162
• Design Tools = 164
• Component Tools = 165
• Developer Tool Add-Ons = 165
• Languages = 168
• Transaction Server = 168
• Data Access／Connectivity = 168
• Data Warehouse Movement = 169
• Workplace Databases = 170
• Enterprise Databases = 170
• Distributed Transaction Services = 170
• Sybase System 11 = 171
• Evolution of System 11 = 171
• New Features in System 11 = 172
• Components In System 11 = 173
• Creating Database Objects in System 11 = 174
• Creating a User = 174
• Modifying User Attributes = 175
• Creating a Table = 178
• Adding Columns to Your Table = 179
• Defining a Primary Key = 182
• Creating an Index = 183
• Creating a Table Manually = 185
• Moving On = 188
• Chapter 10 Using ISQL and Introduction To Queries = 189
• Interactive SQL-ISQL = 189
• What Is ISQL? = 189
• Starting ISQL = 190
• The ISQL Command Window = 191
• Displaying Data in ISQL = 192
• Command Recall = 192
• Saving and Retrieving Saved Queries = 194
• SQL's Advantage = 196
• A Simple Example = 198
• SELECT Statement Clauses = 199
• The From Clause = 201
• The Where Clause = 201
• Joins = 202
• Inner Join = 202
• Left Outer Join = 203
• Right Outer Join = 204
• The IN Operator = 204
• The LIKE Operator = 205
• The Order By Clause = 206
• Using Group By = 207
• The Having Clause = 207
• Moving On = 208
• Chapter 11 Designing Advanced SQL Statements = 209
• Single-Row SQL Functions = 209
• Numeric Functions = 210
• Functions Returning Character Values = 210
• Character Functions Returning Numbers = 212
• Aggregate Functions = 212
• Using Subqueries = 213
• Creating a Subquery = 213
• DML Statements = 214
• Insert Statement = 215
• Update Statement = 216
• Delete Statement = 217
• Create Table As Select = 218
• Learning More = 219
• Moving On = 219
• Chapter 12 Creating and Executing Stored Procedures in System 11 = 221
• Introduction = 221
• Creating a Stored Procedure = 222
• Executing Stored Procedures = 225
• Dropping Stored Procedures = 226
• Renaming Stored Procedures = 226
• Permissions and Stored Procedures = 227
• Summary = 227
• SECTION 3 INTERFACING WITH THE INTERNET USER = 229
• Chapter 13 HTML Forms and Database Access = 231
• Syntax of HTML Markups = 232
• Form Specification = 233
• Input Specification = 234
• Overcoming Limitations of Placing Objects on HTML Forms = 240
• Using Tables = 240
• Using Null Graphics = 242
• Using PRE＞...／PRE Tag Pair = 244
• Sewer-Side Includes = 245
• Database Queries and HTML = 246
• Connect to a Database = 247
• Query the Database = 248
• Format and Display the Result Set = 250
• Drilling Down in a Web Database Application = 251
• Database Updates and HTML = 255
• Form Design Tips = 258
• Moving On = 260
• Chapter 14 Accessing Sybase Databases Using CGI Programs = 261
• Basics Review = 261
• What is CGI? = 262
• The CGI Process = 263
• CGI Data Input and Output = 264
• CGI Environmental Variables = 264
• Passing CGI Data Streams = 265
• Reading User Data into CGI Programs = 266
• Summary of Common Web Database Access Methods = 267
• Why Use Custom CGI Programs for Database Access = 267
• Ways CGI Programs Access Corporate Databases = 268
• Ways CGI Programs Provide Advantages Over Other Methods = 268
• Choosing a CGI Programming Language = 269
• Accessing Web Database Using CGI Programs = 270
• Contents of the CGI Profile File = 271
• Querying a Database = 273
• The Web Database Query Page = 274
• Web Server Action on Receiving the Query Request = 275
• Execution of the CGI Program for a Database Query = 275
• Types of CGI Output Responses = 277
• Output from a CGI Program Doing a SELECT Query = 277
• Redirecting CGI Output = 279
• Returning an Error Code = 280
• Inserting Rows in a Database from a Web Application = 281
• The Web Database Insert Row Page = 281
• Web Server Action on Receiving the Add Row Request = 282
• Execution of the CGI Program to Add a Database Record = 283
• Output from a CGI Program Doing an INSERT Row = 284
• Deleting a Row from a Database Using a Web Application = 288
• The Web Database Delete Row Page = 288
• Web Server Action on Receiving the Delete Row Request = 289
• Execution of the CGI Program to Delete a Database Record = 291
• Output from a CGI Program Doing a DELETE Row = 291
• Updating a Database Row from a Web Application = 292
• The Web Database Update Row Page = 292
• Web Server Action on Receiving the Update Row Request = 293
• Execution of the CGI Program to Update a Database Record = 294
• Output from a CGI Program Doing an Update Row = 295
• Providing Full Database Access from Your Web Application = 295
• The Web Database Full-Access Page = 296
• Web Sewer Action on Receiving the Database Request = 297
• Execution of the CGI Program to Take Action on a Database Record = 298
• Output from a CGI Program Performing an Unspecified Action on a Database = 299
• Moving On = 299
• Chapter 15 MIME and Advanced Data Presentation = 301
• What Is MIME? = 301
• Uses for MIME on the Web = 303
• MIME Headers = 305
• MIME Types and Subtypes = 306
• MIME Type／Subtype Examples = 307
• Multipart Type Example = 308
• Custom MIME Types = 308
• MIME Perspectives = 309
• MIME from a Developer's Perspective = 309
• MIME from a User's Perspective = 309
• Moving On = 311
• Chapter 16 Managing Web Database Access and the Application State = 313
• What is Application State? = 314
• Authentication and Application State = 316
• Using Forms to Maintain State = 319
• Using Database Tables to Maintain State = 321
• Using Persistent Cookies to Maintain State = 323
• What is a Cookie? = 323
• How Do Cookies Work? = 323
• How Can You Use Cookies? = 324
• Maintain Application State = 324
• Virtual Shopping Mall = 325
• Site Personalization = 325
• Additional Information on Cookies = 326
• Moving On = 326
• Chapter 17 Improving Performance of Web Database Applications = 327
• Application Optimization = 327
• Access Speeds = 328
• CGI Programs = 328
• Change = 328
• Development Suites = 329
• Functions in Web Pages = 329
• Java Applets = 330
• Module Size = 330
• Multimedia Components = 330
• Number and Types of Graphics = 331
• Searchability = 332
• Security = 333
• User-Input Validation = 333
• Database Optimization = 334
• Ask Only for What You Need = 334
• Create Temporary Tables for Users = 334
• Create Views on the Server and Link to Them = 334
• Criteria Should Match Server Data Structure = 335
• Distributed Databases = 335
• Do As Much Work on the Server As Possible = 335
• Do Not Use Drop-Down List Boxes Based on Large Numbers of Records = 336
• Error Handling = 336
• Open Web Pages without Retrieving Data = 336
• State Data Stored in a Database = 337
• Stored Procedures = 337
• Moving On = 337
• SECTION 4 ADVANCED TOPICS IN INTERNET DATABASE PUBLISHING = 339
• Chapter 18 Migrating Data from Enterprise Data Stores to Server-Based Databases = 341
• What to Migrate = 341
• Access = 342
• Location = 342
• Response Time = 342
• Security = 343
• Determine What to Migrate = 343
• When to Use Replication = 344
• When Replication Shouldn't Be Used = 344
• Objects That Are Replicatable = 345
• Backup and Recovery = 345
• Backing Up a Web Database = 345
• Designing a Backup Strategy = 346
• Restoring a Web Database = 346
• Moving On = 347
• Chapter 19 Using Firewalls and Security Components to Protect Your Data = 349
• Sybase Security = 349
• Sybase Security and Web Database Applications = 35l
• Web Site Security - The Problem = 352
• Security of Your Web Server = 352
• Server-Side Includes = 353
• Child Execution Privileges = 353
• Secure Sockets Layer - SSL = 353
• CGI Security = 354
• Firewalls = 354
• Other Resources = 355
• Books On Security = 355
• Useful URLs = 356
• Moving On = 356
• Chapter 20 Designing an Internet Course Delivery System = 357
• Background = 358
• XYZ's Existing Environment = 358
• Project Analysis = 359
• JRP Documents = 360
• Management on Track = 365
• The Design Process Described = 365
• Process Design = 366
• A Slight Change in Toolset = 371
• The Development Process = 371
• Mirrored Sites = 372
• Development Approach = 372
• Develop the Web Pages = 374
• Implementation = 375
• Post-Implementation Analysis = 376
• Moving On = 377
• Chapter 21 Building a Simple Class Registration System = 379
• Application Configuration = 379
• Structure of the Database = 380
• HAHTsite IDE Development Tool = 382
• Global Front-End = 384
• Security Login Screen = 389
• Web Database Internet Components in the Application = 390
• Training Course Listing Page = 390
• Course Date／Location Page = 392
• Feedback Page = 393
• Web Database Intranet Components in the Application = 395
• Maintain Available Courses Page = 395
• Maintain Course Dates Page = 397
• Moving On = 398
• Appendix A About the Software = 399
• ABOUT THE COMPANION CD-ROM = 399
• Navigating the CD-ROM = 399
• CD-ROM Contents = 399
• Limits of Liability & Disclaimer of Warranty = 407
• Appendix B Frequently Asked Questions = 409
• What Are Web Applications? = 410
• What Are Intranets? = 410
• What Is a Web Database and Why Have One? = 410
• What Types of Databases Are Accessible in a Web Database Application? = 411
• What Are the Advantages of Web Database Applications for the User? = 411
• What Are the Advantages to a Company from Building a Web Database Application? = 412
• What Is the Role of Databases in Web Applications? = 413
• What Are the Components in a Web Database Application? = 413
• What Should I Consider When Choosing a Programming Language? = 414
• What Are Some of the Languages Available to Help Me Build a Web Database Application? = 415
• What Are Web Database Application Development Suites? = 415
• What Are Some of the Benefits and Limitations to HTML? = 415
• What Is a CGI Program? = 415
• How Does a CGI Program Fit in the Architecture of a Web Database Application? = 416
• How Does Data Get Passed from an HTML Page to a CGI Program? = 416
• Are There Any Programming Principles That I Should Be Aware of When Writing CGI Programs? = 416
• Where Should Security Exist in a Web Database Application? = 417
• What Types of Join Relation ships Are Recognized in Sybase System 11? = 417
• What Types of Objects Are Allowed on HTML Forms? = 417
• How Can I Format and Submit a Database Query from With in an HTML Page? = 418
• Why Should You Use Custom CGI Programs for Database Access? = 418
• What Is MIME? = 418
• Appendix C WWW Database Development Resources = 419
• Databases = 419
• Other = 421
• Programming Languages = 423
• Reference Material = 425
• Security = 427
• Web Servers = 427
• Index = 429