Guest User

Untitled

a guest
Jul 7th, 2015
374
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.81 KB | None | 0 0
  1. Consider a series of disjoint sets which map a label to one or more GCIs. Each GCI begins as a singleton.
  2.  
  3. {05A06F01}
  4. {05A9291B}
  5. {05B4EC32}
  6. {05A0C703}
  7.  
  8. You already have the functionality to union additional GCIs under their PLMN and eNB ID (which becomes the set parent).
  9.  
  10. {310120, 05A06F, {05A06F01, 05A06F02, 05A06F03}}
  11. {310120, 05A929, {05A92919, 05A9291A, 05A9291B}}
  12. {310120, 05B4EC, {05B4EC31, 05B4EC32, 05B4EC33}}
  13. {310120, 05A0C7, {05A0C701, 05A0C702, 05A0C703}}
  14.  
  15. Consider instead allowing an arbitrary label to be assigned to any set.
  16.  
  17. {"NL03XC042", {05A06F01, 05A06F02, 05A06F03}}
  18. {310120, 05A929, {05A92919, 05A9291A, 05A9291B}}
  19. {310120, 05B4EC, {05B4EC31, 05B4EC32, 05B4EC33}}
  20. {"NL13XC116", {05A0C701, 05A0C702, 05A0C703}}
  21.  
  22. You would still represent the sets internally by some serial ID number, but it would be transparent to the user.
  23.  
  24. sitedb=# select id, parent, label, plmn, band, sector, gci, pci, tac from sitelog order by parent, label nulls last, sector, band;
  25. id | parent | label | plmn | band | sector | gci | pci | tac
  26. ----+--------+---------------+--------+------+--------+----------+-----+-------
  27. 1 | 1 | NL03XC042 | | | | | |
  28. 2 | 1 | | 310120 | 25 | 1 | 05A06F01 | 126 | 11524
  29. 3 | 1 | | 310120 | 25 | 2 | 05A06F02 | 295 | 11524
  30. 4 | 1 | | 310120 | 25 | 3 | 05A06F03 | 464 | 11524
  31. 5 | 5 | 310120_05A929 | | | | | |
  32. 6 | 5 | | 310120 | 26 | 1 | 05A92919 | 126 | 11574
  33. 7 | 5 | | 310120 | 26 | 2 | 05A9291A | 295 | 11574
  34. 8 | 5 | | 310120 | 26 | 3 | 05A9291B | 464 | 11574
  35. 9 | 9 | 310120_05B4BF | | | | | |
  36. 10 | 9 | | 310120 | 41 | 1 | 05B4BF31 | 9 | 11524
  37. 11 | 9 | | 310120 | 41 | 2 | 05B4BF32 | 10 | 11524
  38. 12 | 9 | | 310120 | 41 | 3 | 05B4BF33 | 11 | 11524
  39. 13 | 13 | NL13XC116 | | | | | |
  40. 14 | 13 | | 310120 | 25 | 1 | 05A0C701 | 108 | 11524
  41. 15 | 13 | | 310120 | 25 | 2 | 05A0C702 | 277 | 11524
  42. 16 | 13 | | 310120 | 25 | 3 | 05A0C703 | 446 | 11524
  43. (16 rows)
  44.  
  45. The user would then have the ability to union disjoint sets under a common parent and set its label accordingly.
  46.  
  47. sitedb=# select id, parent, label, plmn, band, sector, gci, pci, tac from sitelog order by parent, label nulls last, sector, band;
  48. id | parent | label | plmn | band | sector | gci | pci | tac
  49. ----+--------+-----------+--------+------+--------+----------+-----+-------
  50. 1 | 1 | NL03XC042 | | | | | |
  51. 2 | 1 | | 310120 | 25 | 1 | 05A06F01 | 126 | 11524
  52. 6 | 1 | | 310120 | 26 | 1 | 05A92919 | 126 | 11574
  53. 10 | 1 | | 310120 | 41 | 1 | 05B4BF31 | 9 | 11524
  54. 3 | 1 | | 310120 | 25 | 2 | 05A06F02 | 295 | 11524
  55. 7 | 1 | | 310120 | 26 | 2 | 05A9291A | 295 | 11574
  56. 11 | 1 | | 310120 | 41 | 2 | 05B4BF32 | 10 | 11524
  57. 4 | 1 | | 310120 | 25 | 3 | 05A06F03 | 464 | 11524
  58. 8 | 1 | | 310120 | 26 | 3 | 05A9291B | 464 | 11574
  59. 12 | 1 | | 310120 | 41 | 3 | 05B4BF33 | 11 | 11524
  60. 13 | 13 | NL13XC116 | | | | | |
  61. 14 | 13 | | 310120 | 25 | 1 | 05A0C701 | 108 | 11524
  62. 15 | 13 | | 310120 | 25 | 2 | 05A0C702 | 277 | 11524
  63. 16 | 13 | | 310120 | 25 | 3 | 05A0C703 | 446 | 11524
  64. (14 rows)
Advertisement
Add Comment
Please, Sign In to add comment