oug_ire
Oracle Magazine-Fall 1992
I’ve been collecting Oracle Magazine for almost 20 years now. I have almost the entire collection, but I’m still missing some of the editions. Some people have donated some of the editions I was missing. But I still missing some. Can you help me ? Check out my Oracle Magazine Collection.
Every 2 to 3 weeks I intend to write a blog post on each of the Oracle Magazines that I have, starting with the earliest edition that is from Fall 1992.
The main theme of the Fall 1992 edition was about the new Oracle 7 Database. I didn’t get using an Oracle 7 Database until mid-1994.There are a few customer case studies of Oracle 7 implementations. In the article Migrating to Oracle 7, they list some of the new feature. The following is an extract from the new features section.
Standard Oracle 7 provides the functionality and performance to tackle most mission critical applications:
– Multithreaded server
– Shared SQL
– Cost Based optimiser
– Row level locking
– Declarative integrity
– Role based security
– 100% ANSI/ISO standard SQL
– Enhanced national language support
The procedural option for Oracle 7 provides additional capabilities that enhance the database server in the application environment:
– Stored Procedures and Functions
– Procedure packages
– Database Triggers
– Lock manager package
– Database alerts
The distributed option for Oracle 7 makes a physically distributed database appear as a single, logical database. Features of this option include:
– Distributed updates
– TP monitor (XA) interface
– Transparent two-phase commit
– Remote procedure calls
– Table replication (snapshots)
– Oracle Mail Interface
Another article that stands out is by Richard Barker (do you remember his?) who was responsible for the CASE*Method and Oracle’s CASE Tools.
There was several articles on the new Oracle Forms 3 and Oracle Menu 5. Talking about some of the new features like List of Values (LOVs), pop-up Field editor and Pop-up Pages.
There also also the first articles on using Oracle a Microsoft Windows environment. Oh how I remember the frequent blue screens when developing and compiling my forms and in particular my report, with does early releases on Windows.
The editorial staff of Oracle Magazine have kindly given me permission to make a PDF of the front cover and the table of contents available for each edition. To get this PDF click on the above image or follow this link to see what Oracle Magazine used to look like 20 years ago.
My next blog post on Oracle Magazine, will look at the Winter 1993 edition.
If you have any of the editions that I’m missing from my collection and you would like to donate then, then drop me an email and we can arrange delivery. You wont see any of them on eBay, I promise.
Oracle Ireland Security Seminar–Dublin 8th March 2012
Oracle Ireland will be hosting an security event on Thursday 8th March, between 9:30-13:30, in their East Point offices.
The seminar is titled Defending Against Hackers and Hacking.
There will be a couple of demos what show some of the simple and not so simple techniques that hack and compromise your systems. This can lead to loss of confidential information.
To register for the event go to
Update on Exalytics Pricing
In my previous blog post (Exalytics : How much will it cost me ?) I gave an outline of the pricing you might expect for an Exalytics machine.
The final pricing that I gave of approx $3+M was based on the per processor licencing.
Yesterday (24th Jan) the Oracle Business Intelligence blog by Manan, included the pricing based on the per user licences.
The following is a breakdown of the Exalytics pricing based on the minimum 100 user licencing.
Licence Costs (100 users)
Exalytics machine = $135,000
TimesTen = $300 x 100 users = $30,000
BI Foundation Suite = $3,675 x 100 users = $367,500
Giving a grand total of $532,500.
Support Costs (100 users)
But we need to add the annual support costs to this.
Exalytics machine support = $29,700.
TimesTen support = $66 x 100 users = $6,600
BI Foundations suite = $809 x 100 users = $80,900
Total support costs (100 users) = $116,500
First year & on-going costs costs
Total first year cost for an Exalytics machine = $532,500 + $117,200 = $649,700
Plus on going annual support costs of $117,200 in year 2 and subsequent years.
Discounted Costs
If you are one of the lucky customer who can If I use the same discounts, as I did in my previous blog post, of 25% discount on hardware and 60% discount on the software, we get:
Year 1 cost of : ($135,000*0.75) + ($397,500*0.40) = $260,250
So it might be possible to get an Exalytics machine for $260+K, plus annual support costs.
OUG Ireland 2012 Conference & Re-launching the SIGs in Ireland
The schedule of presentations for the 2012 Oracle User Group Ireland conference has just been released.
This year the conference will be in the Dublin Convention Centre.
There are 5 parallel streams with sessions running all day. Key notes presentations will be given by Eileen O’Mara from Oracle Ireland (given in the morning) and the key note at the end of the day will be given by Mogen Norgaard from Miracle AS in Denmark and founder of the OakTable Network.
There will be 7 Oracle ACE Directors and 3 Oracle ACEs presenting at the conference in addition to other speakers from Ireland, UK and Netherlands. Here is the full list of Oracle ACEs that are presenting
Debra Lilley, ACE Director
Mark Rittman, ACE Director
Roel Hartman, ACE Director
Simon Haslam, ACE Director
Frits Hoogland, ACE Director
Mogens Norgaard, ACE Director
Lonneke Dikmans, ACE Director
Brendan Tierney, ACE
Marcin Przepiorowski, ACE
Grant Ronald, ACE
It is also FREE to attend. So go ahead an book yourself a place for a full day Oracle training.
To register your place – Click here
The agenda for the conference can be found here – Click here
There are a few important web and social media links that might be of interest for all Oracle people in Ireland.
Web : www.oug.og/ireland
Twitter : @oug_ire
@oug_ire2012 For the 2012 conference related tweets
LinkedIn : http://www.linkedin.com/groups?home=&gid=3441701
Re-launching the SIGS in Ireland
Over the past few years the User Group SIGs have been a bit quiet here in Ireland. Except for the BI (&EPM) SIG, which has been getting a good attendance since it launched back in 2009.
In particular the Oracle Technology SIG basically ceased to exist over the past 5 or 6 years, since the days when John Knox and Tagdh Cashman were running it.
At the conference it is hoped that to get some people to volunteer to get this SIG back up and running again. Maybe we could get 3 SIG events each year. What do you think ?
Drop me an email if you have any questions regarding the SIGs in Ireland (I’m deputy chair of the BI & EPM SIG).Hopefully
I’ll see you there on the 21st March.
New additions to my Oracle Magazine Collection
I put out a call a few months ago looking for help in completing my Oracle Magazine collection. I also had a letter in the Nov/Dec 2011 edition of Oracle Magazine looking for help.
The following people contacted me in December offering to send me some of my missing editions.
Lisa Dobson – Oracle DBA at Durham University and Vice President of UKOUG
Debra Lilley – President of UKOUG
Christian Antognini – Trivadis AG, Switzerland
Dan Vlamis – Vlamis Software Solutions, MO, USA
Many thanks for your donations.
It seems that people don’t keep their Oracle Magazines!
I’m now just missing a very small number of editions since 1992. Can anyone else help ?
Does anyone have any Oracle Magazines from before 1992 ?
The following table gives the current collection (printed editions). The grey boxes are the editions that I’m still missing, and keep an eye on my Oracle Magazine page for updates.
ODM 11gR2–Real-time scoring of data
In my previous posts I gave sample code of how you can use your ODM model to score new data.
Applying an ODM Model to new data in Oracle – Part 2
Applying an ODM Model to new data in Oracle – Part 1
The examples given in this previous post were based on the new data being in a table.
In some scenarios you may not have the data you want to score in table. For example you want to score data as it is being recorded and before it gets committed to the database.
The format of the command to use is
prediction(ODM_MODEL_NAME USING )
prediction_probability(ODM_Model_Name, Target Value, USING )
So we can list the model attributes we want to use instead of using the USING * as we did in the previous blog posts
Using the same sample data that I used in my previous posts the command would be:
Select prediction(clas_decision_tree
USING
20 as age,
‘NeverM’ as cust_marital_status,
‘HS-grad’ as education,
1 as household_size,
2 as yrs_residence,
1 as y_box_games) as scored_value
from dual;
SCORED_VALUE
————
0
Select prediction_probability(clas_decision_tree, 0
USING
20 as age,
‘NeverM’ as cust_marital_status,
‘HS-grad’ as education,
1 as household_size,
2 as yrs_residence,
1 as y_box_games) as probability_value
from dual;
PROBABILITY_VALUE
—————–
1
So we get the same result as we got in our previous examples.
Depending of what data we have gathered we may or may not have all the values for each of the attributes used in the model. In this case we can submit a subset of the values to the function and still get a result.
Select prediction(clas_decision_tree
USING
20 as age,
‘NeverM’ as cust_marital_status,
‘HS-grad’ as education) as scored_value2
from dual;
SCORED_VALUE2
————-
0
Select prediction_probability(clas_decision_tree, 0
USING
20 as age,
‘NeverM’ as cust_marital_status,
‘HS-grad’ as education) as probability_value2
from dual;
PROBABILITY_VALUE2
——————
1
Again we get the same results.
My first set of Oracle Products
I started working with Oracle back in 1993 and my first project involved working with Oracle 5, Forms 2.3 and for reports RPT.
The Oracle Database and tools were very simple back then, but there was lots of “features” to work around.
Check out this video, for a short demo of Oracle 5 and Forms 2
Article for Oracle Scene–Due 13th Jan
As we approach Christmas, many of us will be looking forward to a few days holidays/vacation. During this period we may start thinking about some techniques or methods that we discovered over the past 12 months or about things we need to find out more on, over the coming months.
One thing to consider is to write an article on these techniques or methods, for Oracle Scene. The next due date for submitting articles is 13th January.
http://www.ukoug.org/what-we-offer/oracle-scene/editorial-calendar/
For more details and ideas check out my webpage Oracle Scene
Make sure you check out the Article Guidelines and Submission Details
http://www.ukoug.org/what-we-offer/oracle-scene/article-submissions/
I hope to write an article based on the presentation I gave at the UKOUG Conference in Birmingham.
The most common question that I get asked is ‘how long should it be?’. The length of an article can be anything from half a page, up to 4 or 5 pages long.
Oracle Big Data Videos
Mark Townsend, Database Product Manager at Oracle gave a presentation on Big Data at the UKOUG conference and used the following videos to illustrate how a company can evolve their Big Data into useful and meaningful information.
Big Data – Gold Mine or just Stuff
My UKOUG Presentation on ODM PL/SQL API
On Wednesday 7th Dec I gave my presentation at the UKOUG conference in Birmingham. The main topic of the presentation was on using the Oracle Data Miner PL/SQL API to implement a model in a production environment.
There was a good turn out considering it was the afternoon of the last day of the conference.
I asked the attendees about their experience of using the current and previous versions of the Oracle Data Mining tool. Only one of the attendees had used the pre 11g R2 version of the tool.
From my discussions with the attendees, it looks like they would have preferred an introduction/overview type presentation of the new ODM tool. I had submitted a presentation on this, but sadly it was not accepted. Not enough people had voted for it.
For for next year, I will submit an introduction/overview presentation again, but I need more people to vote for it. So watch out for the vote stage next June and vote of it.
Here are the links to the presentation and the demo scripts (which I didn’t get time to run)
Demo Script 1 – Exploring and Exporting model
Demo Script 2 – Import, Dropping and Renaming the model. Plus Queries that use the model
- ← Previous
- 1
- …
- 7
- 8
Ora-lytics 