Transactional Information Systems

Author: Gerhard Weikum
Publisher: Morgan Kaufmann
ISBN: 9781558605084
Release Date: 2002
Genre: Computers

This book describes the theory, algorithms, and practical implementation techniques behind transaction processing in information technology systems.

Morgan Kaufmann series in data management systems

Author: Stefano Ceri
Publisher: Morgan Kaufmann
ISBN: 1558608435
Release Date: 2003
Genre: Computers

The most prominent Web applications in use today are data-intensive. Scores of database management systems across the Internet access and maintain large amounts of structured data for e-commerce, on-line trading, banking, digital libraries, and other high-volume sites. Developing and maintaining these data-intensive applications is an especially complex, multi-disciplinary activity, requiring all the tools and techniques that software engineering can provide. This book represents a breakthrough for Web application developers. Using hundreds of illustrations and an elegant intuitive modeling language, the authors-all internationally-known database researchers-present a methodology that fully exploits the conceptual modeling approach of software engineering, from idea to application. Readers will learn not only how to harness the design technologies of relational databases for use on the Web, but also how to transform their conceptual designs of data-intensive Web applications into effective software components. * A fully self-contained introduction and practitioner's guide suitable for both technical and non-technical members of staff, as well as students. * A methodology, development process, and notation (WebML) based on common practice but optimized for the unique challenges of high-volume Web applications. * Completely platform- and product-independent; even the use of WebML is optional. * Based on well-known industry standards such as UML and the Entity Relationship Model. * Enhanced by its own Web site (http://www.webml.org), containing additional examples, papers, teaching materials, developers' resources, and exercises with solutions.

Fuzzy Modeling and Genetic Algorithms for Data Mining and Exploration

Author: Earl Cox
Publisher: Academic Press
ISBN: 9780121942755
Release Date: 2005-01-01
Genre: Computers

Fuzzy Modeling and Genetic Algorithms for Data Mining and Exploration is a handbook for analysts, engineers, and managers involved in developing data mining models in business and government. As you'll discover, fuzzy systems are extraordinarily valuable tools for representing and manipulating all kinds of data, and genetic algorithms and evolutionary programming techniques drawn from biology provide the most effective means for designing and tuning these systems. You don't need a background in fuzzy modeling or genetic algorithms to benefit, for this book provides it, along with detailed instruction in methods that you can immediately put to work in your own projects. The author provides many diverse examples and also an extended example in which evolutionary strategies are used to create a complex scheduling system. * Written to provide analysts, engineers, and managers with the background and specific instruction needed to develop and implement more effective data mining systems. * Helps you to understand the trade-offs implicit in various models and model architectures. * Provides extensive coverage of fuzzy SQL querying, fuzzy clustering, and fuzzy rule induction. * Lays out a roadmap for exploring data, selecting model system measures, organizing adaptive feedback loops, selecting a model configuration, implementing a working model, and validating the final model. * In an extended example, applies evolutionary programming techniques to solve a complicated scheduling problem. * Presents examples in C, C++, Java, and easy-to-understand pseudo-code. * Extensive online component, including sample code and a complete data mining workbench.

Data Mining Southeast Asia Edition

Author: Jiawei Han
Publisher: Morgan Kaufmann
ISBN: 0080475582
Release Date: 2006-04-06
Genre: Computers

Our ability to generate and collect data has been increasing rapidly. Not only are all of our business, scientific, and government transactions now computerized, but the widespread use of digital cameras, publication tools, and bar codes also generate data. On the collection side, scanned text and image platforms, satellite remote sensing systems, and the World Wide Web have flooded us with a tremendous amount of data. This explosive growth has generated an even more urgent need for new techniques and automated tools that can help us transform this data into useful information and knowledge. Like the first edition, voted the most popular data mining book by KD Nuggets readers, this book explores concepts and techniques for the discovery of patterns hidden in large data sets, focusing on issues relating to their feasibility, usefulness, effectiveness, and scalability. However, since the publication of the first edition, great progress has been made in the development of new data mining methods, systems, and applications. This new edition substantially enhances the first edition, and new chapters have been added to address recent developments on mining complex types of data— including stream data, sequence data, graph structured data, social network data, and multi-relational data. A comprehensive, practical look at the concepts and techniques you need to know to get the most out of real business data Updates that incorporate input from readers, changes in the field, and more material on statistics and machine learning Dozens of algorithms and implementation examples, all in easily understood pseudo-code and suitable for use in real-world, large-scale data mining projects Complete classroom support for instructors at www.mkp.com/datamining2e companion site

Artificial Intelligence and Soft Computing

Author: Leszek Rutkowski
Publisher: Springer
ISBN: 9783319193694
Release Date: 2015-06-04
Genre: Computers

The two-volume set LNAI 9119 and LNAI 9120 constitutes the refereed proceedings of the 14th International Conference on Artificial Intelligence and Soft Computing, ICAISC 2015, held in Zakopane, Poland in June 2015. The 142 revised full papers presented in the volumes, were carefully reviewed and selected from 322 submissions. These proceedings present both traditional artificial intelligence methods and soft computing techniques. The goal is to bring together scientists representing both areas of research. The first volume covers topics as follows neural networks and their applications, fuzzy systems and their applications, evolutionary algorithms and their applications, classification and estimation, computer vision, image and speech analysis and the workshop: large-scale visual recognition and machine learning. The second volume has the focus on the following subjects: data mining, bioinformatics, biometrics and medical applications, concurrent and parallel processing, agent systems, robotics and control, artificial intelligence in modeling and simulation and various problems of artificial intelligence.

Data Model Patterns A Metadata Map

Author: David C. Hay
Publisher: Morgan Kaufmann
ISBN: 0080477038
Release Date: 2010-07-20
Genre: Computers

Data Model Patterns: A Metadata Map not only presents a conceptual model of a metadata repository but also demonstrates a true enterprise data model of the information technology industry itself. It provides a step-by-step description of the model and is organized so that different readers can benefit from different parts. It offers a view of the world being addressed by all the techniques, methods, and tools of the information processing industry (for example, object-oriented design, CASE, business process re-engineering, etc.) and presents several concepts that need to be addressed by such tools. This book is pertinent, with companies and government agencies realizing that the data they use represent a significant corporate resource recognize the need to integrate data that has traditionally only been available from disparate sources. An important component of this integration is management of the "metadata" that describe, catalogue, and provide access to the various forms of underlying business data. The "metadata repository" is essential to keep track of the various physical components of these systems and their semantics. The book is ideal for data management professionals, data modeling and design professionals, and data warehouse and database repository designers. A comprehensive work based on the Zachman Framework for information architecture—encompassing the Business Owner's, Architect's, and Designer's views, for all columns (data, activities, locations, people, timing, and motivation) Provides a step-by-step description of model and is organized so that different readers can benefit from different parts Provides a view of the world being addressed by all the techniques, methods and tools of the information processing industry (for example, object-oriented design, CASE, business process re-engineering, etc.) Presents many concepts that are not currently being addressed by such tools — and should be

SQL 1999

Author: Jim Melton
Publisher: Morgan Kaufmann
ISBN: 9780080517605
Release Date: 2001-05-30
Genre: Computers

SQL: 1999 is the best way to make the leap from SQL-92 to SQL:1999, but it is much more than just a simple bridge between the two. The latest from celebrated SQL experts Jim Melton and Alan Simon, SQL:1999 is a comprehensive, eminently practical account of SQL's latest incarnation and a potent distillation of the details required to put it to work. Written to accommodate both novice and experienced SQL users, SQL:1999 focuses on the language's capabilities, from the basic to the advanced, and the ways that real applications take advantage of them. Throughout, the authors illustrate features and techniques with clear and often entertaining references to their own custom database. Gives authoritative coverage from an expert team that includes the editor of the SQL-92 and SQL:1999 standards. Provides a general introduction to SQL that helps you understand its constituent parts, history, and place in the realm of computer languages. Explains SQL:1999's more sophisticated features, including advanced value expressions, predicates, advanced SQL query expressions, and support for active databases. Explores key issues for programmers linking applications to SQL databases. Provides guidance on troubleshooting, internationalization, and changes anticipated in the next version of SQL. Contains appendices devoted to database design, a complete SQL:1999 example, the standardization process, and more.

Database Tuning

Author: Dennis Shasha
Publisher: Morgan Kaufmann
ISBN: 0080503780
Release Date: 2002-06-07
Genre: Computers

Tuning your database for optimal performance means more than following a few short steps in a vendor-specific guide. For maximum improvement, you need a broad and deep knowledge of basic tuning principles, the ability to gather data in a systematic way, and the skill to make your system run faster. This is an art as well as a science, and Database Tuning: Principles, Experiments, and Troubleshooting Techniques will help you develop portable skills that will allow you to tune a wide variety of database systems on a multitude of hardware and operating systems. Further, these skills, combined with the scripts provided for validating results, are exactly what you need to evaluate competing database products and to choose the right one. Forward by Jim Gray, with invited chapters by Joe Celko and Alberto Lerner Includes industrial contributions by Bill McKenna (RedBrick/Informix), Hany Saleeb (Oracle), Tim Shetler (TimesTen), Judy Smith (Deutsche Bank), and Ron Yorita (IBM) Covers the entire system environment: hardware, operating system, transactions, indexes, queries, table design, and application analysis Contains experiments (scripts available on the author's site) to help you verify a system's effectiveness in your own environment Presents special topics, including data warehousing, Web support, main memory databases, specialized databases, and financial time series Describes performance-monitoring techniques that will help you recognize and troubleshoot problems

Advanced SQL 1999

Author: Jim Melton
Publisher: Morgan Kaufmann
ISBN: 1558606777
Release Date: 2003
Genre: Computers

This guide documents SQL: 1999Us advanced features in the same practical, "programmercentric" way that the first volume documented the language's basic features. This is no mere representation of the standard, but rather authoritative guidance on making an application conform to it, both formally and effectively.

Joe Celko s SQL for Smarties

Author: Joe Celko
Publisher: Morgan Kaufmann
ISBN: 0080460046
Release Date: 2010-07-26
Genre: Computers

SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 10 years later and in the third edition, this classic still reigns supreme as the book written by an SQL master that teaches future SQL masters. These are not just tips and techniques; Joe also offers the best solutions to old and new challenges and conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. In the third edition, Joe features new examples and updates to SQL-99, expanded sections of Query techniques, and a new section on schema design, with the same war-story teaching style that made the first and second editions of this book classics. Expert advice from a noted SQL authority and award-winning columnist, who has given ten years of service to the ANSI SQL standards committee and many more years of dependable help to readers of online forums. Teaches scores of advanced techniques that can be used with any product, in any SQL environment, whether it is an SQL-92 or SQL-99 environment. Offers tips for working around system deficiencies. Continues to use war stories--updated!--that give insights into real-world SQL programming challenges.

Querying XML

Author: Jim Melton
Publisher: Morgan Kaufmann
ISBN: 0080540163
Release Date: 2011-04-08
Genre: Computers

XML has become the lingua franca for representing business data, for exchanging information between business partners and applications, and for adding structure– and sometimes meaning—to text-based documents. XML offers some special challenges and opportunities in the area of search: querying XML can produce very precise, fine-grained results, if you know how to express and execute those queries. For software developers and systems architects: this book teaches the most useful approaches to querying XML documents and repositories. This book will also help managers and project leaders grasp how “querying XML fits into the larger context of querying and XML. Querying XML provides a comprehensive background from fundamental concepts (What is XML?) to data models (the Infoset, PSVI, XQuery Data Model), to APIs (querying XML from SQL or Java) and more. * Presents the concepts clearly, and demonstrates them with illustrations and examples; offers a thorough mastery of the subject area in a single book. * Provides comprehensive coverage of XML query languages, and the concepts needed to understand them completely (such as the XQuery Data Model). * Shows how to query XML documents and data using: XPath (the XML Path Language); XQuery, soon to be the new W3C Recommendation for querying XML; XQuery's companion XQueryX; and SQL, featuring the SQL/XML * Includes an extensive set of XQuery, XPath, SQL, Java, and other examples, with links to downloadable code and data samples.

Database Modeling and Design

Author: Toby J. Teorey
Publisher: Academic Press
ISBN: 0080470777
Release Date: 2010-08-05
Genre: Computers

Database Modeling and Design, Fourth Edition, the extensively revised edition of the classic logical database design reference, explains how you can model and design your database application in consideration of new technology or new business needs. It is an ideal text for a stand-alone data management course focused on logical database design, or a supplement to an introductory text for introductory database management. This book features clear explanations, lots of terrific examples and an illustrative case, and practical advice, with design rules that are applicable to any SQL-based system. The common examples are based on real-life experiences and have been thoroughly class-tested. The text takes a detailed look at the Unified Modeling Language (UML-2) as well as the entity-relationship (ER) approach for data requirements specification and conceptual modeling - complemented with examples for both approaches. It also discusses the use of data modeling concepts in logical database design; the transformation of the conceptual model to the relational model and to SQL syntax; the fundamentals of database normalization through the fifth normal form; and the major issues in business intelligence such as data warehousing, OLAP for decision support systems, and data mining. There are examples for how to use the most popular CASE tools to handle complex data modeling problems, along with exercises that test understanding of all material, plus solutions for many exercises. Lecture notes and a solutions manual are also available. This edition will appeal to professional data modelers and database design professionals, including database application designers, and database administrators (DBAs); new/novice data management professionals, such as those working on object oriented database design; and students in second courses in database focusing on design. + a detailed look at the Unified Modeling Language (UML-2) as well as the entity-relationship (ER) approach for data requirements specification and conceptual modeling--with examples throughout the book in both approaches! + the details and examples of how to use data modeling concepts in logical database design, and the transformation of the conceptual model to the relational model and to SQL syntax; + the fundamentals of database normalization through the fifth normal form; + practical coverage of the major issues in business intelligence--data warehousing, OLAP for decision support systems, and data mining; + examples for how to use the most popular CASE tools to handle complex data modeling problems. + Exercises that test understanding of all material, plus solutions for many exercises.

Moving Objects Databases

Author: Ralf Hartmut Güting
Publisher: Elsevier
ISBN: 9780080470757
Release Date: 2005-09-06
Genre: Computers

The current trends in consumer electronics--including the use of GPS-equipped PDAs, phones, and vehicles, as well as the RFID-tag tracking and sensor networks--require the database support of a specific flavor of spatio-temporal databases. These we call Moving Objects Databases. Why do you need this book? With current systems, most data management professionals are not able to smoothly integrate spatio-temporal data from moving objects, making data from, say, the path of a hurricane very difficult to model, design, and query. Whether your field is geology, national security, urban planning, mobile computing, or almost anything in between, this book’s concepts and techniques will help you solve the data management problems associated with this kind of data. Focuses on the modeling and design of data from moving objects--such as people, animals, vehicles, hurricanes, forest fires, oil spills, armies, or other objects--as well as the storage, retrieval, and querying of that very voluminous data. Demonstrates through many practical examples and illustrations how new concepts and techniques are used to integrate time and space in database applications. Provides exercises and solutions in each chapter to enable the reader to explore recent research results in practice.

Location Based Services

Author: Jochen Schiller
Publisher: Elsevier
ISBN: 0080491723
Release Date: 2004-05-21
Genre: Computers

Location-based services (LBS) are a new concept integrating a user’s geographic location with the general notion of services, such as dialing an emergency number from a cell phone or using a navigation system in a car. Incorporating both mobile communication and spatial data, these applications represent a novel challenge both conceptually and technically. The purpose of this book is to describe, in an accessible fashion, the various concepts underlying mobile location-based services. These range from general application-related ideas to technical aspects. Each chapter starts with a high level of abstraction and drills down to the technical details. Contributors examine each application from all necessary perspectives, namely, requirements, services, data, and scalability. An illustrative example begins early in the book and runs throughout, serving as a reference. · This book defines the LBS field and identifies its capabilities, challenges, and technologies. · The contributors are recognized experts from academia and industry. · Coverage includes navigation systems, middleware, interoperability, standards, and mobile communications. · A sample application, the "find-friend" application, is used throughout the book to integrate the concepts discussed in each chapter.

Joe Celko s Thinking in Sets Auxiliary Temporal and Virtual Tables in SQL

Author: Joe Celko
Publisher: Morgan Kaufmann
ISBN: 008055752X
Release Date: 2008-01-22
Genre: Computers

Perfectly intelligent programmers often struggle when forced to work with SQL. Why? Joe Celko believes the problem lies with their procedural programming mindset, which keeps them from taking full advantage of the power of declarative languages. The result is overly complex and inefficient code, not to mention lost productivity. This book will change the way you think about the problems you solve with SQL programs.. Focusing on three key table-based techniques, Celko reveals their power through detailed examples and clear explanations. As you master these techniques, you’ll find you are able to conceptualize problems as rooted in sets and solvable through declarative programming. Before long, you’ll be coding more quickly, writing more efficient code, and applying the full power of SQL • Filled with the insights of one of the world’s leading SQL authorities - noted for his knowledge and his ability to teach what he knows. • Focuses on auxiliary tables (for computing functions and other values by joins), temporal tables (for temporal queries, historical data, and audit information), and virtual tables (for improved performance). • Presents clear guidance for selecting and correctly applying the right table technique.