December 23, 2014 Posted in Blogs

Our utility client has a large site with numerous sub-sites that need to be migrated to a new million dollars WCM (Web Content Management) based system. The new site is based on Adobe CQ* which is a neat WCM system.

The problem is the migration can’t be done in one day. In a large organization, the way it works is to migrate sub-sites one by one. The procedure can take a few months or longer. So we need to bridge the legacy site and new one to help on seamless migration. When user accesses the site, user may access the bookmarks or favorite links that they stored in their browsers. Those bookmarks still point to legacy sites even there are newly migrated sites available. What we need do is to find the match in between and redirect the legacy URLs to the new one running on new WCM system.

December 21, 2014 Posted in Blogs

One of our utility clients uses MS Visio as its logical data modeling tool. MS Visio is designed as a drawing tool,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...

December 20, 2014 Posted in Blogs

Nowadays, there are quite a few content management systems available on the market. Almost every big vendor has their own solutions in this arena. IBM got FileNet in early days, HP paid $10B for Autonomy, Oracle has its UCM (acquired from Stellent), Adobe acquired CQ from Day Software.

Except all these big players, Alfresco offers quality open source suite for enterprise content management needs. The solution is impressive. It doesn’t require high-power clustered servers to run, alternatively, you may even install and play with it on your laptop. The implementation of Alfresco presents some big trends in IT industry: quick implementation, modularized, integrated some market-approved products, such as Apache Tomcat, PostgreSQL and LibreOffice (a sibling of OpenOffice), etc.

Here’s a b...