Posts tagged queue
Xenogenetics for PL/SQL: Infusing with Java Best Practices and Design Patterns (presentation at OOW 2010)
0Xenogenetics for PL/SQL: Infusing with Java Best Practices and Design Patterns – Alex Nuijten and Lucas Jellema
PL/SQL is a venerable programming language that is both vital and very much alive. This session will discuss how we further rejuvenate and enhance the way we create PL/SQL programs. We’ll tap into the world of .NET, Java, and other modern programming language to do some cherry picking: what are the very best practices, concepts, and design patterns and how can we apply them to PL/SQL? We’ll explain and demonstrate dependency injection, the observer pattern based on listeners, aspect-oriented programming (AOP), the decorator and template pattern, use of user-defined nested types, and collections.PL/SQL is a venerable programming language that is both vital and very much alive. This session will discuss how we further rejuvenate and enhance the way we create PL/SQL programs. We’ll tap into the world of .NET, Java, and other modern programming language to do some cherry picking: what are the very best practices, concepts, and design patterns and how can we apply them to PL/SQL? We’ll explain and demonstrate dependency injection, the observer pattern based on listeners, More >
Oracle Advanced Queuing and JMS – bridging from AQ to JMS and vice versa
0In preparation for our Oracle Open World session ‘Xenogenetics for PL/SQ – Infusing with Java Best Practices and Design Patterns’ – I have been doing a little work on Advanced Queuing in the Oracle RDBMS, as well as on Java Stored Procedures. The objective of this presentation is to bring best practices, design patterns as well as new functionality to the world of PL/SQL from other worlds, such as Java. Interaction between database applications and the rest of the world is an important part of that. And such interaction, especially when we have a need for decoupled interaction, which we frequently should have, Advanced Queues will be used at the database end to support that interaction.
The concept of queuing – and more generally: messaging – has its Java counterpart in JMS, the Java Message Service. The question I then asked myself is: how exactly can I map AQ to JMS and how can I link the two worlds. How can I expose the AQ Queue or Topic in the RDBMS as a JMS Queue or Topic? And how can I consume messages from JMS into the database, possibly to AQ?
One of my reasons for making the connection between AQ and JMS has to do with another presentation at OOW I will deliver, More >
Event based Decoupling in PL/SQL – your first Advanced Queue adventure
1Back in 2004 when we started with the AMIS Technology Blog, my main objective was to record the things I infrequently do in order to have notes describing the steps to go through whenever I needed to do the thing again. I was own primary audience, so to say. Over the years, the articles have increased in complexity and sometimes in absurdity too. This one is back to that original intention. This article is not fancy at all – even though it touches upon a powerful (and underrated) subject: the Advanced Queue in the Oracle RDBMS. For the 1000s of database developers and architects that make frequent use of AQ, I am not going to add anything: this article merely shows the steps for creating an Advanced Queue, how to register a listener on the queue and how to publish a message on the queue. That is not fancy at all, obviously.
What is extremely fancy and powerful – and not nearly used enough – is the architectural pattern that AQ allows us to introduce. Queues are a key concept for achieving decoupling. Decoupling itself is like the holy grail of architects – because it allows agility and reuse. Through a Queue, a publisher (or discoverer) of events can make them available to More >
An evening with Oracle Coherence and Oracle Data Integrator – on Compute Grids, JMS implementations and trickle feed
The other night I had an interesting dinner date: seated around me were an Oracle ACE Director (Mark) and two Oracle employees, experts on Oracle Coherence (Ewan) and Oracle Data Integrator (Craig) respectively. The dinner was the closing event for all presenters and ACE Directors attending the EMEA SOA Partner Community Forum, put together by Jürgen Kress. A great event, a fine dinner and even better dinner conversation. Apart from discussing the Bejing 2008 and London 2021 (that is not a typo, the gentlemen were fairly pessimistic about the construction schedules for most Olympic venues), Dutch and British politics, American peculiarities, the wonderful Dutch countryside etc. we inevitably found ourselves back on the topics most on our minds: grids and clustering, message and data transport and the likes. (more…)
Recent Comments