Your Professional Resource for Developing with ColdFusion 5

Master ColdFusion--the premier environment for developing flexible, powerful Web applications--with the authoritative information in this professional-level resource. From installing and optimizing your development operating system, to mastering advanced practices like advanced application security and using Web Distributed Data Exchange (WDDX), "ColdFusion 5 Developer's Guide delivers the accurate, thorough instruction required to design and deploy a wide range of useful Web applications. ColdFusion developer and e-commerce guru Michael Buffington will help you discover--and master--the tools you'll need to excel in ColdFusion Web application development.Properly serve ColdFusion applications Deploy applications using development methods and code standards Get the most from conventions, adaptations, and portable code Work easily within all major operating systems and server platforms Develop ColdFusion applications using variables, forms, and imported tools Plan, design, administer, and monitor databases Understand Third Normal Form and other database structures Master security and automation techniques Prevent lost data, orphaning, and corruption Transfer platform-independent data with WDDX

Web-Powered Databases provides an excellent snapshot of current research and development activities in the area of Web or internet databases. Its content supplies potential answers to many questions that have been raised regarding database accesses through the Web. The book also provides a number of case studies of successful Web database applications, including multiple-choice assessment through the Web, an online pay claim, a product catalogue, and content management and dynamic Web pages.

This text has been written for the new and experienced OneWorld professionals who need to use and get the most from the Object Management Workbench (OMW). It provides the fundamentals and details behind the business and technical information about OMW, alongside practical advice and special sections containing proven tips and recommendations for successful usage of OMW.

The Ultimate Resource for Developing Error-Free SQL Operations

Create a functional debugging environment to develop Structured Query Language solutions efficiently and troubleshoot SQL statements effectively. Use best practices to help perform maintenance, and to find and fix bugs when they do occur. Explore and familiarize yourself with SQL programming problems, learn to write code that's portable across databases, and realize efficiencies by expressing data in a variety of types. Develop the skills you need to debug SQL, and learn to move deftly and creatively around almost every limitation that SQL imposes on your operating environment.Write trouble-free SQL statements and procedures Optimize SQL statements and avoid problem areas Join and aggregate data and other SQL Select statements Debug and use practical regions and sequences Use and debug arrays, sets, and graphs Understand tree structures and hierarchies Secure data and protect response time Examine the appropriate use of data types Select, insert, update, and delete data using SQL syntax Recognize and mitigate fatal and logical errors Format SQL for single queries or extensive procedures using best practices

Essential Skills for First-Time Developers

Discover the easiest way to construct Web-based applications and interactive Web sites with help from this instructive guide. "ColdFusion 5: A Beginner's Guide uses a proven learning method to give even total beginners profound and useful insights into the world of programming. Cover server setup and administration, learn programming fundamentals and specifics of the ColdFusion language, then follow examples and tutorials designed to help you build and deploy your own dynamic Web site--including incorporating data from ODBC Databases, such as Access or SQL Server. Whether you're new to programming, or brushing up on ColdFusion techniques, this potent learning tool will help you meet your goals.

This Beginner's Guide is Designed for Easy Learning: Modules--Each concept is divided into logical modules (chapters), ideal for individualized learning Goals--Each module opens with the specific skills you'll have by the end of the module Ask the Experts--Q&A sections throughout are filled with extra information and interesting commentary 1-Minute Drills--Quick self-assessment sections to check your progress Annotated Syntax--Example code annotated with commentary that points to the particular technique illustrated Projects--Exercises contained in each module show how to apply what you are learning Mastery Checks--End-of-module reviews that test your knowledge using short-answer, multiple-choice, fill-in-the-blank, and simple coding questions

"Advanced SQL:1999 - Understanding Object-Relational and Other Advanced Features" is the practitioner's handbook to the standard's advanced features. It is not a re-presentation of the standard, but rather an authoritative, in-depth guide to its practical application. Like its companion, "SQL:1999 - Understanding Relational Language Components," which explained the standard's basic features, this book will show you how to make your applications both effective and standard-compliant.

This handy reference has a modular format so you can explore specific topics with ease. It is equally useful to those upgrading from earlier versions of SQL and those with no previous experience. Written by the standard's distinguished editor, "Advanced SQL:1999" will complete your knowledge and support your skills like no other book can.
* Focuses entirely on the issues that matter to programmers who are connecting applications to databases.
* Details SQL:1999's object facilities, including structured user-defined types, typed tables, user-defined routines, and routine invocation.
* Examines facilities new to SQL, including those relating to on-line analytical processing (OLAP), management of external data (SQL/MED), and Java support.
* Covers the ongoing development of XML support.
* Includes appendices that cover the SQL:1999 annexes, a SQL:1999 example using UDTs, status codes, and useful information on the standardization process.

From seasoned developer and trainer Rob Macdonald comes "Serious ADO: Universal Data Access with Visual Basic," which teaches experienced Visual Basic developers how to make the most of ADO, Microsoft's flagship product for database access. "Serious ADO" covers the full range of uses for ADO, from basic use of the ADO technology to specialized topics and advanced techniques that will benefit even the most experienced developers.

The first part of the book provides thorough coverage of ADO's components and what they can do. Along the way, Macdonald offers real-world code examples along with complete explanations of exactly what is occurring at each stage of the development process. This part also covers some of the key concepts upon which ADO programming is based, such as locking and transactions, connection pooling, marshalling, and Inter Process Communication, among others.

The second part of the book addresses the use of ADO in real-world development scenarios. Here, Macdonald demonstrates advanced user interface creation, including new ways to control the binding process. You'll also learn how to use Microsoft Transaction Server of COM+ applications to create transactional component-based systems.

Learn the basics of Structured Query Language programming from the tutorials and examples in this easy-to-follow resource.

SQL: A Beginner's Guide teaches you how to use SQL to work with data in a database, develop database objects, create subqueries, build views, write stored procedures, and accomplish complex selects and updates. The examples throughout the book walk you through real-world database tasks. If you want to get started programming in SQL right away, this is the ideal self-paced learning tool for you.

This Beginner's Guide is Designed for Easy Learning: Modules - Each programming concept is divided into logical modules (chapters), ideal for individualized learningGoals - Each module opens with the specific programming skills you'll have by the end of the moduleAsk the Experts - Q&A sections throughout are filled with extra information and interesting commentary1-Minute Drills - Quick self-assessment sections to check your progressAnnotated Syntax - Example code annotated with commentary that points to the particular technique illustratedProjects - Coding exercises contained in each module show how to apply what you are learningMastery Checks - End-of-module reviews that test your knowledge using short-answer, multiple-choice, fill-in-the-blank, and simple coding questions

This book constitutes the thoroughly refereed post-proceedings of the 9th International Workshop on Persistent Object Systems, POS-9, held in Lillehammer, Norway, in September 2001.The 19 revised full papers presented together with seven session overviews and an epilogue were selected during two rounds of reviewing and revision for inclusion in the proceedings. Among the topics addressed are persistence-enabled optimization, Java applications, JVM, systems architecture, persistent GIS, data sharing middleware, polylingual persistence, transactions, distributed object systems, object stores, garbage collectors, WWW and persistence, persistent computation implementation, orthogonally persistent Java, and personal information devices.

Includes information that every Oracle administrator and programmer must know to maximize uptime and recover data without compromising mission critical systems.

Cooperative Information Systems have emerged as a central concept in a variety of applications, projects, and systems in the new era of e-business. The conference at which the papers in this volume were presented was the ninth international conference on the topic of Cooperative Information Systems (CoopIS 2001), and was held in Trento, Italy on September 5-7, 2001. Like the previous conferences, CoopIS 2001 has been remarkably successful in bringing together representatives of many di?erent ?elds, spanning the entire range of e?ective web-based Cooperative Information Systems, and with interests ranging from industrial experience to original research concepts and results. The 29 papers collected here out of the 79 ones that were submitted, dem- strate well the range of results achieved in several areas such as agent te- nologies, models and architectures, web systems, information integration, m- dleware technologies, federated and multi-database systems. The papers th- selves, however, do not convey the lively excitement of the conference itself, and the continuing spirit of cooperation and communication across disciplines that has been the hallmark of these conferences. We would especially like to thank our keynote speakers: Philip A. Bernstein (Microsoft Research, USA), Edward E. Cobb (BEA Systems, USA), and Ma- izio Lenzerini (Universit'a di Roma "La Sapienza", Italy) for providing a portrait of the best contemporary work in the ?eld. We would also like to thank the many people who made CoopIS 2001 possible.

Welcome to 00lS'01 and Calgary! This is the 7th International Conference on Object-Oriented Information Systems (OOlS) that focus on Object-Oriented and Web-Based Frameworks for Information Systems. In the last few years we've seen significant new development in this field, from one-off design technologies to reusable frameworks, and from web applications to bioinformatic systems. We perceive that information processing is one of the most important activities of human beings. Object-orientation and frameworks have been the main-stream technologies for design and implementation of large-scale and complex information systems. Recent research advances and industrial innovations in information systems modeling and Internet applications have explored the new trends in shifting information system vendors from component and system developers to services providers. Users of information systems are increasingly demanding higher performance, mobility, and personalization in order to realize the dream to access and obtain necessary information anywhere and anytime. The new development requires the investigation of new architectures, frameworks, processes, and inter-connectivity of information systems at society, organization, team, and personal levels. The 00lS'01 Proceedings has put together a program of 53 papers from leading researchers and practitioners in the field of object technology and information systems.

Don't Let the Real Test Be Your First Test!

Practice Makes Perfect--Score Higher With The Most Effective Self-Test & Quick Review Program

More Questions--More ContentBased on Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition Exam (70-228) Coverage features quick review of all technology objectives and realistic exam questions to build your knowledge Exclusive "Exam Watch" features point out the most frequently missed questions--and how to answer them correctly

This book is not just another theoretical text on statistics or data mining. Instead, it's designed for database administrators who want to buttress their understanding of statistics to support data mining and customer relationship management analytics and who want to use Structured Query Language (SQL). Each chapter is independent and self-contained with examples tailored to business applications. Each analysis technique is expressed in a mathematical format that lends itself to coding either as a database query or as a Visual Basic procedure using SQL. Each chapter includes: formulas (how to perform the required analysis, numerical example using data from a database, data visualization and presentation options (graphs, charts, tables), SQL procedures for extracting the desired results, and data mining techniques.

This book covers the basic statistical and analytical techniques of computer intrusion detection. It is aimed at both statisticians looking to become involved in the data analysis aspects of computer security and computer scientists looking to expand their toolbox of techniques for detecting intruders. The book is self-contained, assumng no expertise in either computer security or statistics. It begins with a description of the basics of TCP/IP, followed by chapters dealing with network traffic analysis, network monitoring for intrusion detection, host based intrusion detection, and computer viruses and other malicious code. Each section develops the necessary tools as needed. There is an extensive discussion of visualization as it relates to network data and intrusion detection. The book also contains a large bibliography covering the statistical, machine learning, and pattern recognition literature related to network monitoring and intrusion detection. David Marchette is a scientist at the Naval Surface Warfacre Center in Dalhgren, Virginia. He has worked at Navy labs for 15 years, doing research in pattern recognition, computational statistics, and image analysis. He has been a fellow by courtesy in the mathematical sciences department of the Johns Hopkins University since 2000. He has been working in conputer intrusion detection for several years, focusing on statistical methods for anomaly detection and visualization. Dr. Marchette received a Masters in Mathematics from the University of California, San Diego in 1982 and a Ph.D. in Computational Sciences and Informatics from George Mason University in 1996.

The second edition of the best-selling Inside Relational Databases is revised and updated to bring you the most reader-friendly explanation of the relational model and its importance to database designers and builders.Clear explanations make use of examples rather than equations to show you how an understanding of the relational model can make your databases faster, more flexible and thoroughly fit for their purpose.Dr Mark Whitehorn has an extensive understanding of relational database theory and his popular and long running database column in the UK's "Personal Computer World" has already made database theory accessible to thousands.Bill Marklyn has an intimate knowledge of relational databases and was the Development Manager who oversaw the entire design of the first two major releases of Microsoft's highly successful database product, Access.Together they make a great team, illuminating a tricky subject with substance and style.Reviews from the first edition of Inside Relational Databases:"Quite simply - superb. By making relational databases understandable, Mark Whitehorn and Bill Marklyn have achieved far more than most. Making the subject interesting and entertaining as well puts these two authors firmly in a class of their own."- Neil Fawcett, Group Technical Editor, VNU Business Publications"PCW and Amazon.co.uk contributor Mark Whitehorn is that rare combination - an expert in his field, databases, and a fine writer too, with a talent for honing a complex subject down to its essentials."- Tamsin Todd, Computer & Internet Editor, Amazon.co.uk"Inside Relational Databases is excellent. It is clearly and concisely written and full of humorous asides which ease the reader through an otherwise weighty topic. Probably the most engaging technical book I have read."- Paul McGowan

Learn the essentials of using Oracle8i on a network.

Get step-by-step details on implementing Net8 - the Oracle8i mode of networking.

Oracle8i Networking 101 explains how interactions over a network take place, describes the hardware and software required, and how all the components interface to produce successful communications between computers and databases. Step-by-step procedures illustrated by screen shots demonstrate precisely how to configure on Oracle8i network. Details on Internet protocols and network encrytion are also included.Determine the hardware and software components required for an Oracle networkConfigure Oracle clients and servers to communicate using Net8Configure Oracle Names serversMake us of configuration tools, including Net8 Assitant, Net8 Configuration Assistant, and the Connection ManagerSupport large networks with multi-threading and client load balancingUse Oracle WebDB, internet Application Server (iAS), and Internet Directory serverHandle security and troublehsooting

Written by an Oracle DBA and authorized by Oracle Corporation, this hands-on resource shows you everything you need to know to plan and set up an Oracle8i networking environment.

Essential ColdFusion fast gives the reader a working knowledge of ColdFusion and how to use it and how it integrates with other web-based technologies. Lots of working examples are included throughout, all of which are also available via a web-site that is powered by ColdFusion, which shows exactly how they work.Matthew Norman has written a 'get started quick' guide to ColdFusion, in the style of the Essential series, describing the setting up of a development system. He talks about how to achieve this on a budget, using techniques that are applicable to large scale operations as well.Anyone with a working knowledge of the internet, and who wants to learn more about what ColdFusion does and how they can start using it quickly, will find this book a real help.

Implement Oracles Internet-based Manufacturing and Supply Chain Management products using this Oracle authorized resource. This comprehensive guide explains how to implement the planning, engineering, pricing, order fulfillment, and inventory management components of Oracle Manufacturing and Supply Chain--and develop and deliver goods and services faster, cheaper, and more efficiently than your competitors.

If you want to learn how to write stored procedures and triggers for Microsoft SQL Server, "Code Centric: T-SQL Programming with Stored Procedures and Triggers" is the book for you. Youll learn real-world coding and how to build non-trivial applications. All of the examples covered in the book are available for download, making it easier to work through over 5,000 lines of sample code.

While there is extensive coverage of the new functionality in SQL Server 2000such as UDFs (user-defined functions)you can use this book effectively for virtually any version of SQL Server6.x, 7.0, or 2000.

Oracle RMAN Pocket Reference is ideal for DBAs who require a concise reference to common RMAN tasks. The first portion of the book presents commands for such tasks as taking a full database backup, recovering from loss of data file, and cloning a database. The second portion offers a very concise RMAN syntax reference. This book will save DBAs time when performing tasks that are infrequent, yet extremely vital.

With the development of the World-Wide Web, data management problems have branched out from the traditional framework in which tabular data is processed under the strict control of an application, and address today the rich variety of information that is found on the Web, considering a variety of ?exible envir- ments under which such data can be searched, classi ed , and processed. Da- base systems are coming forward today in a new role as the primary backend for the information provided on the Web. Most of today's Web accesses trigger some form of content generation from a database, while electronic commerce often triggers intensive DBMS-based applications. The research community has begun to revise data models, query languages, data integration techniques, - dexes, query processing algorithms, and transaction concepts in order to cope with the characteristics and scale of the data on the Web. New problems have been identi ed , among them goal-oriented information gathering, management of semi-structured data, or database-style query languages for Web data, to name just a few. The International Workshop on the Web and Databases (WebDB) is a series of workshops intended to bring together researchers interested in the interaction between databases and the Web. This year's WebDB 2000 was the third in the series, and was held in Dallas, Texas, in conjunction with the ACM SIGMOD International Conference on Management of Data.

Small, special-purpose computing devices and high-end core Internet servers need fast, reliable database management. Berkeley DB is an embedded database that provides high-performance, scalable, transaction-protected and recoverable data management services to applications. Extremely portable, this library runs under almost all UNIX and Windows variants, as well as a number of embedded, real-time operating systems.

Berkeley DB is the ultimate resource for the world's most widely deployed embedded database engine. This book will aid software architects and engineers, product managers, and systems and network administrators without the overhead imposed by other database products.

Designed by programmers for programmers, this classic library style toolkit provides a broad base of functionality to application writers. This book will help you to make intelligent choices about when and how to use Berkeley DB to meet your needs.

You can visit the Sleepycat website to get the latest errata for this book.

NOTE: The first printing of this book contained an error in the table of contents that caused the page numbers to be off. This will be corrected in the second printing. If you have an earlier edition, you can download a pdf of the correct table of contents that you can print out and use with your book. If you have any questions, please feel free to contact the editor of this book at [email protected].

"SQL Server: Common Problems, Tested Solutions" consists of over 500 common and not-so-common questions that users of all versions of SQL Server are likely to ask. Most of these problems and solutions are either undocumented or poorly documented in Microsofts own literature. Answers are as concise and to the point as possible.

Each FAQ article in the book contains helpful information about the applicable SQL Server version, related FAQ articles, related Microsoft Knowledge Base articles, and other reference works. This book's dual indices and cross-references allow the reader to easily find related FAQ articles in other categories.

Knowledge of "insider" tips on administering Oracle databases can mean the difference between a secure, smoothly running database and a corporate disaster. This book provides high-end administrative solutions for the day-to-day DBA by leveraging relatively unexplored Oracle features with methods that have proven merit in practical situations.