Data Architecture tagged posts

Iterative Enterprise Architecture Design on Oracle Fusion Middleware Stack

Prerequisites: Enterprise Architecture, Oracle WebCenter Portal, Content, SOA, SOFEA, ADF

Recently I built up a PowerPoint presentation for a potential client. This client has Oracle Fusion Middleware in place and starts their digital strategies in order to improve their online services.

This presentation starts from introducing enterprise architecture, methodologies and frameworks, walks through enterprise architecture domains, discusses WebCenter portal application integration, application and site migration plan, summarizes ADF project best practices.

This presentation sums up my many years experiences and best practices on ADF development, explains profound enterprise architecture design in intuitive way, highlights numerous key points in implementations, from data architecture, applic...

Read More

Case Study: Data Modeling Transition for BI

One of our utility clients uses MS Visio as its logical data modeling tool. MS Visio is designed as a drawing dmtool,not as a professional data modeling tool by Microsoft official statement. To create DDL from MS Visio diagram is not straightforward; usually it takes lots of efforts.

We prefer to use UML modeling instead of ERD modeling. Since to adopt object-oriented design in database field is better aligned with object-oriented application design. In order to achieve this goal, we did some research on quite a few tools in the market, and we found Visual Paradigm is an ideal UML modeling tool in data architectural design.

Below is a case study regarding how we transit client’s data model from Visio to Visual Paradigm in their data warehouse project, and how we utilize Visual Paradigm in...

Read More