"How to Build a Digital Library" is the only book that offers all the knowledge and tools needed to construct and maintain a digital library, regardless of the size or purpose. It is the perfectly self-contained resource for individuals, agencies, and institutions wishing to put this powerful tool to work in their burgeoning information treasuries. The Second Edition reflects new developments in the field as well as in the Greenstone Digital Library open source software. In Part I, the authors have added an entire new chapter on user groups, user support, collaborative browsing, user contributions, and so on. There is also new material on content-based queries, map-based queries, cross-media queries. There is an increased emphasis placed on multimedia by adding a "digitizing" section to each major media type. A new chapter has also been added on "internationalization," which will address Unicode standards, multi-language interfaces and collections, and issues with non-European languages (Chinese, Hindi, etc.). Part II, the software tools section, has been completely rewritten to reflect the new developments in Greenstone Digital Library Software, an internationally popular open source software tool with a comprehensive graphical facility for creating and maintaining digital libraries. As with the First Edition, a web site, implemented as a digital library, will accompany the book and provide access to color versions of all figures, two online appendices, a full-text sentence-level index, and an automatically generated glossary of acronyms and their definitions. In addition, demonstration digital library collections will be included to demonstrate particular points in the book. to access the online content please visit, http: //www.greenstone.org/howto

*Outlines the history of libraries-- both traditional and digital-- and their impact on present practices and future directions. *Written for both technical and non-technical audiences and covers the entire spectrum of media, including text, images, audio, video, and related XML standards. *Web-enhanced with software documentation, color illustrations, full-text index, source code, and more."

In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzles and then helps solve them with a variety of solutions and explanations. Joe demonstrates the thought processes that are involved in attacking a problem from an SQL perspective to help advanced database programmers solve the puzzles you frequently face. These techniques not only help with the puzzle at hand, but help develop the mindset needed to solve the many difficult SQL puzzles you face every day. Of course, part of the fun is to see whether or not you can write better solutions than Joe s.
* A great collection of tricky SQL puzzles with a variety of solutions and explanations.
* Uses the proven format of puzzles and solutions to provide a user-friendly, practical look into SQL programming problems - many of which will help users solve their own problems.
* New edition features:
Many new puzzles added
Dozens of new solutions to puzzles, and using features in SQL-99
Code is edited to conform to SQL STYLE rules
New chapter on temporal query puzzles
New chapter on common misconceptions about SQL and RDBMS that leads to problems"

Are you an SQL programmer that, like many, came to SQL after learning and writing procedural or object-oriented code? Or have switched jobs to where a different brand of SQL is being used, or maybe even been told to learn SQL yourself?
If even one answer is yes, then you need this book. A "Manual of Style" for the SQL programmer, this book is a collection of heuristics and rules, tips, and tricks that will help you improve SQL programming style and proficiency, and for formatting and writing portable, readable, maintainable SQL code. Based on many years of experience consulting in SQL shops, and gathering questions and resolving his students' SQL style issues, Joe Celko can help you become an even better SQL programmer.
+ Help you write Standard SQL without an accent or a dialect that is used in another programming language or a specific flavor of SQL, code that can be maintained and used by other people.
+ Enable you to give your group a coding standard for internal use, to enable programmers to use a consistent style.
+ Give you the mental tools to approach a new problem with SQL as your tool, rather than another programming language - one that someone else might not know!

How do you approach answering queries when your data is stored in multiple databases that were designed independently by different people? This is first comprehensive book on data integration and is written by three of the most respected experts in the field.

This book provides an extensive introduction to the theory and concepts underlying today's data integration techniques, with detailed, instruction for their application using concrete examples throughout to explain the concepts. Data integration is the problem of answering queries that span multiple data sources (e.g., databases, web pages). Data integration problems surface in multiple contexts, including enterprise information integration, query processing on the Web, coordination between government agencies and collaboration between scientists. In some cases, data integration is the key bottleneck to making progress in a field.

The authors provide a working knowledge of data integration concepts and techniques, giving you the tools you need to develop a complete and concise package of algorithms and applications.

*Offers a range of data integration solutions enabling you to focus on what is most relevant to the problem at hand.

*Enables you to build your own algorithms and implement your own data integration applications

*Companion website with numerous project-based exercises and solutions and slides. Links to commercially available software allowing readers to build their own algorithms and implement their own data integration applications. Facebook page for reader input during and after publication.

The demand for SQL information and training continues to grow with the need for a database behind every website capable of offering web-based information queries. SQL is the de facto standard for database retrieval, and if you need to access, update, or utilize data in a modern database management system, youwill need SQL to do it. TheSecond Editionof "Joe Celko's Trees and Hierarchies in SQL for Smarties" covers two new sets of extensions over three entirelynew chapters and expounds upon the changes that have occurred in SQL standards since the previous edition's publication. Benefit from mastering the challenging aspects of these database applications in SQL as taught by Joe Celko, one of the most-read SQL authors in the world.

*Expert advice from a noted SQL authority and award-winning columnist who has given 10 years of service to the ANSI SQL standards committee

*Teaches scores of advanced techniques that can be used with any product, in any SQL environment

*Offers graph theory and programming techniques for working around deficiencies and gives insight into real-world challenges"

A multitude of problems is likely to arise when developing data models. With dozens of attributes and millions of rows, data modelers are always in danger of inconsistency and inaccuracy. The development of the data model itself could result in difficulties presenting accurate data. The need to improve data models begins with getting it right in the first place.

Using real-world examples, "Developing High Quality Data Models" walks the reader through identifying a number of data modeling principles and analysis techniques that enable the development of data models that both meet business requirements and have a consistent basis. The reader is presented with a variety of generic data model patterns that both exemplify the principles and techniques discussed and build upon one another to give a powerful and integrated generic data model. This model has wide applicability across many disciplines in government and industry, including but not limited to energy exploration, healthcare, telecommunications, transportation, military defense, transportation, and more.

* Uses a number of common data model patterns to explain how to develop data models over a wide scope in a way that is consistent and of high quality

*Offers generic data model templates that are reusable in many applications and are fundamental for developing more specific templates

*Develops ideas for creating consistent approaches to high quality data models

"Data Modeling Essentials, Third Edition" provides expert tutelage for data modelers, business analysts and systems designers at all levels. Beginning with the basics, this book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and database design. Later chapters address advanced subjects, including business rules, data warehousing, enterprise-wide modeling and data management.
The third edition of this popular book retains its distinctive hallmarks of readability and usefulness, but has been given significantly expanded coverage and reorganized for greater reader comprehension. Authored by two leaders in the field, "Data Modeling Essentials, Third Edition" is the ideal reference for professionals and students looking for a real-world perspective.
- Thorough coverage of the fundamentals and relevant theory.
- Recognition and support for the creative side of the process.
- Expanded coverage of applied data modeling includes new chapters on logical and physical database design.
- New material describing a powerful technique for model verification.
- Unique coverage of the practical and human aspects of modeling, such as working with business specialists, managing change, and resolving conflict.
- Extensive online component including course notes and other teaching aids (www.mkp.com).
UML diagrams now available! Visit the companion site for more details.
Click here to view a book review by Steve Hoberman!

The key to client/server computing.
Transaction processing techniques are deeply ingrained in the fields of
databases and operating systems and are used to monitor, control and update
information in modern computer systems. This book will show you how large,
distributed, heterogeneous computer systems can be made to work reliably.
Using transactions as a unifying conceptual framework, the authors show how
to build high-performance distributed systems and high-availability
applications with finite budgets and risk.

The authors provide detailed explanations of why various problems occur as
well as practical, usable techniques for their solution. Throughout the book,
examples and techniques are drawn from the most successful commercial and
research systems. Extensive use of compilable C code fragments demonstrates
the many transaction processing algorithms presented in the book. The book
will be valuable to anyone interested in implementing distributed systems
or client/server architectures.

Making the move from an IT technician or team member to management is one of the most difficult career steps you ll face. Help from management and targeted training can be hard to come by - and your success depends on your ability to adapt to your new role almost overnight. You might have years of experience in the trenches, but you ll quickly find that managing a team, setting budgets, and creating a winning strategy for the first time can be daunting tasks.

Now in its third edition, "IT Manager s Handbook" provides a practical reference that you will return to again and again in an ever-changing corporate environment where the demands on IT continue to increase. Make your first 100 days really count with the fundamental principles and core concepts critical to your success as a new IT Manager. The book also includes discusses how to develop an overall IT strategy as well as demonstrate the value of IT to the company.

In this book, you ll learn how to: Manage your enterprise s new level of connectivity with a NEW chapter covering social media, handheld devices, and moreImplement and optimize cloud services to provide a better experience for your mobile and virtual workforce at a lower cost to your bottom lineIntegrate mobile applications into your company s strategyManage the money, including topics such as department budgets and leasing versus buyingWork with your "customers," whomever those might be for your IT shopHire, train, and manage your team and their projects so that you come in on time and budgetSecure your systems to face some of today's most challenging security challenges"

Would the basics of SQL querying be useful to you, but you don't want to start at the very beginning? Do you wish you had an easy way to ramp up quickly to get a basic understanding of key features and capability? Then you need this book! Without a ton of conceptual information or general programming basics you already know, this book is a quick guide for computing professionals and programmers to learn the basics--and more--in an easily digestible way.
+ Provides tutorial-based instruction for the main features of SQL for programmers and other technical professionals in need of a brief but really good introduction to SQL.
+ The approach is vendor-neutral-so very adaptable and flexible-but the book's Web site includes information about DBMS-specific peculiarities.
+ The focus is on teaching concepts by walking through concrete examples and explanations, and self-review exercises are included at the end of each chapter.
+ Coverage is on the key features of the language that are required to understand SQL and begin using it effectively.
+ SQL 2003-compliant.

Whether you are a software developer, systems architect, data analyst, or business analyst, if you want to take advantage of data mining in the development of advanced analytic applications, Java Data Mining, JDM, the new standard now implemented in core DBMS and data mining/analysis software, is a key solution component. This book is the essential guide to the usage of the JDM standard interface, written by contributors to the JDM standard.
The book discusses and illustrates how to solve real problems using the JDM API. The authors provide you with:
* Data mining introduction an overview of data mining and the problems it can address across industries; JDM s place in strategic solutions to data mining-related problems;
* JDM essentials concepts, design approach and design issues, with detailed code examples in Java; a Web Services interface to enable JDM functionality in an SOA environment; and illustration of JDM XML Schema for JDM objects;
* JDM in practice the use of JDM from vendor implementations and approaches to customer applications, integration, and usage; impact of data mining on IT infrastructure; a how-to guide for building applications that use the JDM API.
* Free, downloadable KJDM source code referenced in the book available here
* Data mining introduction an overview of data mining and the problems it can address across industries; JDM's place in strategic solutions to data mining-related problems;
* JDM essentials concepts, design approach and design issues, with detailed code examples in Java; a Web Services interface to enable JDM functionality in an SOA environment; and illustration of JDM XML Schema for JDM objects;
* JDM in practice the use of JDM from vendor implementations and approaches to customer applications, integration, and usage; impact of data mining on IT infrastructure; a how-to guide for building applications that use the JDM API.
* Free, downloadable KJDM source code referenced in the book available here"