[Skip to Content]
Fresche Quadrant Software BCD Software SoftBase NetLert

Archive for the ‘Big Data’ Category

Big Data = Big Pressure on DBAs

All Baseline Posts, Big Data, Multi-Row FETCH

Everyone is talking about Big Data. But what is it really? Data is generated by a plethora of activities in today’s digital world and is typically stored for a period for any number of reasons. It can be data from weather sensors, electrical grid sensors, pharmaceutical data, social media posts, purchase transactions, cell phone GPS signals, customer information, insurance claims, etc—the list goes on and on.  But as new data continues to grow at faster and faster rates, IT professionals see a mounting problem. How are they going to manage, store and use this information to create a competitive advantage?

These days, you rarely hear someone talking about Big Data without mentioning analytics or warehousing. While Big Data clearly has its uses for business intelligence, we pay for this insight with ever-increasing workloads and throughput demands. Since DBAs need to ensure that they can meet these new growing demands without compromising mission-critical applications, it’s more important than ever for DBAs to quickly improve application efficiency and keep CPU utilization growth from getting out-of-hand.

We’ve seen significant CPU savings in our customers who’ve implemented multi-row FETCH, and recommend to all our customers that they consider implementing it. Our Attach Facility now implements multi-row FETCH for you, automatically. Contact us today for more information!

 


Lighten the Load with Multi-Row FETCH

All Baseline Posts, Big Data, Multi-Row FETCH

With the explosion of data and the challenges that Big Data presents, today’s DBAs are managing more data than ever before. With more programs being developed and tested, more tools are needed to help optimize data processing and efficiency. Using tools such as Multi-Row Fetch (MRF), DBAs are able to cut down on CPU time and improve application efficiency, even in facing Big Data.

MRF testing has been shown to provide CPU savings on individual FETCH statements in the 50-60% range. As FETCH statements are an integral part of batch processing, it’s not unreasonable to see TOTAL batch CPU savings in the double digits. As Big Data continues to get bigger and IT budgets continue to tighten, DBAs will need to implement as many CPU saving techniques as they reasonably can. They will have to do a lot more with more data and less resources.

Implementing MRF is a great way to lighten the load, and SoftBase can help you do it without any source code changes. Using the revolutionary, patent-pending Attach Facility MRF feature, SoftBase helped customers automatically implement MRF for CPU savings as high as 74%. Contact us to learn more about how this works.