| Presentation Title: | A brief, but practical, introduction to Oracle analytic functions |
| Speaker: | Mr Peter Scott |
| Company: | Getronics UK Ltd |
| Co-presenter: | |
| Presentation abstract: | Analytic functions have been available since version 8.1.6 of the Oracle database. However, like many newer features, they are often overlooked by developers and DBAs. This paper presents an overview of the analytic functions and provides a simple rationale for understanding the partitioning, ordering, and windowing components of analytic function syntax. Some typical (and also less common) uses of anlytic functions will be presented and comparsion with more traditional relational functions, both in terms of query performance and query 'maintainability', will be made. Finally, some pitfalls in the use of analytic functions will be discussed. |
| Presentation begins: | 14/11/2006 17:45 |
| Presentation duration: | 45 |
| Presentation content level: | 4 (1 = indepth, 5 = strategic overview) |
| Audience experience: | Experienced (2-3 years) |
| Audience function: | |
| Speaker biography: | Peter Scott works for Getronics, a multi-national IT services company where he leads their UK operation’s Business Intelligence team. His main technical interests are data warehouse architecture and design. Outside of his employment, Peter is the person behind the “Pete-s random notes” Blog and a regular contributor to on-line fora. |
| Related topics: | Server Technology: Business Intelligence, Datawarehousing & Reporting Tools, Server Technology: Server Technology & DBA Topics |
| Hall: | 10a |
