← Back to team overview

ubuntu-touch-coreapps team mailing list archive

Re: [RSS Reader] E-R diagram

 

Hi Michael,

Good question :P

My friend and I have discuss this question for several hours, then our
final explanation is : the "favourite"(forever) includes "read
later"(temporarily) .

>From the user's point of view, if the user mark a article "read later" that
means user wants to keep this article for a while, kind of temporarily; if
the user wants to keep this article forever, just mark it "favourite", of
course the user will "read it later".

Thanks for asking this question :)


2013/4/25 Michael Hall <mhall119@xxxxxxxxxx>

> This would mean that an article can't be both favorite and "read later",
> is that desirable/acceptable?
>
> Michael Hall
> mhall119@xxxxxxxxxx
>
> On 04/25/2013 04:27 AM, Joey Chan wrote:
> > sorry... wrong E-R diagram, here's the correct one:
> >
> > 内嵌图片 1
> >
> >
> > 2013/4/25 Joey Chan <qqworini@xxxxxxxxx <mailto:qqworini@xxxxxxxxx>>
> >
> >     Hi Gentlemen,
> >
> >     I consult one of my friends who is a database specialist, he advise
> >     me to combine "favourite" and "readlater" into an attribute called
> >     "status" of article entity, to make the database designs more
> >     simple, here's the new E-R diagram:
> >     内嵌图片 1
> >
> >
> >     According to this diagram, only three database tables are needed.
> >
> >     Any different opinions are welcome :)
> >
> >
> >
> >     2013/4/22 Joey Chan <qqworini@xxxxxxxxx <mailto:qqworini@xxxxxxxxx>>
> >
> >         Hi Svenn-Arne,
> >
> >         Agree with your advice that rename "Tag" to "category", we
> >         developers will easily understand what the functions would like.
> >
> >         For avoiding duplicate tag names, this is a good idea but should
> >         not be included in this part(database), will talk about later.
> >
> >         :)
> >
> >
> >         2013/4/22 Svenn-Arne Dragly <s@xxxxxxxxxx <mailto:s@xxxxxxxxxx>>
> >
> >             I think it looks like a very good core design for the
> database.
> >
> >             We could rename "tag" to "category". It is likely that the
> >             user will want to organize feeds in different categories to
> >             merge them in one view. For instance "Business", "News",
> >             "Hobbies", "Sports", etc.
> >
> >             "Tags" and "categories" from a database perspective is
> >             pretty much the same, so the proposal to rename "Tag" to
> >             "category" is merely to emphasize that it will be used as a
> >             strong organizing tool. (Basically, I want to avoid having
> >             the user create multiple tags like "hobbies", "hobby", "my
> >             hobbies" for the same thing, and rather put them all in one
> >             category, "Hobby").
> >
> >
> >             Great work!
> >
> >
> >             On 04/22/2013 11:38 AM, Joey Chan wrote:
> >>             Seems that was my misunderstand  :P
> >>
> >>             So, any further suggestion or advices to the E-R diagram?
> >>
> >>
> >>             2013/4/22 <mrqtros@xxxxxxxxx <mailto:mrqtros@xxxxxxxxx>>
> >>
> >>                 I think we have misunderstanding.
> >>
> >>                 Look in databasemodule.js
> >>
> >>                 We have two tables, "userfeeds" and "feedentries" (mb
> >>                 not exact names, I can't check actual names).
> >>
> >>
> >>                 22.04.13 13:06 Joey Chan написал(а):
> >>
> >>                 Hi Roman,
> >>
> >>                 Not similar exactly, I separate the article(item) from
> >>                 feed because I want to store the feeds and
> >>                 articles(items) in separate database tables. This may
> >>                 sounds a bit complicated but I think this is necessary.
> >>
> >>                 :)
> >>
> >>
> >>                 2013/4/22 <mrqtros@xxxxxxxxx <mailto:mrqtros@xxxxxxxxx
> >>
> >>
> >>                     We already have similar model, without favourites
> >>                     and tags, am I right? =)
> >>
> >>
> >>                     22.04.13 6:49 Joey Chan написал(а):
> >>
> >>                     Hi Ladies and Gentlemen,
> >>
> >>                     I've done the E-R diagram of RSS Reader, preview:
> >>                     内嵌图片 1
> >>
> >>                     description:
> >>
> >>                     1. feed is the primary entity, it may contains
> >>                     many "tags" , "articles(items)" and
> >>                     necessary attributes;
> >>
> >>                     2. article(item) is the secondary entity, every
> >>                     article(item) has its own attributes.
> >>                     I separate article(item) from feed(which has a
> >>                     complete xml include articles) because the reader
> >>                     doesn't need to read the whole xml content if the
> >>                     user just wants to read one article, also, the
> >>                     design team will have more freedom to design the
> >>                     interaction with one article(item);
> >>
> >>                     3. tag, means ... maybe call it "category"   >_<
> >>
> >>                     4. favourite, favourite articles;
> >>
> >>                     * the attachment is a gia source file, pls use
> >>                     Dia(sudo apt-get install dia) to open it and feel
> >>                     free to discuss :)
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> >
> >
> >
>
> --
> Mailing list: https://launchpad.net/~ubuntu-touch-coreapps
> Post to     : ubuntu-touch-coreapps@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~ubuntu-touch-coreapps
> More help   : https://help.launchpad.net/ListHelp
>

Follow ups

References