Database method and system for conducting integrated dispatching
US007085775B2
(12) United States Patent Short, III et al.
(54)
(10) Patent N0.: (45) Date of Patent:
DATABASE METHOD AND SYSTEM FOR
4,688,244 A 4,750,197 A
CONDUCTING INTEGRATED DISPATCHING
4,804,937 A D306,720 S 5,265,006 A
(75) Inventors: Charles F. Short, III, Belvedere, CA
(US); Sanjiv Prabhakaran, San Jose, CA (U S)
5,321,605 A 5,627,517 A
Notice:
*
5,636,122 A
TX (US) Subject to any disclaimer, the term of this patent is extended or adjusted under 35
U.S.C. 154(b) by 511 days.
061. 17, 2001
(65)
Prior Publication Data
Hannon et al. ............. .. 377/58 Denekamp et al. .... .. 455/404.2
Barbiaux et al. Flies Asthana et al. Chapman et a1. McCormack et al. Theimer et al.
....... .. 340/5721
6/1997 Shah et a1.
8/1997 Tamiya
5,737,727 A 5,758,313 A
4/1998 Lehmann et a1. 5/1998 Shah et a1.
5,904,727 A
*
5/1999
Prabhakaran ............. .. 701/208
5,922,040 A
*
7/1999
Prabhakaran ............. .. 701/117
5,944,769 A
(22) Filed:
5/1997
Aug. 1, 2006
5,659,486 A
5,987,463 A
(21) App1.No.: 09/981,686
8/1987 6/1988
2/1989 3/1990 11/1993 6/1994 7/1996
5,541,848 A
(73) Assignee: Sidewinder Holdings Ltd., Coppell, (*)
* *
US 7,085,775 B2
8/1999 Musk et al. * 11/1999
Draaijer et al. ............. .. 707/10
6,041,402 A
3/2000 Cannon et a1.
6,073,007 A * 6,292,657 B1 *
6/2000 9/2001
Doyle ................... .. 455/412.2 Laursen et al. ........... .. 455/411
(Continued)
US 2002/0188702 A1 Dec. 12, 2002
OTHER PUBLICATIONS
Related US. Application Data (63)
(60)
Continuation of application No. 09/204,325, ?led on Dec. 2, 1998, now abandoned, which is a continuation-in-part of application No. 09/057,375, ?led on Apr. 8, 1998, now abandoned. Provisional application No. 60/067,444, ?led on Dec. 3, 1997, and provisional application No. 60/043,224, ?led on
Apr, 9, 1997.
(51)
Int. Cl. G06F 17/30
Queree, Vehicle Integration of Fleet Management Systems, IEE, Colloquium, 1993, pp. 10/1*10/3.* Feijoo et al., A System for Fleet Management using DiiTer ential GPS and VHF Data Transmission Mobile Networks,
Procedings of the lEEEilEE, 1993, pp. 4454448.>X
Handle All Available Messages
Send ONE Only -/ 96
Before Sending New Data
\
>
FIG. 1B
J
U.S. Patent
Aug. 1, 2006
2
3
7’
\,
HEADER |
/
\
Synch Packet
Sheet 3 0f 17
l
A‘ |
DATA
|
\ Data Length
(STX) Type (Excluding Header)
FIG. 1C
US 7,085,775 B2
)
U.S. Patent
Aug. 1, 2006
Sheet 4 of 17
Receive Arrival Information About
US 7,085,775 B2
N 102
Vehicle Transporting Product
Receive Unloading Information
w 104
About Product
1 Receive Storage Information About Product
w 106
l Receive Loading Information
w 108
‘ About Product
v Receive Departure Information About Vehicle Transporting
w 110
Product
l
integrating The Arrival, Unloading, Storage, Loading And Departure
Information With Routing information
i
@ FIG. 1D
w 112
U.S. Patent
Aug. 1, 2006
900 \
Sheet 5 0f 17
Order Entry
l Dispatch 1 Billing 1 Accounting 1 Reporting
US 7,085,775 B2
w 901
M 903
tv 905 M 907
w 909
FIG. 2A 1201 N
lnput Order data
F 1203 'v
input Fixed Routes
I 1205 N
Schedule Orders To Routes
t 1 207
Output Schedule N 1206
1209 M
Perform Delivery
it 1211 w
Transmit Delivery Data
1213® FIG. 2B
U.S. Patent
Aug. 1, 2006
Sheet 8 0f 17
US 7,085,775 B2
/ 1300 1301 J
Input Route Data
1303 *v
Select Dag And '?me
1305 w
Select+Route
1306
Output+Route
1307 *v
Perform+Delivery
1309 w
Obtain Rtute Data
(12) United States Patent Short, III et al.
(54)
(10) Patent N0.: (45) Date of Patent:
DATABASE METHOD AND SYSTEM FOR
4,688,244 A 4,750,197 A
CONDUCTING INTEGRATED DISPATCHING
4,804,937 A D306,720 S 5,265,006 A
(75) Inventors: Charles F. Short, III, Belvedere, CA
(US); Sanjiv Prabhakaran, San Jose, CA (U S)
5,321,605 A 5,627,517 A
Notice:
*
5,636,122 A
TX (US) Subject to any disclaimer, the term of this patent is extended or adjusted under 35
U.S.C. 154(b) by 511 days.
061. 17, 2001
(65)
Prior Publication Data
Hannon et al. ............. .. 377/58 Denekamp et al. .... .. 455/404.2
Barbiaux et al. Flies Asthana et al. Chapman et a1. McCormack et al. Theimer et al.
....... .. 340/5721
6/1997 Shah et a1.
8/1997 Tamiya
5,737,727 A 5,758,313 A
4/1998 Lehmann et a1. 5/1998 Shah et a1.
5,904,727 A
*
5/1999
Prabhakaran ............. .. 701/208
5,922,040 A
*
7/1999
Prabhakaran ............. .. 701/117
5,944,769 A
(22) Filed:
5/1997
Aug. 1, 2006
5,659,486 A
5,987,463 A
(21) App1.No.: 09/981,686
8/1987 6/1988
2/1989 3/1990 11/1993 6/1994 7/1996
5,541,848 A
(73) Assignee: Sidewinder Holdings Ltd., Coppell, (*)
* *
US 7,085,775 B2
8/1999 Musk et al. * 11/1999
Draaijer et al. ............. .. 707/10
6,041,402 A
3/2000 Cannon et a1.
6,073,007 A * 6,292,657 B1 *
6/2000 9/2001
Doyle ................... .. 455/412.2 Laursen et al. ........... .. 455/411
(Continued)
US 2002/0188702 A1 Dec. 12, 2002
OTHER PUBLICATIONS
Related US. Application Data (63)
(60)
Continuation of application No. 09/204,325, ?led on Dec. 2, 1998, now abandoned, which is a continuation-in-part of application No. 09/057,375, ?led on Apr. 8, 1998, now abandoned. Provisional application No. 60/067,444, ?led on Dec. 3, 1997, and provisional application No. 60/043,224, ?led on
Apr, 9, 1997.
(51)
Int. Cl. G06F 17/30
Queree, Vehicle Integration of Fleet Management Systems, IEE, Colloquium, 1993, pp. 10/1*10/3.* Feijoo et al., A System for Fleet Management using DiiTer ential GPS and VHF Data Transmission Mobile Networks,
Procedings of the lEEEilEE, 1993, pp. 4454448.>X
Handle All Available Messages
Send ONE Only -/ 96
Before Sending New Data
\
>
FIG. 1B
J
U.S. Patent
Aug. 1, 2006
2
3
7’
\,
HEADER |
/
\
Synch Packet
Sheet 3 0f 17
l
A‘ |
DATA
|
\ Data Length
(STX) Type (Excluding Header)
FIG. 1C
US 7,085,775 B2
)
U.S. Patent
Aug. 1, 2006
Sheet 4 of 17
Receive Arrival Information About
US 7,085,775 B2
N 102
Vehicle Transporting Product
Receive Unloading Information
w 104
About Product
1 Receive Storage Information About Product
w 106
l Receive Loading Information
w 108
‘ About Product
v Receive Departure Information About Vehicle Transporting
w 110
Product
l
integrating The Arrival, Unloading, Storage, Loading And Departure
Information With Routing information
i
@ FIG. 1D
w 112
U.S. Patent
Aug. 1, 2006
900 \
Sheet 5 0f 17
Order Entry
l Dispatch 1 Billing 1 Accounting 1 Reporting
US 7,085,775 B2
w 901
M 903
tv 905 M 907
w 909
FIG. 2A 1201 N
lnput Order data
F 1203 'v
input Fixed Routes
I 1205 N
Schedule Orders To Routes
t 1 207
Output Schedule N 1206
1209 M
Perform Delivery
it 1211 w
Transmit Delivery Data
1213® FIG. 2B
U.S. Patent
Aug. 1, 2006
Sheet 8 0f 17
US 7,085,775 B2
/ 1300 1301 J
Input Route Data
1303 *v
Select Dag And '?me
1305 w
Select+Route
1306
Output+Route
1307 *v
Perform+Delivery
1309 w
Obtain Rtute Data
