IP Library Granted Patent US 8,812,525
Granted Patent B1
US 8,812,525 · App. 12/981,940 · Granted Aug 19, 2014

Local SQL files for mobile clients

Inventor: Buford Leonard Taylor, III (San Francisco, CA)
Assignee: Eventbrite, Inc.
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,812,525
App. No.
12/981,940
Granted
Aug 19, 2014
Kind
B1
Abstract

In one embodiment, a method includes receiving a request from a mobile client system for an event attendee list and transmitting a request to a data store for the event attendee list. If the event attendee list is available on the data store, then receiving the event attendee list from the data store, else transmitting a request to a data store for the event attendee list and receiving the event attendee list from a module. After receiving the event attendee list, the method includes transmitting the event attendee list to the mobile client system.

Claims (66)

1. A method implemented by one or more processors of one or more servers associated with an event management system that includes a local file store and a relational database, comprising:

receiving, by one or more of the servers, a request for an event attendee list from a first mobile check-in device, the first mobile check-in device being associated with an event organizer of the event and with a check-in location at a venue for an event, wherein the first mobile check-in device comprises a embedded-database engine, wherein the event attendee list is a complete structured query language client-side database comprising a plurality of tables, indices, and triggers, and wherein the event attendee list identifies, for each of a plurality of attendees of the event:

a ticket identifier associated with a ticket for the event, the ticket being associated with the attendee;

an attendee identifier associated with the attendee; and

whether the attendee is checked-in or not checked-in;

retrieving, by one or more of the servers, the event attendee list, wherein:

if the event attendee list is available in the local file store of the event management system, then retrieving the event attendee list from the local file store;

else:

retrieving attendee data associated with the event from the relational database;

converting the attendee data into the event attendee list; and

storing the event attendee list in the local file store of the event management system; and

transmitting, by one or more of the servers, the event attendee list to the first mobile check-in device.

2. The method of claim 1 , further comprising:

periodically receiving from the first mobile check-in device a first event attendee list update identifying the one or more attendees checked-in with the first mobile check-in device; and

periodically transmitting to the first mobile check-in device a second event attendee list update that identifies one or more attendees who have checked-in with one or more second mobile check-in devices.

3. The method of claim 2 , wherein:

the first event attendee list update is an application programming interface call and the second event attendee list update is a structured document object notation string.

4. The method of claim 1 , wherein:

the event attendee list that is a client-side database comprises one or more order identifiers;

each order identifier is associated with one or more attendee identifiers; and

each attendee identifier is associated with one or more ticket identifiers.

5. The method of claim 1 , wherein the request is hypertext-transfer protocol request message using an application programming interface.

6. An apparatus comprising: one or more processors; and a memory coupled to the processors comprising instructions executable by the processors, the processors operable when executing the instructions to:

receive a request for an event attendee list from a first mobile check-in device, the first mobile check-in device being associated with an event organizer of the event and with a check-in location at a venue for an event, wherein the first mobile check-in device comprises a embedded-database engine, wherein the event attendee list is a complete structured query language client-side database comprising a plurality of tables, indices, and triggers, and wherein the event attendee list identifies, for each of a plurality of attendees of the event:

a ticket identifier associated with a ticket for the event, the ticket being associated with the attendee;

an attendee identifier associated with the attendee; and

whether the attendee is checked-in or not checked-in;

retrieve the event attendee list, wherein:

if the event attendee list is available in a local file store of an event management system, then retrieving the event attendee list from the local file store;

else:

retrieving attendee data associated with the event from a relational database;

converting the attendee data into the event attendee list; and

storing the event attendee list in the local file store of the event management system; and

transmit the event attendee list to the first mobile check-in device.

7. The apparatus of claim 6 , wherein the processors are further operable when executing the instructions to:

periodically receive from the first mobile check-in device a first event attendee list update identifying the one or more attendees checked-in with the first mobile check-in device; and

periodically transmit to the first mobile check-in device a second event attendee list update that identifies one or more attendees who have checked-in with one or more second mobile check-in devices.

8. The apparatus of claim 7 , wherein:

the first event attendee list update is an application programming interface call and the second event attendee list update is a structured document object notation string.

9. The apparatus of claim 6 , wherein:

the event attendee list that is a client-side database comprises one or more order identifiers;

each order identifier is associated with one or more attendee identifiers; and

each attendee identifier is associated with one or more ticket identifiers.

10. The apparatus of claim 6 , wherein the request is hypertext-transfer protocol request message using an application programming interface.

11. One or more computer-readable non-transitory storage media embodying instructions that are operable when executed to:

receive a request for an event attendee list from a first mobile check-in device, the first mobile check-in device being associated with an event organizer of the event and with a check-in location at a venue for an event, wherein the first mobile check-in device comprises a embedded-database engine, wherein the event attendee list is a complete structured query language client-side database comprising a plurality of tables, indices, and triggers, and wherein the event attendee list identifies, for each of a plurality of attendees of the event:

a ticket identifier associated with a ticket for the event, the ticket being associated with the attendee;

an attendee identifier associated with the attendee; and

whether the attendee is checked-in or not checked-in;

retrieve the event attendee list, wherein:

if the event attendee list is available in a local file store of an event management system, then retrieving the event attendee list from the local file store;

else:

retrieving attendee data associated with the event from a relational database;

converting the attendee data into the event attendee list; and

storing the event attendee list in the local file store of the event management system; and

transmit the event attendee list to the first mobile check-in device.

12. The media of claim 11 , wherein the media further embodies instructions that are operable when executed to:

periodically receive from the first mobile check-in device a first event attendee list update identifying the one or more attendees checked-in with the first mobile check-in device; and

periodically transmit to the first mobile check-in device a second event attendee list update that identifies one or more attendees who have checked-in with one or more second mobile check-in devices.

13. The media of claim 12 , wherein:

the first event attendee list update is an application programming interface call and the second event attendee list update is a structured document object notation string.

14. The media of claim 11 , wherein:

the event attendee list that is a client-side database comprises one or more order identifiers;

each order identifier is associated with one or more attendee identifiers; and

each attendee identifier is associated with one or more ticket identifiers.

15. The media of claim 11 , wherein the request is hypertext-transfer protocol request message using an application programming interface.

Assignments (8)
NOTICE OF GRANT OF SECURITY INTEREST IN PATENTS Recorded Aug 6, 2025
From: EVENTBRITE, INC.
To: FIRST-CITIZENS BANK & TRUST COMPANY
Reel/Frame 072958/0396 →
TERMINATION AND RELEASE OF SECURITY INTEREST IN PATENTS Recorded Mar 12, 2021
From: WILMINGTON TRUST, NATIONAL ASSOCIATION
To: EVENTBRITE, INC.
Reel/Frame 055583/0602 →
ASSIGNMENT AND ASSUMPTION OF PATENT SECURITY AGREEMENT Recorded Jun 15, 2020
From: FP CREDIT PARTNERS L.P.
To: WILMINGTON TRUST, NATIONAL ASSOCIATION
Reel/Frame 052937/0145 →
SECURITY INTEREST Recorded May 11, 2020
From: EVENTBRITE, INC.
To: FP CREDIT PARTNERS, L.P
Reel/Frame 052629/0295 →
RELEASE OF SECURITY INTEREST Recorded Sep 26, 2018
From: VENTURE LENDING & LEASING VII, INC.; VENTURE LENDING & LEASING VIII, INC.
To: EVENTBRITE, INC.
Reel/Frame 046976/0248 →
SECURITY INTEREST Recorded May 29, 2018
From: EVENTBRITE, INC.
To: VENTURE LENDING & LEASING VIII, INC.
Reel/Frame 046251/0072 →
SECURITY INTEREST Recorded Jul 6, 2017
From: EVENTBRITE, INC.
To: VENTURE LENDING & LEASING VII, INC.; VENTURE LENDING & LEASING VIII, INC.
Reel/Frame 042926/0727 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 3, 2011
From: TAYLOR III, BUFORD LEONARD
To: EVENTBRITE, INC.
Reel/Frame 025571/0978 →