Автор: C.J. Date Название: Temporal Data & the Relational Model, ISBN: 1558608559 ISBN-13(EAN): 9781558608559 Издательство: Elsevier Science Рейтинг: Цена: 6166 р. Наличие на складе: Невозможна поставка.
Описание: Temporal database systems are systems that provide special support for storing, querying, and updating historical and/or future data. Current DBMSs provide
essentially no temporal features at all, but this situation is likely to change soon for a variety of reasons; in fact, temporal databases are virtually certain to become important sooner rather
than later, in the commercial world as well as in academia. This book provides an in-depth description of the foundations and principles on which those temporal DBMSs will be
These foundations and principles are firmly rooted in the relational model of data; thus, they represent an evolutionary step, not a revolutionary one, and they will stand
the test of time. This book is arranged in three parts and a set of appendixes: Preliminaries - provides a detailed review of the relational model, and an overview of the Tutorial D
language; Laying the Foundations - explains basic temporal data problems and introduces fundamental constructs and operators for addressing those problems; Building on the
Foundations - applies the material of the previous part to issues of temporal database design, temporal constraints, temporal query and update, and much more; and, Appendixes -
include annotated references and bibliography, implementation considerations, and other topics. The key features: describes a truly relational approach to the temporal data problem;
addresses implementation as well as model issues; covers recent research on new database design techniques, a new normal form, new relational operators, new update operators, a
new approach to the problem of 'granularity', support for 'cyclic point types', and other matters; and, includes review questions and exercises in every chapter.
The book is
suitable for both reference and tutorial purposes.
Описание: 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.
Автор: Date, C.j. Название: Sql and relational theory ISBN: 0596523068 ISBN-13(EAN): 9780596523060 Издательство: Wiley Рейтинг: Цена: 3238 р. Наличие на складе: Поставка под заказ.
Описание: Understanding SQL`s underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. This book demonstrates how you can apply relational theory directly to your use of SQL, with numerous examples and clear explanations of the reasoning behind them.
Автор: Tom Johnston Название: Managing Time in Relational Databases, ISBN: 0123750415 ISBN-13(EAN): 9780123750419 Издательство: Elsevier Science Рейтинг: Цена: 5605 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: 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.
Learn effective and scalable database design techniques in a SQL Server 2016 and higher environment. This book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in SQL Server 2016. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for forty years coupled with technology that is constantly changing. Pro SQL Server Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to 'get it right' in SQL Server database design and lay a solid groundwork for the future use of valuable business data.The pace of change in relational database management systems has been tremendous these past few years. Whereas in the past it was enough to think about optimizing data residing on spinning hard drives, today one also must consider solid-state storage as well as data that are constantly held in memory and never written to disk at all except as a backup. Furthermore, there is a trend toward hybrid cloud and on-premise database configurations as well a move toward preconfigured appliances. Pro SQL Server Relational Database Design and Implementation guides in the understanding of these massive changes and in their application toward sound database design.
Gives a solid foundation in best practices and relational theoryCovers the latest implementation features in SQL Server 2016Helps you master in-memory OLTP and use it effectivelyTakes you from conceptual design to an effective, physical implementationWhat You Will Learn
Develop conceptual models of client data using interviews and client documentationRecognize and apply common database design patternsNormalize data models to enhance scalability and the long term use of valuable dataTranslate conceptual models into high–performing SQL Server databasesSecure and protect data integrity as part of meeting regulatory requirementsCreate effective indexing to speed query performance
Who This Book Is For
Programmers and database administrators of all types who want to use SQL Server to store data. The book is especially useful to those wanting to learn the very latest design features in SQL Server 2016, features that include an improved approach to in-memory OLTP, durability enhancements, temporal data support, and more. Chapters on fundamental concepts, the language of database modeling, SQL implementation, and of course, the normalization process, lay a solid groundwork for readers who are just entering the field of database design. More advanced chapters serve the seasoned veteran by tackling the very latest in physical implementation features that SQL Server has to offer. The book has been carefully revised to cover all the design-related features that are new in SQL Server 2016.
Автор: Pivert Olivier Название: Fuzzy Preference Queries to Relational Databases ISBN: 1848168691 ISBN-13(EAN): 9781848168695 Издательство: World Scientific Publishing Рейтинг: Цена: 13600 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: 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.
Автор: Schmidt Название: Relational Mathematics ISBN: 0521762685 ISBN-13(EAN): 9780521762687 Издательство: Cambridge Academ Рейтинг: Цена: 8326 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: 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.
Описание: Fully revised, updated, and expanded, Relational Database Design and Implementation, Third Edition is the most lucid and effective introduction to the subject available for IT/IS professionals interested in honing their skills in database design, implementation, and administration. This book provides the conceptual and practical information necessary to develop a design and management scheme that ensures data accuracy and user satisfaction while optimizing performance, regardless of experience level or choice of DBMS.<br>The book begins by reviewing basic concepts of databases and database design, then briefly reviews the SQL one would use to create databases. Topics such as the relational data model, normalization, data entities and Codd's Rules (and why they are important) are covered clearly and concisely but without resorting to "Dummies"-style talking down to the reader.<br>Supporting the book's step-by-step instruction are three NEW case studies illustrating database planning, analysis, design, and management practices. In addition to these real-world examples, which include object-relational design techniques, an entirely NEW section consisting of three chapters is devoted to database implementation and management issues.<br> <br><br>* Principles needed to understand the basis of good relational database design and implementation practices. <br>* Examples to illustrate core concepts for enhanced comprehension and to put the book's practical instruction to work.<br>* Methods for tailoring DB design to the environment in which the database will run and the uses to which it will be put.<br>* Design approaches that ensure data accuracy and consistency.<br>* Examples of how design can inhibit or boost database application performance.<br>* Object-relational design techniques, benefits, and examples.<br>* Instructions on how to choose and use a normalization technique.<br>* Guidelines for understanding and applying Codd's rules.<br>* Tools to implement a relational design using SQL.<br>* Techniques for using CASE tools for database design. <br>
Автор: Long Название: Relational Data Clustering ISBN: 1420072617 ISBN-13(EAN): 9781420072617 Издательство: Taylor&Francis Рейтинг: Цена: 8254 р. Наличие на складе: Невозможна поставка.
Описание: A culmination of the authors’ years of extensive research on the topic, this book provides a complete, self-contained introduction to advances in relational data clustering. It presents a novel theoretical framework as well as the most state-of-the-art models for relational data clustering. The authors also describe a family of new algorithms for various relational clustering problems arising in a wide range of important applications. Concepts and theory are explained through detailed application examples and the book includes a comprehensive reference list of related literature.
Автор: Terry Halpin Название: Information Modeling and Relational Databases, ISBN: 0123735688 ISBN-13(EAN): 9780123735683 Издательство: Elsevier Science Рейтинг: Цена: 7013 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: 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.
Описание: Offering an introduction to relational database design, this second edition offers the information you need to develop a design that ensures data accuracy and user satisfaction while optimizing performance, regardless of your experience level or choice of DBMS. It features 3 case studies illustrating the planning, analysis, and design steps.
Описание: Database theory is now in a mature state, and this book addresses important extensions of the relational database model such as deductive, temporal and
object-oriented databases. It provides an overview of database modelling with the Entity-Relationship (ER) model and the relational model providing the pivot on which the material
revolves. The main body of the book focuses on the primary achievements of relational database theory, including query languages, integrity constraints, database design, comput able
queries and concurrency control.
The most important extensions of the relational model are covered in separate chapters. This book will be useful to third year computer
science undergraduates and postgraduates studying database theory, and will also be of interest to researchers and database practitioners who would like to know more about the
ideas underlying relational dat abase management systems and the problems that confront database researchers.
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru