Hi David,
Yes, we would still have an advanced search page. I still quite like the idea of using searchy protocols, I think it would be easier to type "title: Origami Design Secrets" than to go to the Book title listing page. This way we can also squeeze more functionality into one textfield.
Saj
Improvement of the ODB
Forum rules
READ: The Origami Forum Rules & Regulations
READ: The Origami Forum Rules & Regulations
If you've found the forum useful, please consider making a donation.
Code: Select all
*creators
-first name
-last name
-biography
*resources
-list of creator_identifier (the person(s) who made the book)
-type (book/booklet/magazine/CDROM/website)
-title
-ISBN / ISSN-number / URL
-publishing date (month-year)
-quick summary
-comments
*models
-name
-traditional name (optional)
-list of creator_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/(low/mid/high)intermediate/complex)
-cuts or no cuts
-glue or no glue
*diagrams
-resource_identifier
-model_identifier
-language
-comments
-type (diagram/CP/diagram+CP)
-page of the model in the book
-made with computer/written by hand/photodiagram ??
*reviews
-resource_identifier
-user_identifier
-review text
-rating
*photos
-model_identifier
-path to the photo
-folder name for copyright reasons
-photographer name for copyright reasons
*comments
-model_identifier or diagram_identifier ??
-user_identifier
-comment
Daniel, what do you mean exactly by "conacated data strings to make up a single search field- eg Designer Last, Designer First, Book Title, Model Name." ?
You mean if I want to search for the book "origami 4", I have to search for ",,origami 4," ?
-
Daydreamer
- Moderator
- Posts: 1423
- Joined: October 28th, 2005, 2:53 pm
- Location: Vienna, Austria
- Contact:
The database structure is starting to look good.
I'm not sure though if anyone will bother to enter publishing date for resources, especially not down to the level of month-year. Publishing year might be more than enough.
I'm also not sure if the type "diagram+CP" is necessary or if it is better to have two instances, one of type "diagram" and one of type "CP" if both appear in a book. The reason for that is that they might appear on different pages in the book....
About concated search fields, David (not Daniel) meant the same like I wrote earlier. The simple search should search the fields "Model-name", "Author-Name", "Categories",... all together, that is in (Pseudo)-SQL something like:
Alternatively you could use something like:
I'm not sure though if anyone will bother to enter publishing date for resources, especially not down to the level of month-year. Publishing year might be more than enough.
I'm also not sure if the type "diagram+CP" is necessary or if it is better to have two instances, one of type "diagram" and one of type "CP" if both appear in a book. The reason for that is that they might appear on different pages in the book....
About concated search fields, David (not Daniel) meant the same like I wrote earlier. The simple search should search the fields "Model-name", "Author-Name", "Categories",... all together, that is in (Pseudo)-SQL something like:
Code: Select all
SELECT ..... WHERE tbl_model.name + tbl_author.firstname + tbl_author.lastname + ... LIKE '%search_string%'Code: Select all
SELECT ..... WHERE tbl_model.name LIKE '%search_string%' OR tbl_author.firstname LIKE '%search_string%' OR ....So long and keep folding ^_^
Gerwin
Gerwin
-
Daydreamer
- Moderator
- Posts: 1423
- Joined: October 28th, 2005, 2:53 pm
- Location: Vienna, Austria
- Contact:
I am not surprised at all by this kind of message, I will just answer that in most of the cases you would be right.
I will not argue with that (it's an origami board, not a dev board) , but if you spend some hours to look at the features of RoR you will understand why I said that
Anybody know what is the status of the copyright of the pictures on the current ODB ?
I will not argue with that (it's an origami board, not a dev board) , but if you spend some hours to look at the features of RoR you will understand why I said that
Anybody know what is the status of the copyright of the pictures on the current ODB ?
For my personal website, most pages are hand coded by me, with the exception of the forum and my journal (which I haven't updated for ages). I'm slowly getting into RoR, and I'm sure it would not have got its cult status if it was generating poor code...Daydreamer wrote:I prefer to write SQL-queries (and web-sourcecode) myself because that way I have all the controll without relying on someone's software to create the sourcecode for me. It might be a bit more work but usually turns out cleaner.
Regarding the photos, I'm sure Dennis keeps a record of the photographer/copyright in a database, which perhaps isn't linked to the main project.
Saj
If you've found the forum useful, please consider making a donation.
About the :
*model
-list of creator_identifier (the person(s) who created the model)
do we need a LIST of creators of one model ? I don't think so.
how many models are created by more that one creator ?
If it is just a few, it is useless. I think that daydreamer talked about the fact that a couple created some models, and some of their models were created by only one of them...
*model
-list of creator_identifier (the person(s) who created the model)
do we need a LIST of creators of one model ? I don't think so.
how many models are created by more that one creator ?
If it is just a few, it is useless. I think that daydreamer talked about the fact that a couple created some models, and some of their models were created by only one of them...
-
Ondrej.Cibulka
- Buddha
- Posts: 1055
- Joined: January 9th, 2006, 4:18 pm
- Location: Czech republic
- Contact:
I am sure that many authors chooses the same model. For instance only several races of insect are composed, several very popular and looking interesting: praying mantis, hercules beetle, longhorn beetle etc. And what about elephant page in Origami design secrets? So if I would like to fold something (mantis) I will find whole amount of mantises of different authors and then choose the best.
Maybe I understand to that function of database incorectly.
Maybe I understand to that function of database incorectly.
Ondrej Cibulka Origami, www.origamido.cz
-
Daydreamer
- Moderator
- Posts: 1423
- Joined: October 28th, 2005, 2:53 pm
- Location: Vienna, Austria
- Contact:
The problem Alexandre mentioned is different. Of course there will be every elephant by different authors in the database, but those are different models. The question at hand is about one model designed by two (or more) authors in corporation like is f.e. the case with the Shumakovs.
There are two possibilities that I can think of to solve that problem:
1. make a list of authors for each model, which would be cleaner but possible more work to maintain.
2. Allow an author like "Katrin & Yuri Shumakov" which would result in three authors in the database "Katrin Shumakov", "Yuri Shumakov" and "Katrin & Yuri Shumakov". Even though this is the cleaner solution it might give problems when searching.
I don't know which solution would be better. Except for the Shumakovs I ran across a model like that (with two different authors) only once, but I can't remember which one that was...
There are two possibilities that I can think of to solve that problem:
1. make a list of authors for each model, which would be cleaner but possible more work to maintain.
2. Allow an author like "Katrin & Yuri Shumakov" which would result in three authors in the database "Katrin Shumakov", "Yuri Shumakov" and "Katrin & Yuri Shumakov". Even though this is the cleaner solution it might give problems when searching.
I don't know which solution would be better. Except for the Shumakovs I ran across a model like that (with two different authors) only once, but I can't remember which one that was...
So long and keep folding ^_^
Gerwin
Gerwin
Code: Select all
*creators
-first name
-last name
-biography
*resources
-list of creator_identifier (the person(s) who made the book)
-type (book/booklet/magazine/CDROM/website)
-title
-ISBN / ISSN-number / URL
-publishing date (month-year)
-quick summary
-comments
*models
-name
-traditional name (optional)
-creator_identifier (the person 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/(low/mid/high)intermediate/complex)
-cuts or no cuts
-glue or no glue
*diagrams
-resource_identifier
-model_identifier
-language
-comments
-type (diagram/CP/diagram+CP)
-page of the model in the book
-made with computer/written by hand/photodiagram ??
*reviews
-resource_identifier
-user_identifier
-review text
-rating
*photos
-model_identifier
-path to the photo
-folder name for copyright reasons
-photographer name for copyright reasons
*comments
-model_identifier or diagram_identifier ??
-user_identifier
-comment
We have to talk about the links between the pictures, the users, and the models too. Maybe the photograph or the folder of a model on a picture can be a user of the ODB, it could allow to create gallery of the work of the folders/users. Something like http://d307280.p33.patchhost.com/photogallery.asp maybe.
