Improvement of the ODB

Post by **Daydreamer** » April 17th, 2006, 11:42 pm

I agree with wolf that the name of the diagrammer is not necessary for the database. If anyone wants to know that he can always check the book.

But there are some other things you missed:
Picture (portrait) for the author.
Picture (coverscan) for the book.

And there's something you probably don't want to hear, but it is these exceptions that make database programming so much fun....

Models can actually have more than one author. The most obvious example of that are the Shumakovs (there are models by Katrin, models by Yuri and models by Katrin & Yuri) and there are other cases like that as well.

Concerning language I would say that the language of the diagram is the important thing, the language of the book can be (like Alexandre stated earlier) the languages of the diagrams added together. One diagram can have more than one language though like the diagrams in Nicolas Terry's Passion Origami which are English and French.
Then the question is how to cope with books that don't have any diagrams (like the Masters of Origami exhibition book), because those won't have any language assigned then.
This gives the additional problem if we want to have the models displayed in "picture books" listed in the database as well, so that we have an additional type of instance as "picture only".

wolf · Post by **wolf** » April 17th, 2006, 11:57 pm

Given that the model database is meant as a database of diagrammed models, I think that picture books don't really belong there.

Post by **Daydreamer** » April 18th, 2006, 12:13 am

I agree with you on that but....
http://d307280.p33.patchhost.com/book_c ... 3775716289

Alexandre · Post by **Alexandre** » April 18th, 2006, 12:35 am

I wanted to start in june but in fact I am already spending quite a lot of time on it...

ok, for the coverscans of books and for author's pictures, is there any legal problems ?

For the multiple authors of models I did not know this fact, but it is manageable. I do not know if there are many cases like this...

If we allow the "pictures books", I can add a type of book picturebook, and in the "instance of model", we got a field : made with computer/written by hand/photo. So for the problem of the language of the book, if we add one model (type=photo), and set this model as english for example, the book will be english.

current draft :

Code: Select all

*publisher
-name
-nationality

*authors
-first name
-last name
-pseudo
-nationality
-birth (month-year)
-death (month-year)
-personal website

*books
-list of author_identifier (the person(s) who made the book)
-publisher_identifier
-type (book/booklet/magazine/CDROM/unpublished/picturebook)
-ISBN/ISSN
-publishing date (month-year)
-quick summary

*models
-name
-list of author_identifier (the person(s) who created the model)
-picture
-paper format (square/$bill/etc..)
-number of pieces (1/2/modular/etc..)
-a list of tags, like "christmas","dinosaur","traditional","action"...
-complexity (simple/intermediate/complex)

*instances of a model
-book_identifier
-model_identifier
-language
-comments [in a separate table]
-first page of the model in the book
-last page of the model in the book
-made with computer/written by hand/photo
-type (diagram/CP/image)

I do not like the part :
-made with computer/written by hand/photo
-type (diagram/CP/image)

Maybe we should just use:
-type : computerdiagram/handmadediagram/CP/picture

Aurèle · Post by **Aurèle** » April 18th, 2006, 8:21 am

Alexandre wrote:Maybe we should just use:
-type : computerdiagram/handmadediagram/CP/picture

perhaps.

wolf wrote: That's going to be unnecessarily complicated. If so, we'll probably need to put in names of photographers, magazine editors, etc as well.

ok,ok. But we have forgotten something necessary: credits on the photo: folded by, photographed by. It is copyright mention we can't avoid.

Post by **Daydreamer** » April 18th, 2006, 12:31 pm

Alexandre wrote:Maybe we should just use:
-type : computerdiagram/handmadediagram/CP/picture

Well that won't work because:
1. If you want to search for diagrams only the query would have to include both types of diagram.
2. There are diagrams from computer, diagrams handdrawn, diagrams with photos, cp from computer, cp handdrawn and also cps as photos.
3. I thought the type "picture" was now meant to signify a photo-only appearance of a model which is totally different from photo-diagrams.

Alexandre wrote:For the multiple authors of models I did not know this fact, but it is manageable. I do not know if there are many cases like this...

Well, that's the fun thing with exceptions... even if there are only a few cases you have to handle them somehow

Alexandre · Post by **Alexandre** » April 18th, 2006, 1:06 pm

Daydreamer wrote: Well that won't work because:
1. If you want to search for diagrams only the query would have to include both types of diagram.
2. There are diagrams from computer, diagrams handdrawn, diagrams with photos, cp from computer, cp handdrawn and also cps as photos.
3. I thought the type "picture" was now meant to signify a photo-only appearance of a model which is totally different from photo-diagrams.

hehe. The goal of the ODB is not to give the full details about everything. In the summary of the book, we can give some complementary informations like the quality of the diagrams etc... That will be really enough I think.
So maybe : Type : diagram / CP / picture(for photobooks)

@Aurele : for the copyright issues I will open a new thread later.

Post by **Daydreamer** » April 18th, 2006, 1:11 pm

Like I said before we shouldn't limit our possibilities beforehand.
The really important information about the model instance is if it is a diagram, a cp or just a photo so this should be presented in this form.
Then there can be additional (optional) information about the style of the diagram/cp, i.e. handdrawn, computer or photo.

malachi · Post by **malachi** » April 18th, 2006, 2:58 pm

What about books that have CPs and diagrams?

Post by **Daydreamer** » April 18th, 2006, 3:00 pm

The type CP/diagram is saved with the model-instance not with the book.

malachi · Post by **malachi** » April 18th, 2006, 3:03 pm

Daydreamer wrote:The type CP/diagram is saved with the model-instance not with the book.

Sorry, I was unclear in my meaning.
What about books where each model has both a CP and a diagram?

wolf · Post by **wolf** » April 18th, 2006, 3:12 pm

I'll toss in another two questions:

1 - What about CPs with no diagrams, eg Maekawa's alien in Origami Omnibus?

2 - What about model variants, eg in the latter part of Passion Origami?

Post by **Daydreamer** » April 18th, 2006, 3:12 pm

malachi wrote:What about books where each model has both a CP and a diagram?

Well, it should be possible to add the model twice once as diagram from pages xx - yy and once as cp on page zz.
Problem with that is that using (model_id,book_id) as primary key won't work then anymore, so that there has to be an artificial primary key as (book_id, diagram_id) and model_id only as foreign key included. Alternatively (model_id, book_id, type) could be used as primary key.

wolf wrote:1 - What about CPs with no diagrams, eg Maekawa's alien in Origami Omnibus?

That's what the instance-type "CP" is for

wolf wrote:2 - What about model variants, eg in the latter part of Passion Origami?

Well, Nicolas Terry states these model variants as unique models in his model listing, so I think those should be handled like that as well.

Alexandre · Post by **Alexandre** » April 18th, 2006, 3:21 pm

//edit
daydreamer answered

Post by **Daydreamer** » April 18th, 2006, 3:23 pm

I was quicker