Uncategorized
Review of Oracle Magazine–Jan/Feb 1999
The headline articles for the Jan/Feb 1999 edition of Oracle Magazine were all on the Year 2000 issue (Y2K). There was lots of work for the consultancy companies around the work on this. Most of the work was not very interesting but was vital to ensure that our applications continued to work.
Other articles included:
- Oracle Developer and Developer Server Release 6.0 allows for the migration of your existing applications to the Web
- Oracle Enterprise Manager 2.0 is released. What version are we on now and how things have improved.
- Oracle announces that it has begun a pilot program for its Business OnLine hosting service for enterprise applications. It will provide a full complement of the Oracle Applications for financials, manufacturing, distribution and HR on a subscription basis.
- Oracle and DELL have teamed up to deliver Oracle8 databases preinstalled on the Dell PowerEdge servers. This was one of Oracle’s first attempts at a database machine/appliance.
- Oracle 8 Data Cartridge allows you to extend the functionality available in PL/SQL with code that is available external to the database is now flexible and efficient manner. The steps involved in this included, and sample code was provided:
- Create a relocatable library fro shared objects.
- Create Oracle 8 objects.
- Configure an external procedure listener to run the cartridge.
- Configure tnsnames.ora with the extproc entry
- How to recover a dropped table when you you only have a full OS backup of it and no export of the table.
- Determine which tablespaces need to be restored in order to create the table to be recovered
- Determine the file-system space requirements.
- Build the database copy and establish the environment for the copy database
- Export the required tables from the copy database, and import them back into the database that needs to be recovered
- Oralce 8 comes with point in time recovery.
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.
Access Control List (ACL) in Oracle
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl => ‘Twitter.xmll’,
host => ‘twitter.com’,
lower_port => 80,
upper_port => 80);
acl => ‘Twitter.xmll’,
host => ‘api.twitter.com’,
lower_port => 80,
upper_port => 80);
END;
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (
acl => ‘Twitter.xmll’,
host => ‘*.twitter.com’,
lower_port => 80,
upper_port => 80);
END;
Rexer Analytics 2013 Data Miner Survey
Rexer Analytics has been conducting the Data Miner Survey since 2007. Each survey explores the analytic behaviors, views and preferences of data miners and analytic professionals. Over 1300 people from around the globe participated in the 2011 survey. Summary reports (PDFs of about 40 pages) from previous surveys are available FREE to everyone who requests them by emailing us at DataMinerSurvey@RexerAnalytics.com. Also, highlights of earlier Data Miner Surveys are available online, including best practices shared by respondents on analytic success measurement, overcoming data mining challenges, and other topics. The FREE Summary Report for this 2013 Data Miner Survey will be available to everyone in the fall of 2013.
Your survey responses are completely confidential. This research is not being conducted on behalf of any third party, but is solely for Rexer Analytics to disseminate the findings throughout the data mining and analytics community.
To participate, please click on the link below, then click on the “Start Survey” link on the bottom of the webpage. Please enter the access code in the space provided. The survey should take approximately 15-20 minutes to complete. Anyone who has had this email forwarded to them should use the access code in the forwarded email.
Survey Link: www.RexerAnalytics.com/Data-Miner-Survey-2013-Intro.html
Access Code: UL3X7
Agenda Planning for OUG Ireland Annual event 2013
Over the past week there has been a number of meetings by the organising committee of the Annual OUG Ireland event, to arrange the agenda for the 2013 event. This will be held on the 12th March in the DCC (same as last year)
We have had a large number of submitted presentations from experts from around the world. The choices we have had to make were very difficult.
The agenda is almost complete. A few finishing touches and we should have it all sorted out by the end of the week.
This year we will have the largest conference/annual event yet. There will be a good mixture of presentations from Oracle, Customers, Partners, Oracle ACE’s and other people (with an interesting story to tell) from around the world.
At the moment it looks like we will have tracks on
- Oracle Database
- Tech
- Development
- Fusion
- EBS
- Product & JDE
- BI & EPM (this may have 2 parallel tracks)
When the agenda is available and live, I put up a new post.
Registration is now live and by reports a lot of people have already registered.
OUG Ireland Annual event – online Registrations
In previous years this event used to be called the Annual OUG Ireland Conference, but the Conference part has been dropped. I’ll try to explain it over a drink some time.
Oracle Magazine-Sept/Oct 1998
The headline articles for the Sept/Oct1998 edition of Oracle Magazine were on all on how to build and deploy intranets within an organisation, using Oracle products. There were a few case studies illustrating the benefits that using intranets can bring to an organisation
Other articles included:
- Project Webview was the codename for a new project (part of Oracle 8i) whose aim was to provide and end-to-end solution for instantly building, deploying and proactively monitoring database applications and content driven websites. This was a very early start to what we call APEX now.
- Oracle 8i would be available any day now during the fall of 1998!
- Oracle Applications R11 now has a Business Intelligence system integrated into it. It comes with preconfigured standard performance indicators and with the ability to perform what-if analysis
- Oracle purchases Price Waterhouse ACTIVA Software. ACTIVA is a strategic software solution for activity management, process improvement, activity based budgeting and performance measurement
- You can not install and use Oracle Lite on a Palm Pilot, allowing replication with an enterprise Oracle 8i database.
- There was some useful tips given for companies who are looking to issue and RFP (Request for Proposal)
- Realize that everything costs money
- Provide a complete description of your current state
- Be clear, definitive, comprehensive and complete about your requirements
- Require the vendor to take a position on each and every requirement
- Whenever you ask vendors to provide costs, also ask them to list their assumptions
- Give vendors room to be creative and make suggestions on good alternatives
- When designing your data marts don’t be afraid to add more dimensions than you think are required for the initial spec. By adding more dimensions gives your users greater flexibility with slicing and dicing
- There are 7 simple ways to take advantage of Oracle 8
- New Table partitioning option.
- New Index partitioning
- Improved backup and recovery
- New Parallel data-manipulation language ability
- New and improved networking features
- A better optimizer
- Reduced resource consumption
- Using array process with dynamic SQL using the following steps
- Open a cursor
- Parse the cursor with the PL/SQL statement
- Associate a PL/SQL type table_var with the cursor, by using a DEFINE_ARRAY for each variable in the select statement
- Execute the fetch in a loop
- Associate each variable in the select statement using a COLUMN_VALUE with the PL/SQL TABLE_VAR
- Use the PL/SQL table variable for any processing
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.
AIB Presentation at Oracle Open World
Today AIB is presenting at Oracle Open World on using Real Application Testing, how they were able to consolidate their database environment and saved a lot of euros.
The was a good turnout and in the audience was the well known Tom Kyte from Oracle (asktom.oracle.com)
Solar Panels
I’ve just had a quick look at the solar panels on the house. This is one of the first truly sunny days this weak and by 11am this morning we have the water tank in the hot press reading that we have maxed out with 300 litres of water at 60C.
The panels have reached a temperature of 128C. Again this is at 11:30 this morning.
Based on the weather outlook for the next 7 days, we will not be using the Gas boiler to head any water over the next week 
Book Case
I finally got round to finishing a 5 foot high, by 4 foot wide, book case. It is made out of Sycamore wood with Mahogany wedges
Sycamore is a Very hard wood and can splinter easily.
One of the things that I like about this wood is when you apply danish oil you get variances in the colouration of the wood. I’ve ended up with some darker patches and some light patches. So you don’t get a consistent coloured finished.
This is one of the joys of working with natural solid wood rather than manufactured wood or veneered wood.
This is why I like it working with natural wood. It has lots of character. Plus the colouring will vary over the coming months.
When I moved book case into its new home in the dining room I discovered that the floor in not level. The book case was leaning away from the wall 
This was easily fixed with a very small wedge placed under each end piece. This is not ideal.
Paper at UKOUG annual conference 2011
I recently received word that one of my two submissions has been accepted for the annual UKOUG conference in Birmingham (UK).
The paper is titled ‘How to deploy your Oracle Data Miner 11gR2 Workflow in a Live Environment’. This presentation is scheduled to be on Wednesday 7th December between 3:20pm and 4:05pm. This is a 40 minute presentation, which is not a lot of time really given the topic to be covered. I’ll have to see what I can squeeze in.
My second submission is on the reserve list. This means if someone drops out of the schedule or decides that they do not want to give their presentation then I can give my presentation called ‘Oracle Data Miner – New Features’. This presentation is the same as my VirtaThon presentation on July 18th, 2011.
OOW Oracle Mix 2011–End Result
After 3 weeks the voting on Oracle Mix has come to an end. There was a record number of submissions and voting this year on Oracle Mix.
Based on the results from previous years anyone with a vote count over 30 seemed to have gotten they presentation accepted for Oracle Open World.
With this years increase interest, number of presentations and the total number of votes cast it looks like the you will need at least 87 votes to get into the top 20.
The organisers say that the winners are select based on the total number of votes case, but they can adjust things as this see fit – whatever that means.
I had submitted 3 presentations – it was my first attempt at submitting to Oracle Open World.
My best place (or most popular) presentation was ‘Using Oracle Data Miner 11gR2 & SQL Dev. for Data Mining’. For this presentation I received 56 votes, which puts me in 52nd place.
So it looks like I’m way outside making to short list for OOW11. Maybe next year.
I’ve also submitted 2 of my presentations to the annual UKOUK conference in December. The closing date was the 5th June and the results should be out in August.
Fingers crossed.
Vote for my Oracle Open World Presentation on Oracle Mix
I’ve submitted the following 3 presentations on Oracle Mix, to be included in the voting process.
Voting finishes on 19th June.
Please vote for my presentations. As they stay about elections in Ireland, Vote early and Often.
Upskilling a Data Developer for Data Mining
Oracle Data Mining has been available for many years now and has proven to be a powerful tool but seems to be over looked by longer established products that are a lot more expensive. Many companies have put significant work into development their BI environments. But what can they do now to improve their organisational knowledge. This presentation will look at how a database developer is more suited to doing data mining than someone with a PhD in statistics. Using the ODM tool and the CRIP-DM life-cycle it will be demonstrated how a data mining project can be conducted
See my YouTube channel for a my videos on Oracle Data Miner 11g R2
http://www.youtube.com/user/btierney70/
Using Oracle Data Miner 11gR2 & SQL Dev. for Data Mining
With the release of the new Oracle Data Mining tool and it being part of SQL Developer, this presentation will have a look at how these too tools can be used in combination. In particular the presentation will focus on the Data Understanding stage of the CRISP-DM Life Cycle. Using the key elements of the Data Understand stage the presentation will look at how a database developer can use the new features of the new Oracle Data Mining tool in conjunction with SQL Developer to explore the data with the aim of gaining a key insight into the data.
See my YouTube channel for my videos on Oracle Data Miner 11g R2
http://www.youtube.com/user/btierney70/
How to Deploy your Oracle Data Miner 11g R2 Workflows in a Live Environment
The new Oracle Data Miner 11g R2 tool is now easier to develop your Data Mining models and workflows. A Data Mining project has two main stages. This presentation will look at how you take your Data Mining workflow and Data Mining Model, that have been developed using the new Oracle Data Miner 11g R2 tool. It will show you have to extract the SQL code from the work flow to perform the Data Transformations, execute the Data Mining Model, how you can link these to your new data and finally how you can apply the model.
See my YouTube channel for my videos on the Oracle Data Miner 11g R2 tool
Ora-lytics 
You must be logged in to post a comment.