Описание: Improve the performance of relational databases with indexes designed for today's hardware. Over the last few years, hardware and software have advanced beyond all recognition, so it's hardly surprising that relational database performance now receives much less attention. Unfortunately, the reality is that the improved hardware hasn't kept pace with the ever-increasing quantity of data processed today. Although disk packing densities have increased enormously, making storage costs extremely low and sequential read very fast, random reads are still painfully slow. Many of the old design recommendations are therefore no longer valid the optimal point of indexing has come a long way. Consequently many of the old problems haven't actually gone away they have simply changed their appearance. This book provides an easy but effective approach to the design of indexes and tables. Using lots of examples and case studies, the authors describe how the DB2, Oracle, and SQL Server optimizers determine how to access data, and how CPU and response times for the resulting access paths can be quickly estimated. This enables comparisons to be made of the various designs, and helps you choose available choices for the most appropriate design. This book is intended for anyone who wants to understand the issues of SQL performance or how to design tables and indexes effectively. With this title, readers with many years of experience of relational systems will be able to better grasp the implications that have been brought into play by the introduction of new hardware.
Описание: The book constitutes the joint refereed proceedings of the 9th International Conference on Relational Methods in Computer Science, RelMiCS 2006, and the 4th International Workshop on Applications of Kleene Algebras, AKA 2006, held in Manchester, UK in August/September 2006.The 25 revised full papers presented together with 2 invited papers and the abstract of an invited talk were carefully reviewed and selected from 44 submissions. The papers are devoted to the theory of relation algebras, Kleene algebras, and related formalisms as well as to their diverse applications in software engineering, databases, and artificial intelligence; a special focus is on formal methods, logics of programs, and links to neighbouring disciplines.
Автор: Dzeroski Saso, Lavrac Nada Название: Relational Data Mining ISBN: 3540422897 ISBN-13(EAN): 9783540422891 Издательство: Springer Рейтинг: Цена: 14629 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: As the first book devoted to relational data mining, this coherently written multi-author monograph provides a thorough introduction and systematic overview of the area. The first part introduces the reader to the basics and principles of classical knowledge discovery in databases and inductive logic programming; subsequent chapters by leading experts assess the techniques in relational data mining in a principled and comprehensive way; finally, three chapters deal with advanced applications in various fields and refer the reader to resources for relational data mining.This book will become a valuable source of reference for R&D professionals active in relational data mining. Students as well as IT professionals and ambitioned practitioners interested in learning about relational data mining will appreciate the book as a useful text and gentle introduction to this exciting new field.
Описание: The first two editions of Inside Relational Databases have both been best sellers. These new editions will also cover the relational database model but will use different engines to illustrate the model. In doing so, readers will be able to apply the model using their preferred database engine. Initially three versions are planned starting with Access, SQL Server and my SQL.The books show just how simple and useful databases can be. No prior knowledge is required i.e. real world examples show how to manage data efficiently. A significant amount of new material is included in the core of the book and particular emphasis is given to showing how to make a database run faster and more efficiently.
Автор: Terry Halpin Название: Information Modeling and Relational Databases, ISBN: 0123735688 ISBN-13(EAN): 9780123735683 Издательство: Elsevier Science Рейтинг: Цена: 7838 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Information Modeling and Relational Databases, Second Edition, provides an introduction to ORM (Object-Role Modeling)and much more. In fact, it is the only book to go beyond introductory coverage and provide all of the in-depth instruction you need to transform knowledge from domain experts into a sound database design. This book is intended for anyone with a stake in the accuracy and efficacy of databases: systems analysts, information modelers, database designers and administrators, and programmers. Terry Halpin, a pioneer in the development of ORM, blends conceptual information with practical instruction that will let you begin using ORM effectively as soon as possible. Supported by examples, exercises, and useful background information, his step-by-step approach teaches you to develop a natural-language-based ORM model, and then, where needed, abstract ER and UML models from it. This book will quickly make you proficient in the modeling technique that is proving vital to the development of accurate and efficient databases that best meet real business objectives.
Описание: Features more than 200 solved problems and an equal number of supplementary problems facilitating the understanding of database technology. Syntax and database technology employed by important database developers are featured. Lab and practice tests similar to the tests used in the database certification exams for database developers are included.
Автор: Pivert Olivier Название: Fuzzy Preference Queries to Relational Databases ISBN: 1848168691 ISBN-13(EAN): 9781848168695 Издательство: World Scientific Publishing Рейтинг: Цена: 12884 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: The manipulation of databases is an integral part of a world which is becoming increasingly and pervasively information-focused. This book puts forward a suggestion to advocate preference queries and fuzzy sets as a central concern in database queries and offers an important contribution to the design of intelligent information systems. It provides a comprehensive study on fuzzy preference queries in the context of relational databases. Preference queries, a recent hot topic in database research, provide a basis for rank-ordering the items retrieved, which is especially valuable for large sets of answers.This book aims to show that fuzzy set theory constitutes a highly expressive framework for modeling preference queries. It presents a study of the algorithmic aspects related to the evaluation of such queries in order to demonstrate that this framework offers a good trade-off between expressivity and efficiency. Numerous examples and proofs are liberally and lucidly demonstrated throughout, and greatly enhance the detailed theoretical aspects explored in the book.Researchers working in databases will greatly benefit from this comprehensive and up-to-date study of fuzzy preference queries, and it will also become an invaluable reference point for postgraduate students interested in advanced database techniques.The only other books which deal with this topic are edited books or conference proceedings which include a few contributions about some specific aspects of the question. This book provides a comprehensive view of the issue, starting with basic notions related to relational databases and fuzzy set theory, up to the detailed study of complex fuzzy queries and the way they can be efficiently processed. It is the compendium of more than 20 years of research by the authors who benefit from a great international recognition in the domain of intelligent information systems, on the subject.
Автор: Tom Johnston Название: Managing Time in Relational Databases, ISBN: 0123750415 ISBN-13(EAN): 9780123750419 Издательство: Elsevier Science Рейтинг: Цена: 6265 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Managing Time in Relational Databases: How to Design, Update and Query Temporal Data introduces basic concepts that will enable businesses to develop their own framework for managing temporal data. It discusses the management of uni-temporal and bi-temporal data in relational databases, so that they can be seamlessly accessed together with current data; the encapsulation of temporal data structures and processes; ways to implement temporal data management as an enterprise solution; and the internalization of pipeline datasets. . The book is organized into three parts. Part 1 traces the history of temporal data management and presents a taxonomy of bi-temporal data management methods. Part 2 provides an introduction to Asserted Versioning, covering the origins of Asserted Versioning; core concepts of Asserted Versioning; the schema common to all asserted version tables, as well as the various diagrams and notations used in the rest of the book; and how the basic scenario works when the target of that activity is an asserted version table. Part 3 deals with designing, maintaining, and querying asserted version databases. It discusses the design of Asserted Versioning databases; temporal transactions; deferred assertions and other pipeline datasets; Allen relationships; and optimizing Asserted Versioning databases.
Автор: C.J. Date Название: Time and Relational Theory, ISBN: 0128006315 ISBN-13(EAN): 9780128006313 Издательство: Elsevier Science Рейтинг: Цена: 4802 р. Наличие на складе: Поставка под заказ.
Описание: Time and Relational Theory provides an in-depth description of temporal database systems, which provide special facilities for storing, querying, and updating historical and future data. Traditionally, database management systems provide little or no special support for temporal data at all. This situation is changing because: . . Cheap storage enables retention of large volumes of historical data in data warehouses. Users are now faced with temporal data problems, and need solutions . Temporal features have recently been incorporated into the SQL standard, and vendors have begun to add temporal support to their DBMS products . Based on the groundbreaking text Temporal Data & the Relational Model (Morgan Kaufmann, 2002) and new research led by the authors, Time and Relational Theory is the only book to offer a complete overview of the functionality of a temporal DBMS. Expert authors Nikos Lorentzos, Hugh Darwen, and Chris Date describe an approach to temporal database management that is firmly rooted in classical relational theory and will stand the test of time. . This book covers the SQL:2011 temporal extensions in depth and identifies and discusses the temporal functionality still missing from SQL.
Автор: Schmidt Название: Relational Mathematics ISBN: 0521762685 ISBN-13(EAN): 9780521762687 Издательство: Cambridge Academ Рейтинг: Цена: 9777 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: Relational mathematics is to operations research and informatics what numerical mathematics is to engineering: it is intended to help modelling, reasoning, and computing. Its applications are therefore diverse, ranging from psychology, linguistics, decision aid, and ranking to machine learning and spatial reasoning. Although many developments have been made in recent years, they have rarely been shared amongst this broad community of researchers. This comprehensive 2010 overview begins with an easy introduction to the topic, assuming a minimum of prerequisites; but it is nevertheless theoretically sound and up to date. It is suitable for applied scientists, explaining all the necessary mathematics from scratch using a multitude of visualised examples, via matrices and graphs. It ends with tangible results on the research level. The author illustrates the theory and demonstrates practical tasks in operations research, social sciences and the humanities.
Описание: This book constitutes the thoroughly refereed joint postproceedings of the 7th International Seminar on Relational Methods in Computer Science and the 2nd International Workshop on Applications of Kleene Algebra held in Bad Malente, Germany in May 2003.The 21 revised full papers presented were carefully selected during two rounds of reviewing and improvement. The papers address foundational and methodological aspects of the calculi of relations and Kleene algebra as well as applications of such methods in various areas of computer science and information processing.
Описание: This book constitutes the thoroughly refereed joint post-proceedings of the 6th International Conference on Relational Methods in Computer Science, RelMICS 2001 and the 1st Workshop of COST Action 274 TARSKI, Theory and Application of Relational Structures as Knowledge Instruments held in Oisterwijk, The Netherlands, in October 2001.The 20 revised full papers presented together with an invited paper were carefully reviewed and selected. The papers are organized in topical sections on algebraic and logical foundations of real world relations, mechanization of relational reasoning, and relational scaling and preferences.
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru