Appendix Z. References. ----------- Z.1 Oracle Servers -------------- Oracle Server Story by Ken Jacobs (Part 1) OM 1-2.1995 p.65, (Part 2) OM 5-6.1995 p.57 Future Directions in Database Server - A AM96#239(2-1339) Technical Overview.-By Kennet Ng, Director, Object Database Development, Oracle Corporation Рассуждения об объектно-ориентированных и объектных базах данных и осторожные намеки на то, что сейчас называется Oracle 8 Object Technology for The Oracle AM96#416(2-1453) Server: Strategy And Direction.-By Jim Trezzo, Oracle Corp. Про Oracle8, Абстрактные Типы Данных, Implementing Oracle Enterprise Manager AM96#264(2-1421) in Distributed Environment.- By Neeracha Taychakhoonavodh, Oracle Corp Краткий, но полезный обзор утилиты enterprise Manager. Advanced Oracle Performance Management AM96#515(2-1429) With the Oracle Performace Pack Applications.- By Neeracha Taychakhoonavodh, Oracle Corp. Краткое руководство по устройству и работе с утилитами, входящими в пакет Oracle Performance Pack для Enterprise Manager. Полезно. RDBMS, Development, SQL, PL/SQL... ---------------------------------- Dynamic SQL Comes to PL/SQL OM 3-4.1995 p.85 By Steve Bobrowski, Animated Learning, (Using DBMS_SQL package Good paper but the scripts need be slightly corrected) Hints & Techniques: Exploiting PL/SQL PH95p#82,v1 Features/Enhancements (2.1/2.2) Which an Application Developer Must Know.-By Prabhaker Gonglor & Rakesh Birla, Oracle Useful. Cover PL/SQL 2.1 (7.1.x) and 2.2 (7.2.x), dynamic SQL advices, debugging with procedure builder, PL/SQL Wrapper Utility, overloading(polymorphism), implicit datatypes conversion, cursor variables. PL/SQL Packages: The Mystery ad the Magic PH95p#13,v1 by Steven Feuerstein, SSC Inc. Packages' structures & shared memory architecture. (He also wrote [FEU95]) Top twenty PL/SQL Programming Tips and PH95p#37,v1 Techniques by Steven Feuerstein, SSC Inc. Some useful practical advises. (He also wrote [FEU95]) Avoiding Mutating Table Errors With PH95p#33,v1 Synthetic Constraints.-By Rory Darling, State of Alaska - Department of tranportations Very useful: How to develop: 1. Primaty keys that can be updated. 2. Foreign Key with NULL delete constraints 3. A child table which updates the parent is related with a CASCADE delete constraint relationships PL/SQL Product Update.-By Peter Vasterd, PH95p#149,v2 Oracle. Very useful. Summary of new features in 7.2 (PL/SQL 2.2) and 7.3 (2.3) including (2.2 )new debugging features , wrappers, cursor variables, DBMS_JOB package, (2.3:) tables of records and operations on them (first, last, count...), PL/SQL tables memory enhacements (B*Tree rather then hashing), RPC dependency model, server-side file I/O, new syntax for recompiling triggers... Updatable Join Views.-By Atif Chaudhry, AM96#410(2-1167) Chaudhry, Oracle. Очень познавательно. Rools for updatable views in 7.3 are described. The first paper conserning details of updatable join views. Materialized View Principle (MVP) and Operation Preservation Правила и примеры использования, как работать with check option Updadtable Join Views.-By Atif Chaudhry, PH95p#158,v2 Chaudhry, Oracle. Очень познавательно. Rools for updatable views in 7.3 are described. The first paper conserning details of updatable join views. Materialized View Principle (MVP) and Operation Preservation Using Oracle Event Processing to Faclitate PH95p#93,v2 Client Calls to Server Programs.-By Sandra K. Thrasher, Ogden Government Services. Small two-pages paper. General principles, Oracle DBMS_ALERT package. An Indepth Look at Oracle NLS PH95p#182,v2 Runtime Library.-By Georg Chang, Oracle NLS RTL is described, NLSDATA boot files (system and user) are introdused as well as other important NLS issues. Query Optimization from Desigion Support AM96#408(2-1333) with the Oracle Cost Based Optimizer Иллюстрированные преимущества оптимайзера в 7.3 по сравнению с 7.2. Занятно.