The Dobler Consulting Blog
A Wealth of Information from the vault of Dobler Consulting
SAP Sybase has developed a new, innovative and dynamic staging technology, allowing full use of the native, high-speed data load mechanism SAP Sybase IQ offers . . . Real Time Loading (RTL).
RTL addresses the need to have another system prepare the data for load by taking real time data movement from the source database, and applying staging technology to the data transfer in the background.
Up until now, the only option for loading data from an Online Transaction Processing (OLTP) database . . . airline reservation systems, financial transactions, etc., into a SAP Sybase IQ data warehouse was a so-called staging process. Staging means that the OLTP is isolated from the data warehouse loading process to ensure data integrity, due to the rapidly changing data content in the OLTP database systems.
Direct replication into SAP Sybase IQ was limited to low data movement environments. The reason lies in the fundamental differences on how SAP Sybase IQ processes data, and data movement strategies SAP Sybase Replication Server applies.
SAP Sybase IQ is a column vector database. Retrieving a single row requires assembling the row from each column component. This process makes row by row processing ineffective, and the so- called “trickle feed” loading of SAP Sybase IQ nearly impossible. The advantage of a column vector database is in the unmatched speed for complex data retrieval operations and data aggregation on huge data sets.
Download the White Paper for FREE!!
Local Database Services Company Supports Tampa Bay’s IT Community by Sponsoring the 2016 CIO of the Year Awards and Luncheon
Tampa, FL (August 19, 2016) – Dobler Consulting, a Tampa-based information technology and database services company offering a wide spectrum of world-class services, is excited to announce that it will be a sponsor of the Tampa Bay Business Journal (TBBJ) 2016 CIO of the Year Awards. Created to recognize leadership and technical excellence in the information technology field, the TBBJ CIO of the Year Awards will be presented at a luncheon on August 25, 2016, at the Straz Center for the Performing Arts in Downtown Tampa.
CEO Peter Dobler Cites Employee Engagement and Client Satisfaction as Keys to the Database Services Company’s Ongoing Success
Tampa, FL (July 22, 2016) — Dobler Consulting (doblerconsulting.com), a leading information technology and database services company offering a wide spectrum of services to its clients, recently ranked 17 on the 2016 Tampa Bay Business Journal “Fast 50”—a listing of the 50 fastest-growing, privately held companies in the Tampa Bay area. This is the second such award for Dobler Consulting, who ranked No. 10 on the 2013 Fast 50 list.
Consider your database administrator (DBA). Most DBAs spend their workdays on capacity planning, installation, configuration, migration, performance monitoring, security, troubleshooting, backup, and data recovery — after they have resolved all the trouble tickets and answered all the panic-stricken user calls.