Wiki articles tagged with "database"

Showing 21-22 of 22 items.

Single table inheritance

Created 12 years ago by samdark, updated 12 years ago by samdark.

Relational databases do not support inheritance so if we need to represent it, we have to somehow store meta info while keeping performance by minimizing JOINs. One way to solve this problem is using single table inheritance. All fields for the whole class tree are stored in a single table. Class name is stored in the type field...

34 0
35 followers
Viewed: 52 982 times
Version: 1.1
Category: How-tos

Guidelines for good schema design

Created 12 years ago by Steve Friedl, updated 5 years ago by softark.

Virtually all Yii applications are built on top of a database, and though Yii is very flexible in how it addresses your DB, some design choices make things more convenient than others.

124 0
71 followers
Viewed: 121 688 times
Version: 1.1
Category: Tips