I have to create 2 tables:
Magazine ( 10 millions of rows with these columns: id, title, genres, printing, price )
Author ( 180 millions of rows with these columns: id, name, magazine_id )
.
Every author can write on ONLY ONE magazine and every magazine has more authors.
So if I want to know all authors of Motors Magazine, I have to use this query:
SELECT * FROM Author, Magazine WHERE ( Author.id = Magazine.id ) AND ( genres = 'Motors' )
The same applies to Printing and Price column.
To avoid these joins with tables of millions of rows, I thought to use this tables:
Magazine ( 10 millions of rows with this column: id, title, genres, printing, price )
Author ( 180 millions of rows with this column: id, name, magazine_id, genres, printing, price )
.
and this query:
SELECT * FROM Author WHERE genres = 'Motors'
Is it a good approach ?
I can use Postgresql or Mysql.
