Text Server ----------- Oracle Text Server3 with ConText OM 7-8.1995 p.20 (1 page features' description) Media server ------------ Z.2 Technical Support ---------------------- Extending the Reach of Oracle7. OM 9-10.1995 p.133 By Jay Mehta, Mobil Oil Corporation (Excellent. Communication with application server via DBMS_PIPE package. Good examples clear lagnguage). Solving Oracle Data Block Corruption. OM 1-2.1996 p.106 Easy solutions for a startling Problem.-By Toon Koppelaars, ORCA Solutions. Several straightforward technicues for fixing after data block corruption. Techniques to restore data from corrupted block in the table are given. Very nice! Function Point Analysis (FPA) with OM 1-2.1995 p.115 Oracle CASE Dictionary (New aproach to software sizing & estimating) Supportlink: Online Information Service OM 5-6.1995 p.120 by John Costiner The physical Design of Oracle Databases PH95p#56v1 for storage arrays. By Bruce T. Driver, Fusion Systems Group. 1. Physical and logical constructions of the SPARCsrorage Array Model 101 and SPARCstorage volume manager 1.3 (RAID) 2. Recomendations on physical layout of an Oracle database on a storage array. Configuring Compaq RAID Technology for AM96#477(2-1381) Oracle Database.-By Jose Sanchez-Jimenez Compaq Computer EMEA, Munich, Germany Очень добротная и полезная статья. Содержит массу информации по RAID Oracle Video Server ------------------- Implementing Oracle Image Server. Storing OM 1-2.1995 p.100 and Retrieval Images With Oracle7 Just Got Easier Z.4 Oracle and Third Party Products ------------------------------- Tools: Comparative Analysys --------------------------- Join the Club and Check Out These Tools DPD 11.1995 pp.57-59 New tools easy the heavy lifting of SQL joins.- By Doug Thomson. Comparative analyzis several respects of joins in: EDA/SQL from Information Builder, Developer/2000 from Oracle, Visual Works from ParcPlace Systems (SmallTalk-based), Uniface v6 from Compuware, SQLWindows 5.0 from Gupta, PowerBuilder from PowerSoft. Disigner/2000 & PowerBuilder - hard wired to DBMS. PowerBuilder is natural-join client modelled also EDA/SQL helps to bring together data from systems of various ages and architectures. Evaluating Windows-based Tols for Oracle7. PH95p#2v1 By Earl D. Shaffer, Barron Collier partnerships. Very nice paper. How to evaluate a GUI tool for Oracle7 with different point of views. Designing Client/Server Applications - A PH95p#83v2 Comparison of PowerBuilder and CDE2. By Yori Lavi & Galia Kaufman, Levi Tech. Ltd Useful and nice paper. Write positions were chosen comparison! Product Overviews and News -------------------------- Product News OM 3-4.1996 p.17 Oracle Interoffice Suite, Release 7.3 fetures and options WG Server for Alfa NT MVS Parallel Server Options Personal Oracle Lite Oracle RDB7 CDD Repository Release 7.0 Oracle Applications Release 10SC Oracle Internet Commerce Enterprise Backup Utility for Oracle7 Oracle Applications at Rockford OM 3-4.1996 p.28 Oracle Power Objects 2.0 OM 3-4.1996 p.31 Web-Walking Discoveries.- By OM 1-2.1996 p.9 Julie Gibbs, OM editor - Oracle7 Release 7.3 OM 1-2.1996 p.17 - Oracle7 based 4-Terabyte DSS OM 1-2.1996 p.18 - Oracle WebSystem OM 1-2.1996 p.20 - Web Alliances, Partnership, and Services OM 1-2.1996 p.22 - Web Consulting, Applications,and Oracle Store OM 1-2.1996 p.22 - AT&T Delivers with Oracle WebSystem OM 1-2.1996 p.22 - Oracle WebServer to ship with SGI CHALLENGE System OM 1-2.1996 p.22 - Oracle New Media Alliance Programme, initiative, and Projects (Philips, Hitachi, NET Open Initative OM 1-2.1996 p.24 - Network Computer OM 1-2.1996 p.26 - Oracle Annonces Obsolescence of DOS Product Line OM 1-2.1996 p.26 - Oracle Access Manager for AS/400 OM 1-2.1996 p.26 - SmartStart Oracle OM 1-2.1996 p.26 - Oracle Financial Analyzer OM 1-2.1996 p.28 - Oracle TextServer Release 3.1 OM 1-2.1996 p.28 - Oracle Power Objects for Macintosh OM 1-2.1996 p.28 - Oracle Internet Sequrity OM 1-2.1996 p.30 - Designer/2000 and Developer/2000 Release 1.2 OM 1-2.1996 p.30 - Oracle Education for Blind Students OM 1-2.1996 p.30 - Home savings of America Wins Oracle Awards OM 1-2.1996 p.28 Oracle Enterprise Manager by OM 11-12.1995 p.17 Mark Jarvis. Consists of programmable Intelligent Agent Nerve Center communicating with Oracle7 Server via SQL*Net and Management Console communicating with Agent anf providing GUI interface. All the SMTI Member are also supported. EM will ship with 7.3. For basic database administration and software distribution- free og charge. Advanced features (performance tuning, monitoring, and diagnostics) for additional price. Oracle Online Analytical Processing (OLAP) OM 11-12.1995 p.22 products: - Oracle Express EIS, - Oracle Express Analyzer, - Oracle Financial Analyzer, - Oracle Sales Analyzer. For any platform. Oracle Applications Release 10SC OM 11-12.1995 p.20 Oracle's Applications Software Taps OM 11-12.1995 p.20 Internet. Introduces Oracle Internet Commerce & Oracle EDI Gateway. Oracle Delivers Decision Support with OM 11-12.1995 p.22 the Oracle Applications Data Warehouse.- by Peter Heller OM 11-12.1995 p.22 Oracle Translation Manager OM 11-12.1995 p.22 Oracle Video Server For the OM 11-12.1995 p.24 Enterprise Environment Developer/200 & Designer/2000 for OM 11-12.1995 p.24 Windows 95 (and also for Windows NT 3.51) Oracle Discoverer/2000 ad hoc Query and OM 11-12.1995 p.26 Analysis Tool: Data Query for end user and Data Browser for power user Workgroup/2000 Available on Compuserve OM 11-12.1995 p.28 Oracle & Compuserve sign Distribution agreement. Oracle Object MArketplace on the WWW- OM 11-12.1995 p.28 for companies who wish to develop and deploy applications usion OPO. Sixteen Companies Form Object-Definition OM 11-12.1995 p.26 Alliance (ODA) Oracle Enterprise Imaging/Workflow Products OM 11-12.1995 p.30 Dicoverer/2000, OLAP (Online Analytical OM 9-10.1995 p.22 processing) tools, MultiDimension, Oracle7 TextServer, Designer/2000, Developer/2000 WEB-Based support, Oracle/Rdb, Oracle OM 9-10.1995 p.30 Magazine Interactive OM 9-10.1995 p.92 Oracle Introdiuces Oracle7 Release 7.2 OM 7-8.1995 p.15 (Brief list of new 7.2 features) Developer/2000 & Designer/2000 OM 7-8.1995 p.17 Software Suits Oracle Power Objects OM 7-8.1995 p.18 Oracle Media Objects OM 7-8.1995 p.18 Oracle Text Server3 with ConText OM 7-8.1995 p.20 (1 page features' description) Oracle Gateways Enable Applications OM 7-8.1995 p.22 to Access All Data (EDA/SQL, DB2/400 RDB and related Business OM 7-8.1995 p.22 Oracle Announces Availability of OM 7-8.1995 p.24 Oracle7 Workgroup Server for UNIX Oracle Workgroup/2000 OM 3-4.1995 p.13 (OO for OLE, Personal Oracle, SmartStart ...) Oracle Book 2.2, SDK OM 5-6.1995 p.16 New Transparent Gateways for Sybase, OM 5-6.1995 p.16 Informix and Ingres SNMP - Simple Network Management Protocol OM 5-6.1995 p.16 Oracle Workgroup Server for Solaris X86 OM 5-6.1995 p.18 Expanding Internet Distribution Service OM 5-6.1995 p.18 for WG/2000 Products Oracle MultiDimension Extension to Oracle7 OM 5-6.1995 p.20 Oracle Office 2.1 OM 5-6.1995 p.24 Server manager replces SQL*DBA OM 5-6.1995 p.24 Oracle Data Query 4.0 OM 5-6.1995 p.26 Networking and client/server ---------------------------- Client/Server Administrator Security.-By OM 11-12.1995 p.91 Steve Bobrovski, Animated Learning. Nice small paper. User-authentification option, Privileged administrative connections, ORAPWD utility, SYSOPER and SYSDBA privileges, starting a privileged-administrative connection. Troubleshooting Client/server Network OM 11-12.1995 p.108 Problems.-By Paul Jackson, formerly in Oracle, now at the Wharton School of Business Oracle Client/Server: Configuring OM 5-6.1995 p.87 Your System, Part 1. By Steve Bobrowski, president of Animated Learning (Very good paper. Network Manager is described. Disabling automatic interprocess communication is mentioned. Starting of listener is discussed, dead connection detection (keep alive) interval SQLNET.EXPIRE_TIME = 10 is introduced) Oracle Client/Server: Configuring OM 7-8.1995 p.81 Your System, Part 2. By Steve Bobrowski, (Very good paper. Multi-threaded server. Troubleshooting tips. The procedure to monitor the configuration of Oracle Server MTS is given) SNMP for Dummies.- Perry J. O'Neil PH95p#95v2 SNMP basics are introdused. Fine! Developer's Materials --------------------- Oracle Developer from PINNACLE OM 9-10.1995 p.73 Newsletters on Developer/2000 and Designer/200, PL/SQL .... Media - discettes, $149 (+$50 later on) Developer/2000 -------------- OLE and Developer/2000 OM 3-4.1996 p.61 By Teck Choo Tan, Oracle Customize Developer/2000 Applications OM 11-12.1995 p.66 Using VBX Custom Controls for Microsoft Windows Calling Stored Procedures from Oracle OM Fall 1994 p.125 Forms. By Cris Lunt, Oracle Very useful small paper. Covers forms 3 & 4 and provides detailed description how stored procedures shouldbe called from SQL*Forms. Steve Muench made contribution to this paper. FAQ on FORMS 4.0.13 by Ben Wright OM 1-2.1995 p.113 FAQ on Oracle Graphics 2.5 by OM 3-4.1995 p.83 Ivan Chong, Oracle (Ansvers to 2 questions) FAQ on Oracle Reports. OM 5-6.1995 p.119 (conversion utilities from SQL*ReportWriter to Oracle Reports) FAQ on Oracle's Procedure Builder OM 7-8.1995 p.96 and Developer/2000 (4 answers) FAQ on Developer/2000 (Libraries) OM 9-10.1995 p.141 (1 question) Oracle Forms 4.0: Minimizing OM 3-4.1995 p.65 Client/Server Network Traffic Creating Flex Fields in Oracle Forms. OM Fall 1994 p.119 By Chuck Weiss, Oracle Object-Oriented Programming in OM 5-6.1995 p.75 Oracle Forms 4.5. By Ben Wright, Oracle (It should be called "Pseudo Object Oriented". How to emulate all the object-oriented properties (inheritance, object reuse, encapsulation, modularity and polymorphism) in Oracle Forms 4.5) Procedure Builder ----------------- FAQ on Oracle procedure Builder OM 3-4.1995 p.89 by Ivan Chong, Oracle (3 answers) FAQ on Oracle's Procedure Builder OM 7-8.1995 p.96 and Developer/2000 (4 answers) Oracle Server Manager by Steve Bobrowski, OM 1-2.1995 p.97 Oracle (The overview) Oracle Network Manager --------------------- Oracle Client/Server: Configuring OM 5-6.1995 p.87 Your System. By Steve Bobrowski, president of Animated Learning (Very good paper. Network Manager is described. Disabling automatic interprocess communication is mentioned.) Designer/2000 ------------- Oracle Designer/2000 Visual Basic OM 1-2.1996 p.73 Generator.- By Mike Gwyer, Oracle UK A Simple Case for Designer/2000 OM 9-10.1995 p.105 by Steve Bobrowski, Oracle (Good introduction to CASE) Bringing th Gap. By Mary Ann Conroy OM 7-8.1995 p.65 (How to manage and improve existing application developed without Oracle Case using Oracle Case. Technique to re-engineering existing packaged applications into case repository. Good paper.) Function Point Analysis (FPA) with OM 1-2.1995 p.115 Oracle CASE Dictionary (New approach to software sizing & estimating) Oracle Power Objects -------------------- Developing Applications Using Oracle OM 9-10.1995 p.81 Power Objects by Matthew Bennett (Good beginner's guide) Accessing Legacy Data with Oracle OM 11-12.1995 p.98 Power Objects. On Mainframes Microsoft Access ---------------- How Sweet It Is - Microsoft Access and PH95p#6v1 Oracle.-Bt Bradley D.Brown, The Ultimate Software Consultunts Very useful practical guide on connections and features Access and Oracle via ODBC PowerBuilder (Powersoft) ------------------------ Power Builder and Oracle - The inside Story PH95p#52v1 by Bill Rabkin & Scott Marlow, Powersoft Corporation. Very interesting for powersoft developers Oracle World Wide Web --------------------- Oracle WWW Interface kit. Tools for OM 5-6.1995 p.15 Harnessing the Internet. WWW Address: http://wwworacle.com/ OM 5-6.1995 p.54 How tio Build Web Applications OM 1-2.1996 p.86 Using Oracle7 and Oracle WebServer WebMaster in untangling the Web: OM 1-2.1996 p.33 Busting Five Myths about Internet and the World Wide Web OM 1-2.1996 p.34 Tour the Internet! OM 1-2.1996 p.38 Four Short Stept to the Internet OM 1-2.1996 p.39 The Internet: An Overnight Star? OM 1-2.1996 p.41 The Oracle Web System! Launch OM 1-2.1996 p.42 your own WEB Applivcations. Spin your Own Web OM 1-2.1996 p.44 Finding the right Webmaster! OM 1-2.1996 p.46 Oracle Web Alliance OM 1-2.1996 p.48 Oracle Media Objects -------------------- Oracle Media Objects Available over the OM 9-10.1995 p.28 Internet Oracle Objects for OLE ---------------------- ODBC ---- Understanding ODBC Beyond What the Acronim PH95p#4,v1 Means. By John Molinaro, Sargent & Lundy L.L.C ODBC Features, differencecs between ODBC drivers. ODBC ABC's - Connecting Windows to Oracle PH95p#124,v2 By Thomas Harleman, Paradigm Consulting, Inc. Nice and clear paper. Oracle in Motion ----------------- Oracle Media Objects -------------------- SIDONA ------ Gateways -------- Oracle Transparent Gateway for EDA/SQL OM 5-6.1995 p.116 by Sherie Bernandez, Oracle (The gaytway provides read access to data residing in 15 mainfraim datastores including ADABAS, CA-DATACOM, CA-IDMS, FOCUS, IMS, Infoman, ISAM, Model 204, QSAM, SAP, SUPRA, SYSTEM 2000, Teradata, TOTAL, and VSAM) Oracle Financials ----------------- Global Bookkeppeng. Oracle Financials and OM 1-2.1996 p.81 Foreing Currency Accounts Oracle RDB ---------- Oracle RDB: Round-the-clock Reliability. By OM 5-6.1995 p.109 Ian Smith Using Storage Technology Products with your Oracle Rdb Database.-by Katherine Oakey, Oracle RDB Using of RAIDs in RDB Third Party (Value Added) Tools -------------------------------- Oracle Value Added Initiatives ---------------------------- Oracle Warehouse Technology Initiative OM 9-10.1995 p.150 (WTI) CASE & Data modelling------------------------------------------ ERwin from Logic Works OM 3-4.1995 p.109 (ERwin for Oracle CASE and OM 9-10.1995 p.95 ERwin/ERX 2.0) OM 5-6.1995 p.21 OM 7-8.1995 p.23 Silverrun from Computer Systems Advisers ARGUSSOFT Topcase. Special Support for Oracle S-Designor from SDP Technologies, Inc OM 9-10.1995 p.34 OM 5-6.1995 p.42 One page advertising OM 7-8.1995 p.29 OM 11-12.1995 p.14 INCOME from PROMATIS Informatik OM Fall 1994 p.137 Tools for modelling, simulating and developing business processes DBStar Migration Architect from DBStar, Inc. OM Fall 1994 p.137 Transforms any legacy databese model to mathematically correct relational model Database Illustrator from Ray Ontko & Co. OM 5-6.1995 p.126 DBA---------------------------------------------- Platinum DBA Tools from Platinum OM 1-2.1995 p.122 Technology - EasyDba UNIX, VMS, OS/2 OM 9-10.1995 p.25 - Desktop DBA (cross-server administration) OM 9-10.1995 p.37 OM 11-12.1995 p.121 - DBVision (Monitoring & performance OM 9-10.1995 p.153 tuning, problem prevention automated storage management cross pltform support, graphical interface) - DB-Alert (alarm notification) OM 9-10.1995 p.153 - SQL Spy (Monitoring) OM 9-10.1995 p.31 - SQL Coder (development environment) OM 9-10.1995 p.103 OM 7-8.1995 p.105 - UniVision 2.1, AutoSys, AutoSys/Xpert OM 9-10.1995 p.148 UNIX Environment performance & monitoring tools - ProReports OM 11-12.1995 p.14 - TSreorg OM 11-12.1995 p.15 OM 1-2.1996 p.25 - Comlete set at $1,995 OM 1-2.1996 p.21 MetaSUITE from BMC Software OM 9-10.1995 p.21 MetaDesk &M etaManage OM 7-8.1995 p.100 PATROL - top-down view of diverse OM 11-12.1995 p.122 application OM 1-2.1996 p.19 OM 1-2.1996 p.27 MetaQueue from Metasys OM 11-12.1995 p.119 SQL*Trax from TurnStone Software, OM 11-12.1995 p.82 The Database Utility Company. OM 9-10.1995 p.85 (Various statistics, Debug PL/SQL and OM 7-8.1995 p.55 triggers, UNDELETE ROWS,...) Log Analyzer for Oracle7 (SQL*Trax) OM 5-6.1995 p.27 DFRAG from ARIS corporation OM Fall 1994 p.143 Defragmentation and space management utility for Oracle7 including index OM 9-10.1995 p.63 deragmentation OM 11-12.1995 p.21 Training from ARIS OM 1-2.1996 p.31 MetaCube Family of Products OM 5-6.1995 p.125 from Stanford Technology Group. (Informix) OLAP, Tracking quueries and so on (President - Kirill Shenkman) SQL*Studio V2.0 OM 7-8.1995 p.10 OM 11-12.1995 p.12 OM 1-2.1996 p.23 Job Control System (JCS) from Redwood OM Fall 1994 p.135 Business Group. Can be intergated in Oracle Forms applications LDM/XP - Migration and Management OM Fall 1994 p.135 tools from Legent ACE*Insight (Tuning) FORMS 4 Based OM 9-10.1995 p.154 ACE*Tester FORMS 4 Based OM 9-10.1995 p.154 ACE*Timer (Response time) - FORMS 4 Based OM 9-10.1995 p.154 WatchWorks from MITI OM Fall 1994 p.139 Monitoring and alerting tools and resources accounting SQR3 Workbench from MITI OM 3-4.1995 p.110 (Report writer) OM 9-10.1995 p.64 OM 11-12.1995 p.19 HighView from Highland Technologies OM Fall 1994 p.135 Imaging and workflow appl. system OM 7-8.1995 p.103 for Win SQL/ADMIN. Three utilities for DBA OM 1-2.1995 p.127 from Mike Parker & Associates OpenV*SecureMax from OpenVision OM Fall 1994 p.133 (Security management tool) Password Management Software OM Fall 1994 p.133 from BrianTree SQL<>Secure by BrianTree OM 3-4.1995 p.95 SQL<>Secure v4 OM 11-12.1995 p.115 DISKEEPER from Exclusive Software OM 3-4.1995 p.109 Online disk defragmenter for OpenVMS and Windows NT on DEC's VAX and Alpha Alexus Vehicle Maintenance System OM 3-4.1995 p.109 from Support Technologies (Win based network cost tracking Fall 1994 p.133 system). Safe C Rutime Analyzer and QA C OM 3-4.1995 p.110 from ASTA (Software -alalyzis and -testing system) OM 3-4.1995 p.110 COPERNCUS. Data-format translation OM 1-2.1995 p.124 program from New Paradigm Software AdHawk from EVENTS software OM 9-10.1995 p.27 (Database monitoring and problem's OM 7-8.1995 p.43 identification) DBTUNE (Automatic tunung tool) and OM 9-10.1995 p.29 Control Center OM 5-6.1995 p.123 from The Database Solutions Company OM 7-8.1995 p.61 EcoTools from Compuware OM 9-10.1995 p.33 Tools for database, network and OS balancing in client/server env. DBA-XPERT from Compuware OM 9-10.1995 p.145 (control of development, maintenance OM 11-12.1995 p.25 and security) OM 1-2.1996 p.29 Inspect/SQL, Analyze/SQL from Precise OM 9-10.1995 p.83 Software Slutions, Inc. (Database performance analysis and tuning) WatchWorks from Eventus Software OM 5-6.1995 p.125 (Event monitoring and expert-advice software) AdHawk Spacer (Tablespace reorganization) OM 7-8.1995 p.103 Network General with Expert Sniffer OM 9-10.1995 p.69 from Network General Can fin out network problems including SQL*Net SQL-BackTrack from DataTools OM 9-10.1995 p.148 Backup & Recovery tool OM 11-12.1995 p.80 DBGENERAL's Table Space manager for OM 5-6.1995 p.126 Oracle from Bradmark Computer Systems DBGENERAL's Database Console: performance management, Tablespace management, Object management CheckMate from Bit by Bit OM 5-6.1995 p.21 (archiving and more) DBView reengineering Tool from OM 11-12.1995 p.114 Infology TUSC Consulting company (SQR, SQL*Studio, OM 11-12.1995 p.8 Designor) DBScope from The Database Solution OM 11-12.1995 p.119 Company. Oracle Monitoring and configuration manager Development Tools----------------------------------------- KUMARAN Systems, Inc. GUI*Converter from forms2/3 OM 9-10.1995 p.107 to forms 4.5 Impromptu from Cognos OM 9-10.1995 p.75 (Report writer) Forest & Trees from Trinzic Corporation OM 9-10.1995 p.89 Simple ad hoc query & reporting InfoPump (replication Software) OM 7-8.1995 p.47 OSF/Motif based products from OM Fall 1994 p.137 Bluestone Consulting (Development environment, Cross platform Toolset) dbViewer - a browsing and editing tool OM 5-6.1995 p.126 Pro/Helpdesk from Prolin OM 3-4.1995 p.111 (FORMS base problem solving, improving management application) R&R report writer from Concentric Data Systems Parasoft's BenchWorks OM 1-2.1995 p.121 Acu4GL from Acucobol IntelligenceWare products OM 1-2.1995 p.127 NeXT's Enterprise Objects Framework OM 3-4.1995 p.108 (object-building software) OM 7-8.1995 p.103 SQL Power Plan Analyzer from OM 9-10.1995 p.135 SQL Power Tools (Explain Plan graphic analyzer Statistics analyzer Index Analyzer SQL Impact Analysis Browser, Documenter ... ) SQL Power Tools from the Development OM 5-6.1995 p.105 Group for Advanced Technology, Inc. (Documentor, Impact Analysis, Migratior, Deadlock predictor) SQL-BackTrack from Admiral Software OM 5-6.1995 p.112 Limited. (Backup/recovery tools) GEO/SQL from Geo/SQL corporation OM 5-6.1995 p.125 (GIS, database management and mapping software) RunHost from Useful Technology OM 5-6.1995 p.126 (Permits Forms 4.x based application initiate and get return from UNIX processes performes on the server WorkTech Reporter from Work OM 5-6.1995 p.126 Technology (internal-report-writing-tool) Application Manager from MORE Systems OM 7-8.1995 p.77 (managing database and Application Security) DemoSHIELD from Stirling Technologies OM 5-6.1995 p.126 (Visual development tool) 7000 Series Network Probe from Network Communications (A point-to-point protocol option) NetMagic from NetMagic Systems OM 7-8.1995 p.101 SequeLonk from TechGnosis OM 7-8.1995 p.49 (high performance connection to many databases, middleware) Oracle Mobile Agent & Radio Agent OM 7-8.1995 p.101 from RAM Mobile Data Actio Request (AR) from Remedy OM 7-8.1995 p.102 Corporation Vantage software from Vanier OM 11-12.1995 p.115 Electronic Data Interchnge, catalogs ... Win-Doc - imaging and file-management OM 11-12.1995 p.119 system, from Capital Technologies Integration SPM+Open - software for online OM 11-12.1995 p.119 statistical process control (SPC) from Salerno Manufacturing Systems DSS tools----------------------------------------------------- DSS Agent 3.0 product line OM 11-12.1995 p.115 from Microstrategy Data Query & Data Pivot from OM Fall 1994 p.139 Brio Technology BrioQuery from Brio Technology OM 3-4.1995 p.108 (Win and MAC based full-featured query, OM 9-10.1995 p.23 analysis and reporting tools. ODBC, SQL*Net) Intelegent Query (IQ Software) OM 1-2.1995 p.121 IQ Access. Permit user managing. OM 9-10.1995 p.6 OM 5-6.1995 p.48 OM 11-12.1995 p.10-11 SQLASSIST from Software Interfaces, Inc. OM Fall 1994 p.141 X/Motif Based ProReport & ProServer from Platinum OM 9-10.1995 p.148 Software Interfaces, Inc. FindOut! fromOpen Data Corporation OM Fall 1994 p.137 DSS (Desision Support) products ImageNet from Technology, MAnagement, & OM Fall 1994 p.139 Alalysis. Document Management products PLEXUS XDP. Imaging software from OM 1-2.1995 p.124 RECOGNITION INTERNATIONAL. SQL*VOX. Voice processing system from OM 1-2.1995 p.124 Minglewood Data Systems EMPOWER/CS - New client/server load OM 1-2.1995 p.125 testing tool from Performix Business Objects from Business Object OM 11-12.1995 p.31 Business-intellegent queries Log Excellerator Family from OM 11-12.1995 p.116 Database Excelleration Systems SCSI-base UNX subsystem. Transaction logging onto Solid State Disk (SSD) PROtecTOR from SEEK Systems OM 11-12.1995 p.119 ZDC from Zitel OM 5-6.1995 p.126 (an intelligent data-management subsystem) ARGUS Professional 4.0 and OM 11-12.1995 p.119 ARGUS Census Map USA from Argus Technologies Data Visualization sw. BP*Link from Brouwer Palmer & Associates OM 11-12.1995 p.119 Reads bar-code and keeps track of inverntory, costs, nd production in a manufacturing-type environment Packaged Applications------------------------------- Siebel Sales Information System OM 1-2.1995 p.122 OM 9-10.1995 p.10 Sales Information Response system OM 11-12.1995 p.116 from Data System Supportt Total Sales Quality (TSQ) from OM 11-12.1995 p.6,7 Siebel & Andersen Consultilg MCS-II from HSBRT OM Fall 1994 p.131 Maintenance Management system for large industrial plants) Nordic Charts from Nordic Systems OM 3-4.1995 p.110 (Oracle Base accounting and manufacturing system. Runs on more then 100 platforms) SQL*TIME. Financial application from OM 1-2.1995 p.124 Minglewood Data Systems Relese for Oracle Forms 4.5 OM 5-6.1995 p.125 Minglewood Data Systems bacame Design Data Systems Financial, Project Management, OM 11-12.1995 p.2,3 Distribution, SQL*Time CONTROL from KCI Computing OM 3-4.1995 p.110 (Tool for Oracle Financials) Voyant from Brossco OM Fall 1994 p.131 DSS system SupportTrak from Aurum Sofware OM Fall 1994 p.137 Customer service and quolity management OM 7-8.1995 p.103 TeleTrak, QualityTrak (customer support, quolity tracking) EMIS - Enterprise Management Information OM 1-2.1995 p.125 system from ESI/Technologies Vantive System 3 fromVantive OM Fall 1994 p.141 Customer services software SQL*Operator from ISA Corporation OM 9-10.1995 p.116 (Output management, batch scheduling, backgroung processing) SQL*Operator v4.1 OM 11-12.1995 p.114 ALCIE from ORANGE Systems OM 9-10.1995 p.119 (CASE based Financial Software) enterprise MPAC from TSW international OM 5-6.1995 p.102 Chalkboard from Breckenridge Software OM 7-8.1995 p.100 (Brokiring service) SPS/Oracle7 from Saratoga Systems OM 7-8.1995 p.102 (account-management and sales information software) Vantive Rnterprise from Vantive OM 7-8.1995 p.102 Corporation (Sales) CustomerFirst from Repository OM 7-8.1995 p.102 Technologies (Inventory-management) Executive Information System from OM 7-8.1995 p.103 Staffware Visual Information Manager for OM 7-8.1995 p.103 Macintosh from Apreture Technologies ClearExpress WebSupport from Clarify OM 7-8.1995 p.103 VentoMap and VentoSales from OM 7-8.1995 p.103 Vento Software GENESYS Enterprise Series from OM 7-8.1995 p.103 GENESYS Software Systems (Human Resource management) PayFlo from TRW Systems Integration OM 11-12.1995 p.103 Group. Intehrates Oracle Payables with FileNet's Imaging and Workflo ARSPAP system accounting software from GEJAC Multi-vendor DBMS Intergration---------------------------------- Replic-Action from Csahl Technology OM 9-10.1995 p.145 Composer + server. Bidirectional synchronization on a scheduled basis Prism Warehouse Manager and Directory OM 9-10.1995 p.146 Manager from Prism Solutions Generates codeto extract data from sourvces databases, Integrates data from various sources and then transforms and loads to the target database ReTarGet from Rankin Companies OM 9-10.1995 p.146 Data-migration from legacy. macControl from Breitschwerdt OM 5-6.1995 p.123 Information Systems EIS/DSS on Apple Macintosh TOP OF MIND from The Molloy Group OM 5-6.1995 p.126 ( A customer-service application) Catalyst Warehouse Management System OM 5-6.1995 p.126 (WMS) from Catalyst Notrix Composer from Percussion OM 7-8.1995 p.101 Software Z.3 Platforms --------- DESKTOP ------- Configuring and Tuning Oracle7 Server OM 3-4.1996 p.101 for Windows NT by Jeff Plank, Compaq Useful with Windows NT point of view Data Warehousing for Workgroups. By OM 1-2.1995 p.109 Marilyn Schneider, Oracle (How to snapshots, links in workgroup servers. Object manger. Useful paper) The enterprise on Your Desktop OM 9-10.1995 p.127 Crossing information chasm, (Part 1) By Mani Subramanyam, Oracle Desctop (Interesting. Using teleprocessing monitors (TP Monitors) The enterprise on Your Desktop OM 11-12.1995 p.103 Crossing information chasm, (Part 2) By Mani Subramanyam, Oracle Desctop Integrating Desktop Into the OM 5-6.1995 p.9 enterprise. By Timoty O'Brien General Drections From the Desktop Working Concert OM 5-6.1995 p.30 to the Data Center By Kelli Wiseth (Future of enterprise organizational structure) UNIX ---- UNIX Clustering Technology. By Hrishi OM 1-2.1995 p.103 Kamat, Oracle. (Using OPO. Sequent, Piramid, IBM, AT&T, DG, HP, SUN, DEC support clusters on UNIX. Using for fault tolerance) SUN Solaris & SUN/OS -------------------- Performance Tuning and Optimization PH95p#165v2 for SUN Solaris.-By Michael Sakayeda, Oracle. New features on Solaris are discussed: Asynchronous I/O , KAIO, Presd(2)/Pwrire(2), O_DSYNC, Nanosleep, 2GB file support, Mapfiles, ISM, Processor Affinity, Real time, Block Size, Large SGA, Dynamic Shared Objects, Post/Wait Driver, Direct I/O-kernel driver (replacement for raw devices) Shared Libraries in Sun Systems. -By AM96#519(2-1413) Gautam Singhal Преимущества и недостатки shared libraries фирмы SUN Personal Oracle --------------- Personal Oracle7 for Windows OM 3-4.1995 p.100 By Liff Stengaard Thomas, Oracle (Overview) Personal Oracle Enterprise Edition OM 9-10.1995 p.32 7.1.4. Includes distributed option, requires 12M RAM, Extension of PO Standard Edition. Contains OO for OLE, ODBC, SQL*Plus, SQL*Net, GUI Administration Tools (DB Manager, User MAnager, Object Manager, Session Manager, DB Expander, Backup & Recovery Manager, SQL*Loader, EXP/IMP) NetWare ------- Configuration and Tuning Oracle7 OM 5-6.1995 p.95 for NetWare. By Bryon Georgson, Compaq (Excellent! Plenty of useful advices!) Managing Oracle7 in NetWare Environment OM 7-8.1995 p.92 By Earl Shaffer, DBA at Barron Collier Partneships. (Good complement to previous paper, backup/recovery, mirroring...) Oracle Server for NetWare - the Next OM 5-6.1995 p.103 Generation. By Larry Robinson, Oracle (SMP, AMP for NetWare, Good paper, Very Interesting). OS/2 ---- IBM's OS/2 WARP Is Truly Client/Server OM 7-8.1995 p.95 By Jagdish Pammani, Oracle. (WARP architecture and future are described. Interesting.) UnixWare, SCO, Solaris x86 -------------------------- Tuning Oracle for Low End UNIX AM96#166(2-1355) Systems.- By Rajesh Radhakrishnan, Oracle Corp. Регулировка для SVR4 based systems: SCO Unix Ware, Solaris X86 Unisys SVR4 и для SVR3 систем: SCO OpenServer Полезна для обладателей этих систем. Затрагивает мультипроцессорную обработку Configuring and Tuning Oracle7 for OM 9-10.1995 p.117 SCO UNIX on Compaq Servers. Digital Platforms ----------------- Digital's AdvantageCluster Architecture OM 3-4.1995 p.98 Oracle Takes Advantage of 64-bit OM 5-6.1995 p.111 Technology. By John Nordlinger, Oracle (Small but very informative 1 page paper) Oracle7 64-Bit VLM Capability Makes OM 7-8.1995 p.89 Digital UNIX Transactions Blazingly Fast. By John Nordlinger, Oracle (Large system global area and big Oracle blocks (BOB) on 14Gb Alpha) OpenVMS ------- Digital UNIX (OSF/1) -------------------- DEC OSF/1 Cluster Configurations. OM Fall 1994 p.103 By Bonnie Crater, Oracle IBM S/390, MVS Mainframes ------------------------- Oracle7 and OpenEdition MVS OM 3-4.1996 p.95 An Easy Way to Port Your UNIX Applications to The MAinframe By Ti Payne, Oracle The Mainfraim As Data Warehouse OM 1-2.1995 p.100 The third paper in S/290 series Accessing Legacy Data with Oracle OM 11-12.1995 p.98 Power Objects. Oracle7 and OLTP on the S/390 Parallel Mainframe OM 3-4.1995 p.90 Parallel Systems Management OM Fall 1994 p.97 By Bruce Olsen, Oracle (Oracle7 on S/390) Oracle for MVS Client Solution OM 9-10.1995 p.32 Parallel Query Option Performance OM 9-10.1995 p.111 by Barry Perkins, Oracle (IBM MVS oriented). Opening Up the Mainframe by Bruce OM 7-8.1995 p.86 Olsen, Oracle. (MLS in Arabic, I18N + L10N) Z.5 Scientific and General Issues, Methodology ------------------------------------------ OLAP and Data Warehousing ------------------------- Data Warehouse, Building Blocks for OM 3-4.1996 p.34 the Next Millenium Survey of diractions. Oracle approaches to warehousing Designing a Database for OLAP OM 3-4.1996 p.83 A step-by-Step Guide to Using Oracle Expresss, By Dave Menninger Data Warehousing and Parallel OM 5-6.1995 p.97 Processing on Desctop Systems.- By Steve Bobrowsky, Animated Learning WWW Issues ---------- How to Use Web Technology for OM 3-4.1996 p.89 Building Client/Server Database Applications by Steve Bobrovski, Animated Learning More or less, but useful anyway Development ----------- Moving Domain Processing to AM96#349(1-601) Server Side.- By Dimitri Bezrukov FORS, Moscow Обзор средств Oracle для поддержки referential constraints и business rules. Может быть полезен для начинающих. Кроме того, затрагиваются проблемы разработки приложений с переносом существенной части логики на сервер (database end). Рассматриваются проблемы оптимизации путем замены join функцией при обработке простых справочников (domains или lookup tables). Полезно также посмотреть, как работать с job queues и dynamic DDL. К сожалению, я пытался уложиться в 12 страниц и. как показали дальнейшие события, совершенно зря. В реальной жизни примеры триггеров, представленные в appendix A следует дополнить кодами для блокировок строк в мастер-таблице (select for update of) при изменении таблицы-детали (см. следующую статью) Business Rules: All You Need to Know AM96#089(1-615) When implementing Them. -By Toon Koppellaars, Amsterdam Очень полезная для разработчиков и дизайнеров статья. Тон - серьезный ученый и у него своя теоретико-множественная модель данных - очень простая и симпатичная. Эта статья в некотором роде дополнение предыдущей про особенности реализации referential integrity в Oracle. Особенно следует обратить внимание на необходимость блокировок данных при реализации referential integrity через триггеры (в предыдущей статье Безрукова это, к сожалению, отсутствует). Обратите внимание на восклицательные знаки, которыми отмечены наиболее важные места. Rapid Application Development. By Dennis OM 1-2.1995 p.79 Moore. (Consepts, advices...) Extending the Reach of Oracle7. OM 9-10.1995 p.133 By Jay Mehta, Mobil Oil Corporation (Excellent. Communication with application server via DBMS_PIPE package. Good examples, clear lagnguage) Methodology ------------ Total Performance Management (Part 1) OM 5-6.1995 p.83 by Craig Shallahammer. (Holistic approach to performance management. Too mach water.) Total Performance Management (Part 2) OM 7-8.1995 p.75 by Craig Shallahammer. (Several tool that help UNIX performance specialist are mentioned) Oracle Applications ------------------- Time To Clean House: How to Audit OM 3-4.1996 p.71 and Clean Up Your Oracle Applications Data Conversion from Legacy Systems to OM 1-2.1995 p.85 Oracle Applications. By Anne Blaylock & Walt Zerkow, Oracle (Big technical paper, some good advices) The Logical Shell Games OM 3-4.1995 p.75 By Michael Sanders, Oracle (A new world of IS Management and control Using Global Registers to Integrate OM 9-10.1995 p.87 Your Enterprise Information System By Cedric Dettmar, Oracle. (Some useful recommendations how to develop enterprise's shared master list of reference information helping to intergate legacy applications into Oracle and intelligently manage the enterprise) Strategies and Techniques for Using OM 9-10.1995 p.97 Oracle7 Replication: Part 1 by Dominic J. Delmolino, Oracle Consulting SMP, Clusters, Messively Parallel Archtectures ---------------------------------------------- SMP or Massively Parallel Processors OM 3-4.1995 p.94 By Henry Robinson, Pyramid Technology Object Orientation ------------------ Relational Object Bases. OM 1-2.1995 p.81 By Hugh UJhazy, Malaysia Operation Environment -------------------- How Big Is your Database? OM 5-6.1995 p.113 (Surveys of Oracle based production system sizes, number of user ...) Miscellaneous Issues --------------------- Metadata Hullaballo OM 3-4.1995 p.11 By Wayne Eckerdon, Open System information. Surway of warehousing metadata Managing Change by M. Miley, Sun Francisco OM 11-12.1995 p.35 based writer. A big paper for computer executive. A Strategic Approach to Mission-Critical OM 9-10.1995 p.37 Applications by Philip J. Gill, San Diego freelance writer. (A big clever paper) Distributed-Enterprise Chellenges OM 7-8.1995 p.11 (Scalability, Productivity,...) Distributed Enterprise, Thorny Problems. OM 7-8.1995 p.36 Intellegent Solutions. By Paula Borsook. (Network topologies, tactics for managing replicated data, mobil lines security problems. There are many interesting clips inside the paper) Data Warehousing: Rehashing Desigion Support. OM 1-2.1995 p.9 By Kevin Strange, Gartner Group. The True Nature of a Data Warehouse. By OM 1-2.1995 p.128 Wayne Eckerson, Patricia Seybold Group. (Small and clear paper). Oracle7 Release 7.1 Parallel Everything OM 1-2.1995 p.38 Architecture. By Kelly Wiseth. (Introduction, Tools of the Trade, Warehouses) Beyond the Data Warehouse. By Robert OM 1-2.1995 p.40 Tuttle, AT&T. (Concepts and future, small paper) Seven Steps to Building a Data Warehouse OM 1-2.1995 p.43 (Guide to planning and building the data warehouse) Z.7 Oracle Applications ------------------- Oracle Application Release 10SC OM 9-10.1995 p.19 Oracle Applications Release 10SC OM 11-12.1995 p.72 New Architecture Streamlines Business Processes Z.8 Banking and Other Success Stories --------------------------------- Money on the Line OM 3-4.1996 p.46 by Ken Siegman Dutch Ministery of Finance moves to OLAP to Manage Nation's Financial information The Data Bass by Rebecca Hicjman Beer industry in UK. Oracle in Bass Tavern Ship Shape. Oracle System Provides Smooth OM 1-2.1996 p.58 Sailing for Busy Ney York/New Jersay Seaport Banking on Quality OM 7-8.1995 p.52 Belgian Kreditbank choose Oracle for customer support) Money in the Bank OM 1-2.1995 p.52 (CDE in the First National Bank of Chicago (FNBC)). The French Collection (Oracle in french tax services) OM 9-10.1995 p.58 Tracking Crime on the Desktop OM 5-6.1995 p.40 Oracle Based Police System Open Sesame.-By Chris Rauen OM 11-12.1995 p.50 McDonald's Arrgentina The House that Mosprivat Built OM 5-6.1995 p.51 Oracle in Mosprivatizaciya, Moscow Equipping Contractors in the OM 5-6.1995 p.38 Heartland. By Joel N. Sburkin An Oracle Based desctop system matches buyers and sellers of heavy equipment at Heartland Communications. The Rebuilding Mission: Ahlsell AB OM 9-10.1995 p.46 Oracle in Sweden largest building-supply wholesaler company. Driving the Open Road. OM 9-10.1995 p.52 Ford Motor Company uses Oracle7 based software to build a technology infrastructure. World Watch. By Michael Miley. OM 7-8.1995 p.44 (Oracle based system in INTELSAT. the largest commercial satellite service provider) Z.9 User Groups ----------- Integration Oracle User Groups Add Service OM Fall 1994 p.129 and Support News from he Americas, Asia/Pacific, and OM 3-4.1995 p.107 Europe News from Groups Around the Globe OM 5-6.1995 p.128 Users Gather from Around the World OM 7-8.1995 p.99 (Calendar of Events) Coming Up: International Oracle User Week OM 9-10.1995 p.143 Z.10 Hardware -------- Miscellenious ------------- Tadpool Notebook Computer OM 3-4.1995 p.111 Storage Co-Processor from ZITEL OM 9-10.1995 p.146 OM 7-8.1995 p.94 OM 11-12.1995 p.75