The New England Midrange Users Group








Contact an Officer

 Download Annual    Invoice

Home Page



Next Meeting - Wednesday, November 28, 2018 - Transactional vs Analytical SQL


The New England Mid-Range Users Group is organized as a resource for users of IBM System i, i Series and AS/400 systems. If you were looking for the New England M User's Group (MUMPS) goto


Date:  November 28, 2018

 Sign in 5:15p.m.; Speaker 6:00-7:15p.m., Dinner to Follow

Place: Red Stone Grill, 120 Chestnut Street, North Attleboro, MA 02760 
Topic: Transactional vs Analytical SQL
Speaker: Bob Bestgen - IBM Lab Services

Meatloaf - House meatloaf over mashed potatoes then topped with gravy and fried onion strings served with seasonal vegetable

Old School Alfredo - Grilled chicken breast sautéed with broccoli in a creamy garlic parmesan sauce tossed with fresh pappardelle pasta

Salmon - Grain mustard glazed Atlantic salmon filet served with herb roasted potatoes & seasonal vegetables

Vegan or Vegetarian – available on request

Cost:  NEMUG Members $30, Guests $40, Students $10.  Make check payable to NEMUG  Mail to NEMUG, c/o Eileen Newell, 455 Smith Street, N. Attleboro, MA 02760 or register on the NEMUG web site, and pay at the door

We must receive your reply no later than Friday, November 23, 2018
 ** 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.


NEMUG Officers



Dawn Dawson,
The Moore Company

(401) 315-6351

Vice President  

Chip DiFolco,


(774) 227-7373


Rick Marcotte

iTech Solutions  

(508) 243-3508


Eileen Newell,
FGX International

(401) 719-2337


Jerry Perreault

(401) 949-2613

NE Conference Liaison  

Chip DiFolco,


(774) 227-7373


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!

Dawn Dawson

NEMUG President


Special Note
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!!


E-mail Notification
If you are not on our e-mail list, go to the web site at and click on the "Subscribe" button to be added to the list.


Welcome to the following New and Renewing Member Companies

(as of 11/1/2018)


Callico Distributors

FGX International

Franklin Sports
i Tech Solutions Group
JH Lynch & Sons, Inc.
The Moore Company

NATCO Products Corp.

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!




The next meeting
Wednesday, November 28, 2018

Register for next meeting:  Click to register


Manage your subscription to NEMUG emails


Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Subscribe
For Email Marketing you can trust

The Maxava iFoundation, established by Maxava, to support non-profit IBM i user groups, has awarded a grant to NEMUG.  We are proud to be recognized by the Foundation, and to have been selected for this award.  We look forward to a lasting relationship with them.

Click on either of the links to learn more about Maxava, and the Maxava iFoundation.


Click to see a 1968 midrange computer!




Copyright 2011-2012 New England Midrange Users Group

Site created and maintained by Jerry Perreault  -- Last updated November 14, 2018 -- Best Viewed at 800x600

Top of Form