database - GAE - Java - Keyword classification of Datastore Entities -

-

There are 3 main types of organizations in datastore in my scenario, special users, objects and keywords. The problem is modeling relationships among those items and classifying them.

Users can create as many objects as they want and the user-object relationship can be easily applied with an anesthetic link.
I have designed inter-objects and inter-user relationships by defining the unit for any relationship. In this way, I can do all fans and fan-out and scale the relationship with the result set, so it is also time-efficient.

Now I need to classify the objects for keywords. Each object can be linked to limited things, whereas each key can not get limits.
What is the most effective way to implement them? (Time-ability (complexity, ...) and database activity)

One of the first methods can be: Give each object a list of keys:
The search result will be scale with the set , So it will not depend on the number of connections and keys.

Inter-user outlines things and key-object relationships for the inter-object case:
Search will again scale with the result set and thus does not depend on the net again Is the size.

What can I consider as a comparison criterion?

If you put a list of keywords (or their IDs) in your object unit, Costs will be included: Each keyword should write one per person, as a result of the update of the object unit and write an indexed asset per keyword.

If this happens rarely, it will be a small additional cost, and I would recommend a list approach to its simplicity. On the other hand, if the keyword is added / removed more often , Then the costs will increase rapidly.

With the keyword_object unit you avoid additional expenses for updating object entities, but you have to maintain another unit type, and your stored data will take more space (each keyword-object pair An extra key for).

I recommend going with any of these methods and later optimizing, when more data is available, unless you are unsure of getting millions of records very soon , And you already know your data access pattern.


Comments

Post a Comment

Popular posts from this blog

import - Python ImportError: No module named wmi -

-
I followed the instructions for downloading WMI for Python When I try to run the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = wmi.WMI (): if Raw_input ("restart% s?"% S.Caption) .upper () == "Y": s.StartService () I got the error < Code> traceback (most recent call end): file ". \", Line 1, edit: I am using Python 2.7.6 EDIT2: I am running 64-bit Windows 2008 R2, and I've downloaded WMI-1.4.9.zip (md5). I removed the content and put it in D: Python \ Tools \ Scripts I executed dragon setup.py.install I said D : \ Python \ tools \ scripts to% PATH% and when I execute the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = Wmi.WMI (): If raw_input ("Restart% s?"% S. Caption). () == "Y": s.StartService () error me Gets traceback (most recent call final): File ". See \", line 1, &
Read more

Editing Python Class in Shell and SQLAlchemy -

-
I am working on the terminal on a shell script after this tutorial SQLAlchemy tutorial. I need to type gt; & Gt; & Gt; Sqlalchemy import column, integer, string & gt; & Gt; & Gt; Class user (base): __tablename__ = 'users' id = column (integer, primary_key = true) name = column (string) absolute name = column (string) password = column (string) def __repr __ (self): return "& lt ; User (name = '% s', absolute name = '% s', password = '% s') & gt; "% (Self.name, self.fullname, self.password) After the problem I have typed the password = column (string) I hit twice and changed .... >> I then took everything back but then an error was thrown because the class already exists ... I am not completely sure how to fix it. How do I open that slip in the shell script and edit it (Add DF to DRR) The error thrown below: / user / giripeters / TFSQLLX / Lib / python2.7 / site-packages / sqlalchemy / ext / decla
Read more

c# - MySQL Parameterized Select Query joining tables issue -

-
I am using parameterized select questions in conjunction with my program and it works entirely, When I try to join the table Everything I have done is a small fraction: using (MySqlCommand cmd = new MySqlCommand (paramQuery) ToSql (), Connection)) /etc/ paramQuery.ToSql () Equal: "Select TableOne ID, Tableon, Department, Tablet. One by name table, Table 2 h Yes TableOnEID = @Pharmak "* / for (Int Index = 0; Index and Lt; ParamariX Parameter (.c calculation; Index ++) Cmd.Parameters.AddWithValue (paramQuery.Parameters (). ElementAt (index). , ParamQuery.Parameters (). ElementAt (index) .Value); / * ParamQuery.Parameters (). ElementAt (index) .k = "@most 0" paramQuery.Parameters (). ElementAt (index) .Value = "tableTwo.ID" * / MySqlDataReader Reader = cmd.ExecuteReader (); While (reader.Read ()) {// do stuff} } One of the tables I attempt to join is For the table, two with the same id for all. Is there something that I'm doing wrong?
Read more