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!!
Dobler Consulting, (www.doblerconsulting.com), a Tampa, Florida-based provider of a full spectrum of database services, is pleased to announce today year-to-date revenue, ending September 30, 2012, has increased by 100% from the same period of time for two years in a row: 2010, and 2011. Read More
Summer is racing by, and 2012 is moving along faster than I had imagined. I am happy to bring you the first newsletter on our new multi-device website, where you can view content from anywhere. Our “words to the world” are now available on pc’s, tablets, and mobile phones. Please take some time to see our new look on our expanded website at www.doblerconsulting.com. Viewing it from your tablet or smartphone will demonstrate its flexibility. Send me a note if you want a website like this one. Read More
Everywhere we turn this year, we see database technology companies continuing to grow and expand with new offerings for improving computer systems to help you support your company’s important business decisions.
This month’s newsletter describes 3 database technologies that offer new promise for improving performance: Sybase® ASE 15.7, Sybase® IQ 15.4, and Microsoft SQL Server® 2012 RC0.
To all my readers, Happy Holidays! I hope your holidays with family and friends are a source of joy this year. During this time, I’m grateful for you, as my loyal email subscribers. Thank you for reading my newsletter, and giving me the opportunity to share technology information to help improve your database skills and knowledge to become more successful.
I appreciate your continued support! 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 an individual with sales experience in the software and/or IT consulting services sales spaces for an Account Executive position for our customers in the Southeast region. Specific industry sales experience (Software/Database Systems/IT Consulting Services) a must. Managed Services related sales experience a major plus. This is full-time position.
TAMPA, Fla., April 27, 2011
Peter Dobler, of Dobler Consulting, www.doblerconsulting.com, is spearheading the Tampa Bay International Sybase Users Group with monthly meetings to share best practices for becoming more effective Sybase DBA’s, database designers, and software engineers. Dobler plans to strengthen the group by creating regular, on-going meetings to exchange ideas with like-minded database professionals, and promote Sybase technology information sharing.
Wow, Q1 of 2011 is almost over. I hope everybody is busy and takes advantage of the upswing in IT activities over the past few weeks.
On February 24th we had our first Sybase user group meeting at our offices. I am pleased with the total turnout, although there were way more people attending online than in person. I still think that the online folks missed out on pizza and drinks, plus the door giveaway of an ASE 15 book. Read More