Ingres r3 - SCO.com

egyptiannorweiganInternet και Εφαρμογές Web

31 Οκτ 2013 (πριν από 3 χρόνια και 7 μήνες)

78 εμφανίσεις

Ingres
®
r3

SCO Forum

August 8
th
, 2005

Scalability

Flexibility

Robust

Enterprise

Mature
Proven

Relational

database

Management

Full 24/7 Support

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

Agenda


History


Competitive Positioning


Ingres Features


Support Options


Getting (and getting to)
Ingres

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

SQL, Views, Indexes,

Triggers, Groups, Roles,

Unions, Subqueries, Stored

Procedures, Semantic Query

Optimizer, ABF, VISION

6

‘72

‘73

‘74

‘75

‘76

‘77

‘78

‘79

‘80

‘81

‘82

‘83

‘84

‘85

‘86

‘87

‘88

Roots of Success

Origins at UC
-
Berkeley

First freely available

open source

relational database

management system.

R&D

Development of the

“University Ingres”

Community

1
-
3

Commercialized and

became the most robust

RDBMS available.

100% of the DEC/VMS

marketplace.

4
-
5

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

‘89

‘90

‘91

‘92

‘93

‘94

‘95

‘96

‘97

‘98

‘99

‘00

‘01

‘02

‘03

‘04

‘05

The “Open” Technology “Advantage”

Backup & Recovery, Multi
-
location

Sorts, In
-
Memory Temporary Tables,

DMF Cache Locking, Portable Logging

and Locking System, Dual Logging,

Multi
-
Threaded Recovery Server, Visual

DBA 1.0, Replication, Tuxedo Support…

1.0

Row Producing Procedures, Auditdb,

Copydb, Raw Locations, GatherWrite

Threads, XML, MTS Support, Concurrent

Rollback, 64
-
Bit Operating Systems, Linux

O/S Threads, ODBC, JDBC, Hash Joins

Opt. Support, Composite Histograms…

2.6

Row Level Locking, Distributed Multi
-

Cache Management, Variable Page Size,


Alter Table, Async I/O, Parallel Backup &

Restore, Fast Load, R
-
tree, Spatial, ICE,


O/S Threads, Federation, Protocol Bridge,

Data
-
Stream Compression, OpenAPI…

2.0

Ingres

Ingres

Ingres

Ingres

Ingres

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

Ingres r3


Commercial Open Source

‘02

‘03

‘04

’05

‘06

‘07

‘08

‘09

‘10

‘11

‘12

‘13

‘14

‘15

‘16

‘17

‘18

r3

Parallel query, Key range table partitioning, Online modify,
Ingres Grid Option for Linux, Ingres High Availability Option,
Unextenddb utility, Automatic sequence number generation,
No wait for lock requests, Support for new data types, Visual
Database Object Differences Analyzer, Visual Configuration
Differences Analyzer, Export Assistant, Support for JDBC 3.0
API, Data Access Server, JDBC Driver, Updateable result sets
in JDBC, .NET Data Provider and Visual Studio .NET
integration, Ingres ODBC Administrator, WinSock 2.2 API
TCP/IP protocol driver for Windows, ODBC Call
-
level
Interface, RPM packaging for Linux, KDE/GNOME desktop
integration, Linux and OpenVMS cluster support …

Ingres


A Bright Future!

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

Ingres
®

r3

MySQL 4.1

Oracle 10g

SQL Server

2000

Feature Summary

Prsnl

Prof.

One

Std

Ent.

Free download for development or production







MSDE

Unicode Data Types











Stored Procedures, Triggers, & Views











Peer
-
to
-
Peer Replication



opt

opt

opt

opt

Federated Database



opt

opt

opt

opt

Transaction Integrity











On Line Table and Index Reorganization











Parallel Backup & Restore





Grid
-

Parallel Cluster Support





潰o

Key Range Table Partitioning









Parallel Query Execution





Installs in Under 5 minutes







Support for JDBC, ODBC and .Net Drivers















C2 Secure RDBMS







XML Support











Program language pre
-
compilers











Commercial Strength in an Open Source Solution

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

CA Trusted Open Source License


BSD style, OSI approved open source license

-
CA retains ownership, gives up copyright protection

-
Does not have to be carried into derivative work


Includes source, object code & docs


Contributors retain IP ownership

of their contributions

-
Must grant a perpetual use license


Indemnification provided with

support contract

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

Ingres r3 Feature Overview

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

The Perfect Embedded Database


Installs in a matter of minutes


Customizable install techniques

-
Response file used to pass install parameters

-
Utilities to modify Ingres configuration parameters


APIs to programmatically aid in installation

-
How much space will my Ingres install take?

-
Is a particular Ingres instance up and running?

-
Retrieve / replace Ingres configuration values


Silent install functionality

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

Enterprise Solution


Database rules, procedures and events (triggers)


Views, including distributed views incorporating other
data sources


Flexible locking
-

row, page and table level


User defined data types and functions


Value based table partitioning


Parallel query execution


Advanced query optimization


Secure (users, groups, roles,

C2 certified)


Much more…

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

International DBMS


Complete Unicode solution

-
Native Unicode types

-
Coercion between Unicode and non
-
Unicode types

-
Case
-
insensitive collation for Unicode data columns


Certified & translated to

French, German, Spanish,

Italian, Brazilian Portuguese,

Japanese & Simplified Chinese


Supports both single
-
byte and

double
-
byte in one distribution

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

Ingres Connectivity


Supports latest ODBC and JDBC standards
including support for the following J2EE
application servers:

-
JBoss

-
WebSphere

-
WebLogic


Native .Net data provider


Python, Perl and PHP drivers

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.


Provides Federated Database Support

-
Distributed access, storage, and processing


Supports two
-
phase commit for distributed
transactions


Provides transparent,

simultaneous access

across multiple nodes,

hardware platforms,

and database

technologies

Federation through Ingres Star

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

Ingres Replicator


Integrated into the DBMS Server


Maintains a copy of source data at one or more
targets


Real time solution


Replication granularity:

-
Entire Database

-
Table/Column Subset

-
Horizontally partitioned

data


© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

High Availability


Failover cluster support (Windows, UNIX)


Active/active cluster support (Linux) *

-
Shared storage architecture

-
Built upon open source technology

-
Class node affinity (CNA)


On
-
line checkpoints in

cluster environments *


On
-
line table and index

reorganization *

* = to be included in the Ingres r3 3.0.2 2.6 Linux kernel release

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

Ingres Cluster Support

Internet

Or

Intranet

Linux

Clients

Windows

Clients

UNIX

Clients

Clients

MAC

Clients

Database

Connectivity

Over LAN

or WAN

Servers

Web Servers

Application
Servers

Nodes can be added, removed or replaced as
needed without impacting any applications

Ingres Database Cluster

SAN

Fiber Switch

Transaction Log

Database Files

Journal Files

Checkpoint Files

Ingres
-
1

Ingres
-
2

Ingres
-
3

Ingres
-
4

Ingres
-
5

Ingres
-
6

Ingres
-
7

Ingres
-
N

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

Flexible Database Administration


Command line tools for automation of DBA tasks


Rich GUI database administration toolset

-
Visual DBA

-
Log analyzer

-
Import/export

wizards

-
Schema

comparison

tools

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

World Class Support

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

Ingres r3 Support Options


Community support

-
Forums

-
eMail distribution lists

-
News Groups


FastTrack Developer

Support


Enterprise Support


Premium Support


ISV/VAR Technical Support

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

Features Provided

FastTrack
Assistance

Enterprise
Support

Premium
Support
Services

CA Technical Support Access

8 x 5

24 x 7 (Sev. 1)

24 x 7 (Sev. 1)

Number of Incidents Allowed

Unlimited



Unlimited



Unlimited

Indemnification for Term of Support Contract











Pre
-
production Support for Application Development and
Database Tuning








Access to CA tested Product Patches and Service Packs





Unlimited Production Users per Mission
-
Critical Environment
(i.e., Production System Support)





Telephone Support







Custom SLA



Quarterly On
-
Site Meetings to Assist in Planning and Meeting
Upcoming Business Goals



Dedicated Single Point of Access to All Ingres Related CA
Teams



Trend Analysis of Issues Logged



Ingres r3 Support Options

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

Where Can I Get It?

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

Ingres r3 GA Release for OpenServer


Ingres r3 released as Generally Available for

SCO OpenServer 6 and UnixWare 7 on 6/15/2005


Available for
download now at
opensource.ca.com!

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.


Linux

-
X86

-
AMD64 & Itanium

-
S/390


Microsoft Windows

-
X86

-
AMD64 & Itanium


Sun Solaris

-
SPARC and AMD64


IBM AIX


HP
-
UX


HP Tru64


HP OpenVMS

-
Alpha & Itanium


UnixWare


OpenServer


Mac OS X

Platform Support

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

Getting to Ingres: The Million Dollar Challenge


CA sponsored

open source

tools competition


Prizes awarded

to three teams


Solutions for

migrating to

Ingres from

Oracle, SQL

Server & MySQL

© 2005 Computer Associates International, Inc. (CA). All trademarks, trade names, services marks and logos referenced herein
bel
ong to their respective companies.

SELECT

question

FROM

audience a, attitude t

WHERE

a.participant = t.participant

AND

t.attitude = ‘curious’