Feature #5071

Redesign Pithos DB Schema

Added by Christos Stavrakakis about 10 years ago.

Status:New Start date:02/13/2014
Priority:Medium Due date:
Assignee:Chrysostomos Nanakos % Done:

0%

Category:Pithos Spent time: -
Target version:0.16

Description

  • Remove config table
  • Merge xfeature with xfeaturevals table
  • Separate tables for information about current objects and versions:
    - nodes/versions
    - attributes/version_attributes
    - statistics/version_statistics
  • Add account and container to most tables with corresponding indexes
  • Use object UUID as the unique identifier and remove the 'serial' field
  • Misc changes to table columns

The updated DB schema is the following:

attributes / version_attributes
--------------------------------
account
container
domain
uuid
key
value

nodes/versions
--------------
uuid
account
container
path

hash
size
type
source
mtime
muser
checksum
cluster (πάντα 0 στα nodes)

statistics/version_statistics
------------------------------
account
container
size
count
mtime

xfeatures (permissions)
-----------------------
id
account
container
path
key
value

policy
------
account
container
key
value

public
------
id
account
container
path
active
url

groups
------
owner(account)
name
member

Also available in: Atom PDF