Parts database - Page 3 - GM Forum - Buick, Cadillac, Chev, Olds, GMC & Pontiac chat


Forum updates and suggestions Check here for updates about the Forums.

Closed Thread
 
 
 
Thread Tools Search this Thread
Old 11-12-2003, 02:10 AM   #21
Junior Member
Posts like a Ricer Type-R
 
Join Date: Aug 2002
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
willwren is on a distinguished road
Default

The problem with exclusive access is big. This won't be running on our server in Florida. It would have to be somewhere else. How can we keep the membership list synced up between the servers? And passwords? Unless it asks for the username and password here, then links to the remote server?
willwren is offline  
Old 11-13-2003, 10:43 AM   #22
Member
Posts like a V-Tak
 
Join Date: Aug 2003
Location: Upstate NY
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Slick666 is on a distinguished road
Default

It think it is very possible assuming that GM NEVER uses the same part number for different or modifyed parts
(ex pt#3356998 from 1994 is slightly different from pt#3356998 from 199
Parts could be arranged in a binary tree sorted by part number. A binary tree would be easy on the space usage. Number of entries equals the number of parts. Parts used more that once only need to be entered once and it would be quick. To look through 131,071 parts would require the program to only make 17 comparisions (formule is 2 raised to the number of entries -1)

Each node or part would have to store:

part number
array of years used
part name
description (1 to two sentences)

in your program you would have interfaces with searches for
number
year, name

possibly a keyword search for parts
this would require possibly an array of keywords (more space required)
and more code to search

The largest part of this unfertaking would be data entry for each part

opinions anyone?
Slick666 is offline  
Old 11-13-2003, 10:44 AM   #23
Member
Posts like a V-Tak
 
Join Date: Aug 2003
Location: Upstate NY
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Slick666 is on a distinguished road
Default

Does anyone have some online space to store this and how much do you have
Slick666 is offline  
Old 11-13-2003, 01:30 PM   #24
Senior Member
True Car Nut
 
Join Date: May 2002
Location: Edmonton, AB Canada
Posts: 2,621
Thanks: 0
Thanked 0 Times in 0 Posts
DeathRat is on a distinguished road
Default

Quote:
Originally Posted by Slick666
It think it is very possible assuming that GM NEVER uses the same part number for different or modifyed parts
(ex pt#3356998 from 1994 is slightly different from pt#3356998 from 199
Parts could be arranged in a binary tree sorted by part number. A binary tree would be easy on the space usage. Number of entries equals the number of parts. Parts used more that once only need to be entered once and it would be quick. To look through 131,071 parts would require the program to only make 17 comparisions (formule is 2 raised to the number of entries -1)

Each node or part would have to store:

part number
array of years used
part name
description (1 to two sentences)

in your program you would have interfaces with searches for
number
year, name

possibly a keyword search for parts
this would require possibly an array of keywords (more space required)
and more code to search

The largest part of this unfertaking would be data entry for each part

opinions anyone?
If GM updates a Part, GM WILL change the Part Number too for that part.
DeathRat is offline  
Old 11-13-2003, 04:41 PM   #25
Member
Posts like a V-Tak
 
Join Date: Aug 2003
Location: Upstate NY
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Slick666 is on a distinguished road
Default

Perfect!

Anyone else have feedback/opinions ect.?
Slick666 is offline  
Old 11-16-2003, 03:49 PM   #26
Member
Posts like a V-Tak
 
Join Date: Aug 2003
Location: Upstate NY
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Slick666 is on a distinguished road
Default

Anyone else want to do this?

cause if not I'll drop it
Slick666 is offline  
Old 11-16-2003, 03:56 PM   #27
Senior Member
Posts like a Turbo
Thread Starter
 
Join Date: Oct 2003
Location: Eugene/Springfield Oregon
Posts: 322
Thanks: 0
Thanked 0 Times in 0 Posts
Justind23 is on a distinguished road
Default

Like I said I'm down for the data entry. I really want to see this happen. I may be able to use my current mac (10gig) for the server in about two to three months which may seem a long time but it may take that long to get all the data entered. All I need to know is what I can do to help make this happen.
Justind23 is offline  
Old 11-17-2003, 07:23 PM   #28
Member
Posts like a V-Tak
 
Join Date: Aug 2003
Location: Upstate NY
Posts: 65
Thanks: 0
Thanked 0 Times in 0 Posts
Slick666 is on a distinguished road
Default

Well I believe I can write the program needed for such a system but I would need the actual parts lists. do we know who has them?
Slick666 is offline  
 
 
Closed Thread

Related Topics
Thread Thread Starter Forum Replies Last Post
Gas Milage Database... Need info! bmsgaffer86 General GM Chat 18 05-27-2004 07:11 PM
GM part number database vital49 General GM Chat 4 02-09-2004 06:01 PM
Link Database Damemorder Performance, Brainstorming & Tuning 5 10-20-2003 06:36 PM
Knowledge database??? SSEi95 Forum updates and suggestions 15 06-06-2003 01:01 AM


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 09:33 AM.


We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.