SQLBase 11'5

1
SQLBase 11.5

• Features and Benefits

2
Agenda

• Introduction
• SQLBase 11.5 SMP Performance
• New SQLBase Command Center
• Worldwide Database Deployment
• Performance and Scalability
• Easy Upgrade

3
You Told Us What You Want! We Listened

• Improve scalability
• General performance improvements
• Easy Unicode
• Easy database maintenance
• Longer passwords
• Latest OS support (Windows Server 2008, Vista)

4
SQLBase 11.5 SMP Performance

• Higher Performance and Higher Scalability
• Support for multicore and multiprocessor systems
• Read and write processes are multithreaded

5
SQLBase 11.5 SMP Cache Management

• High Performance SMP Cache Manager
• Leverage 1 GB of cache to drastically reduce hard
  disk access
• Fine tune cache manager for optimum performance

6
SQLBase 11.5 SMP Performance Gains

• TPC/C read performance increase of up to 34 on a
  quad core
• TPC/C write performance increase of up to 25
• Plus huge scalability effects
• Totally transparent for users and applications
• Just install SQLBase 11.5 on a SMP capable
  machine and immediately take advantage of it

7
SQLBase Command Center Benefits

• Very easy to use access to all database
  maintenance tasks
• Very nice GUI
• Automate recurring database tasks
• Integrates all previous maintenance tools in one
  application
• SQLConsole
• SQLTalk
• Connectivity Admin

8
Database Object Editor

• Edit all database objects
• Database Level
• Table Level
• User Level
• Stored Procedures

9
Change Script

• Automatic Flight Recorder
• Creates SQL script of all changes to database
  objects
• Save script to disk
• Apply script to deployed installations

10
Stored Procedure Editor

• Color coded editor
• Full testing capabilities
• Editor jumps to error position
• Creates SQL script for further usage

11
SQLBase Command Center Database Maintenance

• Granular Check database with visual results!
• View Database connections
• Kill database connection
• View active locks
• Create, drop, install, uninstall database
• Unload, load database

12
Visual Check Database Results

• Visual check results per database object

13
SQLTalk in SQLBase Command Center

• New modern SQLTalk
• Color coded editor
• Grid Output
• Execution plan view

14
Connectivity Administrator

• Built into SQLBase Command Center

• View and edit config files (sql.ini)
• Set client connectivity settings
• Set server configuration settings

15
SQLBase Command CenterAutomated Database
Administration

• Schedule tasks
• Backup
• Unload/load
• SQL Script
• Shell script
• Force task to execute now
• Email notifications
• Always
• On Error

16
SQLBase Command Center Task Scheduling

• Daily, Weekly, Monthly
• Define execution period
• Start and end date
• Define execution time
• Define multiple steps per task
• Backup
• Unload
• Update Statistics
• Copy file on OS level

17
SQLBase Command Center Task Logging

• Log entries for all execution steps
• Start date/time
• End date/time
• Success
• Failure, with error description
• Automatic notification emails if configured

18
SQLBase Command Center Summary

• Very Modern SQLBase Command Center GUI
• Database Object Editing
• Change Script
• Stored Procedure Editor
• DB Maintenance Features
• Integrated SQLTalk SQL Scripting
• Connectivity Administration
• Automated Database Maintenance

19
SQLBase 11.5 Application Internationalization

• Globalize your applications and sell/use them
  around the globe
• Mix and match languages as your global users need
  them

20
SQLBase 11.5 Application Internationalization

• Store and retrieve data in any language and
  character set
• Sort data respecting local sort orders

21
SQLBase 11.5 Smart Unicode

• Easy Unicode
• No performance penalties if you do not use
  Unicode
• New nchar and nvarchar column types
• Supports international sort orders
• Collations
• Server level
• Database level
• Session level

22
SQLBase 11.5 Security and Operating Systems

• Increased password security (32 characters)
• Supports Windows Server 2008 and Windows Vista
• Migration utility for migrating SQLBase
  International databases to SQLBase 11.5

23
SQLBase 11 and SQLBase 11.5

• The performance Dream Team
• For Utimate Performance use
• SQLBase Read Committed isolation level
• Introduced in SQLBase 11.0
• SQLBase 11.5 SMP

24
SQLBase Read Committed Performance

• TPC-C transaction throughput 2.6 times faster!
• TPC-C reporting throughput 7 times higher!

25
SQLBase 11.5 Easy Upgrading

• No worries about upgrading your SQLBase user base
• SQLBase 11.5 features automatic upgrade of
  database files upon first connect
• Benefit of SMP performance right out of the box
• Migration utility for upgrading from SQLBase
  International

26
Get your SQLBase 11.5 Upgrade Today!

• Contact your local reseller or contact Unify at
  http//www.unify.com