OOW12

OOW content/slides are still available

Posted on

For those people who where lucky to get the Oracle Open World (OOW) and for all the many thousands of people who were not able to make it to OOW, the slides from almost all the presentations are still available.

To get your hands on these presentation slides, all you need to do is to go to the Oracle Open World website

http://www.oracle.com/openworld/index.html

Click on the Tools option on the menu and then click on Schedule Builder. You will need your Oracle Single-Sign-On username and password. Once entered you should get conference content and Schedule page.

image

You can search the content catalog for the presentations you are interested in and download the presentations.

There was been some mutterings that the presentation slides and access to the schedule build will be restricted at some time in the near future.

So get the conference material now.

While you are on the Oracle Open World site, why not sign up for notifications for the 2013 conference. They will probably start around early March.

Advertisements

New features for Developers in Oracle 12c & Tools

Posted on

Continuing on from my previous posts on new features in the Advanced Analytics Option and the 12c Databases, this post will focus on the proposed new features for Developers in 12c and in the new releases of the development tools.

Health Warning: As with all the presentations at OOW that talked about what may be in or may be in the next release, there is no guarantee that these features will actually be in the released version of the database. Here is the slide that gives the Safe Harbor statement.

image

  • APEX 4.2 is out now and has lots of new features in particular features for creating mobile applications including transitions, gestures, changes in orientation and HTML 5 support. Coming in 12c APEX will be able to support the pluggable database environment. You will have the option to install APEX in the Contain database or in the pluggable databases. It will also support the extended VARCHAR2 size
  • SQL Developer will have Data Pump to allow for fast movement of data and for scheduling of the movements. The Database Difference tool has been redesigned to give more options and gives a more reliable comparison. A redesigned Database Copy (more options), improved Migrations and PDF report generation. SQL Developer is not the admin tool to manage the APEX Listener. UI improvements include more/better drag and drop, GRANT statement support in SQL editor and database Doc reporting. A new release of SQL Developer will be made available with the release of 12c that includes all the 12c new features
  • Better Data Compression of data being sent to/from the client/server. So how you use the ORDER BY clause will become more important
  • We will now have BOOLEAN in 12c but only in PL/SQL Sad smile
  • 12c will allow you to grant ROLES to PL/SQL program units. Or we could specify a White List that lists what other code units can call your code. This is a great security enhancement, although it involves more admin work, but it is worth it.
  • 12c will allow you to include PL/SQL in WITH
  • 12c will allow you to create duplicate indexes on the same set of columns. Sometimes you might want two different types of index on the same data, for example a bit map index and a b-tree index.
  • Cursor results sets can now be returned implicitly instead of the existing explicit method
  • The Warning messages when compiling our PL/SQL code can be filtered based on if they are Severe, Performance related or just Informational. This can be set at a System or Session level.

alter session set plsql_warnings=’enable:severe’;

alter session set plsql_warnings=’enable:performance’;

alter session set plsql_warnings=’enable:informational’;

There was a large number of exhibits at OOW. All of them were giving things away. For some of these you had to endure a sales pitch. One of the popular type of give away was a t-shirt. If you really wanted to, you could get enough t-shirts to keep you going for a few years. I popped into the exhibits for JavaOne and the pictures below is my faviourate t-shirt from OOW, by CloudBees.

imageimage

Some of the exhibits were also giving away money. If you would sit through a 10 minute presentation you were given a ticket and if your number was picked your would could win anything from $20 up to $100. Many thanks to Intel Smile

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.

OOW : Day by Day blog or Not

Posted on

Today Sunday is the first full day for Oracle Open World. Although parts of it started on Saturday with the MySQL conference as was as a number of other briefing type session throughout the day and evening.

One thing that I will not be doing over the course of the next 5 days is to give a day by day account of the different sessions that I attended nor will I be giving updates on what was announced at OOW.

There will be plenty of announcements and there will be many thousands of people who will be tweeting, blogging and writing all kinds of articles about the these.

When the conference finishes up next Thursday I will take some time to write a blog post on what were the main announcements for me and in particular for the Oracle Analytics Option and suppose the whole area people call BIG Data.

The first IOUG BIG Data SIG meeting will be on Tuesday morning from 8:45-9:45, Moscone West, Level 3, Overlook 3.

The main presentation on the Oracle Advanced Analytics Option will be on Wednesday by Charlie Berger (Sr Director for Advanced Analytics). In addition to this presentation there will be a number around the whole ORE and BIG Data. This will rounded off by the Keynote on Thursday morning. Yes that is the morning after the big social event on Wednesday night with Kings of Leon and Peal Jam.

One thing that I will be doing each day will be posting a new review of old Oracle Magazine. So check in daily for those.

The next 5 days will be a bit manic as I try to gain learn lots. The problem here is that my interest span a number of areas. OK the main one is the Oracle Advanced Analytics and BIG Data, but I also have DBA and Developer skills/interests too.

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.