(Eduard Keilholz) Recently I ran into trouble reading large portions of XML. Usually we open XML files in notepad, Internet Exporer (IE) or some kind of text editor. However, when you want to open a large XML file, it takes these systems hours to open the file, if these systems do not crash while op
Other News
How To Manually Install XML DB On Oracle 11g
Oracle XML DB is a feature of the Oracle Database. It provides a high-performance, native XML storage and retrieval technology. It is also a pre-requisite for Oracle’s 11g implementation of fine-grained network security.
Extending HL7 v3 schemas using OASIS CAM and CAMProcessor
(Piers Michael Hollott) Traditionally, healthcare implementation projects use W3C XML Schema Definitions (XSDs) to define the Health Level Seven (HL7) messaging standard. By extending these schemas using the OASIS Content Assembly Mechanism (CAM), generating conformance messages becomes quicker and
How To Prevent Microsoft SQL Injection in ASP.Net
This is a two-part tutorial series meant to help beginners understand MS SQL database injection and the problems associated with it, particularly when applied to an ASP.NET web form application.
Redo Log Switches at their Peak
(Asif Momen) One of our customers was having extreme performance issues with their Oracle database. During my investigations I found they had 215 redo log switches per hour. This means a 3.65 log switches per minute or a redo log switch every 16.7 seconds.
Scripting in Oracle Data Integrator: Jython, Java BeanShell, Java, Open Tools, ODI API & SDK, ODI Substitution API
(Uli Bethke) Anyway here is another post on the various scripting options in ODI. It gives a brief overview when to use each and the advantages and disadvantages.
Is Database Administrator (DBA) a good career choice?
(Leon Katsnelson) There is a really interesting discussion going on the IDUG’s DB2 List that started with a simple question:
Redo Logfiles BlockSize – Revisited in 11gR2
(Anand) In November 2011 i had written blog “Minimum Size of Redo Logfiles and Their Block Size” where i mentioned that 512Bytes as the size of redo logfiles, which was not the totally correct to say.Oracle will use the underlying disk sector size as the BLOCKSIZE of redo logfiles which can differ f
I made the cover of z/Journal Magazine
(Willie Favero) Actually, I didn’t personally, but one of my articles made the cover.
Five Considerations for MySQL Security and Compliance in the Cloud
(Sean Hull) In our last piece on MySQL deployments in the cloud we hit on areas including disk I/O, backups, security, scalability and network traffic. Now we’ll cover the rest.