Building a big data warehouse using a Union All View (UAV) table with billions of rows is only the beginning. There has to be a DB2 system that is enabled so the data warehouse can have SQL optimized automatically and queries run efficiently. Hopefully each of the critical DB2 DSNZPARM settings was reviewed during your . . . → Read More: DB2 DSNZPARMS: How to Get DSNZPARM Settings with Data Studio to Improve Big Data Performance
| |||
Building a big data warehouse with billions of rows always needs an extra bit of attention to get the best performance out of the database processing. Application programming is always interesting as the efficiency of the code and the DB2 data types handled by the application code are critical for data quality and integrity. With . . . → Read More: Big Data Analytics: DB2 Data Types When building a large data warehouse with billions of rows any extra processing is magnified exponentially. Any inefficiency quickly becomes a bigger performance problem as it is multiplied by each of the billions of rows. To squeeze every performance drop out the big data standard, centralized processes or built-in functionality always helps the team focus . . . → Read More: Big Data Analytics: Leveraging DB2 Functions The discussion continues about the building of a petabyte table by putting multiple tables under the definition of a UNION ALL View. This provides unlimited growth potential for the logical big data table to all types of regular and analytical users. Sometime you want to have uniqueness across the entire petabyte table and this can . . . → Read More: Big Data Analytics: Union ALL View — Uniqueness through INSTEAD Triggers Last week’s example built a petabyte table by putting multiple tables under the definition of a UNION ALL View. This tactic provides unlimited growth potential for the logical big data table to all types of regular and analytical users. Unfortunately, as some commented, this UNION ALL view may need help to get performance in DB2. . . . → Read More: Big Data Analytics: Union ALL View Petabyte Performance There are many companies that are realizing business insights through new big data analytics. Many are finally looking at data that they only once dreamed of analyzing because of the continuing decline in the cost of storage and CPU as well as the availability of cloud computing resources. The amount of data and the number . . . → Read More: Big Data Analytics: Union ALL View Building a Petabyte Table Last week’s blog information made some upset with its basic advice on Big Data. I agree these basic database issues should be common knowledge for business and database professionals and not have to be discussed or even considered. Unfortunately, all the new developers are thinking that they are prodigies of Leonardo da Vinci and their . . . → Read More: Big Data Analytics: More Maddening Basic Issues: NULLS, VARCHARS and DEFAULTS As I talked about last week the new big data analytics era is upon the IT departments of all types of corporations. Insurance, health care, financial and other types of businesses are starting to accumulate many different and new types of analytics to provide an edge over their competition. As a data management professional these . . . → Read More: Big Data Analytics: Three Critical Success Points Thanks again for all the greetings and comments over the holidays, I really appreciate it. Best wishes and success to everyone this New Year 2012. When we left off last year I was writing about the DB2 business analytics that could help your management understand the growth and hard work your DB2 systems and applications . . . → Read More: Business Analytics: Three Business Areas to Help Your Company’s Bottom Line Thanks for all the comments this last week and throughout the year. I really appreciate it. The comments this week were related to additional business analytics areas that need to be communicated to management. Management needs to be aware of business analytics on maintenance activities, security/compliance efforts and the number of end-users helping make profits . . . → Read More: Analytics Is the Answer: Three More Business Analytics Areas Needed for Management |    | ||
| Copyright © 2024 Dave Beulke - All Rights Reserved | Privacy Policy | Refund Policy Website by The Web Mechanic Powered by WordPress & AtahualpaClick to access the login or register cheese | |||
