modify SQL schema to minimise data load

Registered by gordon chung

currently the data stored in sql is relatively normalised. each sample received is stored essentially the same in sample table. this causes quite a bit of redundancy of data.

proposal is to:
- create a resource table which stores (generally?) static resource data such as user, project, source

Blueprint information

Status:
Complete
Approver:
Eoghan Glynn
Priority:
High
Drafter:
gordon chung
Direction:
Approved
Assignee:
gordon chung
Definition:
Approved
Series goal:
Accepted for juno
Implementation:
Implemented
Milestone target:
milestone icon 2014.2
Started by
Eoghan Glynn
Completed by
Eoghan Glynn

Related branches

Sprints

Whiteboard

Review for corresponding detailed spec:

  https://review.openstack.org/101009

Partially implemented by:

  https://review.openstack.org/111313

Gerrit topic: https://review.openstack.org/#q,topic:bp/bigger-data-sql,n,z

Gerrit topic: https://review.openstack.org/#q,topic:bigger-data-sql,n,z

Addressed by: https://review.openstack.org/113524
    switch to sqlalchemy core

(?)

Work Items

Dependency tree

* Blueprints in grey have been implemented.

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.