windycityrails - "comics" is hard

Welcomeben scofield - @bscofield

http://benscofield.comhttp://www.viget.com/extend

http://www.speakerrate.com/bscofieldSaturday, September 12, 2009

“Comics” Is Hard:On Domains and DatabasesBen Scofield – Viget Labs

Saturday, September 12, 2009

Modeling

flickr: bunchofpants

Biology

Linnean taxonomySaturday, September 12, 2009

AnimaliaChordataMammaliaCarnivoraFelidaePantheratigris

KingdomPhylumClassOrderFamilyGenusSpecies

flickr: pandiyan

AnimaliaChordataMammaliaCarnivoraFelidaePantheratigris

flickr: pandiyan

kingdom phylum class

genus family order

species organism

ProblemThe levels are imaginary

genus family order

species organism

subphylum

superclass subclass

superordersuborder

superfamily

subfamily

subgenus

variety

subspecies

genus family order

species organism

subphylum

superclass subclass

superordersuborder

superfamily

subfamily

subgenus

variety

subspecies

?Saturday, September 12, 2009

taxon taxontaxon species organism

variety

subspecies

Speciesflickr: cpurrin1

Reproductive Isolationflickr: superciliousness

flickr: chiotsrun

flickr: niznoz

Numerical taxonomySaturday, September 12, 2009

CladisticsSaturday, September 12, 2009

taxon taxon organismclade

ProblemCladistics is historical and

counter-intuitive

flickr: goellnitz

flickr: goellnitzflickr: pcoin

The ChallengeUnclear, imprecise domain

Comics

publisher title issue

publisher imprint title

issue volume

tradevariant

issue volume

tradevariant

nested set?volume

tradevariant

publisher

imprint

nested set?volume

tradevariant

storyline ?!?!Saturday, September 12, 2009

horror

superhero

Martial Arts

Pirate

science fiction

independent

historical

genres?

publisherimprint

nested set?volume

tradevariant

storyline

genre@#&*!Saturday, September 12, 2009

The ChallengeComplete insanity

databases unite!

#?forben

Alternatives

http://thisisindexed.com/2009/02/just-because-you-can-doesnt-mean-you-should/

Key-Value

Cassandra*

Tokyo CabinetRedis

Project Voldemort

require "rubygems"require "tokyocabinet" include TokyoCabinet bdb = BDB::new # B-Tree database; keys may have multiple valuesbdb.open("casket.bdb", BDB::OWRITER | BDB::OCREAT) # store records in the database, allowing duplicatesbdb.putdup("key1", "value1")bdb.putdup("key1", "value2")bdb.put("key2", "value3")bdb.put("key3", "value4") # retrieve all valuesp bdb.getlist("key1")# => ["value1", "value2"] # range query, find all matching keysp bdb.range("key1", true, "key3", true)# => ["key1", "key2", "key3"]

http://www.igvita.com/2009/02/13/tokyo-cabinet-beyond-key-value-store/

Biology x

Comics x

Configuration ✓Caching ✓

Translations ✓

Document

{ 'name':'Ben Scofield', 'adjective':'awesomesauce'}

{ 'name':'Magic Pony', 'description':'It is a *lie*!'}

class Question include MongoMapper::Document key :number, Integer, :required => true key :text, String, :required => true many :choicesend

class Choice include MongoMapper::EmbeddedDocument key :text, String, :required => trueend

Biology ✓

Comics x

{ ‘kingdom’:‘Animalia’, ‘phylum’:‘Chordata’, ‘subphylum’:‘Vertebrata’, ‘class’:‘Mammalia’, ‘subclass’:‘Eutheria’, ‘order’:‘Carnivora’, ‘family’:‘Felidae’, ‘subfamily’:‘Panthernae’, ‘genus’:‘Pantera’, ‘species’:‘tigris’, ‘name’:‘Wanda’}

{ ‘kingdom’:‘Animalia’, ‘subkingdom’:‘Eumetazoa’, ‘phylum’:‘Chordata’, ‘subphylum’:‘Vertebrata’, ‘class’:‘Mammalia’, ‘subclass’:‘Theria’, ‘order’:‘Carnivora’, ‘suborder’: ‘Caniformia’, ‘family’:‘Canidae’, ‘subfamily’:‘Caninae’, ‘tribe’:‘Canini’, ‘genus’:‘Canis’, ‘species’:‘lupus’, ‘subspecies’:‘familiaris’, ‘name’:‘Daisy’}

class Question include MongoMapper::Document key :number, Integer, :required => true key :text, String, :required => true many :choicesend

class Choice include MongoMapper::EmbeddedDocument key :text, String, :required => trueend

AllegroGraphJava / Lisp

http://neotechnology.com/why-neo

http://markorodriguez.com/Lectures_files/risk-symposium2009.pdf

flickr: 9948354@N08

Biology ✓

Comics ✓

Felidae

tigris

Panthera

Panthernae

member

speciesof

weight

genusof

Animalia

subfamilyof

genusof

Felidae

tigris

Panthera

Panthernae

member

speciesof

weight

genusof

Animalia

subfamilyof

genusof

tigris

species

Picornaviridae

rhinovirus A

Rhinovirus

member

speciesof

genusof

Picornavirales

familyof

Group IV

orderof

Picornaviridae

human rhinovirus A

Rhinovirus

member

speciesof

genusof

Picornavirales

familyof

Group IV

orderof

Felidae

tigris

Panthera

Panthernae

speciesof

genusof

subfamilyof

genusof

member

Carnivora

familyof

Mammalia

orderof

class group

DC Universe

titleof

imprintof

titleof

Volume 1

volumeof

Lantern nameof

Sci Fi

genreof

issueof genreof

Superhero

Issue #2precedes

coverof

number

require 'neo4j'

Neo4j::Transaction.run do dc = Neo4j::Node.new dc[:name] = 'DC' dc_universe = Neo4j::Node.new dc_universe[:name] = 'DC Universe' dc.relationships.outgoing(:imprints) << dc_universe rel = dc.relationships.outgoing(:imprints).first rel[:started] = 1980 vol1 = Neo4j::Node.new vol1[:started] = 1941 vol1[:ended] = 1949 vol1[:name] = 'Green Lantern' dc.relationships.outgoing(:titles) << vol1 dc_universe.relationships.outgoing(:titles) << vol1

# ...end

Other Options

http://internetmindmap.com/database_software

Column-Oriented

Column-OrientedTemporal

Column-OrientedTemporalConstant

I am your databases... combined!flickr: joriel

tagpost

document id

{ 'title':'Post Title' 'content':'Hello!' 'comments':["First!"]}

� � � � � � � � � � � � � � � � � � � � �

{ 'name':'...' 'attr1':'...' 'attr7':'...'}

��

flickr: joriel

The power is yours

Thank Youben scofield - @bscofield

http://benscofield.comhttp://www.viget.com/extend

http://www.speakerrate.com/bscofieldSaturday, September 12, 2009

windycityrails - "comics" is hard

publisher title issue

publisher imprint title

tokyocabinet bdb

issue nested set

valuesp bdb

owriter bdb

taxon clade taxon organism

true key

Technology

an intro to the comics: alternative comics€¦ · behind...

comics sottomayor

comics by the numbers: historical comics surveys

rage comics y u no know what rage comics are?. what are rage...

old.urban-comics.comold.urban-comics.com/coloriageenfant/flashurban.pdf ·...

comics japoneses

netiquette comics

dc comics guide to coloring and lettering comics

ally watkins comics and graphic novels. comics publishers

the dc comics guide to writing comics

campaigning with grassroots comics - world comics india ·...

comics scholars towards significant change in academia: the...

helvetica comics

comics list

comics strip

fll comics

reading comics comics and graphics traditions methods

twomorrows publishing comics - marvel comics in the 1980s

xlhub comics

rage comics