Databases
StackOverflow2013
Postsdbo
PODesign a tag suggestion feature from startup by C# and database
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODesign a tag suggestion feature from startup by C# and database
    primarykey
    data
    text
    <p>A very simple feature with complex inside.</p> <p>I want when a user input tag, I give suggestions. For example, when type <code>a</code>, I suggest <code>ASP</code>, <code>ASP.net</code>, <code>Apache</code> etc etc.</p> <p>I have (or will save) user inputted tags. I have two options(places) to save them.</p> <ul> <li>SQL Azure</li> <li>Azure Table Storage</li> <li>or Both</li> </ul> <p>About Data Structure, I am not sure yet. But I guess <code>&lt;tagText&gt;</code> <code>&lt;tagUsedTimes&gt;</code> should be essential. For the <code>&lt;tagUsedTimes&gt;</code>, no need very accurate (since its just a suggestion). And for <code>&lt;tagText&gt;</code> I don't know if I should save it literary, but if I do, I have to compare text by <code>.left(length)=</code>, will not perform well.</p> <p>The scale. You can get an idea from how many tags have been used in stackoverflow from millions of posts. And not like stackoverflow, user can input any tags, not limited to the existing tags (I found I can only create new tags after I have 1500 reputations here).</p> <p>Please point me a way to correctly construct this.</p> <p><strong>[EDIT]</strong></p> <p>To be clear, I am not providing this feature now. But I plan to save all data in a correct structure for my next step. So, I like to know any reasonable way to do it</p> <p><strong>UPDATE</strong></p> <p>for <code>&lt;tagUsedTimes&gt;</code>, I have a way since its deployed from start up. I can +1 for exist tags when a new entry( or article etc) saved, and create unexist tags and set <code>&lt;tagUsedTimes&gt;</code> to 1. For editing old entry, just -1 for removed tags.... May not accurate for long run, since may have error here and there within times. But I guess the number is enough for tag popularity. </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USEric Yin
    1. USEric Yin
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PODesign a tag suggestion feature from startup by C# and database
      1. USAlireza Sabouri
      1. VTFavorite
    2. VO
      singulars
      1. PODesign a tag suggestion feature from startup by C# and database
      1. This table or related slice is empty.
      1. VTModeratorReview
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload