Oracle Berkeley DB Java Edition
Welcome to the Berkeley DB Java Edition (JE) Collections API. This document provides a tutorial that introduces the collections API. The goal of this document is to provide you with an efficient mechanism with which you can quickly become efficient with this API. As such, this document is intended for Java developers and senior software architects who are looking for transactionally-protected backing of their Java collections. No prior experience with JE technologies is expected or required.
Read more
iBATIS SQL Maps Tutorial
The SQL Maps framework is very tolerant of bad database models and even bad object models. Despite this, it is recommended that you use best practices when designing your database (proper normalization) and your object model. By doing so, you will get good performance and a clean design. The easiest place to start is to analyze what you’re working with. What are your business objects? What are your database tables? How do they relate to each other? For the first example, consider the following simple Person class that conforms to the typical JavaBeans pattern.
Read more
VBScript Database Tutorial Part 1 to 4
Probably the most popular use for ASP scripting is connections to databases. It’s incredibly useful and surprisingly easy to do. The first thing you need is the database, of course. A variety of programs can be used to create it, but probably the most popular is Microsoft Access. You can also use FoxPro or create it directly in an SQL Server using whichever utilities are supplied with the server (Enterprise Manager in the case of Microsoft SQL Server), or native SQL commands.
Read more
SQL Subqueries Counterparts in Tutorial D
SQL uses the term subquery to refer to a table expression (commonly known as a query) that is contained within another table expression. Until 1992, as far as the international standard for SQL is concerned, subqueries were permitted only inside conditional expressions (i.e., truth-valued expressions), and conditional expressions were permitted only inside the WHERE clause, and the HAVING clause. Nowadays subqueries are permitted in the FROM and SELECT clauses too (and truth-valued expressions can appear in the SELECT clause, but we don’t need to look at examples of those here).
Read more
Informix Guide to SQL Tutorial
The Informix Guide to SQL: Tutorial includes instructions for using basic and advanced Structured Query Language (SQL) as well as for designing and managing your database. This manual is part of a series of manuals that discusses the Informix implementation of SQL. Once you finish reading this manual, you can use the Informix Guide to SQL: Reference and the Informix Guide to SQL: Syntax as references to help you with daily SQL issues.
Read more