Posted by: Martin Teetz
Please read the attached June Newsletter, featuring great news about
SQLBase 11 due for release this late summer. The SQLBase development
team has achieved great things to highly improve concurrent database
operations. Read more in the attached newsletter.
Director of Worldwide Product Marketing
ï»¿ Unify / GUPTA June 2007 Newsletter
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
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.
A database load with Read Only mode enabled is 300% faster in SQLBase 11 compared to SQLBase 9.0.1.
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. We are planning to release SQLBase 11 in late summer this year.
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.
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. Each application will be reviewed by a panel of judges with one winner selected by the judges for each of the categories. Submissions will be judged based on the following criteria: 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? To be eligible for the Unify/GUPTA Development Innovation Award, you must meet the following criteria: 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. How to apply?
Submit your project for the Unify/GUPTA Development Innovation Awards (Deadline September 14, 2007) to firstname.lastname@example.org
Submissions are judged by a panel of judges and a winner selected in each category.
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 Please submit your solution (screen shots, description of application, number of customers etc.) to: email@example.com.
If you have questions, please feel free to contact: firstname.lastname@example.org.
© 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.
Unify Web Site Unify / GUPTA SalesWebinars
Email your comments to the editors.
If you received this newsletter from a friend and would like to receive your own copy by email each quarter, sign up here.
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.