Database Technology Trends

TAMPA, Fla., October 12, 2009 – Dobler Consulting (http://www.doblerconsulting.com) is pleased to announce a strategic channel partnership with Silos-Connect Technologies, US Distributor for ActiveBase software. Peter Dobler, President and Chairman, is offering the new ActiveBase Tool Suite for the first time to Oracle customers in the United States.

Dobler is working with businesses that need to comply with Sarbanes Oxley, HIPAA, and comprehensive security, by providing systems integration, installation, and training to help businesses establish real-time security enforcement. Dobler says, “The ActiveBase Security Solution portion of the Tool Suite is a break-through security application for current times, when a company’s integrity and standing is of utmost importance. We use our several decades of database experience to ensure companies keep their reputation at the highest level, by ensuring their security is at the highest level.”

Unlike traditional database security solutions, ActiveBase Security uses a unique approach – “Dynamic Data Masking” which gives organizations the ability to determine who sees data in its original state, or who views it in masked or encrypted form. ActiveBase uses an innovative approach to help lower costs for security measures, by using ActiveBase’s rules, instead of changes to software applications, or to Oracle databases.

Dobler installs ActiveBase for his clients, integrates the product with other systems, and concentrates on teaching security personnel how to apply and enforce application security policies, and prevent performance degradation. Dobler maximizes this cutting edge technology by showing clients how to comply with real-time security requirements, how to save money by avoiding security breaches, and prevent leakage of sensitive information. His company advises clients about using ActiveBase’s rule technology to mask, scramble, or encrypt SQL requests for personal data.

According to The Society for Information Management, CIO’s say that one of their top 10 priorities for 2010 is preventing security breaches to avoid affecting both their organization’s bottom line, or their company’s brand. See CIO Insight’s web site, (www.cioinsight.com or http://tiny.cc/5HmBz) for more information about CIO’s concerns. Dobler’s mission is to save money for clients, by improving their bottom line with the ActiveBase Security Solution, and his services.

For more information about the company and how they work with ActiveBase, contact Peter Dobler or visit: http://www.doblerconsulting.com
 

About Dobler Consulting

Dobler Consulting is a leading information technology and database services company that offers cutting edge technology and integration for their clients. Founded in 2000, the Tampa consulting firm delivers implementation expertise for Oracle, Sybase, and MS SQL Server. Dobler Consulting has over 20 years of proven experience, working with their clients to improve database efficiencies and reduce costs. See http://www.doblerconsulting.com  for more information.

About Silos-Connect Technologies

Silos-Connect Technologies, based in Metro Atlanta, is an elite provider of Enterprise and IT Solutions specializing in Service Delivery, Application Performance, and IT Governance and Data Privacy. Silos-Connect´s Consulting and Professional Services are provided by world-class, top-notch trainers and consultants, whose credentials are second to none. Silos-Connect also provides best-of-breed technologies from vendors that have a compelling business case, and impressive innovation. Silos-Connect is the exclusive US Distributor for ActiveBase. See http://www.silos-connect.com  for more information.

About ActiveBase Ltd.

About ActiveBase Ltd: ActiveBase, Ltd. (www.active-base.com) is the leader in database performance and security. ActiveBase product suite includes ActiveBase Tuning Robot™, for automatic SQL collection (AWR), optimization and benchmark scheduling (a fully automatic SQL Expert server version); ActiveBase Performance™ for automatic SQL fixing without touching source-code; ActiveBase Priority™ for dynamic server resource prioritization; and ActiveBase Security™, with innovative Dynamic Data Masking capabilities defending mission-critical data against insider misuse as well as outsider intrusion.

Contact:
Peter Dobler, President, Dobler Consulting
813-322-3240
http://www.doblerconsulting.com 
###

It was summer of 2000 when I first learned about Sybase IQ and its revolutionary column vector database technology. As a long time Sybase ASE and Oracle DBA I was used to database engines that organize data in a row by row method. For quite some time I had difficulties to think in column terms and not in row terms.

A column vector database requires totally different methodology for performance and tuning efforts. Nothing is straight forward and the message that more data volume doesn’t make a difference in the query performance is not easy to understand. For example: A traditional database engine allows the usage of only one index per table in the same query. Sybase IQ has no limits. If each column in the query requires a different index, it will use a different index. In fact, by default every column is an index.

Getting my hands around the fact of having queries perform up to a 1000 times faster on Sybase IQ than on traditional row based RDBMS systems is no easy matter either. Of course in an Oracle implementation with the OLAP technology similar results can be achieved. However, you are paying for the underlying OLTP engine regardless if you’re using it or not. Sybase IQ doesn’t have this overhead.

One of the key features of Sybase IQ is its data compression. I worked with Sybase IQ systems that easily exceeded 80% compression ratio. Meanwhile, every database vendor introduced data compression into their database engines, but Sybase IQ is the undisputed leader in the highest compression ratio of them all.

This post is not meant to explain how Sybase IQ works and why it is so superior in analytical query processing compared to its row processing based counter parts. Please click here to read more about Sybase IQ’s amazing technology.

I know that there are other data warehouse systems out there that are equally as fast as Sybase IQ and some are even faster, but in this article I am focused on the Sybase IQ engine and its recent setting of a new benchmark record for TPC-H transactions. This record is all about saving money while providing blazing fast performance. Please click here to read the detail report on this milestone.

OK, back to what’s new in version 15 of Sybase IQ.

There are two major improvements in the new release that are worth mentioning.

1. The overall query performance was once again dramatically improved and yields in an average 20%-50% performance gain, compared to the previous Sybase IQ release.

What does this mean for your business?

Analytical queries are typically CPU hungry monsters that can eat up your entire processing resources. Producing results faster means more queries will be processed in the same time window.

It also means the hardware upgrade can be postponed for a while. Considering that the associated QA requirements to move an entire production system to a new hardware platform can be a very expensive proposition and combined with the cost of the new hardware maybe not worth the investment. In comparison; a standalone upgrade of the database engine might be worth the effort.

It further means that cheaper server hardware on Linux can be used to build Sybase IQ multiplex systems that produce high end performance results on a slim budget. Due to Sybase IQ’s architecture there are no added network constraints either. 

2. Multiple writer nodes in a single multiplex environment.

This is an enormous step forward. Previously a typical Sybase IQ was build with one big server that acts as the writer node and many smaller servers for the reader nodes. The thinking was to provide the best hardware to the CPU intensive load jobs to minimize the load windows. The downside of this architecture was that in a failure situation, one of the smaller servers would take over the writer part and then would be helplessly overwhelmed in case the writer node couldn’t be fixed in time for the next load.

It is also economically not practical to devote high-end, expensive server hardware to a job that only last for a fraction of a daily work load. Having multiple writer nodes solves this problem once and for all.
Utilizing all the available processing power in a multiplex environment ultimately leads to faster load performance, which can be solved without upgrading the writer node server hardware over and over again.

Also, another data load performance improvement is the new feature of loading data directly from clients. This means that data can be loaded from files using a simple SQL statement instead of copying data files onto a server and then using the bcp command.

Of course there are other major improvements in security, flexibility and integration support, but the two improvements above are the major contributors to any cost savings or cost avoidance initiative a business is taking on these days.

Sybase also improved their client apps to better manage Sybase IQ, easier develop applications for Sybase IQ and more effectively monitor Sybase IQ. Once the Achilles heel of Sybase, these tools are now very usable and mature.

From a cost/performance point of view, Sybase IQ is a force to be reckoned with and due to its column vector architecture there is no other major database engine in the market like it. To support Sybase’s strong performance in technology they also had their best financial year ever in 2008 and the best quarter on record in Q1 2009.

I hope you enjoyed my brief introduction into Sybase’s data warehouse engine Sybase IQ and its latest version 15 features.

Take care,
Peter