Method of and apparatus for broadcasting databases

• US 20030177142A1
• Filed: 02/03/2003
• Published: 09/18/2003
• Est. Priority Date: 08/03/2000
• Status: Abandoned Application

• Current Assignee: Radioscape Limited
• Original Assignee: Radioscape Limited
• Inventors: Ferris, Gavin Robert
• Application Number:
  US10/343,809
• Publication Number:
  US 20030177142A1
• Time in Patent Office: Days
• US Class Current: 707/104.1
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
• CPC Class Codes: H04H 20/16 Arrangements for broadcast or for distribution of identical information repeatedly
• CPC Class Codes: H04H 20/86 Arrangements characterised by the broadcast information itself
• CPC Class Codes: H04H 2201/20 digital audio broadcasting [DAB]

Abstract

A method of User broadcasting data using wireless communication in which the data is extracted from a source SQL database and broadcast to a receiving device programmed to reconstruct the data into a SQL database.

Claims

1. A method of broadcasting data using wireless communication in which the data is extracted from a source SQL database and broadcast to a receiving device programmed to reconstruct the data into a SQL database.

2. The method of claim 1 comprising the steps of:

(a) extracting schema defining the source SQL database;

(b) rendering the schema into a form suitable for transmission;

(c) transmitting the schema in its rendered form using wireless communication, with the objective that the schema in its tendered form is received at a receiving device and used to construct an empty SQL database at the receiving device.

3. The method of claim 2 comprising the steps of

(a) rendering a schema defining the source SQL database into a form suitable for transmission by listing a command set defining the schema as text;

(b) sending this text to a transport mechanism which is a carousel-based virtual filing system.

4. The method of claim 3 in which the wireless communication is Eureka-147 and the transport mechanism is a Mutlimedia Object Transport (MOT).

5. The method of claim 3 or 4 in which the schema description text files are subject to lossless compression prior to transmission.

6. The method of claims 2-5 comprising the steps of:

(a) extracting table data from the source SQL database;

(b) rendering that table data into a form suitable for transmission;

(c) transmitting the table data using wireless communication, with the objective that the table data in tendered form is received at a receiving device and used to populate the empty SQL database at the receiving device.

7. The method of claim 6 in which the table data is organised as XML files.

8. The method of claim 7 in which the XML files ate subject to lossless compression prior to transmission.

9. The method of claims 2-8 comprising the steps of:

(a) extracting a query list from the source SQL database;

(b) tendering the query list into a form suitable for transmission;

(c) transmitting the query list using wireless communication with the objective of the tendered query list being received at a receiving device and being passed to an application on the receiving device, in which the application is programmed to allow a user to apply structured queries to the SQL database at the receiving device by using the query list.

10. The method of claim 9 in which the query list is subject to lossless compression prior to transmission.

11. The method of any preceding claim in which the receiving device is programmed with the schema definition without the schema definition being broadcast.

13. The method of receiving data as claimed in claim 12, in which the data is broadcast using a method as claimed in any of claim 1-11.

17. An apparatus programmed to perform the method of claims 1-11.

19. A database application adapted to use data broadcast using the method of claims 1-11.

21. Computer software programmed to perform the method of claims 1-11.

23. An e-commerce transaction system comprising one or mote servers providing data to be broadcast using the method of claims 1-11 and receiving purchase requests issued by one or more receiving device using a back channel.

12. A method of receiving, at a receiving device, data broadcast using wireless communication, in which the broadcast data has been extracted from a source SQL database and is reconstructed into a SQL database at the receiving device.

14. The method of claim 12 or 13 comprising the following steps performed at the receiving device:

(a) receiving schema, tendered into a form suitable for transmission, in which the schema define the source SQL database and

(b) constructing an empty SQL database using the schema.

15. The method of claim 14 comprising the following steps performed at the receiving device:

(a) receiving table data, rendered into a form suitable for transmission, in which the table data define the contents of the source SQL database and

(b) populating the empty SQL database at the receiving device with the table data.

16. The method of claim 14-15 comprising the following steps performed at the receiving device:

(a) receiving a query list, rendered into a form suitable for transmission, in which the query list defines several structured queries which may be performed on the source SQL database and

(b) passed the query list to an application on the receiving device, in which the application is programmed to allow a user to apply structured queries to the SQL database at the receiving device by using the query list.

18. A device programmed to perform the method of claims 12-16.

20. A database application adapted to use data received using the method of claims 12-16.

22. Computer software programmed to perform the method of claims 12-16.