Category Blogs

August 20, 2026 Posted in Blogs, Data Architecture, Data Migration, Database, Enterprise Architecture, Enterprise Integration

I would like to provide a data architecture summary briefly. Additionally, it reflects my long-term working practices in this area.

Data Architecture and Governance:

• Data governance involves strategies, policies, processes and procedures, collaboration, tools, audit and metrics, etc. For detail info, please refer to Seven Steps to Effective Data Governance.
• Data quality includes data validation, foreign keys, constraints and data cleansing. Please refer to 10 Best Practices in Database Schema Design.
• Metadata management involves schema design, data linage, API contracts, etc. Building a Database-driven Application Framework includes good references.
• Toolbox: MS Purview, Ataccama, Denodo

Data Modeling:

• UML: describe the relationship among objects, no emphasize o...

September 16, 2020 Posted in Blogs, Data Migration, Database, GIS, Oracle, Spatial, SQL Server

I spent many years on spatial data modeling and migration on ESRI ArcGIS and ArcSDE, served nature resources sector. Spatial data migration is common when we get involved in map-related applications.

I worked on a project which requested spatial data migration from Oracle to SQL Server. I would like to give you a quick walk-through on how it can be done correctly.

First, let’s introduce some basic concepts:

• WKT & WKB: Well-known Text & Well-known Binary, text markup language defined by Open Geospatial Consortium (OGC), supported by Oracle 9i+, MS SQL Server 2008 R2+, PostgreSQL PostGIS M2, etc.
• Geometry & Geography: Geometry: Euclidean (flat) coordinate system; Geography: Round-earth coordinate system.
• Spatial Data Types: consist of simple types and collection types as illustr...

September 14, 2020 Posted in API, Blogs, BPM, Enterprise Architecture, Enterprise Integration, ESB, SOA

During past two decades, I worked for Oracle, Accenture, Deloitte and involved clients from different industries, including consulting, forestry, finance, healthcare, retails and government agencies, what I observed was their IT environments are more and more complex and expensive, hard to manage and maintain. To simplify IT and reduce cost become strong demands from business.

In enterprise environment, Enterprise Application Integration (EAI) is outstanding since the IT environment is changing quickly with the continuous procurement and integration of new systems. The purpose of this article is to provide the perspectives on middleware selection, approaches and tools, and enterprise integration strategies.

A few key principles of enterprise integration: