Phillyman

Chaining The Databases Together

6 posts in this topic

So as I have mentioned in the past, these individual databases can be chained together thru relational fields. I am thinking about creating an Master Database that would act as a searchable index for information. Lets take one of @kitsunebi77 recent releases.....

On page 79 is a review for "The 7th Guest" by T. Liam McDonald

However there is no easy way to figure that out on Retromags. No one has yet to jot down on the content page within the Magazine DB, but even if they did, we are very limited in gathering the information we need.

What if we had a indexing database, that a user could go to and enter in those few pieces of information.

  • Game Title
  • Magazine Issue
  • Page Number
  • Type of Page (review, cheat, preview, interview)
  • Person

The Game Title and Magazine Issue fields would be tied to their respective databases, so as you type "The 7..." the fields would present matching records from those databases. With all of that data in 1 centralized location, a user could go and filter down results

  • Show me all Interviews in GamePro Magazine
  • Show me all prototype mentions in 1995
  • Show me all reviews for Super Mario Kart

Of course this is only the first piece of the puzzle I need to work thru. We should also be able to chain the Video Game Database to the Strategy Guide Database.....we just would create a new field called "Strategy Guides" in the Video Game DB, and have that field chain back to a field on the Strategy Guide side called "Games in this Guide".

Other chains could be....

  • People Database to the publications they worked on
  • Book Database to the Video Games they mention

Anyhow I don't own a whiteboard, but I am sketching up a rough draft in paint :lol:

databases.png

 

 

2 people like this

Share this post


Link to post
Share on other sites

So as a test I just created a new field in the Video Game DB called Strategy Guides, and chained it to the Strategy Guide DB. When you are editing a video game record it will look like this.....

StratGuideField.gif

 

And when you save the record it will show like this.....

 

2017-02-08 15_48_21-Mario Paint - Super Nintendo - Retromags Community.png

 

and if I turn on Cross Linking, then this shows up on the Strategy Guide Record for Mario Paint....

 

2017-02-08 15_55_52-Mario Paint Player's Guide - Nintendo of America - Retromags Community.png

Share this post


Link to post
Share on other sites

I'm all for improving the search functionality of the site and especially appreciate the idea of cross-referencing games with magazines.  If I could visit RetroMags, edit a game title, then associate the game with one or more magazine issues, strategy guides, credits, etc, that'd be a perfect fit imo.

It'd be a boon for researchers and gaming historians especially.  Search for a game and immediately be presented with magazine issues with coverage of the game?  That'd be crazy useful.

1 person likes this

Share this post


Link to post
Share on other sites
1 hour ago, RetroDefense said:

I'm all for improving the search functionality of the site and especially appreciate the idea of cross-referencing games with magazines.  If I could visit RetroMags, edit a game title, then associate the game with one or more magazine issues, strategy guides, credits, etc, that'd be a perfect fit imo.

It'd be a boon for researchers and gaming historians especially.  Search for a game and immediately be presented with magazine issues with coverage of the game?  That'd be crazy useful.

I remember back to the 90s when Nintendo Power released out the indexes to their magazines. It went over which issues you could find game coverage in....and what type of coverage it was. It was a tremendous help for those first 50 issues of Nintendo Power. The ability to dump all of this into a database that can be filtered and searched would be a huge asset to anyone wanting to track down information.

I know I would love to have an easy way to bring up any launch articles on the Super Nintendo. It would only take a few seconds to place in each entry, and anyone could add to it, but as each entry was added, it would become that much more valuable. :)

1 person likes this

Share this post


Link to post
Share on other sites

This kind of thing was always my goal for my Magazines from the Past Wiki, but everything had to be done manually and it just would never get to the stage  that I would like without a colossal amount of work for each magazine.  I want to be able to search for Mario Kart and find every magazine it's previewed, reviewed, tipped, featured in.  I want to be able to search for a writer and find every review, feature they've written.  And if possible I'd want to have an average score generated for each game for each format in a metacritic style.  Sadly it all became clear i'd never get my Wiki as good as I wanted and have pretty much retired it.

If you are able to quickly link games and people to magazines without having to manually create every game page/person page and manually add the links, that would be superb and i'd be happy to contribute anything i've already done for my Wiki.

1 person likes this

Share this post


Link to post
Share on other sites

This sounds great. I was actually wanting to use the games database like this. When I was done scanning my stuff I wanted to index magazines to the games pages. Like go through every magazine and every mention of a game fill that info into the games page.

 

So say I'm going through EGM 9 or something. The super Mario 3 review. I'd put that information on the Super Mario Bros 3 page that in EGM 9 you can find a review on page 35. 

 

But what your proposing sounds sounds even better.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now