Database Construction System

dayriff

Mongoose
In an online game of Traveller I've been playing in, the GM came up with a very nifty system for constructing databases. It not only gives you a price but also clearly lays out what the database covers. I thought I'd share it here. (If there's someone other than 'Drifter' on the rpg.net boards to credit for this, I don't know them.)

=====
Database - TL 7 Cr. 10 to Cr. 10,000
A database is a large store of information on a topic that can be searched with a
Computer check or using an Agent. You can put together a database and its rough cost using the chart below.

Scope: base cost in Cr.
Scope.
Local (a city, continent,)10
World 10
Subsector 100
Sector 250
Imperium 500
Known space 1000


Depth[price mod]
Basic x1
General x3
Comprehensive x 6
Authority x 10

Subject [price mod]
x1:Specific speciality (droyne physiology, a specific ship series, megacorp interests in a specific system, orchids, a breed of cat..)
x2 speciality (robot types, jump drive components listing, flowers).
x3 specialities (package) (trade database, tourist package, geneology, biomeweb)
x4 Targetted (zoology, the history of..., trades and futures, starship listings)
x6 Broad ('Library' programs, Planetary factfile, nobles, banking, the Navy, Aslan)

Other Mods:
Highly specialised or restricted x 2
'realtime' dataflow x2

Database max price is 10 000cr Mods cannot add up to more than this.
[example; you can have a Comprehensive (x6)Spec package(x3)[in this case Ship I.D.] for known space 1000cr x 9 = 9000cr.]
Cost mod: Autoupdate: 10% of cost of program annually (must be paid in addition to initial price).
Autoupdates happen whenever your computer identifies itself through a very specific series of codes to the Central database of most starports,(and some worlds) and is updated automatically. Essential for things like system shipping reports, stocks and futures and news databases.

=====
Here are a few databases I constructed for my character using the system.

Berke's Peerage and Nobility
Imperium (500) x General Knowledge (3) x Broad Topic (6) + 10% for live updates = 9900 credits

A general guide to all the nobility of the Imperium. Of necessity due to the scope, most entries are very short, consisting of name/age/homeworld, geneology (if non-service noble), Imperial service/awards, current status, and notes regarding official connections to other nobility (Eg. "Despite being on different worlds, the Marquis of Valencia is a vassel of the Count of Barcelona.") In addition, one of the privileges of purchase and annual upkeep is that a noble subscriber is allowed to insert as much information regarding themselves as they see fit. Some subscribers decline to do so while others use it as a virtual blog, inserting reams trivial detail about themselves and their lives. Obviously any such information must be taken as biased and untrustworthy. Updated continually for the latest in noble births, deaths, promotions, and demotions.

Vonda's List of Scout Adventure Novels
Sector (250) x Basic (1) x Specific Speciality (1) + 10% for live updates = 275 credits

The Imperial Scout Service is a popular topic for so-called 'adventure fiction', being viewed as the most romantic and exciting (which is to say dangerous) branch of Imperial service. Enthusiasts throughout the sector maintain a database of the latest and greatest stories and books, providing ratings and reviews on many a new novelist. If you access to this database enough to bother paying for it, you are truly a fan. Updated continually as a labor of love by the fan community.

Cotsen Institute Archaeological Compilations
Sector (250) x Comprehensive (6) X Targeted (4) + 10% for live updates = 6600 credits

Contains the latest books and publications regarding archeology research in the sector. This is a professional-level database containing theories, speculation, and analysis. Live updates bring the very latest in news from the field.

Tourist's Guide to the Imperium
Imperium (500) x Specialized (3) x General (3) = 4500 credits

Maintained by the TAS as a profit-making enterprise, this handy guidebook lists the most spectacular sights for worlds throughout the Imperium. Reissued every five years or so, as good tourist spots are expected to last.

Black Books Computer Hacking/Cracking Database
Sector (250) x General (3) x Speciality (2) x Restricted (2) + 10% for live updates = 3300 credits

Illegal as all heck, this underground database for crackers lists information on computer security throughout the sector. Obviously it's impossible to list every system, but common cracker targets and/or particularly large systems such as megacorporate databases are listed. Due to the constantly changing game of computer security, only the most general information can be listed. (Eg. "This system has nearly unbreakable security on financial records, but inventory records are lightly protected.") Occasionally job offers can be found on recent downloads. Extreme caution should be taken in utilizing data, as the reliability of the information cannot be assured. Updating is considering the responsibility of all subscribers.
 
dayriff said:
In an online game of Traveller I've been playing in, the GM came up with a very nifty system for constructing databases. It not only gives you a price but also clearly lays out what the database covers. I thought I'd share it here. (If there's someone other than 'Drifter' on the rpg.net boards to credit for this, I don't know them.)

=====
Database

Very cool ? One comment - on first readthru,
Subject [price mod]
x1:Specific <etc>

it looked like the price went up as subject became more general -which seemed, if just from modern database examples the opposite -on readthru, I think that what I read initially as generality (the opposite of specificness which is alluded to in the text description) is in fact comprehensiveness - one is not buying a survey, but rather a part of the ultimate database. the level of detail is specified in depth and scope. Does this seem correct ?

Also, to whomever wrote this, my compliments for not yielding to temptation and adding power requirements ! As the book notes, storage capacity is effectively unlimited after TL 10 (?) ; and the search routines would be included in the agent used -either a general one to work independedntly, or as part of any intelligent interface for manual use.

Again. Nice !

The scout fiction is a good touch, too.
 
captainjack23 said:
Subject [price mod]
x1:Specific <etc>

it looked like the price went up as subject became more general -which seemed, if just from modern database examples the opposite -on readthru, I think that what I read initially as generality (the opposite of specificness which is alluded to in the text description) is in fact comprehensiveness - one is not buying a survey, but rather a part of the ultimate database. the level of detail is specified in depth and scope. Does this seem correct ?

I think you've got it right. Of course, you can trade comprehensiveness for level of detail when it comes to price. To take one of the examples given, if you bought a database that was an Authority on droyne physiology, you might get something like a detailed holographic simulation of a droyne body that could be set to different ages and castes and that would simulate real-time responses to various stimuli you input. In such a case there probably is no ultimate database at that level of detail.

The system is meant as a general guideline only, and players and GMs should have fun with it to flesh out details in a creative way. We sure did.
 
One nit - I'd make the base cost for a world db Cr50 instead of the same Cr10 for the local. Or maybe additional levels:

Local (city, district, province) Cr10
Regional (region, nation, continent) Cr25
Global Cr50
Cluster (up to 10 worlds within J2 of world of purchase) Cr100
Subsector Cr250
Quarter-Sector (4 subsectors in 2x2 block) Cr500
Sector Cr1000
Domain (4 Sectors) Cr2500
Multi-Domain Interstellar Polity Cr10000
Charted Space Cr50000

As noted, instead of 'depth', I'd call it 'comprehensiveness' or 'level of detail', and perhaps it gets more levels:

Overview, x1
Basic, x2
Gazetteer, x3
General, x5
Comprehensive, x7
Encyclopedic, x10
Authoritative, x15

I would not cap the price of the database.

What do you see as the difference between 'autoupdate' and 'realtime dataflow'?

Comments above notwithstanding, I like! I'd like to see a bit more expository text on this idea, and then submit it to Freelance Traveller, please! (dammit, we need a smiley for "impressed"!)

(BTW, you created Berke's Peerage as an example; take a look at Rikarunasha's Peers, Precedence, and Protocols of the Third Imperium.)
 
FreeTrav said:
I would not cap the price of the database.

What do you see as the difference between 'autoupdate' and 'realtime dataflow'?

I think the intent was to keep the price range within that suggested by the core rulebook. Both in terms of keeping things from getting too expensive and in limiting the practical comprehensiveness of the database. So it doesn't matter if you have 200,000 to throw at it, you can't get a database giving the deck plans of every single ship ever built in the Imperium. (Though an Imperial agent might possibly have something close.)

I would limit 'realtime' to databases covering an area with no (or little) lightspeed lag. So like a database that tells you the location of every single law enforcement officer within a given city, updated constantly. (Something that's very close to being possible with today's technology.) Probably completely illegal for civilian to have, of course, but you get the idea.
 
Lest we forget:

MCr 0.3 Library - contains local information

That's Classic Traveller, Book 2.

Those who do not study (Traveller) history are doomed to re-invent it.
 
Doing the AAB (Argushiigi Admegulasha Bilanidin aka Vilani Repository of All Knowledge), the definitive Imperial Library, I get:

Known Space (1000) * Authority (10) * Broad (6) + 10% autoupdate = 66,000. (or with FreeTrav's updates: Mcr 4.95)

I agree, don't cap the top end of the database cost.
 
Hi foks.
First of all, thanks to dayriff for posting this up...I never think to share things around.

Thanks for the feedback. I threw this together to make it easier for players to define what they wanted out of specific programs. I used the top-end price (10KCr) as a limiter on what you could get and run on a personal computer (or equivalent) and agree it could be broadened somewhat as posters here have suggested. Same with the name for 'depth'
Maybe I could write this up in draft and post it here before any S&P submission? FreeTrav in particular has made some suggestions that I'd need to incorporate in a rewrite, and dayriff has concretized some of the basic assumptions, so it'd have to be considered a joint effort.

I dunno, I'm new to the idea of actually submitting something bouncing around posting boards.

Anyway, thanks for the positive feedback. Use as you see fit!
 
Back
Top