Personal tools
  •  
You are here: Home Tutorials WORLDCOMP'12 Tutorial: Dr. Saeed Rahimi
Important Date
July 16-19, 2012
The WORLDCOMP'12
22 joint conferences


« September 2015 »
Su Mo Tu We Th Fr Sa
12345
6789101112
13141516171819
20212223242526
27282930
Current Event
WORLDCOMP'15
Click Here

Past Events
WORLDCOMP'14
Click Here

WORLDCOMP'13
Click Here

WORLDCOMP'11
Click Here

WORLDCOMP'10
Click Here

WORLDCOMP'09
Click Here

WORLDCOMP'08
Click Here

WORLDCOMP'07 & '06
Click Here

Join Our Mailing List
Sign up to receive email announcements and updates about conferences and future events




 

WORLDCOMP'12 Tutorial: Dr. Saeed Rahimi

Last modified 2012-06-17 12:52


Beyond SQL: Oracle Analytic Functions
Dr. Saeed Rahimi
University of St. Thomas, USA

Date: July 17, 2012
Time: 6:00pm
Location: Copper Room


DESCRIPTION

    Relational database management systems and Structured Query Processing (SQL) have been in use for On-line Transaction Processing (OLTP) since early 1980’s. Recently, On-line Analytical Processing (OLAP) applications have become necessary tools for decision makers and business analysts. Although it is possible to use native SQL to perform analytics, this approach is very cumbersome and has many shortcomings. Oracle analytical functions are extensions to standard SQL statements that can be used to answer many Decision Support Systems (DSS) and data warehousing types of questions. By attending this session, attendees will learn how to work with Oracle’s analytical functions such as Cubes, Rollups, Ranking, Top-N, Bottom-N, etc. for real-life type of environments that can be very useful in business analysis. Attendees will have the opportunity to apply what we discuss in this session to answer questions similar to the one that they would face in real life.


OBJECTIVES

    • Participants will have an overview of relational database systems and data warehousing
    • Participants will review the basic SQL statements to solve real life OLTP type of problems
    • Participant will review and learn the advanced SQL statements beyond the standard in performing analytical function in Oracle 11g.
    • Examples of to Oracle’s analytic functions in a hypothetical scenario to drill down, roll-up, slice and dice on a sample database will provide and in-depth understanding of these functions.

INTENDED AUDIENCE

    This tutorial will benefit the people in the following (but limited to) job categories:

    • OLAP Developers
    • SQL programmers
    • Development managers
    • Data analysts
    • Data warehouse developers
    • Business intelligence analysts
    • Line managers
    • Scientists
    • Engineers
    • Graduate students studying DSS and OLAP

BIOGRAPHY OF INSTRUCTOR

    Saeed Rahimi is an associate professor with the Graduate Programs in Software, School of Engineering at the University of St. Thomas. Dr. Rahimi has over 32 years of experience in academia and industry focusing on Database Management systems, Database Administration, Distributed Database Systems, Repositories, Data Dictionaries, and Information Engineering. He has spoken in many National and International Conferences and has published many articles in management and scientific journals. He has taught graduate level system courses at the University of St. Thomas and the University of Minnesota since 1981. His current research focus includes distributed database systems, web databases, metadata, and peer-to-peer databases. His previous professional experience includes a number of management and research positions within Fortune 100 companies. Dr. Rahimi has cofounded InfoSpan, DWSoft Corporation, and SRDBSoft, companies specializing in database management systems design and development, metadata management for data warehousing, and database management consulting services. Dr. Rahimi has a B.S. in Electrical Engineering, a M.S. and a Ph.D. in Computer Sciences from University of Minnesota.

Announcements
All tracks of WORLDCOMP have received high citations
Click Here for details

Condolences
Click Here for details

WORLDCOMP'12 Exhibition
Click Here for details


2012 Co-Sponsors
Bioinformatics & Computational Biology Program
George Mason University, USA

Biomedical Cybernetics Laboratory
HST of Harvard University & MIT, USA

Minnesota Supercomputing Institute
University of Minnesota, USA

Center for Cyber Defense, NCAT

Argonne's Leadership Computing Facility of Argonne National Laboratory
Illinois, USA

The Center for Advanced Studies in Identity Sciences
(CASIS: NC A&T;, Carnegie Mellon, Clemson, UNC Wilmington

Knowledge Management & Intelligent System Center (KMIS)
University of Siegen, Germany

Intelligent Cyberspace Engineering Lab., ICEL
Texas A&M; University, Texas, USA
UMIT, Institute of Bioinformatics and Translational Research
Austria

Hawkeye Radiology Informatics
Department of Radiology, College of Medicine, University of Iowa, USA

The International Council on Medical and Care Compunetics
US Chapter of World Academy of Science

Supercomputer Software Department (SSD)
Institute of Computational Mathematics & Mathematical Geophysics, Russian Academy of Sciences


International Society of Intelligent Biological Medicine

Medical Image HPC & Informatics Lab (MiHi Lab)
University of Iowa, USA

High Performance Computing for Nanotechnology (HPCNano)

Manx Telecom

Computer Science Research, Education, and Applications Press;

World Academy of Biomedical Sciences and Technologies




Super Micro Computer, Inc.,
San Jose, California, USA


Intel Corporation


Altera Corporation


Hodges Health

Leading Knowledge


Science Publication

 


Administered by UCMSS
Universal Conference Management Systems & Support
San Diego, California, USA
Contact: Kaveh Arbtan

If you can read this text, it means you are not experiencing the Plone design at its best. Plone makes heavy use of CSS, which means it is accessible to any internet browser, but the design needs a standards-compliant browser to look like we intended it. Just so you know ;)