Use this space for computations. Part I Answer all 28 questions in ...

Use this space for computations. Part I Answer all 28 questions in ...

-

Documents
108 pages
Lire
Le téléchargement nécessite un accès à la bibliothèque YouScribe
Tout savoir sur nos offres

Description

  • exposé
  • expression écrite
Geometry – January '11 [2] Use this space for computations. Part I Answer all 28 questions in this part. Each correct answer will receive 2 credits. No partial credit will be allowed. For each question, write on the separate answer sheet the numeral preceding the word or expression that best completes the statement or answers the question. [56] 1 In the diagram below, _ AB, _ BC, and _ AC are tangents to circle O at points F, E, and D, respectively, AF = 6, CD = 5, and BE = 4.
  • order of the sides
  • pair of angles
  • sides of a right triangle
  • triangle
  • abc
  • separate answer sheet
  • equation
  • point

Sujets

Informations

Publié par
Nombre de visites sur la page 34
Langue English
Signaler un problème


INGRES NEW
FEATURES

What’s New in Ingres
Since
Release 6.4
(up to Ingres 2006 / 9.x)













Presented by

Comprehensive Solutions
4040 N. Calhoun Road
Suite 105
Brookfield, WI 53005
(262) 544-9954


Table of Contents
Section Topic Slides Tab
Course Contents ............................................................................. Intro.1-4...................................... 1
• The history of Ingres

Section 1 - Architecture ................................................................S01.1-24 2
• High Availability and Clustering
• Connectivity Enhancements
• Complex Query Optimisation
• 64-Bit Support
• POSIX Threading Support

Section 2 – Configuration & Maintenance.................................S02.1-39...................................... 3
• GUI Tools
• Checkpoint Management
• Locations
• Database Maintenance

Section 3 - Databases ...................................................................S03.1-74...................................... 4
• New Data Types
• Larger Page Sizes
• Increased Limits
• Value Based Table Partitioning
• Parallel Query Execution
• Unicode
• Sequences
• Locking & Isolation Levels
• Constraints
• XML

Section 4 - SQL...............................................................................S04.1-69...................................... 5
• SQL Enhancements
• New Join Syntax
• Session Temporary Tables
• Rules and Procedures
• Lock waits
• Bulk Loading
• Copydb/unloaddb Enhancements
• Date datatype Enhancements
Ingres New Features
What is new in Ingres since release 6.4
www.Comp-Soln.comIntro.1
© 2006 Comprehensive Consulting Solutions, Inc.All rights reserved.
Course Content
• Architecture & Configuration
• Configuration & Maintenance
• Databases
• SQL
www.Comp-Soln.comIntro.2
© 2006 Comprehensive Consulting Solutions, Inc.All rights reserved.
1A little bit of History
• Ingres has had a varied history
• Many (many) versions
• Many owners
• It is the original RDBMS and originally Open Source!!
• Sybase developed from Ingres code line
• Microsoft SQL Server developed from Sybase
• Bits in Oracle!?
www.Comp-Soln.comIntro.3
© 2006 Comprehensive Consulting Solutions, Inc.All rights reserved.
Ingres Timeline
www.Comp-Soln.comIntro.4
© 2006 Comprehensive Consulting Solutions, Inc.All rights reserved.
2Section 1 – Architecture
In This Section
• High Availability and Clustering
• Connectivity Enhancements
• 64-Bit Support
• POSIX Threading Support
• Complex Query Optimisation
• Log Files
www.Comp-Soln.comS01.1
© 2006-2008 Comprehensive Consulting Solutions, Inc.All rights reserved.
Ingres Architecture
Ingres ODBC Java/.Net
Application Application Application
Ingres Net
Lan/Wan
Server based Ingres Net
Application
Name Server
Database cache DMFDBMS Server
Locking Log Buffers databases
Archiver Tx Log File Recovery ServerJournals
www.Comp-Soln.comS01.2
© 2006-2008 Comprehensive Consulting Solutions, Inc.All rights reserved.
1High Availability
• Ingres directly supports Active/Passive failover on Solaris and
Linux
• Separately installed option
• All Ingres file systems must be on a shared disk device, such
as a SAN
• Two configuration options
• Single Node
• Ingres attempts restart on the failed node
• Dual Node
• Passive Node attempts restart when active node fails
• Starting and stopping must be done using operating system
interfaces
www.Comp-Soln.comS01.3
© 2006-2008 Comprehensive Consulting Solutions, Inc.All rights reserved.
High Availability
Host 1 Host 2
Active Passive
Heartbeat
Ingres
Auto restart Ingres on Auto start Ingres on
Host 1 if Ingres dies Host 2 if Host 1 dies
SAN
Data Ckp Jnl Dmp Work Log
www.Comp-Soln.comS01.4
© 2006-2008 Comprehensive Consulting Solutions, Inc.All rights reserved.
2Clustering
• Active/Active clustering available on OpenVMS for the HP (Dec)
Alpha systems only
• Itanium chip support coming soon
• Built on proprietary technologies with OpenVMS
• Distributed Lock Manager is the key component. This is what allows
multiple systems / Ingres installations to access the same physical
database.
• Overhead is generally high (~20%)
• Can provide very high service levels
www.Comp-Soln.comS01.5
© 2006-2008 Comprehensive Consulting Solutions, Inc.All rights reserved.
Clustering
Host 2
Host 3
Host 1
Ingres
Ingres
Ingres
Jnl Dmp Log SAN Jnl Dmp Log
Jnl Dmp Log
Data Ckp Work
Host n
Jnl JnlDmp Log Dmp Log Host 4
Ingres
Ingres
www.Comp-Soln.comS01.6
© 2006-2008 Comprehensive Consulting Solutions, Inc.All rights reserved.
3Clustering
• Transparent to applications
• Individual nodes can be stopped and started
• Databases can be tied to specific nodes
• Class Node Affinity
• Row level locking not supported
• Star and Replicator not supported
• On-line checkpoints permitted
• Separate recovery system for each node
• Log file, Dump files, Journal files
• Log files accessible by all nodes
www.Comp-Soln.comS01.7
© 2006-2008 Comprehensive Consulting Solutions, Inc.All rights reserved.
Connectivity
• Ingres/Net is the basic client server mechanism available since
release 6
• Ingres/Net handles data conversion between heterogeneous
environments and different Ingres versions.
• Communication over a variety of network protocols.
• TCP/IP
• SNA
• DecNET
• and many more
• Ingres/Net generally provides backward compatibility
• Primary exception is new datatypes not supported in the older release
www.Comp-Soln.comS01.8
© 2006-2008 Comprehensive Consulting Solutions, Inc.All rights reserved.
4Connectivity
• Ingres now supports database access via
• ODBC
• JDBC
• .Net
• Bridge Servers
• Python DBI 2.0
• PHP 5.1
• Ingres/Net enhanced with better security
• Available on all Ingres supported platforms
• New Data Access Server for .Net
www.Comp-Soln.comS01.9
© 2006-2008 Comprehensive Consulting Solutions, Inc.All rights reserved.
Ingres Net Architecture
ODBC Java .Net
JavaApplication Application Application
Ingres Application
Application
.NET Data ODBC Driver JDBC Driver
providers
Net Server DAS JDBC Driver
Lan/Wan
Net Server JDBC Server
DBMS Server
www.Comp-Soln.comS01.10
© 2006-2008 Comprehensive Consulting Solutions, Inc.All rights reserved.
5Connectivity - ODBC
rd• ODBC connectivity available without 3 party software
• Provides access to
• Ingres
• Enterprise Access
• EDBC databases
• Connectivity provided by underlying Ingres/Net configuration
• Simple set up
• Install ODBC option
• Configure Vnode in Ingres-Net
• Vnode appears as Data Source in ODBC configuration
• Numerous performance improvements over the past decade
www.Comp-Soln.comS01.11
© 2006-2008 Comprehensive Consulting Solutions, Inc.All rights reserved.
Connectivity - ODBC
• ODBC Features
• Optionally determines driver characteristics from ODBC configuration
files
• Loads and unloads the ODBC driver into and from application memory
• Maps the driver manager API to the driver API
• Performs basic error checking
• Provides thread safety
• Provides ODBC tracing
• Provides function templates, type definitions, and constant definitions
for ODBC applications
• Driver can be configured as READ ONLY
www.Comp-Soln.comS01.12
© 2006-2008 Comprehensive Consulting Solutions, Inc.All rights reserved.
6