Login Register Actian.com  

Actian Community Wiki

Navigation
Learn About
Developing With
Ingres Talk
Information
Toolbox

Workshops

From Ingres Community Wiki

Jump to: navigation, search



Ingres Workshops

Find out how to use ingres, with our series of simple easy-to-follow workshops. Each workshop contains step-by-step guides, with sample screenshots and explanatory text.
Follow the workshops in a series and soon you will be able to download, install, connect, build databases and load your data.
Other workshops explain more advanced concepts (backup and restore), connectivity, OpenROAD.

Installation Workshops

Install Ingres Server

Ingres can be installed on a variety of operating systems. The server can be installed using GUI or character-based tools:
GUI Installers

Character-Based Installers

Install Ingres VectorWise
Ingres SUSE Studio Appliance
Install Ingres Client

The Ingres server can handle connections from proprietary Ingres clients and also from 3rd party clients:


Ingres VectorWise Workshops

Ingres VectorWise is the next generation of analytic database technology. Ingres VectorWise unlocks the power of modern commodity CPUs with a revolutionary database engine that uses vector-based processing and on-chip memory to provide dramatic performance gains over other databases.
More technical articles are available from our Knowledge Base.
Ingres VectorWise is available from pre-built Ingres VectorWise Amazon EC2 Images.
Ingres VectorWise can also be manually installed. Step-by-step workshops are listed below.

Install Ingres VectorWise


Create an Ingres VectorWise Database


Loading Data Into Ingres VectorWise
Ingres VectorWise Tools and Utilities


Benchmarking Ingres VectorWise


Ingres VectorWise BI Tools


Creation Workshops

An ingres instance can contain many Ingres databases. There are several methods of creating a new database.

Create an Ingres Database



Create an Ingres VectorWise Database


Create an Ingres Table

Import Data Into Ingres

GUI Ingres Import Assistant
SQL copy Command


Connectivity Workshops

Connect Ingres or non-Ingres clients to local or remote Ingres databases - Ingres Connectivity slideshow

Connect Client to Ingres Server Using Ingres Net

Create an ODBC Connection to an Ingres Database

Connect Client to Ingres Server using JDBC



Ingres Query Execution Plans

Ingres has a cost-based optimizer which analyses a query and calculates the most efficient Query Execution Plan(QEP).
The workshops in this section provide a step-by-step guide to illustrate some typical QEPs, and to aid understanding of how to improve the performance of a query without having to alter the query.


Users and Groups Workshops

Users

Ingres Users can be added, using a variety of tools. Ingres Users can then be assigned different permissions and capabilities.

Ingres provides the ability to create Groups, and assign Users to Groups. Groups can be assigned permissions to database objects, which is easier and more maintainable than assigning the same permission to multiple Users.

Groups

Users and Groups


Locations Workshops

Create Data Location

Ingres supports multiple Data locations, ensuring that your database is easily scalable.

Using Data Locations

A new Ingres Data Location can be added to an existing database and it can also be used as the default for a new database.

Extend an Existing Database
Creating New Database With Alternative Location

Using Database Locations in Tables

Moving An Existing Table to Different Locations
Creating A New Table With Different Locations


Ingres Database Backup and Restore Workshops

Backup Ingres Database

An Ingres database can be backed up online or offline. A database backup can be static or dynamic.
The backup can be performed by GUI tools (eg Visual DBA) and operating system commands.

Unloading and Reloading Ingres Database

An Ingres database can be unloaded and reloaded. The intermediate files generated contain the DDL statements for the database objects.

Audit an Ingres Database

Data changes in an Ingres database can be audited by examining the Ingres Journals. Journals can be examined on a live database; flags are available to specify date ranges, table lists, user names etc
There are various tools which allow the Journals to be examined.

Restore Ingres Database

An Ingres database can be recovered using GUI tools (eg Visual DBA, Ingres Journal Analyzer) and operating system commands.
The database restoration can be performed against a static backup.

Dynamically Restore Ingres Database Using Journals

An Ingres database can be dynamically restored to a point-in-time if the database backup was journalled.


OpenROAD Workshops

OpenROAD Install
OpenROAD Development Workshops


Ingres System Administration Workshops


Ingres Database Workbench Workshops

Installing IDW
IDW Management Tools


Database Procedure Workshops

Ingres can store procedures within a database. These "Database Procedures" can be executed from a calling application or script, or from the Ingres Terminal Monitor using SQL.
Database Procedures can also be invoked from an Ingres Database Rule. The database rule is triggered from a SQL DML statement (eg Insert, Update, Delete) and it can be triggered before or after the SQL statement.
This set of workshops demonstrate how to create database procedures and how to handle existing procedure code.


SQL Workshops

This section demonstrates Ingres SQL tips and tricks.


Ingres Solutions Workshops


Retrieved from "http://community.actian.com/wiki/Workshops"
Personal tools
Actian  |  Download Software  |  Enterprise Support  |  Contact Us  |  Terms of Use  |  Actian Corporation  |  Top
© 2011 Actian Corporation. All Rights Reserved