1986–87 Norwegian 1. Divisjon season

The 1986–87 Norwegian 1. Divisjon season was the 48th season of ice hockey in Norway. Ten teams participated in the league, and Valerenga Ishockey won the championship.

Regular season

Club GP W T L GF-GA Pts
1.Stjernen3625110225:13951
2.Vålerenga Ishockey3623310228:15049
3.Sparta Sarpsborg3622212167:14446
4.Frisk Asker3620115172:12241
5.Storhamar Ishockey3617217181:15736
6.Furuset IF3616218177:15934
7.Manglerud Star Ishockey3616218164:15934
8.Bergen/Djerv3616119178:22933
9.Viking IK369126162:24219
10.Hasle-Løren Idrettslag368127144:29717

Playoffs

 
Semi-finalsFinal
 
      
 
 
 
 
Stjernen2
 
 
 
Sparta Sarpsborg0
 
Stjernen1
 
 
 
Vålerenga Ishockey3
 
Vålerenga Ishockey2
 
 
Frisk Asker0
 
Third place
 
 
 
 
 
Not played
 
 
 
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.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.