Accessing data tag information using database queries

• US 7,248,168 B2
• Filed: 06/21/2004
• Issued: 07/24/2007
• Est. Priority Date: 06/21/2004
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Staeck, Jens, Muehl, Gordon, Hinrichs, Karsten
• Primary Examiner(s): La; Anh V.
• Application Number:
  US10/873,837
• Publication Number:
  US 20050280540A1
• Time in Patent Office: 1,128 Days
• Field of Search: 340/572.1, 340/572.4, 340/10.41, 340/10.4, 340/10.33, 340/10.1, 340/825.49, 340/539.13, 707/1, 707/3, 707/8, 235/384, 235/454, 711/118, 711/144, 709/224, 709/223
• US Class Current: 340/572.4
• CPC Class Codes: G06F 16/242 Query formulation
• CPC Class Codes: Y10S 707/99931 Database or file accessing

Abstract

A computer-implemented method for mapping data between a data tag and a database application using a generic and extensible mapping interface. A computer-implemented method includes: communicating with the data tag via a wireless interface using a data tag query protocol; communicating with a database application via a database interface using a database query protocol; reading a mapping definition; exchanging data between the wireless interface and the database interface by mapping between the data tag query protocol and the database query protocol within the mapping interface using the mapping definition; and storing the mapping definition separately from the mapping interface, providing separation between mapping interface and mapping definition.

Claims

1. A computer-implemented method for mapping data between a data tag and a database application using a mapping interface, comprising:

communicating with the data tag via a wireless interface using a data tag query protocol;

communicating with the database application via a database interface using a database query protocol;

reading a mapping definition;

exchanging data between the wireless interface and the database interface by mapping between the data tag query protocol and the database query protocol using the mapping definition, the mapping being performed in the mapping interface; and

storing the mapping definition separately from the mapping interface.

2. The computer-implemented method of claim 1, wherein the mapping definition is stored within the data tag.

3. The computer-implemented method of claim 2, wherein the mapping definition is stored in a separate memory area of the data tag.

4. The computer-implemented method of claim 1, wherein the mapping definition is stored in a file.

5. The computer-implemented method of claim 4, further comprising:

storing various mapping definitions representing different types of data tags within the file.

6. The computer-implemented method of claim 1, further comprising:

managing memory within the data tag using the mapping definition.

7. The computer-implemented method of claim 1, further comprising:

defining un-clustered memory areas for data within the data tag.

8. The computer-implemented method of claim 1, further comprising:

updating the mapping definition; and

storing data within the data tag from a previous format into a new format according to the updated mapping definition.

9. The computer-implemented method of claim 1, further comprising:

dynamically adapting memory usage of the data tag using the mapping definition.

10. The computer-implemented method of claim 1, wherein the mapping definition is stored in a file in a device-independent format.

11. The computer-implemented method of claim 1, further comprising:

providing a description of accessible data within the data tag to an application via the database interface.

12. The computer-implemented method of claim 1, further comprising:

receiving, via the database interface, a database query protocol request from a requesting application to determine a description of accessible data via the database interface;

obtaining the description of accessible data from the mapping definition; and

providing the description of accessible data to the requesting application via the database interface.

13. The computer-implemented method of claim 1, further comprising:

receiving a database query protocol request from an application to determine data from a data tag;

mapping the database query protocol request onto a data tag query protocol request; and

providing the data tag query protocol request to the wireless interface to interrogate the data tag.

14. The computer-implemented method of claim 1, further comprising:

receiving data from a data tag as a data tag query protocol message via the wireless interface;

mapping the data from the data tag query protocol message into a database query protocol message; and

providing the data as a database query protocol message to the database interface.

15. The computer-implemented method of claim 1, further comprising:

providing data from the data tag to the database interface formatted as database data.

16. The computer-implemented method of claim 15, wherein the data from the data tag is provided to the database interface as one row of a database.

17. The computer-implemented method of claim 15, wherein a defined byte area of the data tag is provided to the database interface as one column of a row.

18. The computer-implemented method of claim 1, wherein byte-oriented data is stored on the data tag.

19. The computer-implemented method of claim 1, further comprising:

providing field-oriented data to the database interface.

20. The computer-implemented method of claim 1, wherein a physical layer access interface is used for communicating with the data tag via the wireless interface.

21. The computer-implemented method of claim 20, further comprising:

normalizing messages received from the data tag via the wireless interface into a device-independent format within the physical layer access interface.

22. The computer-implemented method of claim 20, further comprising:

formatting messages received from the mapping interface into a device-specific format within the physical layer access interface.

23. The computer-implemented method of claim 20, further comprising:

communicating data between the data tag and the mapping interface via the wireless interface and the physical access interface.

24. The computer-implemented method of claim 1, further comprising:

continuously scanning for available data tags.

25. The computer-implemented method of claim 1, further comprising:

providing data from a data tag via the database interface to the database application after the data tag is accessible.

26. The computer-implemented method of claim 1, further comprising:

scanning for available data tags after receiving a request from the database application via the database interface.

27. The computer-implemented method of claim 1, further comprising:

write-protecting memory blocks within the data tag, by using database query protocol messages.

28. The computer-implemented method of claim 1, wherein the mapping definition is implemented in a device-independent format.

29. The computer-implemented method of claim 1, wherein mapping between the data tag query protocol and the database query protocol within the mapping interface is implemented in a device-independent format.

30. The computer-implemented method of claim 1, further comprising:

writing data, which is received via the database interface, to the data tag.

31. The computer-implemented method of claim 1, further comprising:

performing byte converting when mapping the data between the data tag query protocol and the database query protocol.

32. The computer-implemented method of claim 1, further comprising:

performing error handling within the mapping interface.

33. The computer-implemented method of claim 1, further comprising:

performing event handling within the mapping interface.

34. A system for mapping data between a data tag and a database application, comprising:

a mapping device comprising;

a mapping interface for reading a mapping definition;

a wireless interface for communicating with the data tag using a data tag query protocol; and

a database interface for communicating with the database application using a database query protocol;

wherein the mapping device is configured to implement communication between the wireless interface and the database interface by mapping between the data tag cuery protocol and the database ciuerv protocol using the mapping definition; and

a storage device that is separate from the mapping device, the storage device for storing the mapping definition separately from the mapping interface.

35. The system of claim 34, wherein the data tag comprises a radio frequency identification tag, a smart tag, or an infrared tag.

36. The system of claim 34, wherein the mapping device comprises a mobile device.

37. The system of claim 34, wherein the storage device is located within the data tag.

38. The system of claim 34, wherein the storage device comprises a memory area for storing the mapping definition.

39. The system of claim 34, wherein the storage device comprises a file system.

40. The system of claim 34, further comprising:

memory management means within the storage device or the mapping device for managing memory within the data tag using the mapping definition.

41. The system of claim 34, wherein the mapping device comprises description providing means to provide a description of accessible data within the data tag to an application via the database interface.

42. The system of claim 34, wherein the mapping device comprises formatting means to provide, to the database interface, data from the data tag that is formatted as database data.

43. The system of claim 42, wherein the formatting means is configured to provide, to the database interface, data from the data tag as one row of a database.

44. The system of claim 42, wherein the formatting means is configured to provide, to the database interface, a defined byte area of the data tag as one column of a row.

45. The system of claim 34, wherein the storage device is configured to store byte-oriented data on the data tag.

46. The system of claim 34, wherein the mapping device comprises a physical layer access interface for accessing the data tag via the wireless interface.

47. The system of claim 46, wherein the physical layer access interface is configured to standardize messages received from the data tag via the wireless interface into a device-independent format.

48. The system of claim 46, wherein the physical layer access interface is configured to format messages received from the mapping interface into a device-specific format.

49. The system of claim 46, wherein the physical layer access interface is configured to communicate data between the data tag and the mapping interface via the wireless interface.

50. The system of claim 34, wherein the data tag comprises write-protect memory blocks that are write-protectable using database query protocol messages.

51. The system of claim 34, wherein the mapping device comprises byte converting means confiaured to perform byte conversion as part of mapping data between the data tag query protocol and the database query protocol.

52. The system of claim 34, wherein the mapping device comprises error handling means to perform error handling.

53. The system of claim 34, wherein the mapping device comprises event handling means to perform event handling.

54. The system of claim 34, wherein the mapping device comprises interrogation means for wirelessly accessing the data tag using the wireless interface.

55. A computer program product readable by a computer and embodying a program of instructions capable of mapping data between a data tag and a database application using a mapping interface, the program comprising instructions operable to cause the computer to perform:

communicating with the data tag via a wireless interface using a data tag query protocol;

communicating with the database application via a database interface using a database query protocol;

reading a mapping definition; and

exchanging data between the wireless interface and the database interface by mapping between the data tag query protocol and the database query protocol using the mapping definition, the mapping being performed in the mapping interface;

wherein the mapping definition is stored separately from the mapping interface.