Apolyton Archive  |  Preserved copy of the Apolyton Civilization Site and its forums as they stood in September 2005. Read-only; nothing here can be posted to or replied to.  |  Forum index |  About this archive |  The 1998–2001 UBB forums
Today on Apolyton WARDELL INTERVIEW PROMO A.C.S. HISTORY CHAPTER 4 GET CIV4 /w FREE PLUS! A.C.S. PHOTO GALLERY GET A.O.M. V1.1
Apolyton Civilization Forums
main| civ2| civ3| civ4| smac| ctp2| ron| moo3| galciv| galciv2| alt| about|
ApolytonPLUS | register | search | faq | new posts | pm (-/-) | upload | members
hall of fame new! | civgroups | civgroups news | interviews | the column | radio | chat | directory | news | store | PLUS
Apolyton Civilization Forums : Powered by vBulletin version 2.0.3 Apolyton Civilization Forums > Miscellaneous > Archive > Civ2-Strategy-Archive > if there was to be a Great Library Database....
Show a Printable Version | Email This Page to Someone! | Receive updates to this thread | Report this to Apolyton news!

bottom of page
  
Author
Thread    < Last Thread     Next Thread > Post New Thread     Post A Reply
MarkG is offline MarkG
Grand Lord of Apolyton, Owner of all this land as far as the eye can see

Donate to the Red Cross
Macedonia, Greece
Jan 1970
time: 07:14
  Old Post 02-07-2001 05:29 Visit MarkG<br><img src=/forums/images/admin-icon.gif>'s homepage!
Edit/Delete Message Reply w/Quote
#1 Report this post to a moderator
if there was to be a Great Library Database.... Support Apolyton, buy Alpha Centauri

what fields would it need?

SlowThinker is offline SlowThinker
King
homeless, Praha, Czech Republic
Jan 2000
time: 06:14
  Old Post 02-07-2001 10:07 Visit SlowThinker's homepage!
Edit/Delete Message Reply w/Quote
#2 Report this post to a moderator
Support Apolyton buy from Amazon

What do you mean? A new field in the forum page?

MarkG is offline MarkG
Grand Lord of Apolyton, Owner of all this land as far as the eye can see

Donate to the Red Cross
Macedonia, Greece
Jan 1970
time: 07:14
  Old Post 02-07-2001 12:20 Visit MarkG<br><img src=/forums/images/admin-icon.gif>'s homepage!
Edit/Delete Message Reply w/Quote
#3 Report this post to a moderator
Full PM-box? Change here!

no, i'm talking about a separate page

so what do we need?
from the top of my head: title, author, content, posting date, last updated date, keywords

KrazyHorse is offline KrazyHorse
King
Macedonia
May 2001
time: 00:14
  Old Post 02-07-2001 12:25 Visit KrazyHorse's homepage!
Edit/Delete Message Reply w/Quote
#4 Report this post to a moderator
Inflate your Upload Space

Is it valuable in SP/MP/Both?

Is it mere information or a strategy?

Some form of member rating

Ming is offline Ming
Chief Minion

Donate to the Red Cross
Mingapulco - CST
Jan 1970
time: 23:14
  Old Post 02-07-2001 13:18 Visit Ming<br><img src=/forums/images/staff-icon.gif>'s homepage!
Edit/Delete Message Reply w/Quote
#5 Report this post to a moderator
Help yourself to an AD-FREE life

MarkG... I think what they really need is for one of the key people to made a moderator of the Civ Strategy forum so that person can update the GL without having to find one of us to unlock and then lock it for them.
As far as what else they need... good question Mark

Marquis de Sodaq is offline Marquis de Sodaq
King
... no, a Marquis.
Jul 2000
time: 23:14
  Old Post 02-07-2001 19:11 Visit Marquis de Sodaq's homepage!
Edit/Delete Message Reply w/Quote
#6 Report this post to a moderator
Support Apolyton, buy Alpha Centauri

Beyond the identification of the thread, we might want a field to list what category it falls into, e.g. discussion, Info:, strategy. Titles aren't always telling of what a thread ends up containing, maybe an abstract (80? characters or some such length) field, too.

Blaupanzer is offline Blaupanzer
Prince
Fairfax, VA
Oct 2000
time: 00:14
Wink  Old Post 02-07-2001 21:47
Edit/Delete Message Reply w/Quote
#7 Report this post to a moderator
Support Apolyton, buy Civilization: The Boardgame

A set of indexed threads is not a database. A database is a set of interrelated tables, each with an identifying data element (primary key) and associated attributes (fields). The tables are related through attributes called foreign keys, which say how one table relates to another. In this way, data can be retrieved from the system based on the interests of the user. If this is not what you want, then call out what you do want so Mark can help.

A series of indexed threads can be made more efficient by creating a table that permits this indexing. This is what Mark offers in his message. Through that the user would be led to the thread of interest based on choosing any of the entries in the table. Would a table with the columns he suggests be sufficient? Who would be responsible for entering the data in the table? Who would be responsible for archiving or caching the associated threads?

MarkG is offline MarkG
Grand Lord of Apolyton, Owner of all this land as far as the eye can see

Donate to the Red Cross
Macedonia, Greece
Jan 1970
time: 07:14
  Old Post 02-07-2001 22:00 Visit MarkG<br><img src=/forums/images/admin-icon.gif>'s homepage!
Edit/Delete Message Reply w/Quote
#8 Report this post to a moderator
Support Apolyton buy from Amazon

quote:
Originally posted by Blaupanzer
A set of indexed threads is not a database. A database is a set of interrelated tables, each with an identifying data element (primary key) and associated attributes (fields). The tables are related through attributes called foreign keys, which say how one table relates to another. In this way, data can be retrieved from the system based on the interests of the user. If this is not what you want, then call out what you do want so Mark can help.

A series of indexed threads can be made more efficient by creating a table that permits this indexing. This is what Mark offers in his message. Through that the user would be led to the thread of interest based on choosing any of the entries in the table. Would a table with the columns he suggests be sufficient?
couldnt say it better

quote:
Who would be responsible for entering the data in the table? Who would be responsible for archiving or caching the associated threads?
as for that, i'm hoping that we will have volunteers from this forum...

Edward is offline Edward
Warlord

Apr 2000
time: 00:14
  Old Post 03-07-2001 01:23
Edit/Delete Message Reply w/Quote
#9 Report this post to a moderator
Increase Your PM Length

The most important fields would be the body of the item and all the key words it falls under.

And determine in advance whether you want to

A) make a neat way to access all the threads in the forum archives
or
B) make a neat way to get information on various aspects of Civ

These two goals will lead to radically different databases. (e.g. in (B) each item is a laboriously crafted summary (like entries in the current and wonderful Great Library); whereas in (A) each item is a poorly titled rambling thread who's pertinent information is buried deep in the 20th reply and resolved in another thread posted 3 days later)

Blaupanzer is offline Blaupanzer
Prince
Fairfax, VA
Oct 2000
time: 00:14
Wink  Old Post 03-07-2001 01:45
Edit/Delete Message Reply w/Quote
#10 Report this post to a moderator
Enter the AD-FREE zone

Why does it sound like both A and B suck in your message, Edward? Could it be your wording? How about a third alternative. Someone (SG?) could pick which threads to stress, and the associated key words for each thread (SlowThinker?), and provide a way to access these from a central point (Mark G?). This would preserve the social aspect of thread development without sending the questioner into gigabytes of archives, guessing the real subject and importance of each thread.

SlowThinker is offline SlowThinker
King
homeless, Praha, Czech Republic
Jan 2000
time: 06:14
  Old Post 03-07-2001 04:57 Visit SlowThinker's homepage!
Edit/Delete Message Reply w/Quote
#11 Report this post to a moderator
Inflate your Upload Space

I am not sure if I understand:
quote:
Originally posted by MarkG
no, i'm talking about a separate page

so what do we need?
from the top of my head: title, author, content, posting date, last updated date, keywords
quote:
Originally posted by Blaupanzer
A series of indexed threads can be made more efficient by creating a table that permits this indexing. This is what Mark offers in his message. Through that the user would be led to the thread of interest based on choosing any of the entries in the table. Would a table with the columns he suggests be sufficient?
Do you mean an improved Great Library Index? It is doable with current "Great Library Index" (with added html), but I suppose MarkG would provide some more comfortable interface for both readers and editors. Am I right?

quote:
Originally posted by Blaupanzer
Someone (SG?) could pick which threads to stress,

Blaupanzer, if you stress some threads, then you speak about Edward's item B) IMHO, i.e. an improved Great Library Index.

The method B) is very tedious IMHO, I am afraid we won't find a such volunteer. Realize that approx. one half of threads contain some useful information and one tenth(?) contains a very useful information. It is a huge amount of threads, incomparable with the current Great Library Index.
Or MarkG would have to make a very comfortable interface for editors: they should be able to index a thread directly from the forum page or the thread page.

I think that method A) might be interesting:
add one field with keywords to the forum page. Adapt "search forums" page.
Great Library Index might be created dynamically: Threads with no value would get no keywords or their keywords would be deleted. Threads with no keywords wouldn't be added to Great Library Index.
a refinement: Add a second field with "add to Great Library Index" tag for valuable threads. (the reason: we could add keywords to all threads; nobody knows exactly what is "unhelpful thread". And it is another reason I prefer A) over B)

10 or 20 people (or everybody?) could get the right to add keywords. Only few people would get the right to add "add to Great Library Index" tag.

Last edited by SlowThinker on 03-07-2001 at 05:05

MarkG is offline MarkG
Grand Lord of Apolyton, Owner of all this land as far as the eye can see

Donate to the Red Cross
Macedonia, Greece
Jan 1970
time: 07:14
  Old Post 03-07-2001 12:19 Visit MarkG<br><img src=/forums/images/admin-icon.gif>'s homepage!
Edit/Delete Message Reply w/Quote
#12 Report this post to a moderator
Increase the size of your Attachments

i'm discussing a database separate from the forums, where information is stored as the outcome of the dicussion at the forums

example: in the "gl index" thread you link to the thread "Unhappiness caused by number of cities". i dont want to read an entire thread with various opinions and discussion on testing stuff, etc. i want the result of the discussion, in a concrete short form.

SlowThinker is offline SlowThinker
King
homeless, Praha, Czech Republic
Jan 2000
time: 06:14
  Old Post 03-07-2001 15:23 Visit SlowThinker's homepage!
Edit/Delete Message Reply w/Quote
#13 Report this post to a moderator
Full PM-box? Change here!

quote:
Originally posted by MarkG
example: in the "gl index" thread you link to the thread "Unhappiness caused by number of cities". i dont want to read an entire thread with various opinions and discussion on testing stuff, etc. i want the result of the discussion, in a concrete short form.

There are only three such threads now :-( and so they don't need a special database presently.
I keep links to them here: "The Great Library: a hierarchical structure" thread

Marquis de Sodaq is offline Marquis de Sodaq
King
... no, a Marquis.
Jul 2000
time: 23:14
  Old Post 03-07-2001 19:35 Visit Marquis de Sodaq's homepage!
Edit/Delete Message Reply w/Quote
#14 Report this post to a moderator
Put an end to popups!

The Info: type threads (the 3 that SlowThinker mentions) are probably the summary that you envision, MarkG. They require a significant amount of work to put together, then a fair amount of editing as new information or clarifications get posted. (I'm falling behind in mine... ) To summarize all the topics in ST's hierarchy, we'd need a handful of people to be willing to cull the relevent info from the threads. Someone else could put the Info: threads together, as long as the summary submitted was thorough. If there were enough of these threads, a database might be worth making. In the meantime, all the key info you seek is buried within piles of verbiage...

Edward is offline Edward
Warlord

Apr 2000
time: 00:14
  Old Post 04-07-2001 00:02
Edit/Delete Message Reply w/Quote
#15 Report this post to a moderator
Support Apolyton, buy Civilization III: Complete

B

If we want a database that only contains useful, concise information, I think the current Great Library is it:
http://apolyton.net/forums/showthre...=&threadid=2723

Yes, as MarkG points out, currently many of it's links go to threads with rambling posts. This, IMHO, is exactly the reason that taking the "normal" threads (those that arise naturally through forum discussion) and selecting some of them, or linking to them, or databasing them, or indexing them, etc. is a bad idea if you're going for objective B ("make a neat way to get information on various aspects of Civ").

In addition to the thread links, there are some polished Great Library entries (thanks, slow thinker et al) that are wonders of detail and summary to behold (e.g. Diplomats and Spies http://apolyton.net/forums/Forum1/HTML/001678.html?36). My assumption is that eventually all Great Library entries will look like this. It's just that it'll take time to create the summarized entries. With all the talent that's currently working on the Great Library, it's hard to see how a separate and new effort (database or not) will create these wonderful summaries any more quickly.

In the interim, the scribes at Great Library have already "stressed" important threads by making links to them until they get around to summarizing them. I believe the "add to the Great Library tag" is, in effect, already implemented by the existing Great Library.

If we lack summaries, it's due to a lack of people working on the Great Library as opposed to a poorly organized Great Library.




A

If we want, instead, objective A ("make a neat way to access all the threads in the forum archives") then a database could be a helpful. Right now we have a more general search function:
http://apolyton.net/forums/search.php
The biggest advantage a database would add is that each thread would have some keywords that the thread is actually about. Then searching on keywords would eliminate a lot of extraneous threads. However, that would still leave the daunting preliminary task of reading all the threads and assigning them keywords - and then adding keywords as new threads arise and recent ones change topic.




p.s. As Blaupanzer points out, the social aspect of the forums will be preserved by preserving the forums. The forums function differently than any Great Library (existing or imagined) and one could never replace the other.

SlowThinker is offline SlowThinker
King
homeless, Praha, Czech Republic
Jan 2000
time: 06:14
  Old Post 04-07-2001 01:19 Visit SlowThinker's homepage!
Edit/Delete Message Reply w/Quote
#16 Report this post to a moderator
Support Apolyton, buy Civilization III: Complete

quote:
Originally posted by Edward
This, IMHO, is exactly the reason that taking the "normal" threads (those that arise naturally through forum discussion) and selecting some of them, or linking to them, or databasing them, or indexing them, etc. is a bad idea if you're going for objective B ("make a neat way to get information on various aspects of Civ").
Yes, it is not ideal, but it is an interphase on the way to "Info:" (condensed) threads.
quote:
The biggest advantage a database would add is that each thread would have some keywords that the thread is actually about. Then searching on keywords would eliminate a lot of extraneous threads. However, that would still leave the daunting preliminary task of reading all the threads and assigning them keywords - and then adding keywords as new threads arise and recent ones change topic.
Unfortunately, my idea of keywords (described in "The Great Library: a hierarchical structure" thread) stagnates. I thought that people (topic starter or anybody else) would add keywords to almost every new thread and to important old thread. In fact, few threads has keywords attached now.
quote:
p.s. As Blaupanzer points out, the social aspect of the forums will be preserved by preserving the forums. The forums function differently than any Great Library (existing or imagined) and one could never replace the other.

I agree perfectly

TCO is offline TCO
Emperor
Richmond, VA
Jan 1970
time: 00:14
  Old Post 05-07-2001 02:40
Edit/Delete Message Reply w/Quote
#17 Report this post to a moderator
Support Apolyton or Terrorists Win

A branching thread structure would be a useful mechanism (although not perfect) for classifying/organizing info.

KrazyHorse is offline KrazyHorse
King
Macedonia
May 2001
time: 00:14
  Old Post 05-07-2001 03:19 Visit KrazyHorse's homepage!
Edit/Delete Message Reply w/Quote
#18 Report this post to a moderator
Support Apolyton

You and your damned branching thread structure.

  < Last Thread     Next Thread > Post New Thread     Post A Reply
All times are GMT. The time now is 05:14.
Apolyton Time is 00:14.
    top of page
Rate This Thread:
archivepost
Forum Jump:
Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is ON
vB code is ON
Smilies are ON
[IMG] code is ON
 




Contact Us - Apolyton Civilization Site - Support Us!

Building a better Apolyton through better information. Click here and take our poll!
Non-US visitors, click here!

Powered by: vBulletin Version 2.0.3
Copyright ©2000, 2001, Jelsoft Enterprises Limited.

Page generated in 0.0481 seconds (91.95% PHP - 8.05% MySQL) with 31 queries
Page Loading Time:

Support Apolyton: Amazon USA | Amazon UK | Amazon DE | Amazon FR |
Support Apolyton and get FREE PLUS, Buy from Chips&Bits: Galactic Civilizations | Galactic Civilizations: Deluxe Edition | Call to Power 2 | Civilization: The Boardgame | GURPS/ Alpha Centauri | Alpha Centauri | Civilization IV | Civilization III: Complete |


Front Page | Civilization IV | Civilization III | Civilization II | Call to Power II | Alpha Centauri | Master of Orion III
Rise of Nations | Galactic Civilizations | Galactic Civilizations II | Misc
Alt.Civs | Civ I | C:CtP I | About | News | Directory | Apolyton Store | Forums | Chat | Columns | Interviews | Newsletter
Scenario League | CSC | Clash of Civs | Spanish Site | CtP Maps | Cradle of Civ | WesW's Ctp1/2 Site | Civ3 Haven

apolyton.net | apolyton.com | civilization2.net | civilization3.net | civilization4.net | civilizationiv.info | calltopower.net | galciv.net | galciv2.net | moo3.net