How to deal with changes in data over NOSQL

We are evaluating the upcoming projects of NoSQL. I tend to think about things in an RDBMS way and have difficulties in conceptualization and lack of standardization.

I know that copying data is not considered wrong in NoSQL. What I cannot understand is to modify the data to prevent exceptions.

For example:

< p>You are organizing a series of poker tournaments. You have players,
locations, and tournament events. As I understand it, a tournament
event might contain a location and a collection of players. It does
not need to have all the player data, but if you want to get the names
and home addresses of everyone going to the next tournament, that info
should be in the tournament collection.

Someone has gotten married and moved, changing their last name and
address. Does the application need to update the player collection and
the tournament collection? Or is my model of the collections wrong? How do
developers“ keep track” of where information is duplicated?

The model I see is recently used Is to have a constant “master” data set (in your case, play Home list, a list of matches with players in each match “relationship” simulation, where the match records a list with player IDs), and can only be updated by running a periodic process on the “master” data Denormalized list (in your case, a list of matches with fully populated player data).

In this way, the application only needs to update the master data, and the regular update process will eventually rebuild the denormalized Results.

We are evaluating the upcoming projects of NoSQL. I tend to think about things in an RDBMS way and have difficulties in conceptualization and lack of normalization.

< /p>

I know that copying data is not considered wrong in NoSQL. What I cannot understand is to modify the data to prevent exceptions.

For example:

You are organizing a series of poker tournaments. You have players,
locations, and tournament events. As I understand it, a tournament
event might contain a location and a collection of players . It does
not need to have all the player data, but if you want to get the names
and home addresses of everyone going to the next tournament, that info
should be in the tournament collection.< /p>

Someone has gotten married and moved, changing their last name and
address. Does the application need to update the player collection and
the tournament collection? Or is my model of the collections wrong? How do
developers “keep track” of where i nformation is duplicated?

The model I have seen recently used has a constant “master” data set (in your case Down, the list of players, the “relationship” simulation with the list of players in each game, where the game records a list of player IDs), and only by running a periodic process on the “master” (master) data. The denormalized list has been updated (in your case, a list of matches with fully populated player data).

In this way, the application only needs to update the master data, and the regular update process will eventually rebuild Unnormalized results.

WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]
SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 674 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC

Leave a Comment

Your email address will not be published.