I have a need for my system:
1) Friends - I need to calculate the distance between users to N degrees, to find common elements related to the work between users. Unable to scale this onmysql well. So, the choice I assume is a Graph database?
2) I have user profile fields, about 120 fields with 80% of them are 1: M fields, so in mysql this means about 96 tables for 1: M storage. If I need to pull out all the user information, then I need to achieve all these tables. So, the solution here is a document database, a colunm database or a key value database?
Currently, I have seen OrientDB, which can act as a document and graphic database. Could this be used for the above needs or are there better DB options for this?
Thank.
EDIT: Req for Profile - Custom fields: IT is a social network career, so there are many portfolios, for example, 1: M fields. So, if there are 120 fields, of which 96 of them are 1: M, what is the best way to store them? Exqample is the company you worked on. Schools you attended. The magazines you read. Articles you wrote, etc. Each of them is 1: M, and there are 96ish fields, such as = 96 Mysql tables. I can’t combine, because some of them have unique metadata. I need to search by fields and allow quick reads in order to maintain a good user interface.
For graphic display: we are talking about connecting people. For launch, I use only one feature when you are viewing someone, which system will say how many degrees separates you from the person. The remaining "social" functions are intended for post-launch. Anyway, in MySQL, I cannot do it well enough to scale. IF I have 100 friends and each person as 100 friends, and therefore, in order to best find my way around these people, I assume Count DB.
The platform is a codeignitor PHP / Mysql for the base database.