NYC LOCAL: Thursday 19 July 2012 UNIGROUP: Alex Scotti on Relational Database Management System Internals

[secretary]

<blockquote
  what="official UNIGROUP announcement"
  assurance="there will be giveaways and food"
  rsvp="registration requested, see below"
  entrance-fee="yes, see http://www.unigroup.org/unigroup-fees.html";
  location="The Cooper Union School of Engineering, see below"
  info="http://www.unigroup.org";
  edits="some paragraphs removed so notice fits in mailboxen">

 Date: Wed, 18 Jul 2012 17:08:01 -0400 (EDT)
 From: Unigroup_of_NY <unilist@unigroup.org>
 Subject: Reminder: UNIGROUP 19-JUL-2012 (Thu): Relational Database Internals

 Unigroup is TOMORROW Thursday...
 Please RSVP if you will be attending and have not already done so...

 =================================================================
 UNIGROUP OF NEW YORK - UNIX USERS GROUP - JULY 2012 ANNOUNCEMENTS
 =================================================================

    -----------------------------------
 1. UNIGROUP'S JULY 2012 MEETING NOTICE
    -----------------------------------

       When:  Thursday, July 19th, 2012    (*** 3rd Thursday ***)

      Where:  The Cooper Union  <http://www.cooper.edu>
              School of Engineering    (*** New Building ***)
              41 Cooper Square      (3rd Ave @ 7th St, bet. 6th & 7th Sts)
              East Village, Manhattan
              New York City
              Meeting Room: 506_CS     (5th Floor)
              ** Please RSVP **        (Note: Room Changes Month-to-Month)

       Time:  6:15 PM - 6:30 PM  Registration
              6:30 PM - 6:45 PM  Ask the Wizard, Questions,
                                 Answers and Current Events
              6:45 PM - 7:00 PM  Unigroup Business and Announcements
              7:00 PM - 9:30 PM  Main Presentation

       Cost:  See the Meeting+Membership Fee Schedule Below.

              -------------------------------------------------------
      Topic:  Relational Database Management System (RDBMS) Internals
              -------------------------------------------------------

    Speaker:  Alex Scotti,
              Bloomberg

    -------------------------------------------------------------------

    INTRODUCTION:
    -------------

    Unigroup's June 2012 meeting will be a technical talk about
    Relational Databases: What they are, How they work, and What you,
    as the RDBMS user/programmer/administrator, should know about them.

    Unigroup's Meeting Schedule:
    19-JUL-2012: Relational Database (RDBMS) Internals (Alex Scotti).
    20-SEP-2012: To-be-announced.

    -------------------------------------------------------------------

    SPECIAL INSTRUCTIONS:
    ---------------------

    Most Unigroup meetings are open to the public!

    To REGISTER for this event, please RSVP by using the Unigroup
    Registration Page:
          http://www.unigroup.org/unigroup-rsvp.html

    This will allow us to automate the registration process.
    (Registration will also add you to our mailing list.)
    Please avoid Emailed RSVPs.

    Please continue to check the Unigroup web site and meeting page,
    for any last minute updates concerning this meeting.  If you
    registered for this meeting, please check your Email for any last
    minute announcements as the meeting approaches.  Also make sure
    any anti-spam white-lists are updated to _ALLOW_ Unigroup traffic!
    If you block Unigroup Emails, your address will be dropped from
    our mailing list.

    Also, if you have an interest in Unigroup, be sure to receive
    Unigroup information DIRECTLY from Unigroup, via direct receipt
    of Emails and by visiting the Unigroup Web Site.  NO OTHER SOURCE
    provides timely, accurate and complete Unigroup information.

    Please RSVP as soon as possible, preferably at least 2-3 days
    prior to the meeting date, so we can plan the food order.
    RSVP deadline is usually the night before the meeting day.

    Note: RSVP is requested for this location to make sure the guard
          will let you into the building.  RSVP also helps us to
          properly plan the meeting (food, drinks, handouts,
          seating, etc.) and speed up your sign-in at the meeting.
          If you forget to RSVP prior to the meeting day, you may
          still be able to show up and attend our meeting, however,
          we cannot guarantee what building security will do if
          you are "not on the list".

    -------------------------------------------------------------------

    MAIN PRESENTATION
    -----------------

    Topic:  Relational Database Management System (RDBMS) Internals


    Introduction & Description of Talk:
    -----------------------------------

    This will be a highly technical talk on the inner workings of a
    modern relation database engine both from a theoretical point of
    view and a practical one.  Implementations that exist in existing
    systems will be discussed, in addition to why certain theoretically
    possible systems were never implemented.  There will be a heavy
    focus on issues of transaction processing (ACID) and a discussion
    of how the "relational" (SQL) portions of a system are implemented.
    We will cover the history of these systems and discuss concrete
    implementations of real world systems.


    Detailed Outline:
    -----------------

    - History:
      - Pre Relational Systems
      - The Early Relational Systems and Why They Became So Dominant.
      - The Lineage of our Modern Day Systems.

    - Detailed Exposure of Internals:
      - Buffer Pool
      - Logging
      - Concurrency Control
      - BTrees
      - Query Planner

    - Analysis of 3 Existing Systems:
      - DB2
      - Oracle
      - PostgreSQL

    - Observations on Current Trends and Predictions on Future Directions.


    References & Web Resources:
    ---------------------------

    Wikipedia Articles on Databases:
      http://en.wikipedia.org/wiki/Relational_database
      http://en.wikipedia.org/wiki/Transaction_processing
      http://en.wikipedia.org/wiki/Isolation_level
      http://en.wikipedia.org/wiki/Isam

    -------------------------------------------------------------------

    Speaker Biography:
    ------------------

    Alex Scotti is the original author and current head of a team
    focusing on the development of the Comdb2 relational database
    system.  Under active development for 10 years, Comdb2 is the
    database that backs the majority of customer facing Bloomberg
    applications.  Alex has a solid understanding of both the
    theoretical underpinnings of database systems, and the practical
    issues of implementation and tradeoffs in both the Comdb2 system
    and most existing systems.

    -------------------------------------------------------------------

    Company Biography:
    ------------------

    Bloomberg, the global business and financial information and news
    leader, gives influential decision makers a critical edge by
    connecting them to a dynamic network of information, people and
    ideas.  The company's strength "delivering data, news and analytics
    through innovative technology, quickly and accurately" is at the
    core of the Bloomberg Professional service, which provides real
    time financial information to more than 310,000 subscribers
    globally.  Bloomberg's enterprise solutions build on the company's
    core strength, leveraging technology to allow customers to access,
    integrate, distribute and manage data and information across
    organizations more efficiently and effectively.

    Through Bloomberg Law, Bloomberg Government, Bloomberg New Energy
    Finance and BNA, the company provides data, news and analytics to
    decision makers in industries beyond finance.  And Bloomberg News,
    delivered through the Bloomberg Professional service, television,
    radio, mobile, the Internet and two magazines, Bloomberg
    Businessweek and Bloomberg Markets, covers the world with more
    than 2,300 news and multimedia professionals at 146 bureaus in 72
    countries.  Headquartered in New York, Bloomberg employs more than
    15,000 people in 192 locations around the world.

    -------------------------------------------------------------------

    Giveaways:
    ----------

    Addison-Wesley Professional/Prentice Hall PTR, and O'Reilly have
    been kind enough to provide us with review copies of some of their
    books, which we will continue to raffle off as giveaways at our
    meetings.  The publishers always ask that the persons receiving
    the books provide a review and/or feedback about their books.

    Unigroup would like to thank both companies for the support
    provided by their User Group programs.

    As always, all of the books will be available for review at the
    start of the meeting.

    Note: Our supply of books is low right now, we hope to resolve
          that soon.

    -------------------------------------------------------------------

    Fee Schedule:
    -------------

    Unigroup is a Professional Technical Organization and User Group,
    and its members pay a yearly membership fee.  For Unigroup members,
    there is usually no additional charges (ie. no meeting fees) during
    their membership year.  Non-members who wish to attend Unigroup
    meetings are usually required to pay a "Single Meeting Fee".

        Yearly Membership (includes all meetings):      $ 50.00
        Student Yearly Membership (with current! ID):   $ 25.00
        Non-Member Single Meeting Fee:                  $ 20.00
        Non-Member Student Single Meeting (with! ID):   $  5.00

      * Payment Methods: Cash, Check, American Express.

      ! Students: We are looking for proof that you are
        currently enrolled in classes (rather than working
        full-time), and as such, your Student ID should show
        a CURRENT date.  We have been presented Student IDs
        containing NO dates whatsoever, and in the
        current environment, perpetual/non-expiring access
        to university facilities just does not feel right.
        If your ID contains no date, please bring
        additional proof of current enrollment.  Thanks,

    NOTE: Simply receiving Unigroup Email Announcements does
          NOT indicate membership in Unigroup.

    Members: Remember to bring your Unigroup membership card with
             you to the meeting, to confirm your yearly renewal date!

    -------------------------------------------------------------------

    Food:
    -----

    Complimentary Food and Refreshments will be served.  This
    includes "wraps" such as turkey, roast beef, chicken, tuna
    and grilled vegetables as well as assorted salads (potato,
    tossed, pasta, etc), cookies, brownies, bottled water and
    assorted SOFT beverages.

    -------------------------------------------------------------------

    Directions:
    -----------

      The Cooper Union  <http://www.cooper.edu>
      School of Engineering  (*** New Building ***)
      41 Cooper Square (3rd Avenue @ 7th St, between 6th & 7th Streets)
      East Village, Manhattan
      New York City, 10003
      Meeting Room: ** (See Above, Room Changes Month-to-Month)

    Located on the East side of Cooper Square.  Look for the
    new building with the non-traditional appearance.
    Entrance is at the corner of 3rd Avenue and 7 Street.

    Building lobby sign-in is required at the guard's desk.
    Enter the building, check in with the guard at the lobby for
      directions to Unigroup (the room varies from month-to-month).

    Nearest mass transit stations are:
      '6'           to Astor Place (stops right at The Cooper Union),
                    then walk 1 block East and 1 block South.
      'R'           to 8th Street, then walk about 2 blocks East
                    then 1 block South.
      '4/5/6/R/N/Q' to Union Square, then walk South and East.
      'B/D/F/V'     to Broadway-Lafayette, then walk North and East.

    Free street parking in the area becomes available at 6pm.

    There are also parking lots on Broadway, at (or just south of)
      Astor Place (8th Street).

    -----

    Please mark this meeting on your calendar and join us!
    Please tell your friends about Unigroup!

 ----------------------------------------------------------------------------
 ----------------------------------------------------------------------------

 < ... />

    --------------------
 5. UNIGROUP INFORMATION
    --------------------

    Unigroup is one of the oldest and largest Unix User's Groups serving
    the Greater New York City Regional Area since the early 1980s.
    Unigroup is a not-for-profit, vendor-neutral and member funded
    volunteer organization.  Unigroup holds regular and special event
    meetings throughout the year on technical topics relating to Unix
    and the Unix/Linux/BSD User Community.

    Unigroup holds regular meetings planned for (at a minimum) the Third
    THURSDAY of Odd Months.  We generally try to hold Field Trip or
    Vendor Specific Meetings on the Even Months, although we do have the
    ability to hold monthly meetings at our regular meeting location.

    Planned regular meeting dates are (usually 3rd Thursdays):
      7/19/2012, 9/20/2012, 11/15/2012, 01/17/2013, 03/21/2013, ...
    Also watch for Special Event meetings and "Field Trips" to the
    facilities of local hardware and software vendors.

    =========================================================================
    = For Unigroup Information, Events and Meeting Announcements be sure to =
    = visit our World Wide Web Home Page:                                   =
    =       http://www.unigroup.org                                         =
    =========================================================================

    For further information or to get on the Unigroup Electronic Mail Mailing
    List send an EMail message to:
         unilist (-a_t-) unigroup.org

    To contact the Board of Directors of Unigroup, send an EMail message to:
         uniboard (-a_t-) unigroup.org

    If you have recently attended a meeting and you are not receiving
    Email announcements, please send us an Email and we will make
    corrections to our lists.

    Please Email the Board with any suggestions, especially potential
    meeting topics and speakers.  Unigroup welcomes contributions and
    content suggestions for our newsletter.  Unigroup is a volunteer
    organization and we need your assistance!  Please let us know if you
    can help!

 ----------------------------------------------------------------------------
 ----------------------------------------------------------------------------

 -Rob Weiner
  Unigroup Executive Director
  unilist (-a_t-) unigroup.org
  http://www.unigroup.org
                    
</blockquote>


Distributed poC TINC:

Jay Sulzberger <secretary@lxny.org>
Corresponding Secretary LXNY
LXNY is New York's Free Computing Organization.
http://www.lxny.org