Best Practices tagged posts

10 Best Practices in Database Schema Design

During past two decades, I have been working on many database design and migration projects. There are a lot of decisions to make in creating new database schema. Any database schema changes can be very expensive in a later date. Some may even result in rewriting the front end applications. So to understand a few best practices and apply them in your database schema design is vital important.

1. Take the advantages of UMLdb_schema

Most people use ERWin to create ERD, then use forward engineering to build up database schema. If we may move further and think about how to use object-oriented UML to describe the world, it might be very helpful. UML brings lots of benefits like composition relationship and inheritance (generalization relationship)...

Read More

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