Flylib.com
Books
Software
Computers & Technology
Home Computing
Business & Culture
Programming
Software
Web Development
Certification
Networking
Security & Encryption
Computer Science
Operating Systems
Microsoft
Hardware
Databases
Graphic Design
Apple
Digital Music
Digital Photography & Video
Games & Strategy Guides
Project Management
Mobile & Wireless Computing
Education & Reference
Encyclopedias
Test Preparation
Studying & Workbooks
Schools & Teaching
Writing, Research & Publishing Guides
Foreign Language Study & Reference
Atlases & Maps
Dictionaries & Thesauruses
Words, Language & Grammar
College & University
Trivia & Fun Facts
Consumer Guides
Business & Investing
Industries & Professions
Management & Leadership
Organizational Behavior
Personal Finance
Small Business & Entrepreneurship
Popular Economics
Marketing & Sales
Finance
Skills
Business Life
Economics
Job Hunting & Careers
Biography & History
Reference
International
Real Estate
Investing
Women & Business
Science & Math
Mathematics
Technology
Reference
Earth Sciences
Physics
Biological Sciences
Behavioral Sciences
Nature & Ecology
Astronomy & Space Science
History & Philosophy
Experiments, Instruments & Measurement
Agricultural Sciences
Category list
Computers & Technology
Software
Databases
Advantage Database Server: The Official Guide - page 1
Buy on amazon.com >>
Jensen C.
,
Anderson L.
<< Previous book
Next page >>
1
2
Table of Contents
Table of Contents
BackCover
Advantage Database Server - The Official Guide
Introduction
Who This Book Is For
Part I: ADS and the Advantage Data Architect
Chapter 1: Introduction to Advantage Database Server
Advantage Database Server Versus Advantage Local Server
Advantage Tools
Building Database Applications Using ADS
Features Added in ADS Version 7
Chapter 2: Creating Tables
ADS Supported Table Types
Creating ADS Tables
Working with Tables
Other Table Support Features
Chapter 3: Defining Indexes
Overview of Index Files
Creating Indexes
Testing Indexes
Indexes and Performance
Full Text Search Indexes
Chapter 4: Understanding and Using Data Dictionaries
Creating a Data Dictionary
Adding Tables to a Data Dictionary
Data Dictionaries and Table Encryption
Implementing Security with Data Dictionaries
Comparing Data Dictionaries
Chapter 5: Defining Constraints and Referential Integrity
Advantages of Constraints
Creating Constraints
Defining Referential Integrity Constraints
Update and Delete Rules
Comments About Constraints and Referential Integrity
Chapter 6: Working with Views
Overview of Views
Creating Editable Views
Views That Use Views
Selecting Record Subsets from Views
Views That Use Other Database Tables
Chapter 7: Creating Advantage Extended Procedures (AEPs)
Overview of Stored Procedures
The Structure of AEPs
Writing AEPs
Using AEPs
Chapter 8: Defining Triggers
Overview of Triggers
Creating Triggers
Example Triggers
Using Triggers
Part II: Using Advantage SQL
Chapter 9: Introduction to Using Advantage SQL
Overview of Advantage SQL Queries
Additional ADS SQL Topics
Advantage SQL Utilities
Chapter 10: Using SQL to Perform Common Database Operations
Creating and Modifying Objects
Selecting Data
Changing Data
Using Transactions
Chapter 11: Using SQL to Access Metadata and Managed Data Dictionaries
System Tables
Dictionary-Related SQL Statements
System Stored Procedures
Part III: Accessing ADS Data
Chapter 12: Using ADS from Delphi
ADS and Delphi
Performing Basic Tasks with ADS and Delphi
Navigational Actions with ADS and Delphi
Administrative Operations with ADS and Delphi
Chapter 13: Using ADS from Java
Performing Basic Tasks with ADS and Java
Navigational Actions with ADS and Java
Administrative Operations with ADS and Java
The Advantage JDBC Driver and JBuilder s DataExpress
Chapter 14: Using ADS from Visual Basic and ADO
MDAC, OLE DB, ADO, and ADS
Performing Basic Tasks with ADS and ADO
Navigational Actions with ADS and ADO
1
2
Buy on amazon.com >>
Jensen C.
,
Anderson L.
<< Previous book
Next page >>