|
Post by Chinnico on Sept 15, 2022 22:45:17 GMT
Recently I have been reading quite a few books on videogame history. Some better than others, but overall very interesting.
One of the difficulties I personally have, regardless of how well the books are written and organised, is to keep track of timelines, company or people names, as they change and move around.
So I thought that for me it would be more convenient, if there was a way of visualising all the information in a graphical way.
For example, I could start from Atari on the 70s and mark key dates: foundation, acquisition by Warner, transfer to Tramiel etc. Then I would join people's information: who worked there, from when to when.
And following relationships between companies and people, I would like to create and visualizer a network of connections, that develops across a span of a number of years.
Visually, I really see a series of parallel lines, that run along the time axis. For example, a company would start at its foundation, maybe split or merge if sold or acquired, and terminate if closed.
'Zooming in', one could see details and, connected at certain key time points, other lines, representing for example the people working on there, or external studios with a collaboration contact. And even the games that were produced at s certain date.
I know little about them, but I thought that a graph database could be used better than a classic relational one. If anyone had experience on this topic and could lend some advice, it would be really appreciated.
I hope I was not too confusing in presenting the idea. I myself I have not but a fizzy image in my head yet!
|
|
|
Post by Markopoloman on Sept 16, 2022 0:26:18 GMT
Well, you managed to insert a fizzy image in my head reading that! It would be great!!
|
|
|
Post by Chinnico on Sept 16, 2022 7:43:57 GMT
Well, you managed to insert a fizzy image in my head reading that! It would be great!! I am glad you like the idea. actually, I wanted to spell 'fuzzy', but the phone corrected it to'fizzy'and I did not notice. Not that it changes much!
|
|
|
Post by Markopoloman on Sept 16, 2022 8:26:42 GMT
Well, you managed to insert a fizzy image in my head reading that! It would be great!! I am glad you like the idea. actually, I wanted to spell 'fuzzy', but the phone corrected it to'fizzy'and I did not notice. Not that it changes much! There's me thinking you were just being Italian and getting an English word a little wrong!
|
|
|
Post by whazeboo on Sept 16, 2022 9:59:47 GMT
Being a regular contributor to www.mobygames.com/, I think they quite nailed it with their datamodel. It allows users to query games by any dimension imaginable. It is a pity their data is used only at an operative level i.e. per game, publisher or system. A new version of their site is Work In Progress, and I sincerely hope they will also add a couple of high-level graphs/visuals that give an idea of the sheer scope of data they have gathered throughout the years.
|
|
|
Post by Markopoloman on Sept 16, 2022 11:17:26 GMT
I was doing a round on Computer history for our pub quiz and used this site for some of the questions... I guess that sort of thing as a base would be good. www.computerhistory.org/timeline/1933/
|
|
|
Post by necronom on Sept 16, 2022 12:50:53 GMT
In the past when I've read features in Retro Gamer or game history books I've often thought that a large diagram showing the route that people took and the companies that were taken over or changed names would be brilliant. So many people and companies were moving around that having it all in one large page would be excellent. It would take a lot of research, though maybe something people can contribute to would work. Many hands make light work, as they say. No idea how to do it though.
|
|