During recent years, huge efforts have been made to establish digital libraries, in a variety of media, offered from a variety of sources, and intended for a variety of professional and private user communities. As digital data collections proliferate, problems of resource selection and data fusion become major issues. Traditional search engines, even the best ones, are unable to provide access to the hidden web of information that is only available via digital library search interfaces.

Originating from the SIGIR 2003 Workshop on Distributed Information Retrieval, held in Toronto, Canada in August 2003, this book presents extended and revised workshop papers as well as several invited papers on the topic to round off coverage of the core issues. The papers are devoted to recent research on the design and implementation of methods and tools for resource discovery, resource description, resource selection, data fusion, and user interaction.

The 9th International Conference on Database Systems for Advanced Appli- tions (DASFAA 2004) was held during March 17-19, 2004 on the beautiful Jeju island of Korea. The DASFAA conference provides an international forum for technical discussions among researchers, developers, and users of database - stems from academia, business, and industry. The main focus of DASFAA is on research in database theory, development of advanced DBMS technologies, and their advanced applications. A premier database conference in the Asia/Paci?c region, DASFAA has been held every two years, and in many countries in the - gion. To promote the area further and to answer the needs of many participants, the steering committee decided to hold the conference annually. DASFAA 2004 was the ?rst such annual conference. The conference was organized by the Special Interest Group on Databases (SIGDB) of the Korea Information Science Society and the Advanced Infor- tion Technology Research Center (AITrc) at KAIST - an engineering research center of excellence (ERC) supported by the Korea Science and Engineering Foundation (KOSEF). We had a number of sponsors who made generous cont- butionstomaketheconferencesuccessful. TheyareOracleKorea, SamsungSDS, Korea Telecom Data, Inc., the United States Air Force O?ce of Scienti?c Re- arch, theAsianO?ceofAerospaceResearch&Development, theArmyResearch O?ce-Far East, and the Korea Advanced Institute of Science and Technology (KAIST).

PL/SQL is the procedural programming language of choice in the Oracle database. It is completely integrated with SQL and is the most fully optimized, highest performance language for database transaction processing. This book is about effective techniques to solve problems using PL/SQL.

Intended for database administrators, this book shows how to protect an Access database by making changes in the startup options, database options and attributes, menus and toolbars, workgroup security, and the Windows operating system itself. The Australian author discusses the AutoExec macro, data

This book teaches you all of the core concepts behind using the database, shows you the tools and techniques you need to master, and gives you practical examples of programming Oracle. teaching you Oracle technology. need to use Oracle databases with confidence. Oracle is the world's leading relational database. used properly, is the fastest and most scaleable database on which to build enterprise scale applications. an overnight job. this book have that experience. application or administering the database and can guarantee you that the techniques taught in this book are proven and have led them through many successful implementations.

The understanding of data semantics in Web-based information systems is the object of intensive research e?orts. The large volume of data on the Internet originatesaneedforaccessingthesemanticcontentofthatinformation. Furth- more, it requires the personalizing of its search and integration to various types of users. Two approacheshave been proposed in the research literature: integ- tion of Web technologies with database technologies and use of meta-languages such as XML. These solutions o?er highly structured or semi-structured data that allow users to perform queries at a higher semantic level. These also faci- tate thedynamic personalizationof Web-basedapplications. Therefore, it is now important to address the question of how one can e?ciently query and search large collections of XML documents. And it is also necessary to ?nd new so- tions, both to support dynamic architectures for Web-based applications and to model users' search and result presentation criteria. The third international workshop on Databases in Networked Information S- tems (DNIS 2003) was held on September 22-24, 2003 at the University of Aizu in Japan on the occasion of its 10th anniversary. The workshop program included research contributions, and invited contributions. The session on Web IntelligenceincludedinvitedpapersbyProfessorJimingLiuandProfessorCyrus Shahabi. The session on Information Interchange and Management Systems - cluded invited papers by Professor Tosiyasu L. Kunii, Professor Elisa Bertino, and ProfessorMarc Sifer. The session on Information Interchange Among Cyber CommunitieshadinvitedpapersbyProfessorToyoakiNishida, ProfessorMasaru Kitsuregawa, and Dr. Umeshwar Dayal. Finally the session onKnowledge - - notation and Visualization included theinvited contributionby ProfessorDaniel Keim.

The Programmer's Guide to SQL provides an in-depth yet concise tutorial on the use of Structured Query Language (SQL), the standard that defines how to create and manipulate databases and the data that they store. Once you've mastered the fundamentals, the book serves as a handy desktop reference on SQL usage, covering all the major SQL statements that you're likely to need when programming databases, with example code for five major database systems: SQL Server, Oracle, DB2, MySQL, and Access. In each case, it demonstrates how the SQL standard is implemented, and in some cases extended, by each database system vendor. It discusses: - Querying, modifying and summarizing data using SQL - SQL Functions- Complex nested queries and joins - Programming database stores procedures, triggers and views - Creating tables, indexes and other database objects- How to write transaction-safe SQL - How to implement basic database security The book covers the very latest version of the SQL standard, SQL-99, and includes two complete case studies, showing how to create and query the underlying database for a fully featured web site, and how to implement role-based security in your applications. in search of an SQL reference that also demonstrates how to use SQL to solve real business problems

This is the only book that provides comprehensive coverage of SQL Server 2000 specifically from a Visual Basic programmer's point of view. SQL Server is now the first choice for the Visual Basic developer wanting a more powerful, reliable and sophisticated database than MS Access can provide. SQL 2000, is tightly integrated with Windows 2000, offering more support for XML and much improved OLAP (Online Analytical Processing) services. This book is for VB developers who want to integrate SQL Server 2000 into their applications. It covers everything needed to work with SQL Server 2000, including topics such as SQL Server 2000 tools, managing database security, building and deploying English query applications, and more. The Jet database engine, which has traditionally powered Access, is gradually being replaced by the Microsoft Database Engine (MSDE), a limited-client version of the SQL Server engine (but without the front-end tools such as Enterprise Manager). This means that VB developers traditionally used to using a single-file database now have to cope with the client-server architecture of SQL Server. This is a big conceptual leap, and many VB developers struggle to make it. possible, and to show them how to use the full range of SQL Server's powerful tools within their VB applications.

"SQL Server CE Database Development with the .NET Compact Framework" is the only book of its kind for developers wishing to examine in detail all aspects of SQL Server CE 2.0 and the .NET Compact Framework, the most significantly updated area of Visual Studio 2003.

Featuring in-depth information on SQL Server CE 2.0 and the .NET Compact Framework, this book illustrates how both Visual Basic .NET and C# can be used to build powerful database applications for the Pocket PC. While other .NET Compact Framework books try to broadly cover general programming issues, this book focuses strictly on database application development.

SQL Server Administration with Perl significantly empowers SQL Server database administrators and developers with Perl scripting techniques and takes SQL Server administration to the next level. This book is about solving SQL Server administrative problems with Perl. SQL Server Administration with Perl consists of a series of scenarios covering a wide range of SQL Server administrative topics. These are real-world scenarios that you hear DBAs discussing on the SQL Server forums and newsgroups-scenarios that DBAs run into in their day-to-day development or production environments. Readers will walk away from this book with two things: a DBA toolkit with well over 150 Perl scripts and problem-solving techniques they can apply to create even more tools for attacking other SQL Server administrative problems. Most of the sample problems are described and addressed in the context of SQL Server 7 or SQL Server 2000, but they are generally version independent. The next major release of SQL Server (Yukon) may change some of the details, but it will not invalidate the nature of the presented approaches or solutions. with any version of SQL Server.

This book constitutes the refereed proceedings of the 4th International Conference on Web-Age Information Management, WAIM 2003, held in Chengdu, China in August 2003. The 30 revised full papers and 16 revised short papers presented together with 2 invited contributions were carefully reviewed and selected from 258 submissions. The papers are organized in topical sections on Web; XML; text management; data mining; bioinformatics; peer-to-peer systems; service networks; time series, similarity, and ontologies; information filtering; queries and optimization; multimedia and views; and systems demonstrations.

* Presents an innovative, philosophical approach to Oracle database administration, and shows how to think about the whole complex problem of performance tuning, how to break it down, how to root out the cause of performance bottlenecks. *Covers all practical aspects of Oracle performance tuning. * Filled with hands-on lessons and accounts. * Teaches an innovative and effective "Physician to Magician" approach, showing how to understand the problem, uncover the root cause, and choose and implement the most effective solution.

This book constitutes the refereed proceedings of the Second International Workshop on Databases in Networked Information Systems, DNIS 2002, held in Aizu, Japan in December 2002. The 16 revised full papers presented with five invited papers were carefully reviewed and selected for inclusion in the book. The papers are organized in topical sections on information interchange and management systems, Web data management systems, data management systems, networked information systems applications, and networked information systems implementations.

Oracle9i PL/SQL: A Developers Guide is intended for both intermediate-level Oracle developers who are designing or coding applications in SQL and PL/SQL and for advanced PL/SQL programmers who need to learn new PL/SQL 9ifeatures. In addition to providing developers with detailed coverage of the PL/SQL 9i language itself, author -->Bulusu Lakshman--> covers the techniques of using PL/SQL 9i for server-side applications and provides the methodology for implementing robust applications. Lakshman also mentors developers in implementing effective techniques for real-world and code-centric Oracle applications that, in the long run, will save them time and energy.

Oracle9i PL/SQL: A Developers Guide is a solid source for the development of Oracle9i PL/SQL applications. Developers incorporating these technologies into new applications and those migrating from earlier versions will both find Lakshman's expert treatment of the topic beneficial.

This book constitutes the thoroughly refereed post-proceedings of the 4th International Workshop on Distributed Communities on the Web, DCW 2002, held in Sydney, Australia in April 2002.The 25 revised full papers presented together with an introductory overview and outline of the field were carefully reviewed and selected from 59 submissions. The papers are organized in topical sections on adaptive networks, collaborative systems, languages for the Web, and adaptive distributed systems.

"Real-World SQL-DMO for SQL Server" delves into the details of administering Microsoft SQL Server using the SQL-DMO object library. Authors Allan Mitchell and Mark Allison have packed the book with explanations and working code that will help you use the library to its full potential. Additionally, Mitchell and Allison offer advice about when (and when "not") to use the SQL-DMO application programming interface (API).

The code in this book has been tried and tested at sites where database administrators routinely manage more than 50 SQL Servers, ensuring that the techniques can be implemented on environments of almost any scale.

Whether youre a developer or a database administrator, this book will take you to the next level in SQL Server administration.

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 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.

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.

Your database is the foundation of your application. Many programmers assume it's also the bottleneck of productive software development, but with the right techniques, this doesn't have to be true. SQL Antipatterns illustrates some of the most common misconceptions and pitfalls software developers face using relational databases. This book helps you to use a database to produce the most efficient results, and turn sluggish, inflexible code and thankless late-night hours into high-quality, reliable solutions and a job well done. The SQL database programming language is the core of most software in the world, but if you're like most software developers, you're self-taught in SQL, and you know just enough to get by. As a result, you might design fragile databases that cannot scale as the business grows, write queries that produce incorrect results and not know why, or deploy applications that are vulnerable to hackers. Don't reinvent the wheel to solve problems SQL was designed to solve--this book will teach you new SQL techniques for getting your job done. Whatever platform or programming language you use, whether you're a junior programmer or a Ph.D., SQL Antipatterns will show you how to design and build databases, how to write better database queries, and how to integrate SQL programming with your application like an expert. You'll also learn the best and most current technology for full-text search, how to design code that is resistant to SQL injection attacks, and other techniques for success.

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.

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

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.

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.

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.