Tuesday, December 28, 2004

Looking Forward To Oracle 10g Release 2

Mark rittman has an interesting weblog on the new 10- realease2 the features and what to expect. Definitely worth reading .

Looking Forward To Oracle 10g Release 2

Pete Finnigan's Oracle security weblog

An interesting aggregation by pete on what the vulnerabilities of Alert 68 Are . this makes it easy for every DBA to understand how to manage and if patching is ncessary or not.

Pete Finnigan's Oracle security weblog

Tuesday, December 14, 2004

Foreign Keys and Software engineering Concepts

While readin thru dbazine i came thr u with this very interesting post about software engineering tactics by Joe Celko
Its a three part article about basic real life design issues that software developers face.
It sort of answered what i wa slookign for in one of my projects
The article is titled Mop The floor and fix The Leak
its a 3 part article on where should stuff be done ,
In the Application , i the database or both.
Which does pose seom interesting issues.
As Software design Evolves . It is soemtimes hard to give policy decisions in these matters due the the evoloving nature of the rdbms.

How High Can You Go by Jonathan Lewis

This article by Jonathan was based on a discussion in hte oracle-l mailing list the qestion was what if any is oracle's limitation to the height of a btree index.
interesting article with interesting results.
How High Can You Go by Jonathan Lewis

DBAzine.com: the online portal for database issues and solutions

Orablogs has a reference to this wonderful article by Jonathan lewis . After reading thru the article it seems that 10g optimizer has some plusses . the minuses will only be known when application faithfully convert to 10g,
Its the old applications that are always the problem new applications can be tailedmade to the new version.
DBAzine.com: the online portal for database issues and solutions

Wednesday, December 08, 2004

So its finally here.
The Great announcement from openworld 10gr2 is really here .
The feature set is interesting and the fact that Oracle is focusing on security which is a key buzzword in the data marketspace with the HiIPAA and fair accounting proactices stuff.
It is yet to to be seen whatpotiiental the dbms_crypto package can bring. though i wasnt out there in openworld the online presentations did give an outlook of what is in store for us this next year.
Since 10g still isnt very big in the production market. people as usual will take a very cautious note as and when 10g r2 ships.
as a further note this blog also ellaborates a lot of the new features elaborated in this blog
Oracle Database 10g Release 2 keynote at Oracle Open World

Today at Open World one of the key notes was about the introduction of Oracle 10g Release 2. With Release 2 the main thrust is improving efficiency and reducing the cost of management. Its all about Grid computing and automation and self managing databases. What’s in it for us Oracle security aficionados?

Well the most direct points from the "Oracle database 10g Release 2: new feature highlights" document are the quotes to say 10g grid provides 24*7 data access whilst being secure. They don't go to say how the data is secure!, lots of 24*7, such as clusterware redundancy and higher availability, integrated tape backup and recovery (These facts are important for data security), fast failover and most interestingly integrated transparent data encryption and key management in the database. This helps to allow customers to protect their data seamlessly without changing applications - they say. This sounds a very interesting addition, one of which I am keep to get my hands on 10gR2 to test and run through its paces. Encryption of data in the database is an interesting problem. There are three main commercial players in this space - see the links on my Oracle Security Tools page. The fact that Oracle say they will support the handling of keys seamlessly in the database is very interesting. I for one would like to know more.

The backup and high availability functions and improvements are also key features for those interested in security. Backups and recovery processes and also high availability strategies should be a key part of any Oracle security policies and procedures.

One other key item of note in the note in the second page that Oracle are now proving statistics collection from the SGA directly from memory. This means that direct SGA access methods are being used. I have some links to papers written by Kyle Hailey and Miladin Modrakovic on my Oracle Internals page that readers may find very interesting to see how Oracle are doing this. I also talked about Direct SGA access in a couple of previous blog entries.

Posted by Pete On 08/12/04 At 10:40 PM


Sergio's Blog: Update from OpenWorld: HTML DB Going like Gangbusters

Html db is a new way to manage your personal intranet and misc stuff.
i'm currently testing this and hoping the new version makes stuff moer easier

Sergio's Blog: Update from OpenWorld: HTML DB Going like Gangbusters

Google Search