Re: [sacoug] Oracle7 to Oracle8i: What changed for the DBAs and the Application Developers

fyi:

On 6 Apr 2001, at 22:33, The Sacramento Oracle Users Group wrote:

> To: <sacoug_at_yahoogroups.com>
> From: "The Sacramento Oracle Users Group" <meeting_at_sacoug.org>
> Date sent: Fri, 6 Apr 2001 22:33:56 -0700
> Subject: [sacoug] Oracle7 to Oracle8i: What changed for the DBAs and
>the Application Developers
>
> [ Double-click this line for list subscription options ]
>
> Dear ORACLE Professional,
>
> This message contains the information on scope, venue and speakers for
> individual parts of the three part of series being sponsored by SacOug on
> Oracle7 and Oracle8i.
>
> * Part 1 on April 19 will introduce us to the domain of change.
> * Part 2 on April 26 will address the changes in PL/SQL.
> * Part 3 on May 3 will address the changes in Data Administration.
>
> The venue is
> Classroom RVR 1012(4/19 and 4/26) and Lobby Suite, University Union(5/3)
> California State University, Sacramento
> 6000 J Street, Sacramento
> (directions on website)
>
>
>
> The arrival of Oracle8i, with its Web and Java integration, is a dramatic
> development for Oracle customers. In some ways, Oracle8i is like any other
> Oracle release, packed with new products and features that customers need to
> learn about.
>
> But in other ways, Oracle8i, the "Internet database," is something very
> different. Its capabilities range far beyond traditional database
> boundaries. It presents Oracle users with new models for developing
> applications and doing business. Up until now many ORACLE developers and
> database administrators have been working effectively with SQL, PL/SQL, and
> various Oracle tools. With ORACLE 8i, they are now faced with the need to
> learn a whole variety of new and constantly changing technologies: Java,
> XML, and many other Internet-related technologies.
>
> Beginning Thursday night, April 19, The Sacramento ORACLE User Group, in
> conjunction with the Computer Science Department of the California State
> University, Sacramento, produces a three part series exploring in detail the
> issues involved with the move from ORACLE 7 to ORACLE 8i. Seating is
> limited to the first 25 who register. You may register at:
> <http://www.sacoug.org/html/events.htm>.
> "Oracle7 to Oracle8i: What changed for the DBAs and the Application
> Developers"
>
> * Part 1 on April 19 will introduce us to the domain of change.
> * Part 2 on April 26 will address the changes in PL/SQL.
> * Part 3 on May 3 will address the changes in Data Administration.
>
> Here is more detail:
>
> |-----------------------------------------------------------------------
> | Part I - Introduction to Oracle8i
> | Date: April 19, 2001
> | Time: 7:00 - 10:00 PM
> | Venue: Classroom RVR 1012
> | California State University, Sacramento
> | 6000 J Street, Sacramento
> | (directions on website)
>
> This first lecture lays the foundation for the presentations to follow.
> First the challenges presented to developers in ORACLE 7 will be briefly
> presented. Features in PL/SQL and for database administration in Oracle 7
> need improvement.
>
> This lecture will have two sections. The first section introduces the
> relevant features of PL/SQL and their shortcomings in ORACLE 7. You will
> learn how Dynamic SQL and PL/SQL tables in ORACLE 8i addresses these
> shortcomings. The second part provides introduction to some of the
> frustrations of database administration in Oracle7. You will learn how the
> partitioned views, autoextension of extents, and tuning features of Oracle 7
> need further enhancements.
>
> Speaker: Ravi Verma, Practice Manager, Annams Systems Corporation Ravi’s
> experience with Oracle spans over 12 years beginning with Oracle 5. Most of
> these years have been in the role of a DBA and a developer. Prior to joining
> Annams Ravi worked with Oracle corporation where he led data modeling
> effort for customizing Oracle Manufacturing Applications for Automative
> industries. Since joining Annams Systems Corporation he has handled many
> successful data warehousing projects. Bluelight.com the online division of
> Kmart is one of his accounts where he leads the database design and on-going
> tuning effort of very large Oracle8i databases.
>
> Teaching is his favorite pass time. He has taught Database Administration
> course at UC Davis Extension. He is working with the Computer Science
> Department of the Sacramento State University to design courses for working
> professionals in IT industry.
>
> |-----------------------------------------------------------------------
> | Part II - The New Face of PL/SQL
> | Date: April 26, 2001
> | Time: 7:00 - 10:00 PM
> | Venue: Classroom RVR 1012
> | California State University, Sacramento
> | 6000 J Street, Sacramento
> | (directions on website)
>
> ORACLE 8i, the long-awaited "Internet database," offers more than 150 new
> features -- many of them designed to make its popular database programming
> language, PL/SQL, faster, more powerful, and easier to use. This change
> presents a challenge to the developer. The major Oracle8i PL/SQL features
> include the following:
> * Autonomous transactions -> Commit or roll back changes without affecting
> the "main" transaction in the rest of your session.
> * Invoker rights -> At compilation time, you can now decide whether a
> program (or all programs in a package) should run under the authority of the
> definer or the invoker of that program.
> * Native dynamic SQL -> This native implementation of dynamic SQL is faster
> and easier than the DBMS_SQL built-in package.
> * Bulk binds and collects -> This major performance improvement allows you
> to process multiple rows in a single operation.
> * System-level database triggers -> With this feature and Advanced Queuing
> (AQ), you can take advantage of the publish/subscribe capabilities of ORACLE
> 8i.
> * Fine-grained access control -> This feature lets you implement security
> policies with functions and then use those functions to implement row-level
> security on tables or views.
> * Many new and enhanced built-in packages -> New packages include DBMS_JAVA,
> DBMS_PROFILER, DBMS_TRACE, and more. DBMS_UTILITY, DBMS_AQ, and others have
> been enhanced as well.
> * Calling Java methods from within PL/SQL -> You build simple Java classes,
> load them into the Oracle8i database, and leverage those classes from within
> your PL/SQL code.
> * A variety of performance improvements
>
> Some PL/SQL developers are uneasy about what the introduction of Java means
> to their applications -- and their programming future. But the two languages
> are expected to work well together in Oracle8i. You'll be able to take
> advantage of all the power of Java without giving up the performance and
> usability advantages of PL/SQL.
>
> Speaker: Tim Frazier, Vice President, Annams Systems Corporation – Tim
> Frazier was President (and founder) of Sunflower Systems prior to joining
> Annams Systems Corporation. He joined Annams in the wake of acquisition of
> Sunflower Systems by Annams. The Sunflower Assets is The only choice for
> state-of-the-art asset management software with many federal agencies as its
> clients.
> Tim Frazier was part of Oracle Consulting branch of Oracle Corporation
> before he left to form Sunflower Systems.
> Tim Frazier is a wizard with PL/SQL. His product Sunflower Assets is a
> marvel in the most ingenious use of PL/SQL for web enabling an application.
>
>
>
>
> |-----------------------------------------------------------------------
> | Part III - The New Face of Database Administration
> | Date: May 3, 2001
> | Time: 7:00 - 10:00 PM
> | Venue: Lobby Suite, University Union <- NOTE: Venue Change
> | California State University, Sacramento
> | 6000 J Street, Sacramento
> | (directions on website)
>
> The speaker will discuss the following topics relevant to the DBAs of the
> new world:
>
> * Partition Tables offer major performance boost for data warehouses and
> OLTP systems.
>
> * Parallel DML enables application to update, insert, delete data from
> partition tables in parallel.
>
> * Better memory management - new buffer cache management, user memory
> management
>
> * Index only tables - great for lookups in the OLTP and OLAP
>
> * Net8 - much improved performance
>
> * New Datatypes - LOB
>
> * Objects
>
> * Security and Password management
>
> * CARTRIDGES ( i.e.TIME SERIES)
>
> Speaker: Ravi Verma, Practice Manager, Annams Systems Corporation
>

---end---

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
  INET: PierceED_at_csus.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).