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. | Stjernen | 36 | 25 | 1 | 10 | 225:139 | 51 |
2. | Vålerenga Ishockey | 36 | 23 | 3 | 10 | 228:150 | 49 |
3. | Sparta Sarpsborg | 36 | 22 | 2 | 12 | 167:144 | 46 |
4. | Frisk Asker | 36 | 20 | 1 | 15 | 172:122 | 41 |
5. | Storhamar Ishockey | 36 | 17 | 2 | 17 | 181:157 | 36 |
6. | Furuset IF | 36 | 16 | 2 | 18 | 177:159 | 34 |
7. | Manglerud Star Ishockey | 36 | 16 | 2 | 18 | 164:159 | 34 |
8. | Bergen/Djerv | 36 | 16 | 1 | 19 | 178:229 | 33 |
9. | Viking IK | 36 | 9 | 1 | 26 | 162:242 | 19 |
10. | Hasle-Løren Idrettslag | 36 | 8 | 1 | 27 | 144:297 | 17 |
Playoffs
Semi-finals | Final | |||||
Stjernen | 2 | |||||
Sparta Sarpsborg | 0 | |||||
Stjernen | 1 | |||||
Vålerenga Ishockey | 3 | |||||
Vålerenga Ishockey | 2 | |||||
Frisk Asker | 0 | |||||
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.
External links
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.