P1247176259WeAXw

1
The Revolution Has Begun!
Intelligent Business Application Infrastructure
2
Go Creative. Be
Original
3
Why Genero db?

• To better serve our customers
• Better performance
• Tighter Genero integration
• One stop-shopping
• Improves end-user TCO

Page 3
An Alternative Vision Corporate Presentation
8/17/2009
4
Why Genero db?

• Reliability fully automated QA process
• 500 server datacentre
• New code check-ins and QA every hour
• 3,000 hours QA testing per day

Page 4
An Alternative Vision Corporate Presentation
8/17/2009
5
Why Genero db?

• Fastest database
• Lock-free architecture
• Concurrency engine
• Compiled SQL
• Lowest cost
• To buy
• To develop no need for performance partitioning
  ? reduced complexity
• To run increased performance ? server
  consolidation
• To administer ?optimising resources
• Quickest to production
• Reduced training recoding through compatibility
  with leading vendors
• Rapid progressive migrations through
  compatibility with leading vendors

Page 5
An Alternative Vision Corporate Presentation
8/17/2009
6
Why Genero db?

• Revolutionary technology
• Concurrency Engine
• Benefits from atomic architecture of latest
  microprocessors
• Microprocessor threads guarantee scalability
• Compiled SQL execution, main memory optimised

Page 6
An Alternative Vision Corporate Presentation
8/17/2009
7
Why Genero db?

• Revolutionary technology
• Patented lock-free architecture
• ACID database integrity as Informix, Oracle,
  etc...
• Column (field) level locking
• Simultanenous row updates of different columns
• Processes simultaneous updates to the same column
  with commutative arithmetic operations
• Eliminates 99 of all locking scenarios
• Locks only occur in non-deterministic situations
• Multiple users attempt update of same field with
  different values
• Updating 2 fields in same row
• Also SELECT for UPDATE (imposed by application)
• Indexes are lock-free
• Table rows are lock-free
• No conflict between read and write operations

Page 7
An Alternative Vision Corporate Presentation
8/17/2009
8
Why Genero db?

• Up to 15 times faster
• In-memory configuration with automatic dataflow
  to disk
• Lock-free eliminates lock contention
• Preparation by compilation precompiled SQL
• Thread reassignment saves startup overhead

Page 8
An Alternative Vision Corporate Presentation
8/17/2009
9
Why Genero db?
Page 9
An Alternative Vision Corporate Presentation
8/17/2009
10
Doing more with less

• Server Consolidation
• Reduce n of servers
• Reduce network admin and traffic
• Reduce Environmental Costs
• Greater the consolidation, better the return

• Real Database Consolidation
• Enabled by Genero db compatibility
• Significantly less maintenance costs

Page 10
An Alternative Vision Corporate Presentation
8/17/2009
11
Doing more with less

• Optimise resources
• Redeploy critical resources to new strategic
  projects

Page 11
An Alternative Vision Corporate Presentation
8/17/2009
12
Why Genero db?

• Compatibility no need to recode or retrain

Informix and its logo are registered
trademarks of IBM Corp. Oracle and its logo
are regiestered tradmarks of Oracle Corp.
Microsoft SQL Server are registsted trademarks
of Microsoft Corp.
Page 12
An Alternative Vision Corporate Presentation
8/17/2009
13
IBM Informix compatibility

• Genero db 3.61 (Available)
• Stored procedures triggers (SPL)
• Synonyms
• Locking control semantics - SET LOCK mode
• GRANT/REVOKE priviliges
• User authentication with default schema at login
• "DATABASE" notation to transparently convert
  from database to schema name space.
• BEGIN WORK, COMMIT WORK, ROLLBACK WORK
• FILETOCLOB FILETOBLOB
• ANSI outer joins Informix syntax OUTER(tab)
• SUBSTR, LENGTH MATCHES
• Syntax when declaring constrains in DDL
• FLOAT(N), INT8, SMALLFLOAT, BYTE, TEXT, SERIAL
  SERIAL8 types including quering via dbinfo
• TODAY math functions root, pow, trunc
• Comments in curly braces double quoted string
  literals
• WHERE CURRENT OF CURSOR ROWID IN
• Client side cursors selected for update UPDATE
  tab SET (column-list) (value-list)
• Scrollable cursors
• CREATE TEMP TABLE INTO TEMP
  

Page 13
An Alternative Vision Corporate Presentation
8/17/2009
14
IBM Informix compatibility

• Genero db 3.80 (FY07 Q4)
• Client Side SQL Interruption
• DECIMAL data type 15 significant digits
• DATETIME and INTERVAL data type support
• SERIAL(n) column type kept after create table is
  complete
• CREATE FUNCTION support
• MONEY type with precision and scale support
• DEFINE GLOBAL variables in Procedure
• Client memory optimization on multiple statement
  handles
• SELECT ... UNION ... INTO TEMP support
• Error message handling and unique error numbers
• Double quotes as string delimiters support
• ROWID support
• AIX support

IBM, Informix AIX are registered trademarks
of IBM Corp.
15
IBM Informix compatibility

• Eg Major household retail brand
• 15,100 lines of Data Definition Language
• 582 tables
• 771 indices
• 53 triggers
• Only 25 lines changed

Page 15
An Alternative Vision Corporate Presentation
8/17/2009
16
Doing more with less Database Cost Analysis
Years 1 - 5

• All in proposal
• Enterprise perpetual RDBMS license
• RDBMS upgrades support
• Migrate progressively

In Millions of
Page 16
An Alternative Vision Corporate Presentation
8/17/2009
17
Doing more with less

• Return on Investment
• OPEX Down 85
• CAPEX Down 86
• IRR Greater than 100

Page 17
An Alternative Vision Corporate Presentation
8/17/2009
18
Doing more with less

• Return on Investment
• OPEX Down 75
• CAPEX Down 77
• IRR Greater than 100

Page 18
An Alternative Vision Corporate Presentation
19
Architecture

• Networked
• Advanced connection management ? better
  performance
• Handles thousands of concurrent users

• Shared memory inter-process communication
• For co-located clients, faster than networking
• Firewall between application data still
  maintained

• Embedded server
• Genero db server is in-process with app.
• Fastest when there are few connections
• Still a full server others can connect normally
  hot-standby, shared-nothing slave

Concurrency Engine
Page 19
An Alternative Vision Corporate Presentation
8/17/2009
20
Architecture

• Pending Changes Management
• Concurrency conflict
• If changes commutative then no lock
• If hard coded app lock process at least at row
  level and column level when possible
• If lock needed enter into lock table
• If pending change not executable then change
  remains in queue
• Locks removed after commit phase

• Session Phase
• SQL Request Management
• Compile SQL
• Execute SQL
• Create atomic database update queue

Page 20
An Alternative Vision Corporate Presentation
8/17/2009
21
High Availability

• Hot-standby, shared-nothing slave
• Automatic failover of all connections
• Very fast, in seconds
• All committed transactions preserved
• Uncommitted transactions fail application
  replays them and then continues as if nothing
  happened

Page 21
An Alternative Vision Corporate Presentation
8/17/2009
22
High Availability

• Recovery is automatic just restart failed server
• Speed clusters additional replicas
• Real time synchronous with master
• Can be geographically remote for Disaster
  Recovery
• Can be used for reporting, BI, etc.

Page 22
An Alternative Vision Corporate Presentation
8/17/2009
23
Scalability

• Scalability is linear
• Todays limits are locking CPU cache coherency
• Concurrency Engine avoids both problems
• Greatly reduced locking
• Greatly reduced shared data, less cache coherency
  problems
• 103 concurrent connections, 106 users
• Wireless Services 16,000
• 15 million SMS messages/day peak
• Millions of users

Page 23
An Alternative Vision Corporate Presentation
8/17/2009
24
Enterprise Manager

• Monitoring events
• Server status
• Configuration
• DB application performance
• Multiple server monitoring
• Infrequent event probes
• Checkpoint shutdown tasks

Page 24
An Alternative Vision Corporate Presentation
8/17/2009
25
Enterprise Manager Configuration

• Static dynamic
• Import /export
• Auto DSN import

Page 25
An Alternative Vision Corporate Presentation
8/17/2009
26
Enterprise Manager Event logging

• Check errors
• View query plans
• Full text search

Page 26
An Alternative Vision Corporate Presentation
8/17/2009
27
Enterprise Manager Query planning

• Tune SQL queries performance

Page 27
An Alternative Vision Corporate Presentation
8/17/2009
28
Enterprise Manager High Availability

• Configure High Availability replication

Page 28
An Alternative Vision Corporate Presentation
8/17/2009
29
Enterprise Manager Resources

• Table stats space usage
• Server stats usage alerts
• Memory
• Statement rates
• CPU

Page 29
An Alternative Vision Corporate Presentation
8/17/2009
30
Enterprise Manager Tables

• Number of rows
• Space allocated
• Pages allocated
• In-memory pages

Page 30
An Alternative Vision Corporate Presentation
8/17/2009
31
Enterprise Manager Schemas

• View, create, modify, drop schema objects
• Tables
• Views
• Triggers
• Synonyms
• Constants
• Constraints
• Access user roles privileges

Page 31
An Alternative Vision Corporate Presentation
8/17/2009
32
Enterprise Manager Stored procedures

• Create stored procedures
• Edit, modify, search replace SQL tool
• Export SQLquery as XML, HTML etc

Page 32
An Alternative Vision Corporate Presentation
8/17/2009
33
Enterprise Manager SQLquery

• Enter simple or advanced queries
• Syntax highlighting
• Auto-completion
• View multiple query results
• Navigate through query history

34
Enterprise Manager SQLquery

• List session query history
• Modify execute from list

35
Enterprise Manager SQLquery

• Open multiple windows
• Save modify existing queries

36
Performance tuning

• Client-side and Server-side tools
• Client tool
• Allows selective tracing performance
  characterization of queries
• Server tool
• Shows operation counts, timings, query plans
  even within stored procedures
• Find most expensive queries/procedures and tune
• Add indexes as needed
• Hints available if necessary to change query
  plans
• All while server continues to run, with minimal
  impact

Page 36
An Alternative Vision Corporate Presentation
8/17/2009
37
Blobs clobs

• A prefix of each blob/clob is inline
• Any operation (even indexing) supported on inline
  portion
• Efficient storage using a tree structure as a
  page map

Page 37
An Alternative Vision Corporate Presentation
8/17/2009
38
Next steps

• Let us prove to you it works
• Proof of conversion
• Provide schemas
• Sample data
• SQL to test against sample data
• How long does it take?
• 2 4 weeks
• How much does it cost?
• CPU, user licenses
• Competitive upgrade pricing

Page 38
An Alternative Vision Corporate Presentation
8/17/2009
39
QA
Intelligent Business Application Infrastructure
40
Thank You!
Intelligent Business Application Infrastructure