You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@james.apache.org by GitBox <gi...@apache.org> on 2021/08/20 11:01:13 UTC

[GitHub] [james-project] chibenwa opened a new pull request #608: [DOCUMENTATION] mailbox/cassandra table structure and denormalization

chibenwa opened a new pull request #608:
URL: https://github.com/apache/james-project/pull/608


   This is the follow up of a discussion with @vttranlina 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org
For additional commands, e-mail: notifications-help@james.apache.org


[GitHub] [james-project] chibenwa merged pull request #608: [DOCUMENTATION] mailbox/cassandra table structure and denormalization

Posted by GitBox <gi...@apache.org>.
chibenwa merged pull request #608:
URL: https://github.com/apache/james-project/pull/608


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org
For additional commands, e-mail: notifications-help@james.apache.org


[GitHub] [james-project] vttranlina commented on pull request #608: [DOCUMENTATION] mailbox/cassandra table structure and denormalization

Posted by GitBox <gi...@apache.org>.
vttranlina commented on pull request #608:
URL: https://github.com/apache/james-project/pull/608#issuecomment-904280512


   Did you update png image?
   https://github.com/apache/james-project/blob/c11234aeb9335ed7e11047fbb97c693bec87162c/mailbox/cassandra/doc/table_structure.png


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org
For additional commands, e-mail: notifications-help@james.apache.org


[GitHub] [james-project] vttranlina commented on pull request #608: [DOCUMENTATION] mailbox/cassandra table structure and denormalization

Posted by GitBox <gi...@apache.org>.
vttranlina commented on pull request #608:
URL: https://github.com/apache/james-project/pull/608#issuecomment-903581842


   ![Screenshot from 2021-08-23 16-06-01](https://user-images.githubusercontent.com/81145350/130421072-fac95bef-7f80-49db-a141-ee7b56e7e005.png)
   Should be "maxMessageCount"


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org
For additional commands, e-mail: notifications-help@james.apache.org


[GitHub] [james-project] Arsnael commented on a change in pull request #608: [DOCUMENTATION] mailbox/cassandra table structure and denormalization

Posted by GitBox <gi...@apache.org>.
Arsnael commented on a change in pull request #608:
URL: https://github.com/apache/james-project/pull/608#discussion_r693624243



##########
File path: mailbox/cassandra/doc/README.md
##########
@@ -0,0 +1,25 @@
+# Cassandra implementation for the mailbox
+
+This file attempts to provide information useful to mailbox/cassandra developers.
+
+## Table structure
+
+![Table structure chart](table_structure.png)
+
+Can be edited using [this source file](table_structure.drawio) on [this website](https://app.diagrams.net/).
+
+This file should be edited everytime the table structure is modified.
+
+## Approach regarding denormalization
+
+The Cassandra mailbox is heavily relies on denormalization. The same data is stored several time, in distinct tables,

Review comment:
       ```suggestion
   The Cassandra mailbox is heavily relying on denormalization. The same data is stored several times, in distinct tables,
   ```

##########
File path: mailbox/cassandra/doc/README.md
##########
@@ -0,0 +1,25 @@
+# Cassandra implementation for the mailbox
+
+This file attempts to provide information useful to mailbox/cassandra developers.
+
+## Table structure
+
+![Table structure chart](table_structure.png)
+
+Can be edited using [this source file](table_structure.drawio) on [this website](https://app.diagrams.net/).
+
+This file should be edited everytime the table structure is modified.
+
+## Approach regarding denormalization
+
+The Cassandra mailbox is heavily relies on denormalization. The same data is stored several time, in distinct tables,
+to satisfy the various read access patterns. Of course, the various table can become inconsistent between them.

Review comment:
       ```suggestion
   to satisfy the various read access patterns. Of course, the various tables can become inconsistent between them.
   ```




-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org
For additional commands, e-mail: notifications-help@james.apache.org