Posts tagged Database
Data Integriteit anno 2011 – Hands-on met Toon Koppelaars en RuleGen 3.0 bij AMIS op dinsdag 27 september
0datum: dinsdag 27 september; 16.30 uur
locatie: AMIS, Edisonbaan 15, Nieuwegein
sprekers: Toon Koppelaars en Lucas Jellema
Het belang van data integriteit behoeft geen toelichting – als het goed is. Vrijwel iedere enterprise applicatie is gebouwd op het fundament van een database. Robuustheid van die database en absolute betrouwbaarheid van de gegevens daarin zijn. essentieel. Het garanderen van die integriteit en robuustheid is lang niet altijd goed geregeld – en is ook geen triviale uitdaging.
De veelheid van toegangskanalen tot de database – batch jobs, web services, web applicaties in Java en .NET, PL/SQL modules en natuurlijk TOAD voor de applicatie beheerder – maakt wel duidelijk dat de integriteitsregels voor de data ofwel de business rules niet in de applicaties of in een service bus (alleen) kunnen worden geïmplementeerd. Integriteit in moderne applicatie-landschappen kan alleen worden gegarandeerd met implementatie van de business rules in de database zelf.
De Oracle database biedt naast de integrity constraints voor primary, unique en foreign keys weliswaar een veelheid aan mechanismen en constructies maar geen concrete, eenduidige, robuuste en More >
RuleGen 3.0 – the latest, leanest and most robust solution for complex data constraints in an Oracle Database
0No matter how complex the enterprise and application architectures become, no matter the number of tiers, services, devices and user interfaces – at the heart of most enterprises will be a relational database.
And no matter how hard we try to implement a fully service based architecture or a multi-purpose business tier (for example using EJBs) – we will have multiple routes to the database and the data in it. Data will be manipulated through web applications, web services, client/server applications, batch database jobs, application managers working directly against the database from the command line or TOAD-like tools. If for no other reason – that by itself is an overridding motivation for enforcing every data constraint at the lowest possible level – the one level that none of these channels can avoid: the database itself. In addition to the fact that only enforcement inside the database can provide real integrity (and what the hack would be semi-real integrity?), for most data rules (especially complex ones) implementation inside the database is the most performant, scalable, maintainable, managable, agile, elegant and easy to implement as well.
Note: I am not advocating that More >
Choosing the best way for SOA Suite and Oracle Service Bus to interact with the Oracle Database
0In the past few weeks, I have encountered a similar discussion in various organisations. Each organisation uses either SOA Suite (11g) or Oracle Service Bus (11g) at the core of their SOA infrastructure – either for integration purposes, for workflow and process orchestration or for both. In each organisation, the role of one or more databases is crucial and interaction between the SOA environment and the database is one of the most common and therefore important functions in their enterprise IT environment.
Given the importance, it is only logical that the way(s) chosen for linking the SOA component to the database is carefully selected – and evaluated every now and again. Technology may have progressed, experience may have taught us a lesson or two, the knowledge and skills may have evolved.
Interestingly enough, the number of ways for SOA Suite and OSB to communicate with the database is quite high. This article includes an illustration that shows over 20 different interaction channels that we can choose from with a fairly wild variation of attributes, required skills, productivity and performance characteristics.
Among the choices we face is the question of the communication More >
How to use an outerjoin to synchronise data
0There is often a need to synchronize data from a query. For example reading external data and update the tables. Sometimes it can be achieved by a single merge statement, but this is not always possible. Mind, for example, the need to update more than one table, or updating the data using an api. As an example we want to grant and revoke privileges on database objects. Tables needing select, insert, update and delete privileges, packages execute and views select privileges. The table and packages also get the grant option for the select and execute privilege. (more…)
My First Steps with RAC One Node 11gR2 (11.2.0.2)
6I’ve been using RAC (10gR2) for years now and I was wondering how RAC One Node differs from RAC. That’s why I used a few ‘old’ RAC servers that we had ‘laying’ around to install a RAC One Node Cluster. I also used that cluster to get some hands on experience with ASM but that is not the topic for this post, so I will not go into that further.
I assume that installing the software is a breeze for everyone who has some experience with RAC and who has read the manual so I will not go into that as well. Once you have fulfilled the prerequisites it’s a matter of next, next, finish. (more…)
Installing OEL R5U5, Oracle 11gR2, OSB 11gR1 SP2 and SOA Suite 11gR1 SP2 on virtualbox 4.0
6Some time ago I decided to take a look at virtualbox. After using some downloadable appliances I decided to install one for myself from scratch to have it configured just the way I want. This blog describes what I did to achieve this. I am still quit pleased with virtualbox. Somebody pointed out to me that the CPU Utilization is quit high though. Some browsing on the internet and looking in the manual gave me the solution. I will talk about this later.
Installing virtualbox is very simple. Just download the installer and run it. Follow the wizard and do a next/next/finish installation. If you have a dual core PC or laptop (who hasn’t nowadays) please have a look at the end of this blog…. You might have to do some additional settings.
Installing Oracle Enterprise Linux is also very simple. First I created an empty virtual machine with a single disk of at least 15 Gb. I selected two processors and switched on all virtualization acceleration as my hardware supports that. I both tried the PIIX3 and ICH9 chipset. I could install OEL with both only with PIIX3 OEL actually booted. In total these settings resulted in a 10-20% CPU utilization when my guest is idle. Not great but More >
Recent Comments