Oracle Magazine

Review of Oracle Magazine–January/February 1998

Posted on

The headline articles for the January/February 1998 edition of Oracle Magazine were on Electronic Commerce and include justification for building EC applications, creating online shops and what products Oracle has to support as aspects of an EC applications.

image

Other articles included:

  • Oracle Product announcements included:
    • Oracle InterOffice 4.1
    • Oracle Lite 3.0 gets a Java facelift
    • Oracle Gateways for MS SQL Server 8 and Sybase 8
    • Oracle Applications Release 11 is coming soon
    • Applications Desktop Integrator
    • Application Server 3.1
    • Oracle 8 on Sun Sets new World Record. TCP-C Benchmark with 51,871.62 tpmC at $134.36 per tpmC runing Oracle 8 on Sun Solaris 2.6 on a two node Sun Microsystems Ultra Enterprise 6000 cluster
  • Marking the Mart Decision, looked at how using a Data Mart approach you can have a project delivered quicker (3 to 6 months) and a cost of $100,000. All this using the Oracle Data Mart Suite for Windows NT
  • Securing transactions in Network Applications using Oracle’s Web Application Server to control security
    • Digital Certificate Authentication
    • Application Authorization
    • Encryption
  • Managing Unstructured data in Oracle 8. There ware some new data types including LOB, CLOB, BLOB  and BFILE
  • Making the most of Java looks at how you can use applets with Designer/2000 WebServer Generator
  • A quick start guide on how to migrate to Oracle 8, included:
    • Determining the Migration Strategy
      • Ensure compatibility
      • Identify invalid objects and lost statistics
      • Eliminate language problems
      • Take care of read-only tablespaces
      • Know the point of no return
      • Avoid large restores
    • Defining Resource Requirements
      • Define Personnel requirements
      • Set the timing of the migration
      • Determine space requirements
      • Create an appropriate testing environment
    • Determining Potential Problem Areas
      • Review ROWIDs
      • Avoid reserved words
      • Eliminate obsolete init.ora parameters
    • Identifying Verification Tests
      • Develop the test strategy
      • Do migration testing
      • Perform minimal testing
      • Do functional testing
      • Do integration testing
      • Do performance testing
      • Do load-stress testing

To view the cover page and the table of contents click on the image at the top of this post or click here.

My Oracle Magazine Collection can be found here. You will find links to my blog posts on previous editions and a PDF for the very first Oracle Magazine from June 1987.

Advertisements

Review of Oracle Magazine- November/December 1997

Posted on

The headline articles for the November/December 1997 edition of Oracle Magazine were focused on the Network Computing area, how it works, what framework to use, how the architecture works, how it supports the information management universe.

image

Other articles included:

  • The new features of Designer/2000 Release 2.0 included a new Design Editor, an updated Repository to capture more details about the application structure, rules and application logic and reusable module components.
  • Object Database Designer for Object-Relational Databases is beta released with a production version in a few months
  • Oracle’s Very Large Memory (VLM) capability on Windows NT raises the 2GB memory constraint imposed on applications running Windows NT. With VLM, Oracle can cache almost 8GB of database information in memory.
  • Extending Oracle 8 with Objects looked at how to create nested tables, and creating object tables
  • How to Create a Good Test Database gives some guidance on how to extract a referentially intact subset of data for testing a data warehouse with new reports, queries and programs.
  • A Management Perspective on Handling a New Millennium gives a methodology to address the complete management and control issues. The had the following phases:
    • Impact assessment
    • Prechange analysis
    • Compliance
    • Retest and Integration
  • Using Parallel Query to improve Windows NT Data Mart Performance
  • The last section of the magazine had 10 pages of job adverts.

To view the cover page and the table of contents click on the image at the top of this post or click here.

My Oracle Magazine Collection can be found here. You will find links to my blog posts on previous editions and a PDF for the very first Oracle Magazine from June 1987.

Review of Oracle Magazine–September/October 1997

Posted on

The headline articles for the September/October 1997 edition of Oracle Magazine were how to put your data warehouse on the web, how to build it, how it works, differences between a data mart and a data warehouse, how Delicato Vineyard and the US Environmental Protection Agency web enabled their data warehouse,

This was a bumper edition of Oracle Magazine. It had just over 150 pages of content. This is compared to the previous editions that have been +/- a few pages of 100.

image

Other articles included:

  • There was a certain amount of repetition of announcements from the previous edition (a lot). I won’t repeat them here but check out the previous edition review.
  • Extending Oracle 8 with Objects covered how to create and work with Object Types.
  • How to setup and configure your Oracle Database hot standby, how to monitor it and what limitations to watch out for.
  • Oracle Designer/2000 Administration: Tuning Tips and Techniques.
    • The tips for the Repository included:
      • Bring your system up to speed
      • Re-create indexes and hash tables frequently
      • Size the SGA Shared_Pool_Size and the DB_Block_Buffers
      • Pin procedures to the SGA
      • Size the tablespaces
      • Re-create the repository through import/export
      • Be aware of the impact of sharing objects across multiple application systems
    • Tips for Client-side tuning:
      • Use suggested settings for PC clients
      • Install Designer/2000 client tools on a file server
    • Tips for Network Tuning
      • Configure SQL*Net
  • Unlocking the value of test with Oracle ConText cartridge. CareerPath.com uses ConText to enable servers to quickly and efficiently search through hundreds of thousands of job vacancies quickly and relevant for the searchers entered details.

To view the cover page and the table of contents click on the image at the top of this post or click here.

My Oracle Magazine Collection can be found here. You will find links to my blog posts on previous editions and a PDF for the very first Oracle Magazine from June 1987.

Review of Oracle Magazine–July/August 1997

Posted on

The headline articles for the July/August 1997 edition of Oracle Magazine were all focused on using Java, building applications, an interview with James osling using Java and the Oracle Database together and an outline of what Oracle sees as the future for Java.

image

Other articles included:

  • There as a lot of product announcements (similar to the previous edition). These included:
    • Developer/2000 Web Cartridge
    • Enterprise JavaBeans for Integrated Business Solutions
    • Oracle/CNN Launch
    • Personal Oracle Lite 2.4 : Mobile RDBMS
    • Oracle Replication Services Release 1.3: Bidirectional replication
    • Oracle Projects 10.7 Suite of Applications
    • Oracle Web Application Server 3.0 on HP-UX
    • Oracle Discoverer 3.0
    • Oracle GEMMS 4.1
    • Data Mart solution for Windows NT
  • Using the Network Computing Architecture (NCA) with Developer/2000 and Designer/2000. This covered how you can create components that you can mix and match, and plug into your applications. This involved using JDeveloper and the Developer/2000 Web Forms Cartridge to Deploy in Java.
  • There was an article discussing how you can implement your applications in a distributed environment, on a phased basis.
  • Steven Feuerstein writes planning your PL/SQL development to maximise your PL/SQL environment. He suggests that there are two specific steps for PL/SQL: 1 Consolidate access to the underlying database, and 2 Standardize exception handling and creating general utilities that can be reused. Best practices include:
    • Make packages flexible and easy to use
    • Overload the package to make the package smarter
    • Modularize the package so it can be maintained and enhanced.
    • Hide the package data
    • Build multiple packages simultaneously
    • Employing top-down design in PL/SQL
    • Make the most of the PL/SQL language and features

To view the cover page and the table of contents click on the image at the top of this post or click here.

My Oracle Magazine Collection can be found here. You will find links to my blog posts on previous editions and a PDF for the very first Oracle Magazine from June 1987.

Review of Oracle Magazine–May/June 1997

Posted on

The headline articles for the May/June 1997 edition of Oracle Magazine were focused on the release of Oracle 8, with articles on the new features, how Boeing and Arizona Start University are using Oracle 8 to create a plane for the future, and some articles on using object technology in Oracle 8.

I remember back in 1994 Oracle bought an OODBMS company with the aim of ‘if you cannot beat them then buy them’. The Object Relation project of Sedona was born and the first of the deliverables from the project was in Oracle 8.

image

Other articles included:

  • The key benefits of Oracle 8 Server (The Database of Network Computing) can be grouped under Scalable, Available, Object-Relational, Large Scale, Distributed, Secure and Evolutionary.
  • The new features of Oracle 8 have been in new or better functionality for OLTP, Data Warehousing, Parallel Server, Object-Relational (code named Sodona), Partitioning, Backup and Recovery, Connectivity, Replication, NCA Framework and Migration.
  • Oracle announces that they have licensed Borland Java tools and we now have the birth of JDeveloper and the world of ADF will come along many years later.
  • The Industry Applications Division (IAD) of Oracle announce new applications and releases. These included: Oracle Consumer Packaged Goods (CPG) 2.2, Oracle Government Financials, Oracle Energy 3.1, Oracle Clinical 3.1, Oracle Environmental 4.5 and Oracle Health and Safety 2.0.
  • Kumaran Systems, releases a tool that will convert all your reports written in RPT (ReportWriter, which was very similar to PL/SQL) to Reports 2.5.  I really liked RPT. It was quick and you could do a lot with a few lines of code. Converting to Oracle Reports took a bit of getting used to. As a lot of the work you had to put into developing the report revolved you having to play with frames and anchoring box positions. Oh I still have the scares.
  • Los Angeles County uses Oracle 7.1 to help it manage its environmental applications.
  • How to defined and use Summary tables in your Oracle Data Warehouse.
  • Oracle launches a new magazine for its users call Profit and is aimed at the CFO and CIO market.

To view the cover page and the table of contents click on the image at the top of this post or click here.

My Oracle Magazine Collection can be found here. You will find links to my blog posts on previous editions and a PDF for the very first Oracle Magazine from June 1987.

Oracle Magazine Collection

Posted on

Are you going to Oracle Open World & have old Oracle Magazines.
I’ve been working in the Oracle World for 20 years now. During that time I’ve been collecting the print editions of Oracle Magazine since 1992.
I have all the Oracle Magazines from 1998, but I’m missing some of the editions prior to 1998.

Can you help me complete my collection ?   (I promise that you wont find them on ebay!!)

What I would really like to do is to have a print copy of every Oracle Magazine going back to the very first one in June 1987. To see the electronic version of the first edition, which was very kindly made available by Cary Milsap, click here.
image

So in the run up to Oracle Open World could you have a look to see if you have any of my missing editions or any of the early editions. I can collect them off you are Oracle Open World.

If you have a look through my blog you will see that I’ve been posting a review of some of the early editions of Oracle Magazine. Ideally at some time in the future I will have a review of all the Oracle Magazines available.

Review Oracle Magazine–Sept/Oct 2006- 20th Anniversary

Posted on

The Sept/Oct Oracle Magazine from 2006 was the 20th Anniversary edition.

The main articles were focused on Security, Unstructured Data, Using Ajax, Partitioning (this is a regular topic), Application Express and there was the regular articles from Tom Kyte and Steven Feuerstein

image

 

There was only one article focusing o the 20th Anniversary of Oracle Magazine, written by Jeff Spicer and gave a brief overview of how the magazine has progress and the main technologies. The highlights included

  • Oracle Magazine emerged in 1987 from the original newsletter that was issued every quarter
  • In the 1990’s the magazine grew in size and was primarily focus on how Oracle customer were using the products
  • By the late 1990 the magazine evolved into have a number of distinct sections focusing on the wide range of products that Oracle now owned
  • Then into the 2000 Oracle magazine stated to introduce more user focused features. With this we get more user group news and features on community members.
  • Tom Kyte joins with a regular column in 2000
  • Back in 2006 Oracle magazine has a readership of nearly 1 million.

In the November/December 2011 Oracle Magazine, Tom Haunert give an brief history of Oracle Magazine, over its 25 year history

To view the cover page and the table of contents click on the image at the top of this post or click here.

My Oracle Magazine Collection can be found here. You will find links to my blog posts on previous editions and a PDF for the very first Oracle Magazine from June 1987.