Transaction Processing

Concepts and Techniques
Author: Jim Gray,Andreas Reuter
Publisher: Elsevier
ISBN: 0080519555
Category: Computers
Page: 1070
View: 6235
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.

Principles of Transaction Processing

Author: Philip A. Bernstein,Eric Newcomer
Publisher: Morgan Kaufmann
ISBN: 9780080948416
Category: Computers
Page: 400
View: 4832
Principles of Transaction Processing is a comprehensive guide to developing applications, designing systems, and evaluating engineering products. The book provides detailed discussions of the internal workings of transaction processing systems, and it discusses how these systems work and how best to utilize them. It covers the architecture of Web Application Servers and transactional communication paradigms. The book is divided into 11 chapters, which cover the following: Overview of transaction processing application and system structure Software abstractions found in transaction processing systems Architecture of multitier applications and the functions of transactional middleware and database servers Queued transaction processing and its internals, with IBM's Websphere MQ and Oracle's Stream AQ as examples Business process management and its mechanisms Description of the two-phase locking function, B-tree locking and multigranularity locking used in SQL database systems and nested transaction locking System recovery and its failures Two-phase commit protocol Comparison between the tradeoffs of replicating servers versus replication resources Transactional middleware products and standards Future trends, such as cloud computing platforms, composing scalable systems using distributed computing components, the use of flash storage to replace disks and data streams from sensor devices as a source of transaction requests. The text meets the needs of systems professionals, such as IT application programmers who construct TP applications, application analysts, and product developers. The book will also be invaluable to students and novices in application programming. Complete revision of the classic "non mathematical" transaction processing reference for systems professionals. Updated to focus on the needs of transaction processing via the Internet-- the main focus of business data processing investments, via web application servers, SOA, and important new TP standards. Retains the practical, non-mathematical, but thorough conceptual basis of the first edition.

Transactional Information Systems

Theory, Algorithms, and the Practice of Concurrency Control and Recovery
Author: Gerhard Weikum,Gottfried Vossen
Publisher: Morgan Kaufmann
ISBN: 1558605088
Category: Computers
Page: 853
View: 7361
This book describes the theory, algorithms, and practical implementation techniques behind transaction processing in information technology systems.

Data Mining: Concepts and Techniques

Author: Jiawei Han,Jian Pei,Micheline Kamber
Publisher: Elsevier
ISBN: 9780123814807
Category: Computers
Page: 744
View: 3149
Data Mining: Concepts and Techniques provides the concepts and techniques in processing gathered data or information, which will be used in various applications. Specifically, it explains data mining and the tools used in discovering knowledge from the collected data. This book is referred as the knowledge discovery from data (KDD). It focuses on the feasibility, usefulness, effectiveness, and scalability of techniques of large data sets. After describing data mining, this edition explains the methods of knowing, preprocessing, processing, and warehousing data. It then presents information about data warehouses, online analytical processing (OLAP), and data cube technology. Then, the methods involved in mining frequent patterns, associations, and correlations for large data sets are described. The book details the methods for data classification and introduces the concepts and methods for data clustering. The remaining chapters discuss the outlier detection and the trends, applications, and research frontiers in data mining. This book is intended for Computer Science students, application developers, business professionals, and researchers who seek information on data mining. Presents dozens of algorithms and implementation examples, all in pseudo-code and suitable for use in real-world, large-scale data mining projects Addresses advanced topics such as mining object-relational databases, spatial databases, multimedia databases, time-series databases, text databases, the World Wide Web, and applications in several fields Provides a comprehensive, practical look at the concepts and techniques you need to get the most out of your data

Joe Celko's Analytics and OLAP in SQL

Author: Joe Celko
Publisher: Elsevier
ISBN: 0080495931
Category: Computers
Page: 208
View: 7751
Joe Celko's Analytics and OLAP in SQL is the first book that teaches what SQL programmers need in order to successfully make the transition from On-Line Transaction Processing (OLTP) systems into the world of On-Line Analytical Processing (OLAP). This book is not an in-depth look at particular subjects, but an overview of many subjects that will give the working RDBMS programmers a map of the terra incognita they will face — if they want to grow. It contains 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. It offers real-world insights and lots of practical examples. It covers the OLAP extensions in SQL-99; ETL tools, OLAP features supported in DBMSs, other query tools, simple reports, and statistical software. This book is ideal for experienced SQL programmers who have worked with OLTP systems who need to learn techniques—and even some tricks—that they can use in an OLAP situation. 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 First book that teaches what SQL programmers need in order to successfully make the transition from transactional systems (OLTP) into the world of data warehouse data and OLAP Offers real-world insights and lots of practical examples Covers the OLAP extensions in SQL-99; ETL tools, OLAP features supported in DBMSs, other query tools, simple reports, and statistical software

Camelot and Avalon

A Distributed Transaction Facility
Author: Jeffrey L. Eppinger,Lily B. Mummert,Alfred Z. Spector
Publisher: Morgan Kaufmann Pub
Category: Business & Economics
Page: 505
View: 9850
This is a presentation of Camelot, including the design decisions, key algorithms used, implementation details, performance characteristics, and relevant material on the Mach operating system and programming tools.

Database--principles, Programming, and Performance

Author: Patrick O'Neil,Elizabeth O'Neil
Publisher: Morgan Kaufmann
Category: Computers
Page: 870
View: 1709
This second edition relies on the same successful approach that distinguished the first: it covers the principles of database theory with unmatched thoroughness, and it rigorously links theory to the real world of database programming and administration. A careful discussion of SQL standards and a multitude of examples drawn from actual databases-Oracle, DB2, and Informix-complements the authors' concept-oriented instruction, allowing you to develop product-specific understanding and to learn the important differences between the SQL dialects that will enable you to write portable applications. * Focuses extensively on the object-relational model that is rapidly gaining acceptance and revolutionizing the database industry. Collection types and UDF's are thoroughly covered. * Introduces new relational features of SQL taken from the latest versions of today's most popular database products, Oracle, DB2, and Informix. * Offers thorough coverage of the SQL-99 standard, including additions designed to help you take full advantage of the object-relational model. * Provides expanded programming examples intended to improve your understanding of transaction processing and error handling. * Explains clearly the principles of logical database design, including those relating to the E-R model and normalization, with a number of new illustrations and examples. * Presents the latest indexing and query processing techniques, such as bitmap indexing, and shows how to use them to achieve significant performance improvements.

Joe Celko's SQL Programming Style

Author: Joe Celko
Publisher: Elsevier
ISBN: 9780080478838
Category: Computers
Page: 272
View: 2962
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!

Architecture of a Database System

Author: Joseph M. Hellerstein,Michael Stonebraker,James Hamilton
Publisher: Now Publishers Inc
ISBN: 1601980787
Category: Computers
Page: 123
View: 6788
Architecture of a Database System presents an architectural discussion of DBMS design principles, including process models, parallel architecture, storage system design, transaction system implementation, query processor and optimizer architectures, and typical shared components and utilities.

Joe Celko's SQL for Smarties

Advanced SQL Programming
Author: Joe Celko
Publisher: Elsevier
ISBN: 9780080460048
Category: Computers
Page: 840
View: 5494
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.

Physical Database Design

The Database Professional's Guide to Exploiting Indexes, Views, Storage, and More
Author: Sam S. Lightstone,Toby J. Teorey,Tom Nadeau
Publisher: Morgan Kaufmann
ISBN: 9780080552316
Category: Computers
Page: 448
View: 4184
The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ever to optimize database structure for system performance and administration. Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be improved using the methods provided in the book. The first complete treatment on physical database design, written by the authors of the seminal, Database Modeling and Design: Logical Design, Fourth Edition Includes an introduction to the major concepts of physical database design as well as detailed examples, using methodologies and tools most popular for relational databases today: Oracle, DB2 (IBM), and SQL Server (Microsoft) Focuses on physical database design for exploiting B+tree indexing, clustered indexes, multidimensional clustering (MDC), range partitioning, shared nothing partitioning, shared disk data placement, materialized views, bitmap indexes, automated design tools, and more!

Atomic Transactions

Author: Nancy Ann Lynch
Publisher: Springer Science & Business
ISBN: 9781558601048
Category: Computers
Page: 500
View: 4858
This book presents a framework for precise design and verification of distributed and concurrent systems that use atomic transactions as a high-level abstraction. The authors present the most useful algorithms for transaction processing in concurrent and distributed systems, and include a well-developed data processing case study.

Moving Objects Databases

Author: Ralf Hartmut Güting,Markus Schneider
Publisher: Academic Press
ISBN: 0120887991
Category: Computers
Page: 389
View: 1815
First uniform treatment of moving objects databases, the technology that supports GPS and RFID data analysis.

Databases and Transaction Processing

An Application-oriented Approach
Author: Philip M. Lewis,Arthur J. Bernstein,Michael Kifer
Publisher: N.A
ISBN: 9780321210234
Category: Database management
Page: 1014
View: 6580
This is a great book! This is the book I wish I had written. --Jim Gray, Microsoft Research, recipient of 1998 A.M. Turing Award for seminal contributions to database and transaction processing researchDatabases and Transaction Processing provides a complete and clear explanation of the conceptual and engineering principles underlying the design and implementation of database and transaction processing applications. Rather than focusing on how to implement the database management system itself, this text focuses on how to build database applications. To provide a solid foundation for these principles, the book thoroughly covers the theory underlying relational databases and relational query languages.To illustrate both database and transaction processing concepts, a case study is carried throughout the book. The technical aspects of each chapter applied to the case study and the software engineering concepts required to implement the case study are discussed.In addition to the more traditional material -- relational databases, SQL, and the ACID properties of transactions -- the book provides in-depth coverage of the most current topics in database and transaction processing tec

Management of Heterogeneous and Autonomous Database Systems

Author: Ahmed K. Elmagarmid,Marek Rusinkiewicz,Amit Sheth
Publisher: Morgan Kaufmann
ISBN: 9781558602168
Category: Computers
Page: 413
View: 7102
Seventeen leaders in the field contributed chapters specifically for this unique book, together providing the most comprehensive resource on managing multidatabase systems involving heterogeneous and autonomous databases available today. The book covers virtually all the fundamental issues, concepts, and major research topics.

Visual Computing for Medicine

Theory, Algorithms, and Applications
Author: Bernhard Preim,Charl P Botha
Publisher: Newnes
ISBN: 0124159796
Category: Computers
Page: 836
View: 2429
Visual Computing for Medicine, Second Edition, offers cutting-edge visualization techniques and their applications in medical diagnosis, education, and treatment. The book includes algorithms, applications, and ideas on achieving reliability of results and clinical evaluation of the techniques covered. Preim and Botha illustrate visualization techniques from research, but also cover the information required to solve practical clinical problems. They base the book on several years of combined teaching and research experience. This new edition includes six new chapters on treatment planning, guidance and training; an updated appendix on software support for visual computing for medicine; and a new global structure that better classifies and explains the major lines of work in the field. Complete guide to visual computing in medicine, fully revamped and updated with new developments in the field Illustrated in full color Includes a companion website offering additional content for professors, source code, algorithms, tutorials, videos, exercises, lessons, and more

Data Mining

Practical Machine Learning Tools and Techniques, Second Edition
Author: Ian H. Witten,Eibe Frank
Publisher: Elsevier
ISBN: 9780080477022
Category: Computers
Page: 560
View: 5550
Data Mining, Second Edition, describes data mining techniques and shows how they work. The book is a major revision of the first edition that appeared in 1999. While the basic core remains the same, it has been updated to reflect the changes that have taken place over five years, and now has nearly double the references. The highlights of this new edition include thirty new technique sections; an enhanced Weka machine learning workbench, which now features an interactive interface; comprehensive information on neural networks; a new section on Bayesian networks; and much more. This text is designed for information systems practitioners, programmers, consultants, developers, information technology managers, specification writers as well as professors and students of graduate-level data mining and machine learning courses. Algorithmic methods at the heart of successful data mining—including tried and true techniques as well as leading edge methods Performance improvement techniques that work by transforming the input or output

Data Preparation for Data Mining

Author: Dorian Pyle
Publisher: Morgan Kaufmann
ISBN: 9781558605299
Category: Computers
Page: 540
View: 8825
A guide to the importance of well-structured data as the first step to successful data mining. It shows how data should be prepared prior to mining in order to maximize mining performance, and provides examples of how to apply a variety of techniques in order to solve real world business problems.

Reliable Distributed Systems

Technologies, Web Services, and Applications
Author: Kenneth Birman
Publisher: Springer Science & Business Media
ISBN: 0387276017
Category: Computers
Page: 668
View: 7561
Explains fault tolerance in clear terms, with concrete examples drawn from real-world settings Highly practical focus aimed at building "mission-critical" networked applications that remain secure

Database Design and Implementation

Author: Edward Sciore
Publisher: Wiley
Category: Computers
Page: 784
View: 3520
* Covering the traditional database system concepts from a systems perspective, this book addresses the functionality that database systems provide as well as what algorithms and design decisions will best implement their functionality * Describes what Java tools and techniques will best help developers build an application that uses a database system * Contains a fully functional database system that allows readers to examine and modify the code