Implementing taxonomies in php/sql/ci ?

I know what taxonomies (categories,tags) are, i just want to learn more about how to implement and manage them in php/sql.
From my searches all i got was wordpress related results, i thought maybe someone here can point me in the right direction.