COSCUP x UbuCon Asia 2026 Logo
  • About
  • Session
  • Transportation
  • Venue
  • Communities
  • Sponsors
    • Participate Guide
    • First Timer
    • Activity
    • Speaker Participation
    • Welcome Party
    • For Overseas Visitors
    • Open Source Communities
    • Sponsorship Partners
    • Invitation Letter Guide
  • Staff
  • Fringe Events / BoF
  • Blog
  • CoC
中文

Modeling "Numbers and Quantities" Correctly in Information Systems

Time
2026-08-08 13:45 ~ 14:15
Speaker
張友謙
Room
RB102
Co-write
PostgreSQL Taiwan AdvancedMandarin

Abstract

"Numbers and Quantities" is one of the most fundamental yet underestimated topics in information system design. This talk focuses on the correct modeling and application of "quantities" in real-world systems, and how it should be properly integrated with Domain-Driven Design (DDD). While "numbers" are pure mathematical concepts, "quantities" carry business rules, units, precision, and cultural differences. From financial rounding and precision issues, manufacturing unit conversions and loss calculations, to medical multilingual processing and complex e-commerce order states, the correct modeling of quantities directly affects system stability, consistency, and maintainability. This talk will explore:

The essential differences between "numbers" and "quantities" Practical database techniques for handling quantities (custom types, domain events, materialized views, triggers) Common anti-patterns and lessons from real projects How DDD should work with database design instead of treating it as a mere implementation detail

The goal is to help developers and architects think more systematically about one of the most critical foundations in information systems.

Speaker

張友謙

張友謙

今年已經是第N年與大家一起分享關於PostgreSQL的方方面面了. 今年會有比較進階且與系統設計有關的議題.

Diamond

Canonical

Gold

Consecutive2 YrsInformation Management AssociationConsecutive2 YrsCathay Financial HoldingsConsecutive5 YrsE.SUN BankCumulative12 YrsMySQLCumulative6 YrsBerry AINitra

Silver

Cumulative16 YrsGamesofa Inc.

Bronze

KKTIXNational Center for High-performance ComputingONLYOFFICEQNAP Systems, Inc.Consecutive16 YrsThe Archilife Research FoundationSUN SQUARE Co., Ltd

Friend

Consecutive3 YrsAndes Technology CorporationAppier

Special Thanks

Consecutive2 YrsDepartment of Information Technology, Taipei City GovernmentSiFiveRozeta AI

Co-host

Collaborator9 YrsNTUST - Department of Electronic and Computer Engineering

Co-organizer

Collaborator12 YrsOpen Culture Foundation

COSCUP x UbuCon Asia 2026

Conference for Open Source Coders, Users, and Promoters | Asia's largest open source community conference.

Contact

  • Attendee Services
  • Sponsorship
  • Call for Proposals
  • Marketing

Resources

  • COSCUP Blog
  • Newsletter Subscription
  • Event Photos

Sitemap

  • Home
  • About
  • Transportation
20062007200820092010201120122013201420152016201720182019202020212022202320242025