API tools faq
paste
Guest User

Промт для теста text-to-SQL 1 (gaming_5)

a guest
Jul 5th, 2025
302
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 58.70 KB | None | 0 0
raw download clone embed print report
  1. <НАЗВАНИЕ ТЕСТА>gaming_5</НАЗВАНИЕ ТЕСТА>
  2. <ЗАДАНИЕ ДЛЯ НЕЙРОСЕТИ>Нужно преобразовать запрос в свободной форме (тег «ИСХОДНЫЙ ТЕКСТОВЫЙ ЗАПРОС НА АНГЛИЙСКОМ») в SQL-запрос, воспользовавшись схемой базы данных (тег «СХЕМА БАЗЫ ДАННЫХ») и словарём знаний (тег «СЛОВАРЬ ЗНАНИЙ, СВЯЗАННЫЙ С БАЗОЙ ДАННЫХ»). При наличии комментариев и пояснений пишите их на русском языке.</ЗАДАНИЕ ДЛЯ НЕЙРОСЕТИ>
  3. <ИСХОДНЫЙ ТЕКСТОВЫЙ ЗАПРОС НА АНГЛИЙСКОМ>List all audio devices with an Audio Quality Index above 8.0. Include each device’s AQI value (rounded to 2 decimal places). Sort the results from highest to lowest AQI.</ИСХОДНЫЙ ТЕКСТОВЫЙ ЗАПРОС НА АНГЛИЙСКОМ>
  4. <ПЕРЕВОД ИСХОДНОГО ТЕКСТОВОГО ЗАПРОСА НА РУССКИЙ (ДЛЯ ИНФОРМАЦИИ)>Перечислите все аудиоустройства с индексом аудиокачества (AQI) выше 8.0. Включите AQI (округлён до 2 десятичных знаков) и отсортируйте по убыванию.</ПЕРЕВОД ИСХОДНОГО ТЕКСТОВОГО ЗАПРОСА НА РУССКИЙ (ДЛЯ ИНФОРМАЦИИ)>
  5. <СХЕМА БАЗЫ ДАННЫХ>
  6. CREATE TABLE "testsessions" (
  7. sessionregistry character varying NOT NULL, /* A VARCHAR(20) primary key uniquely identifying each test session record. */
  8. stampmoment timestamp without time zone NOT NULL, /* A TIMESTAMP(6) capturing the exact date/time when the session was recorded. */
  9. devscope USER-DEFINED NULL, /* An enum (DevScope_enum) indicating the tested device category (e.g., Keyboard, Headset, Gamepad, Mouse, Controller). */
  10. cpuusepct numeric NULL, /* A NUMERIC(5,2) showing CPU usage percentage during the test session. */
  11. memusemb integer NULL, /* An INTEGER specifying memory usage in megabytes at the time of the test. */
  12. driverstatus USER-DEFINED NULL, /* An enum (DriverStability_enum) describing driver stability status (Stable, Beta, or Experimental). */
  13. fwupdur smallint NULL, /* A SMALLINT indicating how many seconds/minutes it takes to complete a firmware update. */
  14. wlsignal numeric NULL, /* A NUMERIC(5,2) representing wireless signal strength (e.g., in dBm or relative scale). */
  15. battlevel smallint NULL, /* A SMALLINT showing current battery percentage (0–100). */
  16. battcapmah integer NULL, /* An INTEGER specifying battery capacity in milliamp-hours (mAh). */
  17. battlifeh numeric NULL, /* A NUMERIC(4,1) for the device’s remaining or estimated battery life in hours. */
  18. chgtimemin numeric NULL, /* A NUMERIC(5,2) indicating the number of minutes required for a full battery charge. */
  19. qchgflag boolean NULL, /* A BOOLEAN (true/false) stating whether quick charge is supported by the device. */
  20. usbpwrline character varying NULL, /* A VARCHAR(25) field describing the USB power delivery or specification (e.g., 7.5W, 5W, 10W). */
  21. latms numeric NULL, /* A NUMERIC(5,2) measuring overall latency in milliseconds from user input to system response. */
  22. inplagms numeric NULL, /* A NUMERIC(5,2) capturing input lag (in ms) between the device and the system. */
  23. pollratehz smallint NULL, /* A SMALLINT describing the device's polling rate in Hertz (times per second). */
  24. dbtimems numeric NULL, /* A NUMERIC(4,2) specifying the debounce time (in ms) for mechanical or electrical inputs. */
  25. resptimems numeric NULL, /* A NUMERIC(4,2) indicating the device’s response time (in ms) after input is detected. */
  26. clkregms numeric NULL, /* A NUMERIC(4,3) measuring how many milliseconds it takes for a click/button press to register. */
  27. PRIMARY KEY (sessionregistry)
  28. );
  29.  
  30. First 3 rows:
  31. sessionregistry stampmoment devscope cpuusepct memusemb driverstatus fwupdur wlsignal battlevel battcapmah battlifeh chgtimemin qchgflag usbpwrline latms inplagms pollratehz dbtimems resptimems clkregms
  32. ----------------- -------------------------- ---------- ----------- ---------- -------------- --------- ---------- ----------- ------------ ----------- ------------ ---------- ------------ ------- ---------- ------------ ---------- ------------ ----------
  33. GPT287164 2024-09-26 17:36:53.795502 Keyboard 3.14 78 Stable 202 -67 33 1939 38 150 True 7.5W 3.35 9.94 1000 2.28 2.53 0.827
  34. GPT831546 2024-11-26 19:47:28.795502 Headset 4.15 27 Beta 93 80.62 9 1115 54 64 True 5W 12.61 5.98 125 9.11 1.39 1.138
  35. GPT573068 2024-10-12 10:19:04.795502 Keyboard 4.04 81 Experimental 79 71.61 17 1026 84 76 False 10W 5.24 1.15 1000 0.14 3.59 1.656
  36. ...
  37.  
  38.  
  39. CREATE TABLE "interactionandcontrol" (
  40. interactregistry character varying NOT NULL, /* A VARCHAR(20) primary key uniquely identifying each interaction/control record. */
  41. interactphysref character varying NOT NULL, /* A VARCHAR(20) foreign key referencing PhysicalDurability(PhysRegistry), linking control features to the physical build. */
  42. interactdevref character varying NOT NULL, /* A VARCHAR(20) foreign key referencing DeviceIdentity(DevRegistry), connecting input/interactivity data to a specific device. */
  43. amblight boolean NULL, /* A BOOLEAN showing whether ambient light sensors are present and used for adaptive brightness. */
  44. tempsense boolean NULL, /* A BOOLEAN indicating if the device has a temperature sensor to track environmental or internal heat. */
  45. accelsense boolean NULL, /* A BOOLEAN stating if accelerometers are included for motion detection. */
  46. gyrosense boolean NULL, /* A BOOLEAN indicating the presence of gyroscopes for orientation or tilt detection. */
  47. hapfeed character varying NULL, /* A VARCHAR(30) describing the haptic feedback system (e.g., Basic, Advanced). */
  48. hapstr smallint NULL, /* A SMALLINT representing the maximum intensity or strength of the haptic feedback. */
  49. vibmodes smallint NULL, /* A SMALLINT counting how many vibration patterns or modes are available. */
  50. forcefeed character varying NULL, /* A VARCHAR(35) naming the force feedback type or system (e.g., Advanced, Basic). */
  51. trigres smallint NULL, /* A SMALLINT for trigger resistance levels or steps (on controllers with adaptive triggers). */
  52. trigtravmm numeric NULL, /* A NUMERIC(3,1) describing trigger travel distance in millimeters. */
  53. joydead numeric NULL, /* A NUMERIC(4,2) specifying the joystick dead zone (as a ratio or percentage). */
  54. joyprec numeric NULL, /* A NUMERIC(4,1) measuring joystick precision or resolution (e.g., in a scale from 0-100). */
  55. btnspcmm numeric NULL, /* A NUMERIC(4,1) indicating spacing (in mm) between buttons (e.g., on a controller face). */
  56. btnszmm numeric NULL, /* A NUMERIC(4,1) describing the physical size (in mm) of face buttons or triggers. */
  57. dpadvar character varying NULL, /* A VARCHAR(30) naming the D-pad style/type (e.g., Hybrid, Standard, Floating). */
  58. dpadacc numeric NULL, /* A NUMERIC(4,1) measuring D-pad accuracy on a scale or in a test metric. */
  59. astickvar character varying NULL, /* A VARCHAR(30) describing the analog stick construction/type (e.g., Standard, Magnetic, Hall Effect). */
  60. driftres numeric NULL, /* A NUMERIC(4,1) reflecting drift resistance or detection in the analog stick, measured on a scale or percentage. */
  61. PRIMARY KEY (interactregistry),
  62. FOREIGN KEY (interactdevref) REFERENCES deviceidentity(devregistry),
  63. FOREIGN KEY (interactphysref) REFERENCES physicaldurability(physregistry)
  64. );
  65.  
  66. First 3 rows:
  67. interactregistry interactphysref interactdevref amblight tempsense accelsense gyrosense hapfeed hapstr vibmodes forcefeed trigres trigtravmm joydead joyprec btnspcmm btnszmm dpadvar dpadacc astickvar driftres
  68. ------------------ ----------------- ---------------- ---------- ----------- ------------ ----------- --------- -------- ---------- ----------- --------- ------------ --------- --------- ---------- --------- --------- --------- ----------- ----------
  69. INT_X42CX3 PHYS_GHOT80 DEV_RQ33OK True True False True Basic 4 5 Advanced 7 7.1 0.11 94.9 4.8 17.5 Hybrid 95.2 Standard 98.5
  70. INT_UHLDYQ PHYS_3F7AUT DEV_UPPRRQ False True False False Advanced 4 4 None 10 7.2 0.19 94.4 2.5 16.7 Standard 99.9 Standard 98.9
  71. INT_HTXID6 PHYS_2Q0KFG DEV_E2VRHA True False True True None 1 4 None 10 6.6 0.13 93.9 3.1 18.4 Standard 92.3 Magnetic 93.9
  72. ...
  73.  
  74.  
  75. CREATE TABLE "performance" (
  76. perfregistry character varying NOT NULL, /* A VARCHAR(20) primary key uniquely identifying each performance record. */
  77. perfsessionref character varying NOT NULL, /* A VARCHAR(20) foreign key referencing TestSessions(SessionRegistry) to link performance metrics to a specific session. */
  78. accelmax smallint NULL, /* A SMALLINT indicating the maximum acceleration (in G or m/s²) the device sensor can handle. */
  79. speedips smallint NULL, /* A SMALLINT for maximum tracking speed in inches per second (IPS) for pointing devices. */
  80. liftdistmm numeric NULL, /* A NUMERIC(3,1) describing the lift-off distance in millimeters, often relevant for mouse sensors. */
  81. angsnap boolean NULL, /* A BOOLEAN stating whether angle snapping (prediction or correction) is enabled. */
  82. btntens USER-DEFINED NULL, /* An enum (BtnTens_enum) describing button tension (Light, Medium, or Heavy). */
  83. clklat numeric NULL, /* A NUMERIC(3,2) measuring click latency (in ms) from actuation to system registration. */
  84. clkdur bigint NULL, /* A BIGINT noting the rated click durability (e.g., number of clicks before failure). */
  85. screnctyp USER-DEFINED NULL, /* An enum (ScrollEncoder_enum) for the scroll wheel mechanism type (Mechanical, Optical, Magnetic). */
  86. scrsteps smallint NULL, /* A SMALLINT for how many discrete 'clicks' or steps a full scroll wheel rotation has. */
  87. scraccy numeric NULL, /* A NUMERIC(4,1) reflecting the scroll wheel’s accuracy or consistency (on a relative scale). */
  88. PRIMARY KEY (perfregistry),
  89. FOREIGN KEY (perfsessionref) REFERENCES testsessions(sessionregistry)
  90. );
  91.  
  92. First 3 rows:
  93. perfregistry perfsessionref accelmax speedips liftdistmm angsnap btntens clklat clkdur screnctyp scrsteps scraccy
  94. -------------- ---------------- ---------- ---------- ------------ --------- --------- -------- -------- ----------- ---------- ---------
  95. PERF_F82J4K GPT287164 36 360 0.8 False Light 0.49 52679106 Optical 20 91.8
  96. PERF_UFXS4T GPT831546 32 396 1.6 False Medium 1.83 36886488 Optical 23 96.8
  97. PERF_3PQ3KQ GPT573068 38 273 1.2 False Light 0.51 32306990 Optical 20 90.2
  98. ...
  99.  
  100.  
  101. CREATE TABLE "deviceidentity" (
  102. devregistry character varying NOT NULL, /* A VARCHAR(20) primary key uniquely identifying the device identity record. */
  103. devsessionref character varying NOT NULL, /* A VARCHAR(20) foreign key referencing TestSessions(SessionRegistry), linking the device to its test session. */
  104. makername character varying NULL, /* A VARCHAR(50) naming the manufacturer or brand of the device. */
  105. modnum character varying NULL, /* A VARCHAR(50) specifying the model name or number of the device. */
  106. fwver character varying NULL, /* A VARCHAR(50) denoting the firmware version running on the device. */
  107. conntype character varying NULL, /* A VARCHAR(35) indicating how the device connects (e.g., Wireless 2.4GHz, Wired, Bluetooth, Hybrid). */
  108. wlrangem numeric NULL, /* A NUMERIC(4,1) measuring the device’s wireless range in meters (if applicable). */
  109. wlinterf character varying NULL, /* A VARCHAR(35) describing interference or constraints on the wireless connection (e.g., Low, High, Medium). */
  110. wlchanhop boolean NULL, /* A BOOLEAN stating if the device automatically hops channels to avoid interference. */
  111. wllatvar numeric NULL, /* A NUMERIC(4,2) capturing variation in wireless latency (e.g., standard deviation). */
  112. pwridlemw integer NULL, /* An INTEGER specifying power consumption (in mW) when the device is idle. */
  113. pwractmw integer NULL, /* An INTEGER indicating power consumption (in mW) under active usage. */
  114. pwrrgbmw integer NULL, /* An INTEGER showing additional power draw (in mW) attributed to any RGB lighting. */
  115. brdmemmb smallint NULL, /* A SMALLINT for onboard memory size (in MB) for storing profiles/macros. */
  116. profcount smallint NULL, /* A SMALLINT specifying how many user profiles can be stored on the device. */
  117. mcresptime numeric NULL, /* A NUMERIC(4,2) measuring the microcontroller’s response time (in ms) to inputs. */
  118. mcexecspeed numeric NULL, /* A NUMERIC(4,2) describing microcontroller execution speed or frequency (possibly in MHz). */
  119. mctimacc numeric NULL, /* A NUMERIC(5,2) representing microcontroller timing accuracy (in percent or a relevant unit). */
  120. dpires integer NULL, /* An INTEGER for the sensor’s primary DPI resolution. */
  121. dpisteps smallint NULL, /* A SMALLINT listing how many DPI step increments the device supports. */
  122. senstype character varying NULL, /* A VARCHAR(50) describing the sensor type (e.g., PMW3389, Optical, Laser, PAW3399). */
  123. sensres integer NULL, /* An INTEGER indicating a secondary sensor resolution or specification (if distinct from DPI). */
  124. PRIMARY KEY (devregistry),
  125. FOREIGN KEY (devsessionref) REFERENCES testsessions(sessionregistry)
  126. );
  127.  
  128. First 3 rows:
  129. devregistry devsessionref makername modnum fwver conntype wlrangem wlinterf wlchanhop wllatvar pwridlemw pwractmw pwrrgbmw brdmemmb profcount mcresptime mcexecspeed mctimacc dpires dpisteps senstype sensres
  130. ------------- --------------- ----------- -------- ------- --------------- ---------- ---------- ----------- ---------- ----------- ---------- ---------- ---------- ----------- ------------ ------------- ---------- -------- ---------- ---------- ---------
  131. DEV_RQ33OK GPT287164 HyperX MDL7333 6.6.9 Wireless 2.4GHz 8 Low False 1.3 90 143 113 8 2 1.51 0.24 92.7 9774 4 PMW3389 22986
  132. DEV_UPPRRQ GPT831546 Corsair MDL8501 5.3.7 Wired 6 Low False 1.45 21 335 149 64 4 2.32 0.36 92.8 24096 1 Optical 16401
  133. DEV_E2VRHA GPT573068 Logitech MDL8929 7.0.3 Bluetooth 16 High False 1.96 45 345 136 8 3 4.63 0.63 96.8 5125 1 Optical 20417
  134. ...
  135.  
  136.  
  137. CREATE TABLE "mechanical" (
  138. mechregistry character varying NOT NULL, /* A VARCHAR(20) primary key uniquely identifying the mechanical properties record. */
  139. mechperfref character varying NOT NULL, /* A VARCHAR(20) foreign key referencing Performance(PerfRegistry), linking mechanical specs to performance metrics. */
  140. mechdevref character varying NOT NULL, /* A VARCHAR(20) foreign key referencing DeviceIdentity(DevRegistry), associating mechanical data with a specific device. */
  141. keyforceg numeric NULL, /* A NUMERIC(5,2) describing actuation force (in grams) for keys or switches. */
  142. keytravmm numeric NULL, /* A NUMERIC(3,1) showing total travel distance (in mm) for keys or buttons. */
  143. swtchvar character varying NULL, /* A VARCHAR(40) naming the specific switch variant (e.g., Membrane, Mechanical, Optical, Magnetic). */
  144. swtchdur bigint NULL, /* A BIGINT indicating the rated switch durability (e.g., total actuations). */
  145. ghostkeys smallint NULL, /* A SMALLINT counting how many keys might exhibit ‘ghosting’ if pressed simultaneously. */
  146. keyrollo character varying NULL, /* A VARCHAR(35) describing the rollover spec (e.g., 2KRO, 6KRO, NKRO). */
  147. swtchcons numeric NULL, /* A NUMERIC(4,1) measuring the consistency in switch actuation force or performance. */
  148. ghosteff numeric NULL, /* A NUMERIC(4,1) quantifying the effective impact of ghosting (on a scale or percentage). */
  149. keychatter numeric NULL, /* A NUMERIC(3,2) indicating key chatter or bounce (in ms or a relative measure). */
  150. actpointmm numeric NULL, /* A NUMERIC(3,1) showing at what point (in mm) the key actuates from the top of its travel. */
  151. respointmm numeric NULL, /* A NUMERIC(3,1) specifying the reset point (in mm) where the switch deactivates on release. */
  152. tacbumpmm numeric NULL, /* A NUMERIC(3,1) measuring the tactile bump position (in mm) in a tactile switch. */
  153. tottravmm numeric NULL, /* A NUMERIC(3,1) for the total travel distance (in mm) if fully bottomed out. */
  154. stabrattle USER-DEFINED NULL, /* An enum (StabRattle_enum) indicating stabilizer rattle level (None, Minimal, Moderate). */
  155. stabtype character varying NULL, /* A VARCHAR(30) naming the stabilizer type (e.g., PCB Mount, Screw-in, Plate Mount). */
  156. capthkmm numeric NULL, /* A NUMERIC(3,1) for the keycap thickness (in mm). */
  157. capmat character varying NULL, /* A VARCHAR(35) specifying the keycap material (ABS, PBT, etc.). */
  158. caplegmeth character varying NULL, /* A VARCHAR(40) describing how the legends are applied (e.g., Double Shot, Dye Sub, Laser Etched). */
  159. kbdangle smallint NULL, /* A SMALLINT indicating the built-in keyboard angle or tilt (in degrees). */
  160. wristflag boolean NULL, /* A BOOLEAN stating whether a wrist rest is integrated or included. */
  161. palmangle smallint NULL, /* A SMALLINT measuring the palm rest angle (in degrees), if applicable. */
  162. ergorate smallint NULL, /* A SMALLINT providing an ergonomic rating (on a defined scale). */
  163. PRIMARY KEY (mechregistry),
  164. FOREIGN KEY (mechdevref) REFERENCES deviceidentity(devregistry),
  165. FOREIGN KEY (mechperfref) REFERENCES performance(perfregistry)
  166. );
  167.  
  168. First 3 rows:
  169. mechregistry mechperfref mechdevref keyforceg keytravmm swtchvar swtchdur ghostkeys keyrollo swtchcons ghosteff keychatter actpointmm respointmm tacbumpmm tottravmm stabrattle stabtype capthkmm capmat caplegmeth kbdangle wristflag palmangle ergorate
  170. -------------- ------------- ------------ ----------- ----------- ---------- ---------- ----------- ---------- ----------- ---------- ------------ ------------ ------------ ----------- ----------- ------------ ---------- ---------- -------- ------------ ---------- ----------- ----------- ----------
  171. MECH_JOL75L PERF_F82J4K DEV_RQ33OK 75.8 3.3 Membrane 74090272 65 2KRO 97 95.2 1.72 1.4 2.4 1.9 3.4 Minimal PCB Mount 1.4 ABS Double Shot 1 True 0 6
  172. MECH_0WBA9L PERF_UFXS4T DEV_UPPRRQ 79.9 2.4 Mechanical 27318594 68 6KRO 99.3 95.2 1.17 2.4 1.4 1.6 3.7 Minimal PCB Mount 1.4 ABS Dye Sub 1 False 15 9
  173. MECH_Q9PD87 PERF_3PQ3KQ DEV_E2VRHA 79.3 1.9 Mechanical 76894521 102 6KRO 92.6 94.8 0.85 1.6 1.5 2.3 4 Minimal Screw-in 1 ABS Double Shot 1 False 8 8
  174. ...
  175.  
  176.  
  177. CREATE TABLE "audioandmedia" (
  178. audregistry character varying NOT NULL, /* A VARCHAR(20) primary key uniquely identifying the audio/media properties record. */
  179. auddevref character varying NOT NULL, /* A VARCHAR(20) foreign key referencing DeviceIdentity(DevRegistry), linking these audio/media specs to a device. */
  180. audperfref character varying NOT NULL, /* A VARCHAR(20) foreign key referencing Performance(PerfRegistry), associating audio/media data with performance metrics. */
  181. sndleveldb numeric NULL, /* A NUMERIC(4,1) measuring sound output level in decibels from the device. */
  182. sndsig character varying NULL, /* A VARCHAR(30) describing the sound signature (e.g., Silent, Thocky, Clicky, Linear). */
  183. noiseisodb smallint NULL, /* A SMALLINT for how many dB of noise isolation the device provides. */
  184. audlatms numeric NULL, /* A NUMERIC(4,1) capturing audio latency (in ms) from signal to output. */
  185. micsensedb numeric NULL, /* A NUMERIC(5,2) measuring microphone sensitivity in dB (e.g., dBV). */
  186. micfreqresp character varying NULL, /* A VARCHAR(50) specifying the microphone frequency response range (e.g., 20Hz–20kHz). */
  187. spkimpohm smallint NULL, /* A SMALLINT indicating the speaker or driver impedance in ohms. */
  188. spksensedb smallint NULL, /* A SMALLINT specifying speaker sensitivity in decibels (dB SPL @ 1kHz). */
  189. thdpct numeric NULL, /* A NUMERIC(3,2) for total harmonic distortion (THD) as a percentage. */
  190. freqresp character varying NULL, /* A VARCHAR(50) describing the device’s frequency response specification (e.g., 20Hz–20kHz). */
  191. drvszmm smallint NULL, /* A SMALLINT measuring the diameter (in mm) of the speaker or audio driver. */
  192. surrsnd character varying NULL, /* A VARCHAR(30) naming any surround sound technology (e.g., Stereo, 5.1, 7.1). */
  193. eqcount smallint NULL, /* A SMALLINT counting available EQ profiles or presets. */
  194. micmon boolean NULL, /* A BOOLEAN indicating if mic monitoring (sidetone) is supported. */
  195. noisecanc USER-DEFINED NULL, /* An enum (NoiseCanc_enum) denoting the noise cancellation type (None, Passive, Active). */
  196. btversion character varying NULL, /* A VARCHAR(35) referencing Bluetooth version (e.g., 4.0, 5.0, 5.1, 5.2) if applicable. */
  197. btrangem smallint NULL, /* A SMALLINT specifying typical Bluetooth range in meters. */
  198. btlatms numeric NULL, /* A NUMERIC(5,2) measuring Bluetooth audio latency (in ms). */
  199. multidev boolean NULL, /* A BOOLEAN stating whether the device can connect to multiple endpoints simultaneously. */
  200. autoslpmin smallint NULL, /* A SMALLINT specifying how many minutes pass before the device goes into auto-sleep mode. */
  201. wakems numeric NULL, /* A NUMERIC(5,1) representing how many milliseconds it takes for the device to wake from sleep. */
  202. PRIMARY KEY (audregistry),
  203. FOREIGN KEY (auddevref) REFERENCES deviceidentity(devregistry),
  204. FOREIGN KEY (audperfref) REFERENCES performance(perfregistry)
  205. );
  206.  
  207. First 3 rows:
  208. audregistry auddevref audperfref sndleveldb sndsig noiseisodb audlatms micsensedb micfreqresp spkimpohm spksensedb thdpct freqresp drvszmm surrsnd eqcount micmon noisecanc btversion btrangem btlatms multidev autoslpmin wakems
  209. ------------- ----------- ------------ ------------ -------- ------------ ---------- ------------ ------------- ----------- ------------ -------- ---------- --------- --------- --------- -------- ----------- ----------- ---------- --------- ---------- ------------ --------
  210. AUD_62KLBY DEV_RQ33OK PERF_F82J4K 54.4 Silent 26 15 -34 87-14667Hz 16 108 1.82 17-22680Hz 53 Stereo 9 False Passive 4 21 217.7 True 6 771.6
  211. AUD_HN6IA9 DEV_UPPRRQ PERF_UFXS4T 37.2 Silent 21 3.1 -42 38-19153Hz 64 108 1.11 18-28862Hz 50 5.1 6 False Active 5 25 147 False 11 979.7
  212. AUD_QYXW48 DEV_E2VRHA PERF_3PQ3KQ 63.6 Thocky 15 11.5 -38 42-10348Hz 16 99 0.81 19-20571Hz 53 7.1 4 False Active 5.1 19 200.2 False 9 373.9
  213. ...
  214.  
  215.  
  216. CREATE TABLE "rgb" (
  217. rgbregistry character varying NOT NULL, /* A VARCHAR(20) primary key uniquely identifying each RGB lighting record. */
  218. rgbmechref character varying NOT NULL, /* A VARCHAR(20) foreign key referencing Mechanical(MechRegistry), associating RGB details with a mechanical record (e.g., a keyboard). */
  219. rgbaudref character varying NOT NULL, /* A VARCHAR(20) foreign key referencing AudioAndMedia(AudRegistry), linking RGB details to audio/media data if necessary. */
  220. rgbbright smallint NULL, /* A SMALLINT indicating the RGB brightness level (on a predefined scale or percentage). */
  221. rgbcoloracc numeric NULL, /* A NUMERIC(4,1) measuring color accuracy or uniformity (e.g., Delta E or similar scale). */
  222. rgbrfrate smallint NULL, /* A SMALLINT specifying the refresh rate (in Hz) at which the RGB lighting updates. */
  223. rgbmodes character varying NULL, /* A VARCHAR(25) naming the different RGB lighting modes (e.g., 'Wave', 'Static', 'Breathing'). */
  224. rgbzones smallint NULL, /* A SMALLINT counting how many independent zones or sections of RGB control the device has. */
  225. rgbcolors integer NULL, /* An INTEGER for the total number of distinct colors supported (e.g., 16.8 million). */
  226. PRIMARY KEY (rgbregistry),
  227. FOREIGN KEY (rgbaudref) REFERENCES audioandmedia(audregistry),
  228. FOREIGN KEY (rgbmechref) REFERENCES mechanical(mechregistry)
  229. );
  230.  
  231. First 3 rows:
  232. rgbregistry rgbmechref rgbaudref rgbbright rgbcoloracc rgbrfrate rgbmodes rgbzones rgbcolors
  233. ------------- ------------ ----------- ----------- ------------- ----------- ---------- ---------- -----------
  234. RGB_33D8M7 MECH_JOL75L AUD_62KLBY 88 84.3 166 18 1 3461298
  235. RGB_INHK9M MECH_0WBA9L AUD_HN6IA9 12 87.1 847 11 3 3206043
  236. RGB_0P73NA MECH_Q9PD87 AUD_QYXW48 23 97.2 159 14 1 11826339
  237. ...
  238.  
  239.  
  240. CREATE TABLE "physicaldurability" (
  241. physregistry character varying NOT NULL, /* A VARCHAR(20) primary key uniquely identifying each physical durability record. */
  242. physrgbref character varying NOT NULL, /* A VARCHAR(20) foreign key referencing RGB(RgbRegistry), linking durability data to RGB hardware (often in keyboards or mice). */
  243. physperfref character varying NOT NULL, /* A VARCHAR(20) foreign key referencing Performance(PerfRegistry), associating physical durability with overall performance metrics. */
  244. wgtgram smallint NULL, /* A SMALLINT specifying the device’s weight in grams. */
  245. wgtdist character varying NULL, /* A VARCHAR(30) describing weight distribution (e.g., 'Front Heavy', 'Back Heavy', 'Balanced'). */
  246. cablegram smallint NULL, /* A SMALLINT measuring the cable’s weight in grams (if relevant). */
  247. cabledrag character varying NULL, /* A VARCHAR(25) characterizing the cable’s drag or friction level (e.g., 'Moderate', 'Minimal', 'Significant'). */
  248. feetmat character varying NULL, /* A VARCHAR(25) naming the material of the device’s feet/skates (e.g., Glass, Virgin PTFE, PTFE, Ceramic). */
  249. feetthkmm numeric NULL, /* A NUMERIC(3,1) indicating thickness (in mm) of the device’s feet/skates. */
  250. glidecons numeric NULL, /* A NUMERIC(4,1) measuring gliding consistency or friction uniformity (relative scale). */
  251. fricstatic numeric NULL, /* A NUMERIC(3,2) specifying static friction coefficient or rating. */
  252. frickinetic numeric NULL, /* A NUMERIC(3,2) specifying kinetic friction coefficient or rating. */
  253. surfcompat character varying NULL, /* A VARCHAR(25) indicating the recommended or tested surface compatibility (e.g., Cloth Preferred, Hard Pad Preferred, Universal). */
  254. gripsty character varying NULL, /* A VARCHAR(30) describing the handle/grip style (e.g., Palm, Hybrid, Fingertip, Claw). */
  255. gripcoat character varying NULL, /* A VARCHAR(30) naming the grip coating type (must match GripCoat_enum if relevant). */
  256. gripdur smallint NULL, /* A SMALLINT specifying approximate grip durability or rating (e.g., hours or a scale). */
  257. sweatres character varying NULL, /* A VARCHAR(30) detailing sweat resistance or finish claim (e.g., Low, Medium, High). */
  258. tempres USER-DEFINED NULL, /* An enum (TempRes_enum) describing the temperature resistance level (Standard, Premium, Enhanced). */
  259. humidres USER-DEFINED NULL, /* An enum (HumidRes_enum) indicating humidity resistance level (Standard, Premium, Enhanced). */
  260. dustres character varying NULL, /* A VARCHAR(30) referencing dust ingress rating or claim (e.g., IPX1, IPX2, IPX3, IPX0). */
  261. waterres character varying NULL, /* A VARCHAR(35) referencing water ingress protection (e.g., IPX1, IPX3, IPX0, IPX2). */
  262. impres character varying NULL, /* A VARCHAR(30) describing impact resistance (e.g., Standard, Military Grade, Enhanced). */
  263. drophtm numeric NULL, /* A NUMERIC(3,1) measuring the tested or guaranteed drop height in meters. */
  264. bendforce smallint NULL, /* A SMALLINT indicating how much force (in N or a relative scale) is needed for noticeable bending. */
  265. twistdeg smallint NULL, /* A SMALLINT specifying the angle (in degrees) at which twisting becomes significant or detrimental. */
  266. cablebend integer NULL, /* An INTEGER showing the tested cable bend cycles or durability count. */
  267. usbconndur integer NULL, /* An INTEGER representing how many connect-disconnect cycles the USB port can handle before failure. */
  268. PRIMARY KEY (physregistry),
  269. FOREIGN KEY (physperfref) REFERENCES performance(perfregistry),
  270. FOREIGN KEY (physrgbref) REFERENCES rgb(rgbregistry)
  271. );
  272.  
  273. First 3 rows:
  274. physregistry physrgbref physperfref wgtgram wgtdist cablegram cabledrag feetmat feetthkmm glidecons fricstatic frickinetic surfcompat gripsty gripcoat gripdur sweatres tempres humidres dustres waterres impres drophtm bendforce twistdeg cablebend usbconndur
  275. -------------- ------------ ------------- --------- ----------- ----------- ----------- ----------- ----------- ----------- ------------ ------------- ------------------ --------- ---------- --------- ---------- --------- ---------- --------- ---------- -------- --------- ----------- ---------- ----------- ------------
  276. PHYS_GHOT80 RGB_33D8M7 PERF_F82J4K 83 Front Heavy 62 Moderate Glass 1.2 85.4 0.41 0.27 Cloth Preferred Palm Rubberized 17 Low Standard Premium IPX1 IPX1 Standard 1 106 30 4036 2814
  277. PHYS_3F7AUT RGB_INHK9M PERF_UFXS4T 84 Back Heavy 74 Minimal Virgin PTFE 1 91.1 0.48 0.12 Hard Pad Preferred Palm Matte 22 Medium Premium Enhanced IPX2 IPX1 Standard 1.9 350 32 3626 1975
  278. PHYS_2Q0KFG RGB_0P73NA PERF_3PQ3KQ 116 Back Heavy 99 Minimal Virgin PTFE 0.6 90.7 0.44 0.22 Cloth Preferred Hybrid Rubberized 24 Low Enhanced Enhanced IPX3 IPX3 Standard 1.7 346 34 2085 1742
  279. ...
  280. </СХЕМА БАЗЫ ДАННЫХ>
  281. <СЛОВАРЬ ЗНАНИЙ, СВЯЗАННЫЙ С БАЗОЙ ДАННЫХ>
  282. {"id": 0, "knowledge": "Sensor Performance Index (SPI)", "description": "A composite metric that evaluates overall sensor quality based on resolution, accuracy, and response time.", "definition": "SPI = \\frac{DpiRes}{1000} \\times \\left(1 - \\frac{McRespTime}{10}\\right) \\times 10, \\text{ where higher values indicate better overall sensor performance with balanced resolution and responsiveness.}", "type": "calculation_knowledge", "children_knowledge": -1}
  283. {"id": 1, "knowledge": "Battery Efficiency Ratio (BER)", "description": "Measures how efficiently a device uses its battery capacity relative to its power draw under active conditions.", "definition": "BER = \\frac{BattLifeH \\times BattCapMah}{PwrActMw \\times 10}, \\text{ where higher values indicate more efficient power management and battery utilization.}", "type": "calculation_knowledge", "children_knowledge": -1}
  284. {"id": 2, "knowledge": "Input Responsiveness Score (IRS)", "description": "Quantifies the overall input responsiveness of a device considering polling rate, latency, and response time.", "definition": "IRS = \\frac{PollRateHz}{100} \\times \\left(1 - \\frac{InpLagMs + RespTimeMs}{30}\\right) \\times 10, \\text{ where higher values indicate more responsive input with minimal lag.}", "type": "calculation_knowledge", "children_knowledge": -1}
  285. {"id": 3, "knowledge": "Comfort Index (CI)", "description": "Evaluates the ergonomic comfort of a device based on its physical design factors and ergonomic rating.", "definition": "CI = \\frac{ErgoRate}{10} \\times \\left(1 + \\frac{(WristFlag ? 1 : 0)}{5}\\right) \\times \\left(1 - \\frac{|PalmAngle - 15|}{45}\\right) \\times 10", "type": "calculation_knowledge", "children_knowledge": -1}
  286. {"id": 4, "knowledge": "Audio Quality Index (AQI)", "description": "A comprehensive metric for evaluating audio device quality based on frequency response, distortion, and sensitivity.", "definition": "AQI = \\left(1 - \\frac{ThdPct}{2}\\right) \\times \\frac{SpkSenseDb}{100} \\times \\left(1 - \\frac{AudLatMs}{100}\\right) \\times 10, \\text{ where higher values indicate better overall audio quality with minimal distortion.}", "type": "calculation_knowledge", "children_knowledge": -1}
  287. {"id": 5, "knowledge": "Switch Performance Rating (SPR)", "description": "Rates mechanical switch performance based on durability, consistency, and tactile feedback.", "definition": "SPR = \\frac{\\log_{10}(SwtchDur)}{7} \\times SwtchCons \\times \\left(1 - \\frac{KeyChatter}{2}\\right), \\text{ where higher values indicate better switch quality with longer lifespan and consistent performance.}", "type": "calculation_knowledge", "children_knowledge": -1}
  288. {"id": 6, "knowledge": "RGB Implementation Quality (RIQ)", "description": "Evaluates the quality of RGB implementation based on brightness, color accuracy, and lighting zones.", "definition": "RIQ = \\frac{RgbBright}{100} \\times \\frac{RgbColorAcc}{10} \\times \\left(0.5 + \\frac{RgbZones}{20}\\right), \\text{ where higher values indicate premium RGB lighting with accurate colors and extensive customization options.}", "type": "calculation_knowledge", "children_knowledge": -1}
  289. {"id": 7, "knowledge": "Durability Score (DS)", "description": "Quantifies overall device durability based on material quality, environmental resistance, and impact protection.", "definition": "DS = \\left(\\frac{DropHtM}{2} + \\frac{BendForce}{100} + \\frac{TwistDeg}{90}\\right) \\times \\frac{UsbConnDur}{10000} \\times 10, \\text{ where higher values indicate more durable devices capable of withstanding physical stress.}", "type": "calculation_knowledge", "children_knowledge": -1}
  290. {"id": 8, "knowledge": "Wireless Performance Rating (WPR)", "description": "Rates the quality of wireless connectivity based on range, latency, and interference handling.", "definition": "WPR = \\frac{WlRangeM}{10} \\times \\left(1 - \\frac{WlLatVar}{5}\\right) \\times \\left(1 + \\frac{WlChanHop}{2}\\right) \\times \\frac{WlSignal + 100}{100}, \\text{ where higher values indicate more reliable wireless performance with better range and stability.}", "type": "calculation_knowledge", "children_knowledge": -1}
  291. {"id": 9, "knowledge": "Gaming Device Value Index (GDVI)", "description": "A comprehensive metric evaluating overall gaming device value considering performance, durability, and comfort.", "definition": "GDVI = \\left(SPI \\times 0.3\\right) + \\left(IRS \\times 0.3\\right) + \\left(DS \\times 0.2\\right) + \\left(CI \\times 0.2\\right), \\text{ where higher values indicate better overall device quality across multiple dimensions.}", "type": "calculation_knowledge", "children_knowledge": [0, 2, 7, 3]}
  292. {"id": 10, "knowledge": "Premium Gaming Mouse", "description": "Defines the criteria for a high-end gaming mouse based on sensor performance and ergonomics.", "definition": "A mouse with SPI > 7.5, DpiRes ≥ 16000, PollRateHz ≥ 1000, and CI > 8.0, offering exceptional precision and comfort for competitive gaming scenarios.", "type": "domain_knowledge", "children_knowledge": [0, 3]}
  293. {"id": 11, "knowledge": "Tournament-Ready Keyboard", "description": "Defines what constitutes a keyboard suitable for competitive tournament play based on response time and switch quality.", "definition": "A keyboard with IRS > 8.5, ClkLat < 1.0ms, PollRateHz ≥ 1000, and SPR > 8.0, ensuring minimal input latency and consistent actuation during high-pressure competitive scenarios.", "type": "domain_knowledge", "children_knowledge": [2, 5]}
  294. {"id": 12, "knowledge": "Audiophile Gaming Headset", "description": "Defines the standards for premium audio quality in gaming headsets suitable for audiophiles.", "definition": "A headset with AQI > 8.0, FreqResp covering at least '10Hz-22kHz', ThdPct < 0.5%, and NoiseIsoDb > 15, delivering exceptional sound clarity, detail, and isolation for immersive gaming experiences.", "type": "domain_knowledge", "children_knowledge": [4]}
  295. {"id": 13, "knowledge": "Extended Battery Life Device", "description": "Identifies devices with exceptionally efficient battery performance for extended gaming sessions.", "definition": "A device with BER > 7.5, BattLifeH > 30, QChgFlag = true, and PwrIdleMw < 100, enabling marathon gaming sessions with minimal charging interruptions.", "type": "domain_knowledge", "children_knowledge": [1]}
  296. {"id": 14, "knowledge": "Professional Esports Controller", "description": "Defines the quality standards for controllers used in professional esports competitions.", "definition": "A controller with IRS > 8.0, JoyPrec > 9.0, DriftRes > 9.5, TrigRes ≥ 5, and HapStr > 8, offering precise inputs and reliable performance required for competitive play at the highest level.", "type": "domain_knowledge", "children_knowledge": [2]}
  297. {"id": 15, "knowledge": "Streaming-Optimized Device", "description": "Identifies devices specifically designed for content creators and streamers with appropriate features.", "definition": "A device with MicSenseDb < -45, MicFreqResp covering at least '50Hz-18kHz', McRespTime < 1.0, and ProfCount ≥ 5, allowing streamers to capture high-quality audio while maintaining flexible device configurations.", "type": "domain_knowledge", "children_knowledge": -1}
  298. {"id": 16, "knowledge": "Competitive-Grade Durability", "description": "Defines durability standards for devices intended for intensive competitive use.", "definition": "A device with DS > 8.5, UsbConnDur > 15000, DropHtM > 1.5, and GripDur > 1000, designed to withstand the rigors of frequent transport and intensive use during tournament environments.", "type": "domain_knowledge", "children_knowledge": [7]}
  299. {"id": 17, "knowledge": "Minimal Input Latency", "description": "Identifies devices with exceptionally low input latency suitable for reaction-critical games.", "definition": "A device with InpLagMs < 1.0, PollRateHz ≥ 1000, LatMs < 2.0, and ClkLat < 0.8, providing almost instantaneous input recognition critical for competitive FPS and fighting games.", "type": "domain_knowledge", "children_knowledge": -1}
  300. {"id": 18, "knowledge": "Premium Wireless Solution", "description": "Defines high-end wireless gaming devices with performance comparable to wired alternatives.", "definition": "A device with WPR > 9.0, ConnType = 'Wireless 2.4GHz', LatMs < 2.5, and BattLifeH > 24, eliminating common wireless drawbacks while maintaining the convenience of cable-free operation.", "type": "domain_knowledge", "children_knowledge": [8]}
  301. {"id": 19, "knowledge": "Full-Featured Gaming Setup", "description": "Identifies comprehensive gaming setups combining multiple high-quality devices with complementary features.", "definition": "A collection of devices where the average GDVI > 8.5 across at least three different device categories (Mouse, Keyboard, Headset, etc.), providing a complete and cohesive premium gaming experience.", "type": "domain_knowledge", "children_knowledge": [9]}
  302. {"id": 20, "knowledge": "LatMs (Latency)", "description": "Illustrates the significance of latency measurements in gaming peripherals for competitive play.", "definition": "Measured in milliseconds, representing the delay between user input and system response. Values below 1.0ms enable split-second reactions in fast-paced competitive games, while values above 5.0ms can create noticeable input delay that impacts performance in timing-critical scenarios.", "type": "value_illustration", "children_knowledge": -1}
  303. {"id": 21, "knowledge": "PollRateHz (Polling Rate)", "description": "Illustrates the importance of polling rate in gaming device responsiveness.", "definition": "Measured in Hertz (times per second), representing how often the device reports its state to the computer. Values of 125Hz are standard for office peripherals, 500Hz is good for casual gaming, 1000Hz is preferred for competitive play, and 4000Hz+ represents cutting-edge technology offering ultra-responsive input for professional esports.", "type": "value_illustration", "children_knowledge": -1}
  304. {"id": 22, "knowledge": "DpiRes (DPI Resolution)", "description": "Illustrates the impact of DPI resolution settings on mouse sensitivity and precision.", "definition": "Measured in dots per inch, representing sensor tracking precision. Values around 800-1600 are typically used by professional FPS players for precision, while 12000+ allows for extremely fast cursor movement with minimal physical motion, beneficial for MOBAs and strategy games that require covering large screen areas quickly.", "type": "value_illustration", "children_knowledge": -1}
  305. {"id": 23, "knowledge": "SwtchDur (Switch Durability)", "description": "Illustrates the significance of switch durability ratings in keyboard longevity.", "definition": "Measured in actuation cycles before failure. Values around 20 million indicate consumer-grade mechanical switches, 50 million represent premium mechanical switches for enthusiasts, and 100+ million typically denote optical or magnetic switches designed for extended competitive use with minimal degradation over time.", "type": "value_illustration", "children_knowledge": -1}
  306. {"id": 24, "knowledge": "ErgoRate (Ergonomic Rating)", "description": "Illustrates the significance of ergonomic ratings in gaming peripherals for comfort during extended use.", "definition": "Rated on a scale of 1-10, where 1-3 indicates basic designs prioritizing aesthetics over comfort, 4-6 represents good ergonomics for average gaming sessions, 7-8 denotes devices designed for extended comfort, and 9-10 indicates specialized ergonomic designs preventing repetitive strain injuries during marathon sessions.", "type": "value_illustration", "children_knowledge": -1}
  307. {"id": 25, "knowledge": "WlSignal (Wireless Signal Strength)", "description": "Illustrates the importance of wireless signal strength measurements for stable connectivity.", "definition": "Typically measured in dBm, with values ranging from -30 (excellent) to -90 (poor). Signal strength above -50dBm indicates optimal performance with minimal interference, -50 to -70dBm represents good connectivity suitable for most gaming, while below -70dBm may experience occasional disconnections or increased latency in challenging environments.", "type": "value_illustration", "children_knowledge": -1}
  308. {"id": 26, "knowledge": "ThdPct (Total Harmonic Distortion)", "description": "Illustrates the impact of harmonic distortion measurements on audio quality in gaming headsets.", "definition": "Measured as a percentage, representing audio signal distortion at high volumes. Values below 0.1% indicate audiophile-grade reproduction with imperceptible distortion, 0.1-0.5% represents excellent gaming audio quality, 0.5-1.0% is acceptable for most gaming scenarios, while values above 1.0% may produce noticeable distortion during intense gaming sequences.", "type": "value_illustration", "children_knowledge": -1}
  309. {"id": 27, "knowledge": "DriftRes (Drift Resistance)", "description": "Illustrates the significance of drift resistance in analog sticks for consistent gaming performance.", "definition": "Rated on a scale of 1-10, where values below 5 indicate susceptibility to developing drift over time, 6-8 represents good resistance to drift under normal use conditions, and 9-10 indicates premium Hall Effect or magnetic sensing technologies specifically designed to eliminate drift entirely throughout the controller's lifespan.", "type": "value_illustration", "children_knowledge": -1}
  310. {"id": 28, "knowledge": "RgbZones (RGB Lighting Zones)", "description": "Illustrates the customization potential of RGB lighting zones in gaming peripherals.", "definition": "Measured as distinct independently controllable lighting areas. Single-zone devices offer basic lighting effects, 3-5 zones allow for moderate customization like directional effects, 10+ zones enable complex patterns and game-reactive lighting, while per-key RGB (often 100+ zones) provides maximum customization with unique effects for individual keys or areas.", "type": "value_illustration", "children_knowledge": -1}
  311. {"id": 29, "knowledge": "BrdMemMB (Onboard Memory)", "description": "Illustrates the significance of onboard memory capacity for storing gaming profiles and settings.", "definition": "Measured in megabytes, representing storage for device configurations. Values of 1MB typically store 1-3 basic profiles with limited macros, 4-8MB allows for 5+ detailed profiles with complex macros and lighting effects, while 16MB+ enables tournament players to store numerous game-specific configurations with extensive customization independent of software.", "type": "value_illustration", "children_knowledge": -1}
  312. {"id": 30, "knowledge": "Competitive Gaming Performance Index (CGPI)", "description": "A comprehensive metric evaluating a device's suitability for competitive gaming based on response time, accuracy, and durability.", "definition": "CGPI = \\left(IRS \\times 0.4\\right) + \\left(SPI \\times 0.3\\right) + \\left(SPR \\times 0.2\\right) + \\left(RAI \\times 0.1\\right)", "type": "calculation_knowledge", "children_knowledge": [2, 0, 5, 31]}
  313. {"id": 31, "knowledge": "Response Accuracy Index (RAI)", "description": "Measures the accuracy and consistency of input response in gaming devices, accounting for both sensor precision and control stability.", "definition": "RAI = \\left(\\frac{JoyPrec + DpadAcc}{20}\\right) \\times \\left(1 - \\frac{InpLagMs}{10}\\right) \\times 10", "type": "calculation_knowledge", "children_knowledge": -1}
  314. {"id": 32, "knowledge": "Ergonomic Sustainability Factor (ESF)", "description": "Evaluates how suitable a device is for extended gaming sessions based on ergonomic design and comfort metrics.", "definition": "ESF = CI \\times \\left(1 + \\frac{ErgoRate - 5}{10}\\right) \\times \\left(1 - \\frac{|PalmAngle - 15|}{30}\\right) \\times \\left(1 + \\frac{ErgoRate \\times WristFlag}{50}\\right)", "type": "calculation_knowledge", "children_knowledge": [3]}
  315. {"id": 33, "knowledge": "Immersion Enhancement Coefficient (IEC)", "description": "Quantifies how well a device contributes to gaming immersion through audio quality, haptic feedback, and visual elements.", "definition": "IEC = \\left(AQI \\times 0.5\\right) + \\left(HFQ \\times 0.3\\right) + \\left(RIQ \\times 0.2\\right)", "type": "calculation_knowledge", "children_knowledge": [4, 34, 6]}
  316. {"id": 34, "knowledge": "Haptic Feedback Quality (HFQ)", "description": "Measures the quality and effectiveness of haptic feedback systems in gaming controllers and devices.", "definition": "HFQ = \\left(\\frac{HapStr}{10}\\right) \\times \\left(1 + \\frac{VibModes}{10}\\right) \\times \\left(1 + \\frac{ForceFeed\\_length}{20}\\right)", "type": "calculation_knowledge", "children_knowledge": -1}
  317. {"id": 35, "knowledge": "Wireless Performance Efficiency (WPE)", "description": "Evaluates the efficiency of wireless performance relative to battery consumption for untethered gaming devices.", "definition": "WPE = WPR \\times \\sqrt{\\frac{BER}{5}} \\times \\left(1 - \\frac{WlLatVar}{3}\\right) \\times 2", "type": "calculation_knowledge", "children_knowledge": [8, 1]}
  318. {"id": 36, "knowledge": "Gaming Versatility Score (GVS)", "description": "Assesses a device's versatility across different gaming genres and use cases based on adaptability and feature set.", "definition": "GVS = \\frac{ProfCount + 1}{3} \\times \\left(CGPI \\times 0.6\\right) + \\left(IEC \\times 0.4\\right)", "type": "calculation_knowledge", "children_knowledge": [30, 33]}
  319. {"id": 37, "knowledge": "Physical Endurance Rating (PER)", "description": "Measures the physical endurance of a device under intense gaming conditions, combining durability with effective heat management. ", "definition": "PER = DS \\times \\left(1 + \\frac{DustRes score + WaterRes score}{6}\\right) \\times \\left(1 - \\frac{100 - BendForce}{200}\\right), where DustRes and WaterRes are scored based on IP ratings (IPX0=0, IPX1=1, IPX2=2, IPX3=3).", "type": "calculation_knowledge", "children_knowledge": [7]}
  320. {"id": 38, "knowledge": "Professional Adoption Rating (PAR)", "description": "Quantifies the level of professional gamer adoption and tournament presence of a device based on performance metrics and pro-level features.", "definition": "PAR = \\frac{CGPI}{10} \\times \\left(1 + \\frac{ProfCount}{5}\\right) \\times \\left(\\frac{SPI + IRS}{15}\\right)", "type": "calculation_knowledge", "children_knowledge": [30, 0, 2]}
  321. {"id": 39, "knowledge": "Value Proposition Index (VPI)", "description": "A comprehensive metric evaluating a gaming device's overall value by balancing performance, durability, ergonomics, and professional adoption.", "definition": "VPI = \\left(GDVI \\times 0.4\\right) + \\left(ESF \\times 0.3\\right) + \\left(PER \\times 0.2\\right) + \\left(PAR \\times 0.1\\right)", "type": "calculation_knowledge", "children_knowledge": [9, 32, 37, 38]}
  322. {"id": 40, "knowledge": "Tournament Standard Device", "description": "Defines the minimum requirements for devices used in formal esports tournaments and professional competitions.", "definition": "A device that meets the CGPI > 8.0, LatMs < 2.0, PollRateHz ≥ 1000, and WlLatVar < 1.0 if wireless, supporting the precision and reliability demands of tournament play with consistent performance across extended match durations.", "type": "domain_knowledge", "children_knowledge": [30]}
  323. {"id": 41, "knowledge": "Ergonomic Excellence Certification", "description": "Designates devices specifically designed to prevent repetitive strain injuries and support extended professional gaming sessions.", "definition": "A device with ESF > 8.5, ErgoRate > 8, CI > 8.5, and at least one specialized ergonomic feature (WristFlag = true or PalmAngle between 10-20°), designed to maintain player comfort and prevent strain during marathon gaming sessions.", "type": "domain_knowledge", "children_knowledge": [32, 3]}
  324. {"id": 42, "knowledge": "Professional Multi-Genre Setup", "description": "Identifies device configurations specifically optimized for players who compete across multiple game genres at a high level.", "definition": "A device or device set with GVS > 8.5, ProfCount ≥ 4, and CGPI > 7.5, providing the adaptability and precision required by players who compete across FPS, MOBA, RTS, and other competitive genres.", "type": "domain_knowledge", "children_knowledge": [36, 30]}
  325. {"id": 43, "knowledge": "Ultra-Responsive Gaming Device", "description": "Defines the elite tier of input devices with exceptional response characteristics for reaction-critical competitive games.", "definition": "A device with IRS > 9.0, RAI > 8.5, LatMs < 1.0, and ClkLat < 0.5, delivering near-instantaneous input recognition essential for competitive gaming at the highest levels where milliseconds determine outcomes.", "type": "domain_knowledge", "children_knowledge": [2, 31]}
  326. {"id": 44, "knowledge": "Premium Immersive Experience Device", "description": "Identifies devices specifically optimized to enhance gaming immersion through superior sensory feedback.", "definition": "A device with IEC > 8.0, AQI > 7.5, HFQ > 8.0 if applicable, and RIQ > 7.0 if featuring lighting, designed to maximize player immersion in atmospheric and narrative-driven games.", "type": "domain_knowledge", "children_knowledge": [33, 4, 34, 6]}
  327. {"id": 45, "knowledge": "Extended Tournament Ready Wireless", "description": "Defines wireless devices suitable for full-day tournament use without connectivity or battery concerns.", "definition": "A wireless device with WPE > 8.5, BER > 7.0, BattLifeH > 40, and LatMs < 2.5, providing reliable, tournament-grade performance throughout extended competition days without requiring recharging or experiencing degraded responsiveness.", "type": "domain_knowledge", "children_knowledge": [35, 1]}
  328. {"id": 46, "knowledge": "Professional-Grade Control Consistency", "description": "Identifies controllers and input devices with exceptionally consistent control characteristics required for high-level competitive play.", "definition": "A device with RAI > 8.5, SwtchCons > 9.0, JoyPrec > 9.0 (if applicable), and DriftRes > 9.0 (if featuring analog sticks), delivering the precise, predictable input response professional players rely on for muscle memory development and consistent performance across practice and tournament environments.", "type": "domain_knowledge", "children_knowledge": [31]}
  329. {"id": 47, "knowledge": "Ultra-Durable Tournament Device", "description": "Defines devices with exceptional physical durability designed to withstand the rigors of frequent tournament travel and intensive competition use.", "definition": "A device with PER > 9.0, DS > 8.5, UsbConnDur > 20000, and at least one premium durability feature (DropHtM > 2.0 or WaterRes containing 'IPX7' or higher), engineered to maintain performance integrity despite frequent transportation, setup/teardown cycles, and competition intensity.", "type": "domain_knowledge", "children_knowledge": [37, 7]}
  330. {"id": 48, "knowledge": "Pro-Player Performance Certified", "description": "Identifies devices that have been validated through professional player testing and competition use at the highest levels.", "definition": "A device with PAR > 8.5, CGPI > 8.0, and specialized features matching competitive requirements for at least two major esports titles, representing equipment that has proven its performance capabilities in professional tournament environments.", "type": "domain_knowledge", "children_knowledge": [38, 30]}
  331. {"id": 49, "knowledge": "Elite Gaming Ecosystem", "description": "Identifies comprehensive device ecosystems that deliver exceptional performance across all gaming interaction points for competitive players.", "definition": "A multi-device setup where each component achieves VPI > 8.5, with an average GDVI > 9.0 across at least three different device categories, providing seamless integration and consistent high performance across all player-game interaction points to maximize competitive advantage.", "type": "domain_knowledge", "children_knowledge": [39, 9]}
  332. {"id": 50, "knowledge": "Battery Efficiency Classification", "description": "A categorical framework for evaluating and classifying the battery efficiency of gaming devices based on their Battery Efficiency Ratio (BER).", "definition": "A classification system that segments wireless gaming devices into four efficiency categories: 'Excellent Efficiency' (BER > 7.5) indicating marathon gaming capability, 'Good Efficiency' (BER between 5.0 and 7.5) for extended gaming sessions, 'Average Efficiency' (BER between 2.5 and 4.9) suitable for regular gameplay, and 'Poor Efficiency' (BER < 2.5) requiring frequent recharging, providing standardized comparison metrics across different gaming peripherals.", "type": "domain_knowledge", "children_knowledge": [1]}
  333. {"id": 51, "knowledge": "RGB Quality Classification", "description": "A systematic framework for categorizing the quality of RGB lighting implementations in gaming peripherals based on the RGB Implementation Quality (RIQ) score.", "definition": "A classification system that segments gaming devices into four RGB quality categories: 'Premium RGB Implementation' (RIQ > 8.0) indicating exceptional color accuracy and customization capabilities, 'High-Quality RGB' (RIQ between 6.0 and 8.0) for advanced lighting effects with good color reproduction, 'Standard RGB' (RIQ between 3.0 and 5.9) suitable for basic customization needs, and 'Basic RGB' (RIQ < 3.0) offering limited lighting features, providing standardized comparison metrics for RGB lighting quality across gaming peripherals.", "type": "domain_knowledge", "children_knowledge": [6]}
  334. {"id": 52, "knowledge": "Subpar Audio Device Identification", "description": "Identifies audio devices that fail to meet audiophile gaming standards and need improvement or removal from premium product lines", "definition": "Audio devices with one or more critical quality deficiencies: AQI score of 8.0 or lower, total harmonic distortion (ThdPct) of 0.5% or higher, noise isolation (NoiseIsoDb) of 15dB or lower, or frequency response not covering the full 10Hz-22kHz range required for immersive gaming audio experiences. These devices are candidates for improvement or reclassification to non-audiophile product categories.", "type": "domain_knowledge", "children_knowledge": [4, 12]}
  335. {"id": 53, "knowledge": "Global Efficiency Percentile (GEP)", "description": "Ranks a device’s Battery Efficiency Ratio (BER) relative to all other wireless gaming devices.", "definition": "GEP = \\text{PERCENT\\_RANK}()_{BER} \\times 100, where PERCENT\\_RANK() is computed over all devices sorted by BER; 0\\% corresponds to the lowest BER and 100\\% to the highest.", "type": "calculation_knowledge", "children_knowledge": [1]}
  336. </СЛОВАРЬ ЗНАНИЙ, СВЯЗАННЫЙ С БАЗОЙ ДАННЫХ>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!