We must receive your reply no later than Friday,
** No shows will be billed, unless cancellation is received by Tuesday,
November 27, 2018
Transactional vs Analytical SQL
Join NEMUG on November 28th when Db2
Industry Expert, Bob Bestgen will join us to present
Transactional vs Analytical SQL.
SQL performance got you down? SQL
statements looking like spaghetti? Proper database design for
the intended usage is important for long term success and good
performance. There is a difference between transactional and
analytical processing and it is useful to understand the
difference. What should an appropriate data model look like?
What are the red flags that your data model is not best for your
usage? This session will discuss these topics along with
strategies for handling cases when analytical processing is
required against your transactional data. Additional topics
touched on include: - real time vs. ETL transformations - using
dimension tables for dates, VINs, customer names and zip codes
- Operational Data stores – and Dimensional Data Models.
Bob Bestgen is an IBM Db2 for i
architect and consultant. In his 30+ years at IBM, Rob has held
a variety of roles including: database developer, database
architect, Business Architect, chief architect of the Db2 for i
SQL Query Engine (SQE), and product development manager of
various products. Rob is currently a proud member of the Db2 for
i Lab Services team, helping customers utilize the amazing
capabilities of Db2 for i, IBM i, and Db2 Web Query for i. Rob
is also the product development manager for Db2 Web Query for i,
the popular IBM i product for query reporting and analytics.
Besides working directly with customers, he is also a frequent
presenter at user conferences.
Message from the Board:
It was great to have Dawn May of
Dawn May Consulting visit the NEMUG group in October. We
learned about IBM i Navigator, IBM i Performance Tools, IBM i
Services for System Admins, IFS Tasks and more. Thank
you for visiting us Dawn. It was great to learn more about how
we can use the i.
For November we have Rob Bestgen from IBM Lab Services who will
speak with us about an SQL topic - Transaction vs. Analytical
SQL. We will learn what the differences are and when to use
each type of SQL.
Happy Thanksgiving everyone! Enjoy
the time off and we look forward to seeing you on the 28th!
Remember that in February, we will again be raffling
2 separate registrations to attend the NEUGC Conference
scheduled for April 8-10, 2019 in Framingham. The registrations
will be chosen by random draw from all meeting surveys received
from September 2018 through February 2019. The more meetings
you attend, the more chances you have to win!!
If you are not on our e-mail list, go to the web site at
www.nemug.com and click on the "Subscribe" button to be added to
to the following New and Renewing Member Companies
If your company has not registered yet, go to the website to
download the annual invoice for membership (on left side of the
home page). Bring a check (payable to NEMUG) and the form with
you to get the member prices at the meeting.
Thank you for your
support of NEMUG!