SQLBase 11 Concurrency Performance Boost
Team Developer 5.1 Partner Summit
Quickly React on Business Process Changes
using NXJ Developer
Unify/GUPTA Development Innovation Award
Mark your calendars for the Worldwide DevCons 2007
Nordic Developers Day in Stockholm/Sweden:
October 11, 2007
Central European Developers Conference in Munich/Germany:
October 15-17, 2007
Southern Developers Day in Paris/France:
October 19, 2007
Americas Developers Conference in Sacramento, California/USA:
November 6-8, 2007
Newsletter Resources
Team Developer 5.1 and Team Developer Roadmap
New combined Unify and GUPTA website
Team Developer 4.2 and Windows Vista
Download DBMoto SQLBase Replication
SQLBase 11 Concurrency Performance Boost
Many more concurrent users can use SQLBase 11 at the same time. SQLBase 11 introduces
new ways of handling transactions for reading (reporting) and for writing
(update/delete/insert) to dramatically improve user concurrency.
For writing transactions we introduce a new isolation level Read Committed (RC).
This new isolation level is also known as page versioning where writing
transactions do not lock reading transactions in the Read Only and Read
Committed isolation levels. Instead of running into a lock, a select reads an
in memory (before update value) copy of the page that is in the process of
being updated and does not have to wait for a lock to be released before it
can continue. Reporting applications should benefit hugely from this new
isolation level specifically when reports are being run against a
production database that is constantly being updated during the reporting process.
|
The Read Only isolation level of SQLBase 11 has been completely re-designed and implemented to eliminate the bottle necks, locks and performance degradations of the previous releases of SQLBase. This new Read Only isolation level will NEVER obtain locks on indexes or tables. This is particularly important for applications that rely heavily on reporting or for reporting only activities. Now these types of activities can be accomplished without performance or locking impact to the operation of the database. |
SQLBase 11 TPC-C Benchmark: Write-access transactions up to 2.6 times faster, reports up to 7 times faster!
The industry standard TPC-C benchmark test simulates a complete environment where a population of terminal operators executes transactions against a database. These transactions include entering and delivering orders, recording payments, checking the status of orders, and monitoring the level of stock at the warehouses (updates, inserts while running reports).
|
SQLBase 11 performs much better in TPC-C
transaction and reporting than SQLBase 9.0.1. All numbers are in transactions per
minute. Enabling the SQLBase 11 Read Only isolation level results in hugely increased transaction throughput from 75 tpm in SQLBase 9.0.1 (RL mode) to 199 tpm in SQLBase 11 which is a whopping 2.6 times improvement over SQLBase 9.0.1. |
|
Reports running on the TPC-C database increase from 209 tpm in SQLBase 9.0.1 (RL) to 1452 tpm in SQLBase 11 using Read Only isolation level. This is an almost 7 times performance increase for reporting solutions in SQLBase 11. |
Other Concurrency Enhancements
New locking mechanisms and functionality have been added to SQLBase 11. The intention of the new locking functionality is to improve concurrency and throughput by reducing or eliminating lock contention including non-application deadlocks. This functionality includes “LOCK TABLE” and “SET AUTOLOCKTABLE” statements that can be prepared and executed as well as configuration settings in the sql.ini file. With AutoLockTable set to SMART non-application deadlocks will be eliminated.
More new Features and Benefits in SQLBase 11
- SQLBase 11 features new Auto-Increment columns to allow for automatic unique key generation.
- Databases greater than 2 gigabytes can be backed up without segmentation.
- The SQLBase 11 JDBC driver has been updated to support the JDK 1.4.1 as well as significant performance and functionality improvements.
- Very easy deployment through automatic upgrade for SQLBase 7.5.1-9.0.1 databases upon first connect.
Team Developer 5.1 Partner Summit
A select number of Unify partners were recently invited to the Unify headquarters in Sacramento,
California to preview the upcoming Team Developer 5.1 release. The partners had a chance to look
at the current status of the product and provide feedback on the new release. Everybody was convinced
that Team Developer 5.1 will be a fantastic new release because it allows users to modernize the User
Interface of existing applications with very little effort and brings much-needed features like
improved ActiveX and Web services consumption to Team Developer programmers. All in all, the group was
ecstatic about what they saw and cannot wait to get the product in their own hands.
Take a look at the new GUI features of Team Developer 5.1, click on the image to see more.
Quickly React on Business Process Changes using NXJ Developer
Cohesia helps large precision-centric manufacturers boost supply chain productivity by managing characteristic
identification and precision compliance with First Article Specification requirements. To maintain its leadership
role, Cohesia wanted to ensure its customers could easily integrate with strategic IT platforms including ERP,
CRM and PLM manufacturing execution systems.
Cohesia performed a comprehensive evaluation of potential providers. The company was looking for a vendor that could meet the technical requirements of today and provide a comprehensive development environment for ongoing product enhancements. Their long-time ISV partner, Unify, proved to be the superior choice. With a close working relationship, Unify helped Cohesia complete the application modernization project in just five months.
Cohesia CEO, Jim Kanir, made modernizing the Cohesia product a top company priority and tagged rapid
time-to-market as one of the project’s goals. “Our customers are continually implementing new process
changes to achieve regulatory compliance. Using NXJ Developer, we were able to quickly respond to customer
demands for changes in business processes. And, we can now provide customers with the flexibility to modify
the application to meet best practices with their organization.”
NXJ Developer enables ISV partners to make the transition to SOA through a combination of intuitive visual
design, flexible SOA programming, and ease of integration with both Java code and .Net business logic via
Web services. Because of its ease of use, developers are highly productive and able to deliver applications
in 80 percent less time with NXJ Developer compared to market alternatives. By modernizing applications,
ISVs achieve rapid time-to-market and a competitive edge in delivering their solutions on the latest,
standards-based technologies such as Web services and Web 2.0, while adhering to an SOA environment.
More about NXJ Developer on the Unify Website.
Unify/GUPTA Development Innovation Award
What is the Unify/GUPTA Development Innovation Award?
Unify/GUPTA is proud to introduce the Development Innovation Awards. The Development Innovation Awards
recognizes technological achievements that showcase both creative thinking and determined problem solving.
We will honour individuals and companies who have forged new ground and used Unify/GUPTA solutions in inspiring ways.
Award Categories
Unify/GUPTA Development Innovation Awards will be presented for each of the following categories.
- Team Developer User Interface: The application with the freshest and most up-to-date look.
- Best Web Application: Most intuitive to use and artistic Web application.
- Most Innovative Application: Most advanced technology and integration.
- Most increased Return of Investment: an innovative approach to drive out cost and achieve measurable ROI as a result of implementing a Unify/GUPTA solution. Results could include financial return or percentage increase in productivity, yield, efficiency, quality or performance.
- Creativity: What new or innovative ways were you able to use Unify/GUPTA technology?
-
Impact:
- How were existing processes improved or new processes successfully implemented by the project?
- How many and what latest technology was used and implemented?
- What technology challenges needed to be overcome to achieve this goal?
- What can the business do today with the Unify/GUPTA technology that it couldn't do before?
- Was there a measurable return on investment (ROI) and increase in competitive advantage generated by the project?
- Presentation: Was the submission articulate and concise?
- Submissions are open to all Unify/GUPTA partners and the development community worldwide.
- Solutions must be live or in production.
- You may submit as many Unify/GUPTA applications for consideration as you'd like.
- Each application must be submitted as a separate nomination.
Step 1
Submit your project for the Unify/GUPTA Development Innovation Awards (Deadline September 14, 2007) to award@unify.com
Step 2
Submissions are judged by a panel of judges and a winner selected in each category.
Step 3
The Unify/GUPTA Development Innovation Awards winners will be announced at the Unify/GUPTA Developers Conferences.
What are the benefits of being named a Unify/GUPTA Development Innovation Award winner?
As a Unify/GUPTA Development Innovation Award winner, you'll receive (one winner awarded in each category):
- One complimentary admission to the Central European Developers Conference in Munich. Includes two days of conference (without hotel). (If you've already purchased your conference registration, we'll reimburse you, should you win.)
- Innovation Award presentation with a profile of your company and solution at the Developers Conference
- Opportunity to highlight you and your team’s accomplishments
- A press release from Unify/GUPTA
- Promotion on the Unify/GUPTA website
- An award to showcase at your business site
If you have questions, please feel free to contact: ines.piech@unify.com.
© Unify Corporation.
Unify recently acquired Gupta Technologies, click here to read more.
GUPTA®, Team Developer®, and SQLBase® are trademarks or registered trademarks of Unify Corporation in the United States, other countries, or both. All rights reserved.
Linux® is a registered trademark of Linus Torvalds. Microsoft®, Windows®, and SQLWindows® are registered trademarks of Microsoft Corporation. Unicode® is a registered trademark of Unicode, Inc. InfoWorld® is a registered trademark of International Data Group, Inc. LinuxWorld© is a registered trademark of IDG. All other names and trademarks are the property of their respective owners.
Newsletter Feedback
Email your
comments to the editors.
Newsletter Sign-Up
If you received this newsletter from a friend and would like to receive your
own copy by email each quarter,
sign up here.
Your subscription
You received this monthly newsletter because you indicated an interest in
receiving information when you downloaded files from our Web site. If you find
the newsletter useful, please tell a friend or colleague about it. Anyone can
sign up for a free subscription.