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:


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


- approximately 10 sections

- organize topics

- topics are repeated in each section


- many topics

- topics organize listings

- listings are unique for each Section and Topic combination


- many listings

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

- may be translated into multiple languages


- many users

- user profiles and details


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


- 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.

Habilidades: Processamento de dados

Veja mais: type of searching in data structure, type of data structure in c, searching in data structure, searching data structure, prototype date, key data structure, indexed data, data structure type, data structure topics, data structure solution, data structure searching, data structure in c notes, type notes, schema, scale, postgresql c++, optimum time, numeric, minimal, many languages

Acerca do Empregador:
( 44 comentários ) Point Roberts, United States

ID do Projeto: #64639