Technical Books

This book introduces you to DB2� application development using DB2 Express-C. Learn about DB2 stored procedures, functions and Data Web services using SQL and XQuery. Learn how to work with DB2 and JavaTM, C/C++, .NET, PHP, Ruby on Rails, Perl, and more!

This guide is designed for people new to DB2 for Linux, UNIX, and Windows. This guide gives answer for the following questions: What is DB2, How does DB2 compare to similar software products, How does DB2 work with other software products, Get started using DB2.

This note explains the following topics: Quick Beginnings for DB2 Clients and Servers, Data Recovery and High Availability, Developing ADO.NET and OLE DB Applications, Developing Embedded SQL Applications, Developing Java Applications, Developing Perl and PHP Applications, Developing SQL and External Routines , XML Extender Administration and Programming.

This note covers the following topics: Traditional DDS, SQL Interface, Data Definition Language, Advanced DML, Security and Admin, DB Connectivity, Query Manager, Object and Row Locking, Save Files, Override DB Files.

This note covers Architecture overview and project history, Data definition language, Query optimization for DB2 parallel edition, DB2 parallel edition runtime, Database utilities, Results, Experiences and future.

This note explains the following topics: database concepts and basics of DB2, Data modeling and relational database design concept, Database objects and DDL, DML and DCL commands, Retrieving data and functions in DB2, DB2 Storage backup and recovery.

This note covers the following topics: Databases and database users, database system concepts and architecture, relational data model, lab manual, the relational data model and constraints, Relational algebra and calculus, sql, basic sql, JDBC API to access relational databases in java, JDBC API javadoc, sun JDBC, JDBC scrollable resultsets, oracle JDBC drivers for java 6, ER model, enhanced ER model.

This book covers the following topics: Databases, Automata, Compilers, Operating Systems, Introductory Java, Data Structures, and Data Mining.

This book explains you how to use this document oriented database as a standalone application framework or with high volume, distributed applications.

This note covers the following topics: Introduction, inductive learning, Decision trees, Rule induction, Instance-based learning, Bayesian learning, Neural networks, Model ensembles, Learning theory, Clustering and dimensionality reduction.

This note is designed to introduce graduate students to the foundations of database systems, focusing on basics such as the relational algebra and data model, query optimization, query processing, and transactions. Topics covered includes: The relational model, Schema design, database internals, Database operators and query processing, Indexing and access methods, Buffer pool design and memory management, Join algorithms, Query optimization, Selinger optimizer, Transactions and locking, Optimistic concurrency control, Distributed transactions, Parallel databases, Scientific databases, NOSQL , ORM, DryadLINQ, Streaming databases, database as a service.

The purpose of this note is to give students about an understanding of what database systems are, why we use them, how to use common database systems efficiently and how database systems work internally. Also teaches about variety of data management tasks and different approaches to them.

The contents include: What is DBMS, The relational data model, Entity-Relationship (E/R)modelling, Relational algebra and relational calculus, SQL, Case Study - Cancer registry for the NHS �challenges, Schema refinement I, Schema refinement II, Schema refinement III and advanced design,On-line Analytical Processing (OLAP), Case Study - Cancer registry for the NHS -Experiences, XML as a data exchange format.

Database is a collection of interrelated data and set of programs can access that system. The contents include: Conceptual Modeling, Relational Approach,Basic Sql Query and Normalization, Transaction Management, Concurrency Control.

Objective of this note is to understand the basic concepts and the applications of database systems, the basics of SQL and construct queries using SQL and explains the relational database design principles.