Board Members:
Wanda Moore President American Express (consulting)
Phone: 602-766-9383 email: wanda.r.moore@aexp.com
Jim Drewe
Vice-President American Express Phone: 602-548-5038 email:
james.drewe@aexp.com
Dan Mueller Past President SRP Phone: 602-236-6899 email: dlmuelle@srp.gov
Andrea Norman IBM Rep. Phone: 602-217-2171 Email: anorman@us.ibm.com
Andy Beresford IBM Rep. Phone: 602-217-2536 Email: aberesfo@us.ibm.com Kathy Erickson Board Member American Express Phone: 602-766-7903 email: kathy.erickson@aexp.com Steve Hunn SWARUG Webmaster
Lightyear Consulting Phone: 480-515-1498 email: lightyr@ibm.net
Ann Urich
Board Member Arizona Public Service Phone 602-250-3686 email: ann_urich@apsc.com If you are not on the mailing list and wish to receive future newsletters about upcoming meetings, please contact Glenn Fuller (602)-381-9460, or e-mail at gfuller@simatics.com- or -
Join SWARUG on-line
Mark your SWARUG calendar
Tech Day 2000 April 26, 2000 at the Phoenix Civic Plaza |
Next Meeting
Our next meeting will be on Thursday March 2, 2000 At IBM 2929 N. Central PhoenixPlease RSVP to Kathy Erickson 602-766-7903
kathy.erickson@aexp.com
Keynote Speaker: From IBM's Santa Teresa Lab Krishna Kulkarni "Hot Off the Press …The New
SQL-99 Standard" Krishna Kulkarni is with IBM in San Jose since 1997. Prior to this he worked for Digital Equipment Corporation, Tandem Computers, Inc. and Informix Software, Inc. He
represents IBM at the ANSI committee responsible for the SQL standard and is part of the US delegation to the corresponding ISO committee. Krishna has been participating actively in both
standards organizations for nearly 10 years. He has contributed extensively to the design of object-relational and procedural extensions in SQL-99, the fourth edition of the SQL standard
published in late 1999. Krishna is a co-author of the book "Object-oriented Databases: a semantic data model approach", published by
Prentice-Hall. He has presented tutorials on the SQL standard in SIGMOD '92, VLDB '93, and ICDE '94, and on object-relational database systems in VLDB '97. Krishna holds a Ph. D. in
Computer Science from the University of Edinburgh, Edinburgh, UK."The keynote will be on the newly-published SQL-99 standard and the work that is currently ongoing for standardization in
the next couple of years. Briefly the new features in SQL-99 are: 1) User-defined types (distinct types, structured types) 2) User-defined functions, procedures 3) Methods
4) Type Hierarchy 5) Typed Tables 6) Table Hierarchy 7) Typed views 8) View Hierarchy 9) Triggers 10) Recursive queries 11) Procedural extensions 12) Binding to Java
The work that is currently ongoing and likely to be standardized in a year or two:1) OLAP extensions - Ranking, cumulative distribution, moving sum, cumulative sum, regression functions, etc. 2) Management of
external data - data links and heterogeneous databaseaccess through the concept of foreign tables.
PARKING INFORMATION:
There is a parking charge of $5 if you use the building parking facility
. You can park free right across the street at Park Central Mall (an easy walk). SWARUG needs you! Our secretary, Glenn Fuller, regretfully had to
resign. Thank you for your service, Glenn. We will miss you.SWARUG needs a volunteer replacement. The member records are maintained on an
Access Database. If you are interested, please call Wanda Moore 602-766-9383 or e-mail to
wanda.r.moore@aexp.com |
|
|
Agenda 9:00 am Registration and continental breakfast.
9:30 am to 11:30 pm Keynote Presentations
11:30 to 12:00 pm Election of new officers and ideas to help SWARUG grow.12:00 to 1:00 Lunch provided by IBM
1:00 to 3:00 pm Special Interest Groups: Three Special Interest Group (SIG)
breakouts: Annie Neroda: OLAP on the s/390 Annie works for IBM in Phoenix as a Data Management Software IT Specialist. She has
been a BI spokesperson for IBM around the globe, presenting and explaining IBM?s Business Intelligence Strategy to Business Partners, the internal DM Sales force and to customers. This
includes IBM's direction in software products (DB2 UDB, Visual Warehouse, DB2 OLAP Server and Intelligent Miner), as well as with worldwide standards (Metadata Interchange, XML). She has
been a featured speaker to wide customer audiences at DB2 Technical conferences, Janet Perna Road shows and international classes on five
continents.Annie's 30+ year career has taken her through the technical paths of programming, database administration, technical management, teaching database and data warehouse curricula and
technical software sales. .
Jay Johnson: DB2 UDB and Web enablement
Relational databases are the foundation of modern e-business. This presentation will discuss some of the tools and techniques available for DB2 UDB to web-enable data and applications.
Jay is a principal consultant for Far West
Systems and is responsible for providing database and e-commerce support for their clients by: - Designing and implementing Medium-To-Large Database Solutions
- Implementing and customization of Data Marts and Data Warehouses
- Developing customized e-commerce solutions
- Integrating new and legacy systems to
meet business needs
Krishna Kulkarni: SWARUG members pick the topic from information presented in the keynote:
Anything you want to know more about from the keynote. You nominate the topic—members vote—and Krishna guarantees to deliver. The last SQL standard was SQL-92. |
|
Don't get frustrated!
SWARUG strives to keep you current with the latest technology. |