PostgreSQL: Introduction and Concepts

EBook Description: POSTGRESQL is the most advanced open source database server. In this chapter, you will learn about databases, open source software, and the history of POSTGRESQL. Three basic office productivity applications exist: word processors, spreadsheets, and databases. Word processors produce text documents critical to any business. Spreadsheets are used for financial calculations and analysis. Databases are used primarily for data storage and retrieval. You can use a word processor or spreadsheet to store small amounts of data. However, with large volumes of data or data that must be retrieved and updated frequently, databases are the best choice. Databases allow orderly data storage, rapid data retrieval, and complex data analysis.

PostgreSQL is one of the most successful open source databases available. It is arguably also the most advanced, with a wide range of features that challenge even many closed-source databases. This book is intended to be a practical guide to PostgreSQL v7.1.x, though most of the book should also apply to earlier and future releases of PostgreSQL. The content is focused on getting you comfortable with PostgreSQL in the most expedient fashion possible. Although we will touch on some academic database subjects, such discussion will be kept brief. Our core focus is to provide the reader with enough of an understanding of PostgreSQL to manage a fully operational PostgreSQL database. Our hope is that by introducing this book to the community we will provide a better understanding of PostgreSQL and its functionality.

Concurrency Control and Recovery in Database Systems

Free database book from Microsoft Research.

Oracle Database 10g

All Release 2 download pages contain Oracle Companion, Client, Clusterware, Gateways, and Application Express standalone downloads

Oracle9i Database

Free Download for all OS

Understanding the New Features of TLD Caching in JSPs

The use of TLD caching speeds performance at application startup and during JSP page translation.

CachedRowSet

This tutorial describes the CachedRowSet, an implementation type of the javax.sql.RowSet, by peering into the concepts, design, and implementation aspects that OTN developers applied to the CachedRowSet Sample Application. OTN developers used OC4J (Oracle Containers for J2EE) with Oracle JDBC to develop the sample application.(Database Tutorial)

JDBC RowSet

This tutorial describes the JDBC RowSet, an implementation type of the javax.sql.RowSet by peering into the concepts, design, and implementation aspects that OTN developers applied to the JDBC RowSet DML sample Application. OTN developers used OC4J (Oracle Containers for J2EE) with Oracle JDBC to develop the sample application.

Web RowSet

This tutorial aims to demystify the concepts behind a new feature in JDBC 3.0, WebRowSet, by peering into the design and implementation aspects that OTN developers applied to the Product Listing Sample Application. OTN developers used OC4J (Oracle Containers for J2EE) with Oracle JDBC to develop the sample application.

Understanding the New Features of Oracle 10g JDBC

This tutorial series is aimed at helping you understand the new features of JDBC 3.0 in relation to the new enhancements that they bring to the Oracle 10g database. Specifically, we will be looking at the following features - Web Rowsets, Connection Cache, and Named Parameters, IEEE datatypes - BINARY_DOUBLE and BINARY_FLOAT, and PL/SQL Index-by Tables. Each of these new features will be dealt in relation to the sample applications that OTN developers have built around these new features. In addition to these features, you will also benefit from reading the tutorial series on RowSet Implementations.

OTN XMLNews Application

The Dynamic News is Oracle XML DB based application that manages News Items for a web-site providing static/customized News Service. The News Items are stored in the database. When the user requests for the news page, the HTML for the static/customized news page is generated and returned to the user.

• Free IAS eBooks
• Free GRE eBooks
• Free MBA eBooks
• Free GATE eBooks