Insights | Archilion

10 Articles

Data & Systems Architecture ×

Why "just add a field" to your ERP is not as simple as it sounds

Nguyễn Hải Minh

Why "just add a field" to your ERP is not as simple as it sounds

A customer wants a new field on the order form — a priority flag, an extra reference number, whatever. It sounds like a five-minute change: one text box, one dropdown. Whoever owns your ERP promises "...

Data & Systems Architecture

Jul 22, 2026

4 reasons spreadsheets and raw files always lose to a real database as a workshop grows

Nguyễn Hải Minh

4 reasons spreadsheets and raw files always lose to a real database as a workshop grows

Most manufacturing workshops start with Excel. Then someone adds a second spreadsheet for inventory, a shared folder for order confirmations, and a third file for supplier contacts. It works for a whi...

Data & Systems Architecture

Jul 22, 2026

The physics of a spinning disk: why your ERP feels slow at the worst possible time

Nguyễn Hải Minh

The physics of a spinning disk: why your ERP feels slow at the worst possible time

Every workshop manager has lived through this moment. It is close to the end of the shift, everyone on the floor is entering the day's production numbers into the ERP at the same time, and the system ...

Data & Systems Architecture

Jul 22, 2026

The Core-Shell model: why "just customize the ERP" is always harder than it sounds

Nguyễn Hải Minh

The Core-Shell model: why "just customize the ERP" is always harder than it sounds

Every workshop that installs an ERP system eventually asks for "just one small change." Add a field to the goods-receipt screen. Change how a discount is calculated. Make the system talk the way the s...

Data & Systems Architecture

Jul 22, 2026

Individual vs. standard software — the "AT-software" trap that makes a system impossible to maintain

Nguyễn Hải Minh

Individual vs. standard software — the "AT-software" trap that makes a system impossible to maintain

Most workshops don't set out to build custom software. They set out to solve one specific problem — connect the warehouse system to the accounting export, or bridge the ERP to a customs portal — and a...

Data & Systems Architecture

Jul 22, 2026

5 types of system integration — a framework for why your two systems "don't talk" to each other

Nguyễn Hải Minh

5 types of system integration — a framework for why your two systems "don't talk" to each other

Every workshop that runs more than one system eventually hits the same wall: the ERP shows one stock number, the shop floor log shows another, and someone has to manually reconcile them every week — o...

Data & Systems Architecture

Jul 22, 2026

OLTP vs. data warehouse — why running the month-end report slows down your entire order system

Nguyễn Hải Minh

OLTP vs. data warehouse — why running the month-end report slows down your entire order system

Every month, the same complaint shows up in workshops running an ERP: someone opens the sales report, and for the next twenty minutes order entry on the shop floor feels sluggish. It's tempting to bla...

Data & Systems Architecture

Jul 22, 2026

The star schema through a real example: measuring delivery time with a fact table and dimensions

Nguyễn Hải Minh

The star schema through a real example: measuring delivery time with a fact table and dimensions

A customer asks why an order shipped three days late last month. Your ERP can answer that for one order, on one screen, in seconds — it was built to run that exact order in the first place: check whic...

Data & Systems Architecture

Jul 22, 2026

Model the process before you automate it — a real example with EPK, XOR and AND

Nguyễn Hải Minh

Model the process before you automate it — a real example with EPK, XOR and AND

A delivery-time calculation sounds like a simple feature: a customer places an order, the system checks stock, and it returns a promised date. Most teams write that logic straight into the ERP's scrip...

Data & Systems Architecture

Jul 22, 2026

The 4 basic OLAP operations: looking at company data from any angle without writing new SQL every time

Nguyễn Hải Minh

The 4 basic OLAP operations: looking at company data from any angle without writing new SQL every time

Every time the owner of a company asks a new question about the numbers — "how do late deliveries look for this customer this quarter?", "which warehouse is causing the delays?" — someone has to go ba...

Data & Systems Architecture

Jul 22, 2026

ContactLiên hệ

Send a messageGửi tin nhắn

Zalo