Posts tagged adf bc
ADF DVT Speed Date: Present Metrics per Year, Quarter and Month using a zoom-enabled ADF DVT Resource Utilization Gantt and ADF BC0
The challenge I will address in this article is the following: I would like to provide a nice presentation of data aggregated by time period. For example: an overview of the number of employees that was hired in each year in each department (example is drawn from table EMP). The presentation could look like this:
To extend the challenge a little bit: I would like to be able to drill down. From the year level shown in this picture, to the Quarter level and even to the Month level. The Quarter level would look similar – but more fine grained:
This article shows how this challenge can be addressed using ADF DVT – Data Visualization components, more specially the Resource Utilization Gantt Chart. It will describe how ADF BC is used in conjunction with the SQL TRUNC function and a smart bind parameter to allow for dynamic zooming to different time aggregation levels. And the approach demonstrated in this article can easily be reused for other time based presentations.
The ADF framework strongly suggests if not dictates a certain application architecture. Through ADF BC (Business Components) – the predominant business service implementation with ADF – applications will typically interact directly with the database, over JDBC Database Connections from a shared connection pool. Developers who create the ADF BC Entity Objects and View Objects will be quite aware of the data model and the database implementation. They will usually write SQL. And the result of their work is substantially coupled with the database. Transactions across multiple data source are very hard to implement in that typical ADF BC scenario because ADF BC talks to a single database and typically controls its own transaction.
When ADF applications are developed in an environment where an enterprise architecture has been laid down, and decoupling is an important objective and service orientation is mandated – then this typical implementation of the business service using ADF BC connecting directly to the database may not be desirable or even allowed.
On one of my projects, we are currently in the situation where we try to determine the guidelines for the implementation of the More >
In a recent article – Advanced SQL to find valid periods – juggling with outer joins, running totals and analytical functions – I discussed how to use Analytical Functions in SQL to cleverly (!) derive the valid periods from a database table that contains periods of inclusion and exclusion. A valid period is a period for which there is at least one inclusion and for which there is no exclusion. I used several powerpoint based graphics to illustrate the business case. For example:
to depict the periods of inclusion and exclusion and this figure to demonstrate how to derive the valid periods (the blue bars):
After completing this article – and fiddling around in Powerpoint quite a bit – I realized that for visualizing data in a table, I have a perfect tool at my fingertips: the Data Visualization Tags (DVT) in ADF 11g are created for this very purpose: turning data into information through visualization. And this rich library of DVTs components contains – in addition to fairly straightforward visualizations such as bar charts, pie charts and line graphs – also more complex visualization components such as the Bubble Chart, Thematic Map and Gantt Chart. The Gantt Chart has three More >
The ultimate ADF event of 2012: The AMIS Master Class Advanced ADF – Christmas Special (Friday 21st of December)0
If you are an ADF developer – and The Netherlands are within reach for you – then Friday 21st of December is a day to mark in your diary. On that day, the shortest of the year in our Northern Hemisphere, we present the Advanced ADF Master Class – in the spirit of the holiday season.
and more like the Magnificent Seven than like Snow White’s dwarfs. Each is an ADF specialist who is committed to deliver an inspiring talk on his specific expertise within the ADF domain. This event is unique – bringing together ADF specialists in a special, intimate Christmas atmosphere – and with Dutch Christmas treats as icing on the cake. The topics are all based on real life experience. The concepts discussed and the approaches demonstrated have immediate practical value. The setting lends itself to up close and personal interactions, discussions and deep dive explanations.
It is a wonderful opportunity for ADF developers as well as application architects to get inspired in various essential areas of ADF, to acquire knowledge and insights that are applicable back on the job and to exchange ideas and experiences with peers – all in a seasonal More >
Last week I have been teaching a two day workshop on customization – one of the most powerful framework facilities in ADF. Customizations allows you to create a set of modifications (or even multiple sets of modifications) on top of a base application. The behavior and appearance of the application can be fine tuned to the specific needs of a site (or instance) of the application, or even to the desires of specific user groups on such a site. Especially for ISVs who develop their products using ADF and who would like to create and ship a single version of the application yet allow customers during implementation to do fine tuning according to local requirements, customization is fantastic feature. It allows the creation of customizations that are separate from the core code and that will survive new releases of the base application.
In future blogs, I will tell you more about customization. In this article, I will focus on a specific aspect of customization of ADF applications that may not be as straightforward. It concerns the definition of the RowImpl class for an Entity Object (or any Java Class referenced from ADF BC components).
Our specific need is that the application ships More >