Rel ruby 7nf
Download
1 / 13

Rel Ruby (+7NF) - PowerPoint PPT Presentation


  • 75 Views
  • Uploaded on

Rel Ruby (+7NF). moriq [email protected] 関西 Reject Kaigi2007. SQL. なんでこんな言語なんだ? SELECT * FROM r SELECT * FROM r WHERE c SELECT name FROM r WHERE c SELECT ... FROM (SELECT name FROM r WHERE c) JOIN s. Tutorial D. そこで Tutorial D ですよ r r[c] r[c]{name} r[c]{name} JOIN s. D.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Rel Ruby (+7NF)' - miron


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Rel ruby 7nf

Rel Ruby(+7NF)

moriq [email protected]関西

RejectKaigi2007


SQL

  • なんでこんな言語なんだ?

  • SELECT * FROM r

  • SELECT * FROM r WHERE c

  • SELECT name FROM r WHERE c

  • SELECT ... FROM (SELECT name FROM r WHERE c) JOIN s


Tutorial d
Tutorial D

  • そこでTutorial Dですよ

  • r

  • r[c]

  • r[c]{name}

  • r[c]{name} JOIN s


D

  • data language specification

  • http://en.wikipedia.org/wiki/Tutorial_D


Rel

  • Tutorial DのJava実装

  • An Implementation of Date and Darwen's "Tutorial D"

  • http://dbappbuilder.sourceforge.net/Rel.html


Rel ruby
Rel Ruby

  • RelをRubyで実装してみた

  • http://dev.moriq.com/svn/rails/trunk/rel-ruby/


O r mapper
O/R mapper

  • Object Model

  • Relational Model

  • なんでマッピングなんだ?


Relation object
Relation Object

  • Relation.new(heading)

  • r = Relation.new(id: Integer, name: String)


Tuple object
Tuple Object

  • Tuple.new(attributes)

  • r << Tuple.new(id: 1, name: 'matz')

  • r << {id: 1, name: 'matz'}


Relational ruby
Relational Ruby

  • RubyでRelational Modelを表現

  • r

  • r.select { |t| t.name == 'matz' }

  • r['name']

  • r['name'].join(s)


Ruby ar vs dbms

validation

reference constraint

inheritance

locking

logging

index

validation

reference constraint

inheritance

locking

logging

index

Ruby(AR) vs DBMS




ad