it sometimes seems like all domains easily map onto relational database like MySQL and Postgres — that we live in a happy land where all Employees are People, and all People are Mammals. Unfortunately, however, there are many domains that just don't map so easily onto a standard relational schema. In this session, we'll look at three general alternatives to the familiar model, as illustrated by some specific examples. We'll also see how some alternative databases provide a better fit for specific domains.
Objectives *Describe distributed database management systems. *Discuss client/server systems. *Define data warehouses and explain their uses. *Discuss the general concepts of object-oriented database management systems. *Summarize the impact of the Internet and intranets on database management systems.
Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators * Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more
* Move business logic into the database * Implement robust exception-handling * Optimize and debug, taking advantage of Oracle SQL Developer * Integrate PL/SQL with web-based applications * Interface with Java code and dynamic languages in the database, and running externally * Run the UTPLSQL unit-testing framework.