Database schema for large scale project

The project is for a database schema for large scale classified listing project. Only the schema for this stage. The key requirements are:

Scaleable

Full text searching

Multilingual - many languages

Revision history (wiki like)

All edits are to be retained and identified by User, time, etc, so that all updates can be individually rolled back to a previous state.

The overall structure is to organize data objects

- Listings

- Comments

- Ratings

- Notes

- Other

Sections

- approximately 10 sections

- organize topics

- topics are repeated in each section

Topics

- many topics

- topics organize listings

- listings are unique for each Section and Topic combination

Listings

- many listings

- listings contain many attribute values (fields), including some with text

- may be translated into multiple languages

Users

- many users

- user profiles and details

Comments

- users may comment on anything – Sections/Topics/Listings/Users

Ratings

- users may rate Topics

Notes and Bookmarks

- users may have notes and bookmarks on anything

We are looking for the optimum solution, but we do have a prototype in PostgreSQL to evaluate against where all the data is in the same table. The table has a minimal number of specific fields relating to the record specifically, plus 100 text, 20 date, 20 numeric, and 10 blob. Templates, based on Section, Topic and record type point to the actual data field location. A certain number of these fields are indexed for performance.

Procesamiento de datos

Nº del proyecto: #64639

Sobre el proyecto