Read Per Topic
Published Date
8 May 2026 12 AM
Article Title
Short Description
Data defintion language or also known as DDL, is a SQL based script which responsible for determining the entire database schema model including table definition, table attribute until configuring the referential integrity.
Background
Database schema should not be created manually to avoid runtime errors and data model inconsistency during the entire development life cycle.
Objectives
To understand how to automate the creation of physical table on postgresql
Deliverables
Article & Illustration
6 Mins Read.
7 May 2026
Postgreql configuration can be tuned up to run on small sized virtual machine. The computing power of postgresql can be limited by adjusting following parameters max_connection, shared_buffers and effective_cache size
9 Mins Read.
7 May 2026
Logical ERD is busiess level abstraction to show business object relationship alongside with the required information and data. In other hand, physical ERD is databases structure which defines table, column, data type, referential integrity and so on as a code and commonly written as SQL.
9 Mins Read.
13 February 2026
while conceptual ERD is used to discuss about the business process interaction on the solution, logical ERD is focus on the required data for each business process.
16 Mins Read.
12 February 2026
Normalized data model especially at relational database design could prevent potential long running or slow query. While, abnormal data model on RDBMS will slowdown the system performance.
Previous
Page: 1 of 1
Next
