Thunderhawk: Operation Phoenix

Thunderhawk: Operation Phoenix, known as Thunderstrike: Operation Phoenix in North America, is a 2001 combat flight simulator video game developed by Core Design and released by Eidos Interactive exclusively for the PlayStation 2. It is the sequel to Firestorm: Thunderhawk 2.

Thunderhawk: Operation Phoenix
Developer(s)Core Design
Publisher(s)Eidos Interactive
Platform(s)PlayStation 2
Release
  • EU: 12 October 2001
  • NA: 15 October 2001
Genre(s)Combat flight simulator
Mode(s)Single-player

Reception

Thunderhawk: Operation Phoenix received mixed reviews from critics. It has an aggregate score of 71.29% on GameRankings[1] and 65/100 on Metacritic.[2]

gollark: Basically, if I want to run a search it just goes `SELECT * FROM page_tokens WHERE token = 'one token in search query'` or something like that, and it now has a list of pages with the right token, and SQLite can execute this query relatively fast.
gollark: I mean, as far as I can tell there isn't really a faster *and* more storage-efficient way to do search than the inverted-index page_tokens thing.
gollark: ```sqlCREATE TABLE crawl_queue ( id INTEGER PRIMARY KEY, url TEXT NOT NULL UNIQUE, lockTime INTEGER, added INTEGER NOT NULL, referrer TEXT);CREATE TABLE pages ( id INTEGER PRIMARY KEY, url TEXT NOT NULL UNIQUE, rawContent BLOB NOT NULL, rawFormat TEXT NOT NULL, textContent TEXT NOT NULL, updated INTEGER NOT NULL);CREATE TABLE page_tokens ( id INTEGER PRIMARY KEY, page INTEGER NOT NULL REFERENCES pages(id), token TEXT NOT NULL, weight REAL NOT NULL);CREATE TABLE links ( id INTEGER PRIMARY KEY, toURL TEXT NOT NULL, fromURL TEXT NOT NULL, lastSeen INTEGER NOT NULL, UNIQUE (toURL, fromURL))```Here is the database.
gollark: To be fair, the text content field isn't that necessary, as for search it uses the page_tokens table anyway and it can be rebuilt from the HTML if I need it.
gollark: The frequency of every word *must* be stored for quick (O(log n) time or something) search, the raw HTML or at least might be needed if I come up with a better way to weight frequency or something, the links are useful for (future) better search ranking algorithms.

References
  1. "Thunderhawk: Operation Phoenix for PlayStation 2". GameRankings. Retrieved 4 July 2013.
  2. "Thunderhawk: Operation Phoenix for PlayStation 2 Reviews". Metacritic. Retrieved 4 July 2013.


This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.