Database management system with persistent, user-accessible bitmap values

• US 20050216518A1
• Filed: 03/26/2004
• Published: 09/29/2005
• Est. Priority Date: 03/26/2004
• Status: Abandoned Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Hu, Ying, Chong, Eugene Inseok, Sundara, Seema, Das, Souripriya, Srinivasan, Jagannathan, Chorma, Timothy
• Application Number:
  US10/810,756
• Publication Number:
  US 20050216518A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2237 Vectors, bitmaps or matrices

Abstract

A database management system that has bitmap values in which set bits in a representation of a bitstring specify a set of objects whose definitions are built into the database management system. The database management system further includes user-accessible operations on the bitmap values. The bitmap values are represented by means of a mapping specifier that specifies a range of the set of objects and a representation of a string of bits that has been mapped onto the set of object specified by the range specifier. The representation of the string of bits may be compressed. Bitmap operations on the values may alter the range specifier, the size of the string of bits, or individual bits in the string of bits. The objects represented by the bitmap values may be objects in the database management system or objects external thereto. An example of bitmap values of the first kind are bitmap values representing sets of rowids. rowid bitmap values may be used to make a user-defined index of attribute values for any set of objects contained in fields in the database management system. An example of bitmap values of the second kind are bitmap values representing sets of electronic product codes. ePC bitmap values may be used in any application where a compact representation of a set of ePC codes is desired.

Claims

1. A database management system having the improvement comprising:

bitmap values, a bitmap value having a representation of a bitstring wherein set bits specify a set of objects whose definitions are built into the database management system, and user-accessible operations on the bitmap values.

2. The database management system set forth in claim 1 wherein the user-accessible operations comprise at least:

a set-to-bitmap operation wherein a bitmap value is derived from a given set of the objects.

3. The database management system set forth in claim 2 wherein:

the derived bitmap value is a new bitmap value that specifies the objects in the given set.

4. The database management system set forth in claim 2 wherein:

the derived bitmap value is a preexisting bitmap value which now further specifies the objects in the given set.

5. The database management system set forth in claim 2 wherein:

the derived bitmap value is a preexisting bitmap value which now no longer specifies any objects in the given set.

6. The database management system set forth in claim 1 wherein the user-accessible operations comprise at least:

a bitmap-to-set operation wherein the set of the objects specified in a given bitmap value is derived from the given bitmap value.

7. The database management system set forth in claim 1 wherein the user-accessible operations comprise at least:

a bitmap-to-count operation wherein the number of the objects in the set specified in a given bitmap value is derived from the given bitmap value.

8. The database management system set forth in claim 1 wherein the user-accessible operations comprise at least:

an existence operation wherein a value representing the logical value TRUE is returned when a given object belongs to the set of the objects represented by a given bitmap value.

9. The database management system set forth in claim 1 wherein the user-accessible operations comprise at least:

a logical operation on a first bitstring represented by a first bitmap value and a second bitstring represented by a second bitmap value.

10. The database management system set forth in claim 1 wherein the user-accessible operations comprise at least:

a comparison operation on a first bitmap value and a second bitmap value wherein a value representing the logical value TRUE is returned when the first bitmap value and the second bitmap value specify the same set of the objects.

11. The database management system set forth in claim 1 wherein:

the bitmap values include settable bitmap values; and

the user-accessible operations comprise at least an assignment operation which sets a target settable bitmap value from a source bitmap value.

12. The database management system set forth in claim 1 wherein:

the bitmap values include bitmap values that are persistent in the database management system.

13. The database management system set forth in claim 12 wherein:

the persistent bitmap values include bitmap values in fields of tables of the database management system.

14. The database management system set forth in claim 1 wherein:

the bitstring is compressed.

15. The database management system set forth in claim 1 wherein:

the objects are identifiers for other objects that exist in the database management system.

16. The database management system set forth in claim 15 wherein:

the identifiers for the other objects are row identifiers of rows in the database management system.

17. The database management system set forth in claim 16 wherein:

the row identifiers are row identifiers returned by a user-defined query executed in the database management system.

18. The database management system set forth in claim 17 wherein:

the query returns a row identifier when a field in the row has an attribute specified in the query,

whereby the bitmap value represents the set of fields having the specified attribute.

19. The database management system set forth in claim 1 wherein:

the objects are identifiers for other objects that exist outside the database management system.

20. The database management system set forth in claim 19 wherein:

the identifiers for objects that exist outside the database management system are electronic product codes for product items.

21. A data storage device, the data storage device being characterized in that:

the data storage device contains code which, when executed in a computer system, implements the database management system set forth in claim 1.

22. A bitmap value employed in a database management system, the bitmap value representing a first set of first objects, the first objects being external to the database management system and members of the first set being mapped onto a members of a second set of second objects that is defined in the database management system, and

the bitmap value comprising:

a mapping specifier that maps a string of bits to a subset of the second set; and

a representation of the string of bits wherein a bit is set in the represented string of bits when the member of the second set that is mapped to the bit has a member of the first set mapped thereto.

23. The bitmap value set forth in claim 22 wherein:

the second set is ordered.

24. The bitmap value set forth in claim 23 wherein:

the order of the members of the second ordered set corresponds to values of the members thereof;

the mapping specifier specifies the mapping by specifying one or more ranges of the values of the members of the second ordered set to which the string of bits is mapped; and

the representation of the string of bits represents strings of bits corresponding to the ranges.

25. The bitmap value set forth in claim 24 wherein:

the mapping specifier specifies the range of the values by specifying a start value and an end value.

26. The bitmap value set forth in claim 24 wherein:

the values include a prefix which determines a range of the values; and

the mapping specifier specifies the range of the values by specifying the prefix for the range.

27. The bitmap value set forth in claim 26 wherein:

the mapping specifier further specifies the range of the values by using a start value and an end value to specify one or more subranges of the range specified by the prefix.

28. The bitmap value set forth in claim 24 wherein:

the objects in the second ordered set are identifiers for objects in the first set.

29. The bitmap value set forth in claim 28 wherein:

the identifiers for objects in the first set are electronic product codes for the objects

30. The bitmap value set forth in claim 22 wherein:

there is a plurality of the bitmap values in the database management system; and

certain of the bitmap values are persistent in the database management system.

31. The bitmap values set forth in claim 30 wherein:

the persistent bitmap values include bitmap values in fields of tables of the database management system.

32. The bitmap value set forth in claim 22 wherein:

the representation of the bitstring is a compressed representation thereof.

33. The bitmap value set forth in claim 22 wherein:

there is a plurality of the bitmap values in the database management system; and

the database management system provides a plurality of user-accessible operations on the bitmap values.

34. The bitmap value set forth in claim 33 wherein:

certain of the user-accessible operations alter the range specifier and the representation of the bitstring as required to map the represented string of bits to a subset of the second set that is required for the operation.

35. A data storage device, the data storage device being characterized in that:

the data storage device contains code which, when executed in a computer system, implements the bitmap value set forth in claim 22.

36. A method employed in a database system of making a bitmap value that represents a first set of objects external to the database system,

the method comprising the steps performed in the database system of:

mapping the objects onto a second ordered set of identifiers defined in the database management system;

mapping a bitstring that is represented in the bitmap value onto a subset of the second set that includes the identifiers onto which the objects have been mapped; and

setting the bits in the bitstring that correspond to the identifiers onto which the objects have been mapped.

37. The method set forth in claim 36 wherein:

in the step of mapping the objects, the identifiers in the second set are identical with identifiers that are employed externally to the database system to identify the objects.

38. The method set forth in claim 37 wherein:

in the second set, the identifiers are electronic product codes.

39. The method set forth in claim 36 wherein the step of mapping a bitstring comprises the steps of:

making a range specifier that specifies a range of the ordered set of identifiers that includes the identifiers into which the objects have been mapped; and

mapping the bits in the bitstring to the specified range.

40. The method set forth in claim 39 wherein the step of making a range specifier includes the step of:

making a start value and an end value which together specify the range.

41. The method set forth in claim 39 wherein the step of making a range specifier includes the step of

making a prefix value which specifies the range.

42. The method set forth in claim 36 further comprising the step of:

compressing the bitstring.

43. A data storage device, the data storage device being characterized in that:

the data storage device contains code which, when executed in a computer system, implements the method set forth in claim 36.

44. A bitmap value employed in a database management system to represent a first subset of the row identifiers defined in the database management system,

the bitmap value comprising:

a mapping specifier that maps a string of bits to a second subset of the set of row identifiers; and

a representation of the string of bits wherein a bit is set in the represented string of bits when the member of the second subset that is mapped to the bit corresponds to a member of the first subset; and

the first subset is returned by a user-defined query executed by the database management system

45. The bitmap value set forth in claim 44 wherein:

the database management system dynamically alters the mapping specifier and the representation of the string of bits as required to map the representation of the string of bits to a second subset of the row identifiers that includes the first subset of the row identifiers.

46. The bitmap value set forth in claim 44 wherein:

the query returns a row identifier when a field in the row identified by the row identifier has an attribute specified in the query,

whereby the bitmap value represents the set of fields whose values have the specified attribute.

47. A data storage device, the data storage device being characterized in that:

the data storage device contains code which, when executed in a computer system, implements the method set forth in claim 44.

48. A method of reducing the size of a list of electronic product codes,

the method comprising the steps of:

making a bitmap value that includes a range specifier and a bitstring representation, the range specifier specifying a range of the electronic product codes that includes one or more electronic product codes on the list and the bitstring representation representing a bitstring that is mapped onto the specified range and

setting a bit in the bitstring representation when the bit corresponds to an included electronic product code.

49. The method set forth in claim 48 further comprising the step of:

compressing the bitstring representation.

50. The method set forth in claim 48 wherein:

the range specifier includes a prefix that is shared by the one or more electronic product codes.

51. A data storage device, the data storage device being characterized in that:

the data storage device contains code which, when executed in a computer system, implements the method set forth in claim 48.

52. A representation of a set of electronic product codes for use in a digital system that transfers or processes electronic product codes,

the representation comprising:

a range specifier that specifies a range of electronic product codes that includes the members of the set; and

a bitstring representation that represents a bitstring whose bits have been mapped onto the range specified by the range specifier, a bit being set in the represented bit string when the bit corresponds to a member of the set.

53. The representation of the set of electronic product codes set forth in claim 52 wherein:

the range specifier includes a prefix which is shared by the members of the set.

54. The representation of the set of electronic product codes set forth in claim 52 wherein:

the bitstring representation is a compressed representation of the bitstring.

55. A data storage device, the data storage device being characterized in that:

the data storage device contains code which, when executed in a computer system, implements the representation of the set of electronic product codes set forth in claim 52.

56. A method of indexing a set of objects contained in fields of an object column of a first table in a database management system, the indexing being done according to attributes that apply to the objects and

the method comprising the steps of:

constructing a second table in the database management system, the second table having columns including

an attribute specifier column whose fields specify attributes according to which the indexing is being done and

a bitmap column whose fields contain bitmap values including bit string representations representing bit strings that are mapped onto row identifiers identifying rows of the first table; and

for each row of the second table,

using the attribute specified in the row to query the first table to determine row identifiers of rows of the first table whose object column fields satisfy the attribute specified in the row and

in the row'"'"'s bitmap value, setting the bits corresponding to the determined row identifiers in the bitstring represented by the bitmap value'"'"'s bitstring representation.

57. A data storage device, the data storage device being characterized in that:

the data storage device contains code which, when executed in a computer system, implements the method set forth in claim 56.