Wallcoverings storage and retrieval system5291395Abstract A system and method for presenting, selecting and retrieving actual samples of wallcoverings based upon selected criteria generated by the user. The user is provided with an input card or brochure listing a number of design characteristics. This input card or brochure includes a chart of color-range cells, each cell representing a range of shades of a base color. Based upon these characteristics, the system would produce a listing of all design patterns, such as wallcoverings which meet these characteristics. The computer system would generate a listing of these patterns. Additionally, the system could include a warehouse/storage facility operatively connected to the computer so as to physically provide the user with the design patterns which were chosen. Claims What is claimed is: Description BACKGROUND OF THE INVENTION
______________________________________
TABLE/
FIELD REF TYPE LENGTH LONG NAME
______________________________________
vendor vendor
*vencod STRING 6 vendor
vennam STRING 30 name
vendba STRING 30 dba
venadd STRING 30 address
vencit STRING 20 city
vensta STRING 2 state
venzip STRING 5 zip
venpri STRING 25 principal
venpph STRING 12 pri-phone
venrep STRING 25 rep
venrph STRING 12 rep-phone
venapc STRING 25 ap-contact
venapp STRING 12 ap-phone
venour STRING 20 our-acc
vengla STRING 5 gl-acc
venssn STRING 11 ss-number
venfid STRING 10 fid
venfac STRING 3 factor
ventyp STRING 3 type
book book
*boocod STRING 6 book
booven
vencod STRING 6 vendor
boonam STRING 25 name
boovno STRING 10 number
boorec DATE received
boodis DATE discon
price price
priboo
boocod STRING 6 book
pricod STRING 3 price-code
pricos AMOUNT 2 cost
priret AMOUNT 2 retail
pripri AMOUNT 2 price
type type
*typcod STRING 5 type
typdes STRING 15 descr
material material
*matcod STRING 5 material
matdes STRING 15 descr
matcom STRING 15 composition
matstr STRING 1 strip
mattri STRING 1 trimmed
matpas STRING 1 pasted
matwas STRING 1 wash
matfas STRING 1 fastness
matadh STRING 4 adhesive
surface surface
*surcod STRING 5 surface
surdes STRING 15 descr
brillance brillance
*bricod STRING 5 brillance
brides STRING 15 descr
match match
*mchcod STRING 5 match
mchdes STRING 15 descr
category category
*catcod STRING 4 category
catdes STRING 15 descr
element element
*elecod STRING 5 element
elecat
catcod STRING 4 category
eledes STRING 15 descr
number number
*numpri STRING 5 primary
numsec STRING 5 secondary
numnum NUMERIC 7 number
coord coord
*coocod NUMERIC 7 coord
design design
*descod NUMERIC 7 design
desboo
boocod STRING 6 book
despag STRING 3 pages
desnam STRING 20 name
desnum STRING 12 number
descol STRING 15 color
despcd STRING 3 price-code
despri AMOUNT 2 price
desver AMOUNT 2 vertical
deshor AMOUNT 2 horizontal
desmch
mchcod STRING 5 match
deswid AMOUNT 2 wide
deslen AMOUNT 2 length
deswei AMOUNT 2 weight
despac NUMERIC 2 packaged
desmin NUMERIC 2 minimum
descus AMOUNT 2 custom-charge
destyp
typcod STRING 5 type
desmat
matcod STRING 5 material
dessur
surcod STRING 5 surface
desbri
bricod STRING 5 brillance
desmot AMOUNT 2 motif-size
descoo
coocod NUMERIC 7 coord
desele desele
dedecd
descod NUMERIC 5 design
deelcd
elecod STRING 5 element
cust cust
*cuscod STRING 12 phone
cuspre STRING 6 prefix
cusla STRING 15 lat-name
cusfir STRING 15 first-name
cusadd STRING 30 address
cuscit STRING 25 city
cussta STRING 2 state
cuszip STRING 5 zip
cuscty STRING 3 card-type
cuscnu STRING 25 card-no
custyp STRING 1 cust-type
firm firm
fircod
cuscod STRING 12 firm
firnam STRING 30 name
firdba STRING 30 dba
firssn STRING 11 ss-number
firfid STRING 10 fid
firtax STRING 10 tax
search search
*seacod NUMERIC 5 search
seacus
cuscod STRING 12 cust
seadat DATE day
seatim TIME times
seaprb AMOUNT 2 beg-price
seapre AMOUNT 2 end-price
searep AMOUNT 2 repeat
seamch
mchcod STRING 5 match
seatyp
typcod STRING 5 type
seamat
matcod STRING 5 material
seasur
surcod STRING 5 surface
seabri
bricod STRING 5 brillance
seamsz AMOUNT 2 motif-size
seaele seaele
sesecd
seacod NUMERIC 5 search
seelcd
elecod STRING 5 element
______________________________________
The architecture of the above schema provides for a potentially exhaustive list of categories and elements that can be entered in the database, and that can be tuned at any time to achieve any level of complexity. The following suggested list of categories and elements attempts to balance the desire to expand the list with the requirements of ease of use and maintenance to achieve the most productive retrieval of the designs matching the required elements. Noted below are also some of the possible modifications in the entries.
______________________________________
TYPE
type descr
paper Papers
borde Borders
fabri Fabrics
poste Posters
bedsh Bed Sheets
bedsh Bed Covers
Note:
May include most home furnishings products
and/or any other product containing elements of
design.
SURFACE
surface descr
smoot Smooth
light Light
mediu Medium
heavy Heavy
Note:
A more rigorous measurement or description of
the surface texture of the product, may be
utilized.
BRILLANCE
brillance descr
dullb Dull Brillance
lowbr Low Brillance
mediu Medium Brillance
highb High Brillance
Note:
A more technical measurement of brillance may
be utilized.
MATCH
match descr
rando Random
acros Across
half Half Drop
multi Multiple Drop
CATEGORY
category descr
back Background
fore Foreground
moti Motif
patt Pattern
styl Style
Note:
The Motif category may be expanded to include
a separate category for foreground motif, and/or
background motifs.
ELEMENT
element category descr
diago patt Diagonal
diffu patt Diffused
freef patt Freeform
horiz patt Horizontal
solid patt Solid
verti patt Vertical
conte styl Contemporary
tradi styl Traditional
count styl Country
nurse styl Nursery
child styl Children
Note:
The elements in the category style can be
expanded to include a more detailed breakdown
of style, period, and cultural or geographic
identity.
ELEMENT
element category descr
abstr moti Abstracts
airpl moti Airplanes
anima moti Animals
berri moti Berries
birds moti Birds
blend moti Blends
block moti Blocks
bows moti Bows
brush moti Brushstrokes
chick moti Chickens
cloud moti Clouds
clown moti Clowns
dots moti Dots
farms moti Farms
flowe moti Flowers
geome moti Geometrics
grape moti Grapes
heart moti Hearts
kitch moti Kitchens
laces moti Laces
leave moti Leaves
lette moti Letters
milit moti Military
paisl moti Paisleys
peopl moti Peoples
plaid moti Plaids
plast moti Plaster
roses moti Roses
scall moti Scallops
shape moti Shapes
shell moti Shells
ships moti Ships
spray moti Spray Flower
squar moti Squares
stars moti Stars
stick moti Sticks
strip moti Stripes
tiedy moti Tyedye
train moti Trains
trend moti Trends
truck moti Trucks
weath moti Weathervanes
Zigza moti ZigZag
ELEMENT
element category descr
12345 back Background
Color
12345 fore Foreground
Color
The Codes of background and foreground color elements
are systematized as follows:
LEVEL 1 Character Use Values
Descr
23 Chroma bl Blue
gr Green
re Red
ye Yellow
or Orange
re Red
pu Purple
Level 2 Character Use Values
Descr
234 Hue blp Blue-Purple
blu Blue
blg Blue-Green
gre Green
yeg Yellow-Green
yel Yellow
yeo Yellow-Orange
ora Orange
reo Red-Orange
red Red
rep Red-Purple
pur Purple
bro Brown
gra Gray
whi White
bla Black
gol Gold
sil Silver
cop Copper
brz Bronze
Level 3 Character Use Values
Descr
1 Shade w White
1 Light
m Medium
d Dark
Character Use Values
Descr
5 Background b Background
5 Foreground f Foreground
Level 4 or higher of color can be incorporated by:
1) providing for additional hues
2) providing for additional shades/tints
______________________________________
The present invention can be implemented in both a retail store environment as well as a "shop at home" environment. The customer is provided with a specially designed brochure incorporating the wallcoverings database architecture and included a specially designed color-ranged cell chart. The customer would then enter in a manner known in the art the particular subjective and/or objective choices for the particular wallcovering that is desired. If a customer is at the retail establishment, these choices would be directly entered into the computer. Alternatively, the customer may mail the brochure with the entered choices directly to the store or may phone in his or her choices. Once the individually mounted wallcovering samples are retrieved, the customer may elect to visit the store to review them to greatly reduce the time required for the customer to find a wallcovering that meets their requirements. The output generated by the computer can take two forms. The first form would consist of a computer output indicating the name and title of the wallpaper chosen along with its specific number 32. At this point, the customer or the sales clerk would obtain the wallcovering or wallcoverings generated by the computer, these wallcoverings provided on their own specific carriers. Alternatively, the computer itself may be connected to a storage or warehousing system 16 in which the particular wallcovering carriers 20 are housed. Therefore, based upon the computer output generated by the computer, the computer system would automatically retrieve the particular wallcovering carriers which are directly provided to the customer. Additionally, if done by mail, these wallcovering carriers can be directly mailed to the respective customer. Although the invention has been illustrated and described with reference to the preferred embodiments described herein, it is to be understood that it is no way limited to the details of such embodiments, but is capable of numerous modifications within the scope of the appended claims. For instance, the present invention, while ideally suited to the wallpaper industry, has an application in other areas such as bedcoverings, floor coverings, and other home furnishing; fabrics; and many other commercially printed products that have graphical or design elements such as posters, ties, stamps, etc.
|
Same subclass Same class Consider this |
||||||||||
