An iCalendar Schema

To start this blog, and to demonstrate database analysis, I’m spend some time creating a schema for the iCalendar standard. You can find the the RFC here. I’ll be concentrating on MySQL (MariaDB in truth), but I’ll make notes about MS SQL and Oracle.

The reason I chose to look at iCalendar first is there have been many requests online for such a schema. This will allow me to create a full schema for the standard and then write Java and C# libraries read and save calendar components to and from the database.

You might question why I selected MySQL instead of MS SQL or Oracle. The primary reason if that MariaDB is the database server my personal web site host uses. I also selected this database because it does not support User Defined Data types. I’ll be forced to using the standard data types.

This blog is meant to allow the readers to follow my  thought process, and hopefully pick up some tips on database analysis.

My next post will be the start of a discussion of the data types defined in the RFC and how to translate them into the appropriate database fields.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s