Image:Db tables.png

The relational database contains seven tables which are devoted to store various information from profiles to file locations.

Table of contents

Nodes table

The Nodes table stores information related to a node : address (IP, port), network capability (bandwidth), presence (last seen time), and some fields to characterize the node (affinity, message_count).

Node Interests table

The Node Interests table describes the words of interest for a given node. The interest of a node for a word is quantified by three values : the specialization and the popularity, and the number of messages involving both the user and the word.

Words table

The Words table stores information related to a word: the number of times a download has been initiated by this word and the number of times the word has appeared in messages.

Document Providers table

The Document Providers table associates a node with a document. It also contains a field indicating the last time this document was owned by the user.

Files table

The Files is the data structure for a file. The fields are various information related to the file.

Documents table

The Documents table differs from the Files table. A document may have many replicas, having different filenames. This table stores basic information related to the contents (text, title), to the administration (size, state) or to the Maay system (the download count or the visibility).

Document Scores table

The Document Scores table is equivalent to the Node Interests table except it applies on documents and words rather than on node and words. The relevance and the popularity are some measures for approximating the relationships between a word and a document.