 | | Lego classification system
|
|
Here is an outline of the first levels of the classification system I'm implementing. It's derived from Auczilla categories to some degree, but I limited the number of categories to nine. Each category can have 9 sub-categories, with a further 9 (...) (25 years ago, 11-Feb-00, to lugnet.db.brictionary)
|
| |
| | Re: Online LEGO Inventory Database
|
|
Steve Bliss wrote in message ... (...) with (...) and (...) Here is the current scema. I have decided to concentrate on the parts section, and themn move onto creating a set inventory section (which I think will be the easy part)... Total of 6 (...) (25 years ago, 10-Feb-00, to lugnet.db.brictionary)
|
| |
| | Re: Online LEGO Inventory Database
|
|
Steve Bliss wrote in message ... (...) with (...) and (...) It will be a relational database, and I tend to remove all hard codings possible. I will be designing the schema later today, and posting it for everyone to rip apart =) --Eric (25 years ago, 10-Feb-00, to lugnet.db.brictionary)
|
| |
| | Re: Online LEGO Inventory Database
|
|
(...) Having a good list of properties at the start is a good idea, but don't hard-code specific properties into the schema. It's just a many-to-many relation between parts and properties. Assuming a relational approach. Steve (25 years ago, 10-Feb-00, to lugnet.db.brictionary)
|
| |
| | Re: Online LEGO Inventory Database
|
|
(...) have (...) I'd thought about this earlier, but forgot to mention it. (...) based (...) Once (...) avoid (...) Yeah, I agree. One of the other threads had come to the same conclusion and are curently trying to decide exactly which properties (...) (25 years ago, 10-Feb-00, to lugnet.db.brictionary)
|
| |
| | Gryphon Bricks (Mac) -> LDraw database
|
|
I've put together a few pages with an inventory of the Gryphon Bricks parts, and attempted to cross-reference them with LDraw pieces from Steve Bliss' site. Take a look at: (URL) is a first pass: there are some mistakes here and there, and quite a (...) (25 years ago, 9-Feb-00, to lugnet.cad, lugnet.db.brictionary)
|
| |
| | Re: Online LEGO Inventory Database
|
|
(...) Yep. (...) Oh, and each description should probably be tagged with a source. That way, when we change the description of some part in LDraw, the cross-reference database can be updated. (...) Yep. A better approach may be modeling a set of (...) (25 years ago, 9-Feb-00, to lugnet.db.brictionary)
|
| |
| | Re: Online LEGO Inventory Database
|
|
(...) collate. (...) Yep. The difficulty is in matching up the descriptions from the various sources (e.g. which LDraw part is this Technica part?). Sometimes it's easy, somethimes it's not. (...) Yep. (...) part (...) a (...) and (...) That's the (...) (25 years ago, 9-Feb-00, to lugnet.db.brictionary, lugnet.db.inv)
|
| |
| | Re: What words describe the Lego elements?
|
|
(...) went in and updated the description parameters to include a count of holes in the piece. So if you see the page before I've updated the page with a new image, just pretend there's a hole-count category, OK? Thanks again. Billb. (25 years ago, 9-Feb-00, to lugnet.db.brictionary)
|
| |
| | Re: What words describe the Lego elements?
|
|
(...) From the discussion so far, I can tell that some of us may be confusing a classification system with being able to identify a Lego element. In the perfect database, the inquiry about a piece would not need to know *anything* about how the data (...) (25 years ago, 9-Feb-00, to lugnet.db.brictionary)
|
| |
| | Re: Online LEGO Inventory Database
|
|
(...) 'The database' should allow multiple descriptions per piece. And should have the major descriptions pre-loaded. The core element table should have an abstract key value, and a pointer to a graphic image for each part. A second table, call it (...) (25 years ago, 7-Feb-00, to lugnet.db.brictionary, lugnet.db.inv)
|
| |
| | Re: The Lepanadat Project (update 1)
|
|
(...) Of course you can use the database I'm working on now for a set inventory. Creating a set inventory was also one of my goals when I started with the Lepanadat project, but it takes a lot of time, so it would probably take many, many years (...) (25 years ago, 7-Feb-00, to lugnet.db.brictionary, lugnet.db.inv)
|
| |
| | Re: Online LEGO Inventory Database
|
|
(...) One problem we have at the moment is that the various sources of parts lists (LDraw, Tim Vattima's set inventories, Auczilla, Technica, etc) all contain different subsets of the full parts list and use different descriptions. We need to (...) (25 years ago, 7-Feb-00, to lugnet.db.brictionary, lugnet.db.inv)
|
| |
| | Re: Online LEGO Inventory Database
|
|
(...) I (...) to (...) Perhaps (...) be (...) Sounds good to me! I'm going to begin by designing the database to hold the data, and deciding on the best method to catalog the parts, or the best existing database to use for the parts. Any suggestions (...) (25 years ago, 7-Feb-00, to lugnet.db.brictionary, lugnet.db.inv)
|
| |
| | Re: What words describe the Lego elements?
|
|
(...) It was... 2 letters off is less than 10% margin of error, which is good enough when you're estimating. :-) Are you sure there isn't an umlaut or AE joined or something in his last name? :-) (25 years ago, 5-Feb-00, to lugnet.db.brictionary)
|
| |
| | Re: What words describe the Lego elements?
|
|
(...) Nope, "Linnaeus" is spelled correctly. However if the "A" above refers to his first name that's wrong, his first name is Carolus. If not, nevermind. -Chris (25 years ago, 5-Feb-00, to lugnet.db.brictionary)
|
| |
| | Re: What words describe the Lego elements?
|
|
(...) Respectfully disagree. Animals are all related (1), and the nomenclature, driven by the Linnaeus classification system, reflects that relationship. Lego elements, except in limited cases, are not related to each other by derivation or (...) (25 years ago, 4-Feb-00, to lugnet.db.brictionary)
|
| |
| | Re: What words describe the Lego elements?
|
|
After thinking about this a lot, I think we need a nomenclature that is similar to the binomial nomenclature that they use for animals. These could be coupled to a standard name, such as lupus wilus, aka Wiley Coyote. The technical name would allow (...) (25 years ago, 4-Feb-00, to lugnet.db.brictionary)
|
| |
| | Re: The Lepanadat Project (update 1)
|
|
I will be creating a set inventory database, with a web-based searchable interface, and will be, of course, needing some way to refer to each of the parts int he inventory. I would like to put your database online also, in a searchable format, and (...) (25 years ago, 4-Feb-00, to lugnet.db.brictionary, lugnet.db.inv)
|
| |
| | Re: What words describe the Lego elements?
|
|
(...) I had also thought about this subject. One of the names that also should appear in the Lepanadat project is some sort of systematic name. This would allow people to find a picture of the piece and the various names for the piece. I had a few (...) (25 years ago, 4-Feb-00, to lugnet.db.brictionary)
|
