Case Study: Flexible Analytics and Intelligent Monitoring In the ETL Process

Registration is free. Login or register to view/download this content.

Author(s)

Business Relationship Manager - Product Lifecycle Management, Chevron Corporation

Jay Yusko is a Consulting Engineer in Application Architectures for Information Resources. He has an MS in Artificial Intelligence from DePaul University and a Ph.D. in Artificial Intelligence from IIT. His research has been in the area of Ontologies and Ontology Inference Engines. Jay developed rule-based systems at Bell Laboratories, Navistar and United Airlines. Information Resources provides a combination of real-time market content, advanced analytics and performance management software.

The technical challenges for complex rules engines are many, especially when dealing with terabytes of information that need to be integrated into many processes. Yusko compared it to a pipeline, where the data comes in one end and leaves at the other, and every data manipulation has to happen inside the pipe in order to maintain the integrity of the data. The challenges include:

  • The requirement for complex decision making in the ETL (Extract, Transform, and Load) flow with the ability to fix data live in the data stream
  • Ability for the departments to maintain the business logic in English in a central repository
  • Embedding a rules engine in a datastage (broken up into stages) custom operator in a way that is normal for a datastage developer to maintain
  • Getting the required speed and scalability
  • Having the ability to spread the decision process across a grid

The business logic and the programming logic need to be separate. Quality control is needed from both the business and the programming side. Yusko advises doing test runs with nine or ten million records to insure the rules do what is intended. Yusko went into detail on the written code for one of these rules. The rule, written in C, was almost in the same English as the business specification, making it understandable to everyone.

The ideal is for each rule to be a black box, where the inputs go in and the outputs come out and what happens inside doesn’t have to be known or changed.  Only the inputs and the outputs need to be specified, which makes things easier for the developer. Most of the rules are written in C++, but then these need to be converted to JRules so they will work with a Java engine that can handle object attributes. Yusko explained how this process works for all the stages and links.

If a record fails for any reason, there is a link going out so a human can find out why. Once the engine is set up, any number or records can be handled through any number of nodes, and in any kind of system. Data also can leave the stream for Business Activity Monitoring (BAM).

One of the benefits of implementing a rules system is that it centralizes and makes accessible all the business rules of the organization, rather than continuing the practice of having some important parts of the business knowledge existing in isolation on some desk somewhere.

The project benefits include:

  • Enables very complex sets of rules to handle the decision process
  • Ability to have explanation facilities
  • Ability to quickly add and change rules in the datastage job
  • Enable scalability by embedding a rules engine in a datastage custom operator tied into the parallel extender, which allows the processing to be spread across a grid
  • Enhance the speed of processing by using a continuous flow of data
  • Rules can be maintained by the proper department in a format that they can understand
  • The business logic is stored in a central repository
  • Real time complex alerts are enabled

Yusko said the new product is in production now. The engine can be installed free-standing or used as a web-service and it can work with any kind of rule.

Similar Resources

Featured Certificate: BPM Specialist

Everyone starts here.

You're looking for a way to improve your process improvement skills, but you're not sure where to start.

Earning your Business Process Management Specialist (BPMS) Certificate will give you the competitive advantage you need in today's world. Our courses help you deliver faster and makes projects easier.

Your skills will include building hierarchical process models, using tools to analyze and assess process performance, defining critical process metrics, using best practice principles to redesign processes, developing process improvement project plans, building a center of excellence, and establishing process governance.

The BPMS Certificate is the perfect way to show employers that you are serious about business process management. With in-depth knowledge of process improvement and management, you'll be able to take your business career to the next level.

Learn more about the BPM Specialist Certificate

Courses

  •  

 

Certificates

  • Business Process Management Specialist
  • Earning your Business Process Management Specialist (BPMS) Certificate will provide you with a distinct competitive advantage in today’s rapidly evolving business landscape. With in-depth knowledge of process improvement and management, you’ll be able to take your business career to the next level.
  • BPM Professional Certificate
    Business Process Management Professional
  • Earning your Business Process Management Professional (BPMP) Certificate will elevate your expertise and professional standing in the field of business process management. Our BPMP Certificate is a tangible symbol of your achievement, demonstrating your in-depth knowledge of process improvement and management.

Certification

BPM Certification

  • Make the most of your hard-earned skills. Earn the respect of your peers and superiors with Business Process Management Certification from the industry's top BPM educational organization.

Courses

 

Certificates

  • Operational Excellence Specialist
  • Earning your Operational Excellence Specialist Certificate will provide you with a distinct advantage in driving organizational excellence and achieving sustainable improvements in performance.
 

 

OpEx Professional Certificate

  • Operational Excellence Professional
  • Earn your Operational Excellence Professional Certificate and gain a competitive edge in driving organizational excellence and achieving sustainable improvements in performance.

Courses

Certificate
  •  

  • Agile BPM Specialist
  • Earn your Agile BPM Specialist Certificate and gain a competitive edge in driving business process management (BPM) with agile methodologies. You’ll gain a strong understanding of how to apply agile principles and concepts to business process management initiatives.  
 

Business Architecture

 

Certificates

  • Business Architecture Specialist
  • The Business Architecture Specialist (BAIS) Certificate is proof that you’ve begun your business architecture journey by committing to the industry’s most meaningful and credible business architecture training program.

  • Business Architecture Professional
  • When you earn your Business Architecture Professional (BAIP) Certificate, you will be able to design and implement a governance structure for your organization, develop and optimize business processes, and manage business information effectively.

BA CertificationCertification

  • Make the most of your hard-earned skills. Earn the respect of your peers and superiors with Business Architecture Certification from the industry's top BPM educational organization.

Courses

 

Certificates

  • Digital Transformation Specialist
  • Earning your Digital Transformation Specialist Certificate will provide you with a distinct advantage in today’s rapidly evolving business landscape. 
 

 

  • Digital Transformation Professional
  • The Digital Transformation Professional Certificate is the first program in the industry to cover all the key pillars of Digital Transformation holistically with practical recommendations and exercises.

Courses

Certificate

  • Agile Business Analysis Specialist
  • Earning your Agile Business Analysis Specialist Certificate will provide you with a distinct advantage in the world of agile software development.

Courses

Certificate
  • DAS Certificate
  • Decision Automation Specialist
  • Earning your Decision Automation Certificate will empower you to excel in the dynamic field of automated decision-making, where data-driven insights are pivotal to driving business innovation and efficiency.