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!!
SAP AG recently announced that with a team of technology partners, including BMMsoft, HP, Intel, NetApp and Red Hat, it has generated a new world record for the world’s largest data warehouse using the SAP HANA platform and SAP IQ software. This independently audited 12.1PB data warehouse has been recognized by Guinness World Records, and is four times larger than the prior record. Read More
We hope your holidays were happy and relaxing. 2013 promises to be a stellar year for Dobler Consulting. We have several new projects in the works, and are continuing to solve the latest challenges and database technology issues. Our team of consultants is providing a wide variety of project assistance for our clients. Read More
Dobler Consulting, a leader in Sybase, Oracle and SQL Server database support services and Sybase (an SAP Company) system integration services for Fortune 500 companies as well as Small and Midsize Business (SMB) in the United States, seeks a SQL Developer with SSIS experience for a healthcare data warehouse project. This is a 6 month contract. Read More