Data Architecture Design tagged posts

Building a Database-driven Application Framework

Normally, people use database as data store, which contains all data tables and lookup tables. The front end application reads the data, presents them to user. If we get another similar request, we simply build another application, which handles another similar database schema. If we get a dozen clients, it’s going to be hard to maintain them all.dbdriven

Many application vendors are struggling to manage the variety of clients’ requirements, while providing similar functional modules to different clients. How do we handle all these changes easily on a common front-end code base? There are many answers, you might say that we may encapsulate the modules, inherit them and expand them. It’s a valid answer...

Read More

Database Modeling in UML

ERWin is a long term standard database modeling tool for building up ERD. Usually data architect spends lots of time on handling the relationships among entities, then utilizes forward engineering function to generate database schema.

During database modeling practices, an outstanding issue has been noticed that some of our clients made mistakes in transaction design. All the transactions of all kinds of activities are kept in one transaction table, with fields createdby, createdon, createdusing, modifiedby, modifiedon and modifiedusing, etc. Initially, the system might work properly. But with time goes, e.g., after 3 years, the transaction table is very likely occupies more than half of the disk spaces of the entire database...

Read More