Category Database

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...

December 21, 2022 Posted in Data Migration, Database, Enterprise Integration, LiveSync Automation, SAP, Uncategorized

One of my clients is moving its SAP on-premise instances to the cloud. SAP offers Near Zero Downtime Technology (NZDT) to reduce the migration downtime from approx. one week to 6-60 hours (from 6pm Friday to 6am Monday). The purpose of applying NZDT is to secure business continuity. However, it’s not cheap, to pay a million-dollar bill for a weekend! If you know how, then the estimation of building your own in-house developed NZDT component should be less than 50K.

Please be aware, NZDT is neither a new technology, nor the invention of SAP. The discussion of how to implement it is all over the place on the internet. Our Architects have gained enough experience in this area during the past two decades. We have designed and developed sophisticated non-stop 24*7 data replication tool Live...

June 1, 2021 Posted in Data Migration, Data Visualization and Analytics, Database, GIS, Oracle, Spatial

As the official SQL client, Oracle SQL Developer is popular. It offers a function to view spatial data using Map View tool.

Assume you have an Oracle Spatial-enabled database, you have a Shape column with SDO_GEOMETRY data type in your spatial table. This column contains spatial data. How to see the actual map or shapes in Oracle SQL Developer?

First, we may do a query for this spatial table, e.g. SELECT * FROM LGS_Land_Parcel_Geo.

Second, go to SQL Developer menu View \ Map View to turn on Map View panel. Click + button in the toolbar of Map View panel to open Map Query box. Insert above query statement and provide a Map Title for your query. Click OK to close the dialog box.

The map of this table shows in left Map View panel...