Product Details
- Hardcover: 306 pages
- Publisher: IOS Press (February 15, 2007)
- Language: English
- ISBN-10: 1586037153
- ISBN-13: 978-1586037154
- Product Description
This publication contains papers that present original results in business modeling and enterprise engineering, database research, data engineering, data quality and data analysis, IS engineering, Web engineering, and application of AI methods. The contributions are from academics and practitioners from the entire world. The editors hope that the presented results will contribute to the further development of research in the field of databases and information systems. Some topics of this publication are: Data Integration Methods; Data Mining; Data Models and Database Design; Distributed Database Techniques and Interoperability; - Read the rest of this entry »
The book presents the latest research ideas and topics on how to enhance current database systems, improve information storage, refine existing database models, and develop advanced applications. It provides insights into important developments in the field of database and database management. With emphasis on theoretical issues regarding databases and database management, the book describes the capabilities and features of new technologies and methodologies, and addresses the needs of database researchers and practitioners.
There are a myriad of new directions in which databases are growing, presenting new and exciting challenges that promise flux in the whole society, because of the impact and changes the database systems have provoked almost everywhere in modern life. This ranges from the way the organizations operate and make their business decisions, to the use of portable devices with database involvements. The Encyclopedia of Database Technologies and Applications is a wide-ranging collection of diverse coverage of topics related to database concepts, technologies, and applications - providing an overview of the state-of-the-art of classical subjects. It also delivers clear and concise explanations of emerging issues and technologies such as multimedia database systems, data warehousing and mining, geospatial and temporal databases, and data reverse engineering. Contributions from hundreds of international researchers make this publication a priceless single reference source in any library on the topic of database technologies and applications.
Owning this reference, which covers everything from the components of a table to performing batch updates, is a must! Beginning with tips for the person who is programming with SQL for the first time, SQL Tips and Techniques grows with your skills. You can start with Tip 1, “Understanding the Definition of a Database,” and by the last tip, “Displaying Image Data Stored Within a SQL Table,” you will have covered all aspects of SQL. Or, you can simply keep this book as a comprehensive reference for answering specific SQL questions quickly. However you read it, this invaluable reference will be the only SQL book you need on your shelf!
As the number of interfaces developed using browser technology is increasing, user expectations for UI sophistication are also increasing. Techniques that might be suitable for an occasional-use website or a non-interactive news site quickly become tedious when used on a daily basis. Javas cript helps developers break users out of this tedium, allowing the creation of more powerful user interfaces while still keeping the zero-install advantages of a browser. Javas cript, however, is neither the easiest language in which to develop nor the most forgiving. Supporting the quirks and API differences of various browsers often drives developers to tear their hair out. Difficulty doing easy things soon leads to near impossibility of doing hard things. Prototype and s criptaculous pull Javas cript back from this brink and make it a much stronger technology for creating reasonably complex user interfaces. It offers more powerful abstractions and a consistent API. This document is a jump-start into using Prototype and s criptaculous that will allow readers to start using these libraries and provide enough insight to understand the Prototype and s criptaculous resources available on the Web. As such, is it not meant as authoritative documentation, but more as a guide to what these technologies can do and how to get started using them. 
*Covering Microsoft’s brand-new SQL 2005 administrator exam, this study guide walks readers through setting up, maintaining, and troubleshooting database solutions
In this complete revision and expansion of his first SQL Puzzles book, Joe Celko challenges you with his trickiest puzzlesand 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 Joes.
SQL Performance Tuning is a handbook of practical solutions for busy database professionals charged with managing an organization’s critically important data. Covering today’s most popular and widely installed database environments, this book is an indispensable resource for managing and tuning SQL across multiple platforms. Packed with tips, techniques, and best practices, this hands-on guide covers SQL commands and queries over a wide range of conditions and environments. Every facet of the SQL environment is covered, from concurrency control to optimizationâ€،±and every issue in between. The book includes an overview of each of the most widely used database management systems (DBMS) and provides tuning tips for common day-to-day situations. Topics covered include: *General and specific tuning *General sort considerations and options *Joins and subqueries *Columns and tables *Indexes, including B-trees and bitmaps *Constraints and stored procedures *ODBC and JDBC *Data changes and concurrency control (locking) *Clients, servers, and middleware 
Discusses creating, using, and managing user-defined functions and system user-defined functions. Covers the three types of UDFs and how to create and use them, how to debug UDFs, and more.
SQL in a Nutshell applies the eminently useful “Nutshell” format to Structured Query Language (SQL), the elegant–but complex–descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world’s top SQL database products. SQL in a Nutshell is a lean, focused, and thoroughly comprehensive reference for those who live in a deadline-driven world. This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format that covers the SQL syntax of no less than 4 different databases. When you need fast, accurate, detailed, and up-to-date SQL information, SQL in a Nutshell, Second Edition will be the quick reference you’ll reach for every time. SQL in a Nutshell is small enough to keep by your keyboard, and concise (as well as clearly organized) enough that you can look up the syntax you need quickly without having to wade through a lot of useless fluff. You won’t want to work on a project involving SQL without it.
As dynamic, database-driven Web sites become the standard, more and more nonprogrammers just like yourself are being forced to work with database information and create and edit database objects. With SQL and this task-based guide to it, you can do it too–no programming experience required!