INAPP Checkbox use

Hi,

I was told that the INAPP check box is used to define whether its stored in a SQL or OLAP database. However when i go to SQL database enterprise manager i see no difference between a SQL and INAPP database. May i know a real life example how a SQL and database looks like and their difference?