Apply powerful window functions in T-SQL—and increase the performance and speed of your queries Optimize your queries—and obtain simple and elegant solutions to a variety of problems—using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks.
Книга авторов из Великобритании посвящена разработке, внедрению и использованию конструкторских баз данных - одного из центральных компонентов современных интегрированных систем автоматизации проектирования и производства. Рассматриваются архитектура конструкторских баз данных, организационная поддержка их использования, программное и аппаратное обеспечение, вопросы проектирования и стандартизации. Описываются важнейшие международные стандарты представления информации. Для инженеров-разработчиков программного и информационного обеспечения ИПР и САПР, руководителей промышленных предприятий, студентов и аспирантов в области промышленной информатики.
Цель курса: приобрести знания и практические навыки использования среды программирования Delphi 2010 для создания приложений работающих с различными СУБД.
Вы научитесь создавать в самой популярной среде для работы с базами данных Delphi, приложения для работы с различными СУБД; получите необходимые знания по теории баз данных, изучите различные технологии работы с ними.
По окончании курса Вы будете уметь: Создавать приложения для баз данных Работать с полями Осуществлять фильтрацию и поиск Создавать запросы Осуществлять выборки Модифицировать записи, таблицы Использовать локальные транзакции Строить отчёты, диаграммы Использовать технологии BDE и ADO
This hands–on guide shows Java developers how to access data with the new 3.0 Java Database Connectivity (JDBC) API, use LDAP–enabled directory services with Java Network Directory Services (JNDI), and manipulate XML data using Java APIs for XML Processing (JAXP). Pick up this book to acquire the skills needed to effectively create Java applications that can access a variety of data sources. Learn the basics of JDBC 3.0 and how it relates to the Java programming language as a whole. Then from this base, build your knowledge by reading about common advanced uses such as connection pooling, JSP implementations, and Enterprise JavaBeans. You will also gain an awareness of several object oriented design patterns for implementing JDBC solutions, and gain a knowledge of JNDI and how to use it to store and retrieve data using LDAP.
Advances in hardware technology have increased the capability to store and record personal data about consumers and individuals. This has caused concerns that personal data may be used for a variety of intrusive or malicious purposes. Privacy Preserving Data Mining: Models and Algorithms proposes a number of techniques to perform the data mining tasks in a privacy-preserving way. These techniques generally fall into the following categories: data modification techniques, cryptographic methods and protocols for data sharing, statistical techniques for disclosure and inference control, query auditing methods, randomization and perturbation-based techniques. This edited volume also contains surveys by distinguished researchers in the privacy field. Each survey includes the key research content as well as future research directions of a particular topic in privacy. Privacy Preserving Data Mining: Models and Algorithms is designed for researchers, professors, and advanced-level students in computer science. This book is also suitable for practitioners in industry.
Marketshare for DB2 has been growing steadily over the past 5 years and with the recent release of DB2 Universal Database V8, the product has never had more momentum. Not only is the product used in every company on the Fortune 500, but it is becoming very popular in the small to medium sized businesses as well. Sams Teach Yourself DB2 Universal Database in 21 Days, Second Edition, focuses on performing tasks using the graphical interfaces and wizards that are provided with DB2 on the Windows platform.
Best-selling author and database expert with more than 25 years of experience modeling application and enterprise data, Dr. Michael Blaha provides tried and tested data model patterns, to help readers avoid common modeling mistakes and unnecessary frustration on their way to building effective data models. Unlike the typical methodology book, Patterns of Data Modeling provides advanced techniques for those who have mastered the basics.
This book touches on an area seldom explored: the mathematical underpinnings of the relational database. The topic is important, but far too often ignored. This book is the only book to explain the underlying math in a way that’s accessible to database professionals. Just as importantly, if not more so, this book goes beyond the abstract by showing readers how to apply that math in ways that will make them more productive in their jobs. What’s in this book will "open the eyes" of most readers to the great power, elegance, and simplicity inherent in relational database technology.
Tsau Young Lin, Ying Xie, Anita Wasilewska, Churn-Jung Liau
Год издания: 2008 Страниц: 578 Язык: английский
This book contains valuable studies in data mining from both foundational and practical perspectives. The foundational studies of data mining may help to lay a solid foundation for data mining as a scientific discipline, while the practical studies of data mining may lead to new data mining paradigms and algorithms.
Agile Oracle Application Express shows how skilled, motivated, and self-organizing developers can realize extraordinary commercial benefits from Oracle Application Express. The secret is to couple Application Express with an agile software development approach. This book leads the way.
