de:modul:ffit:3-jahr:java:learningunits:lu11:aufgaben:b01

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
Nächste Überarbeitung		 Vorhergehende Überarbeitung
de:modul:ffit:3-jahr:java:learningunits:lu11:aufgaben:b01 [2025/11/18 13:40] – apeterde:modul:ffit:3-jahr:java:learningunits:lu11:aufgaben:b01 [2025/11/18 15:58] (aktuell) – apeter
Zeile 6: Zeile 6:
   * https://github.com/andreiramani/pgvector_pgsql_windows/releases/tag/0.8.1_17.6 runterladen und readme.txt lesen   * https://github.com/andreiramani/pgvector_pgsql_windows/releases/tag/0.8.1_17.6 runterladen und readme.txt lesen
   * Im korrekten Verzeichnis entpacken   * Im korrekten Verzeichnis entpacken
-  * Loggen Sie sich mit einem SQL-Benutzer ein. <code bash>psql -U localuser</code>+  * Loggen Sie sich mit dem Superuser ein. <code bash>psql -U postgres</code>
   * Erstellen Sie den Datentyp ''vector'' <code psql>CREATE EXTENSION vector;</code>   * Erstellen Sie den Datentyp ''vector'' <code psql>CREATE EXTENSION vector;</code>
-  * <code psql>SELECT extname,extrelocatable,extversion FROM pg_extension where extname='vector';</code>+  * Überprüfen Sie, ob die entsprechende Zeile vorhanden ist <code psql>SELECT extname,extrelocatable,extversion FROM pg_extension where extname='vector';</code>
   * Erstellen Sie die Tabelle ''documents'' <WRAP><code psql>CREATE TABLE documents (   * Erstellen Sie die Tabelle ''documents'' <WRAP><code psql>CREATE TABLE documents (
     id SERIAL PRIMARY KEY,     id SERIAL PRIMARY KEY,
Zeile 26: Zeile 26:
   * <WRAP><code psql>INSERT INTO documents (content, embedding) VALUES ('PostgreSQL ist eine leistungsfähige Datenbank.', '[-0.03429, 0.06173, -0.03975, 0.04145, -0.13126, 0.08621, 0.00319, 0.03005, 0.02991, -0.05117, -0.04699, 0.04494, -0.06536, -0.11712, -0.05831, -0.03202, -0.03093, 0.04725, 0.07477, -0.04728, -0.08303, -0.09535, -0.07372, 0.06229, -0.01554, -0.03045, 0.03512, -0.03472, -0.00566, -0.05086, -0.03260, 0.02053, 0.00268, 0.00175, 0.01844, 0.04087, 0.07505, -0.06817, -0.00669, -0.04954, -0.06285, -0.02958, -0.03496, 0.00985, 0.00384, -0.00861, 0.01516, 0.05489, -0.10802, 0.05866, -0.04387, 0.01079, 0.04925, -0.04233, 0.06288, -0.00771, -0.05741, -0.00522, 0.02249, 0.02093, 0.01000, 0.02915, -0.07094, 0.00470, -0.04696, -0.05301, 0.08767, -0.00060, 0.05788, -0.03261, 0.00762, 0.01103, -0.05033, 0.00664, -0.12247, 0.07863, -0.01307, -0.00867, 0.00905, -0.07175, 0.01002, 0.00153, -0.05467, 0.03779, -0.04065, -0.06465, -0.00931, 0.06274, -0.01006, -0.03775, 0.00558, 0.07641, -0.01715, 0.01494, -0.02367, -0.08040, 0.01042, 0.02684, 0.09627, 0.07352, 0.02585, 0.11794, -0.01239, 0.08656, -0.09040, -0.05076, -0.04871, -0.10463, 0.00778, 0.01017, -0.00876, -0.00884, -0.01377, -0.09049, 0.05491, 0.02176, -0.01173, -0.05618, 0.06138, -0.06323, 0.05558, 0.01370, 0.00106, -0.03077, -0.01695, 0.00426, 0.11145, 0.00000, -0.01202, -0.04827, 0.13671, -0.06535, -0.01604, -0.06013, 0.00468, -0.00589, 0.01689, 0.07291, -0.03153, -0.03819, -0.02570, -0.11258, 0.05101, 0.06928, -0.01854, 0.03407, 0.10890, 0.00512, 0.03370, -0.05489, -0.00358, 0.10547, 0.07028, -0.03498, 0.01182, 0.00162, 0.01408, 0.02239, 0.05972, -0.03349, -0.06217, 0.03234, 0.06371, -0.00949, -0.04787, 0.04037, 0.02349, 0.02598, 0.05811, -0.04757, -0.02338, -0.07412, 0.05797, 0.06830, 0.01898, -0.00709, 0.08436, -0.01178, -0.08683, -0.01899, -0.05214, 0.02430, 0.02977, 0.03940, -0.02171, -0.03022, 0.03671, 0.04785, 0.01935, -0.04217, -0.05305, -0.02807, -0.04319, -0.00436, -0.00642, 0.02296, 0.03615, 0.05378, -0.03141, 0.01154, 0.05067, 0.03298, -0.01094, 0.00116, -0.02965, 0.08282, -0.01046, 0.03991, -0.03255, -0.02745, -0.00858, -0.01008, -0.02097, 0.06187, 0.02063, 0.06393, -0.01959, 0.01639, -0.06338, 0.06820, 0.04937, 0.05954, 0.05427, -0.00000, -0.03163, -0.03699, -0.06069, 0.06353, 0.00068, 0.00493, -0.02719, 0.08729, -0.00329, 0.05034, -0.02068, -0.01700, 0.07002, 0.00851, -0.00563, 0.07312, -0.00705, -0.02048, -0.12685, 0.04062, -0.05809, 0.05376, -0.06523, -0.00163, 0.11719, -0.02240, 0.04088, 0.03741, -0.05736, 0.05935, 0.03757, -0.07742, 0.03090, 0.03066, -0.06035, -0.05338, 0.07963, -0.04046, 0.05022, 0.08698, -0.09134, 0.07421, -0.02496, -0.02369, 0.06774, 0.09304, -0.06478, -0.02399, -0.01144, -0.05802, -0.03668, 0.00622, -0.03913, -0.05955, 0.08552, 0.00956, -0.04334, 0.05085, 0.00232, -0.01426, -0.04774, 0.02829, 0.09394, -0.00823, 0.07830, -0.09227, 0.07673, -0.00887, 0.06290, -0.06586, 0.09524, 0.02547, 0.00277, 0.05460, -0.10717, 0.01665, -0.02714, 0.10181, -0.05907, -0.01473, -0.04846, 0.06107, 0.02659, 0.07890, -0.00959, -0.02693, 0.04252, -0.03587, -0.06534, -0.05752, -0.02028, 0.01663, -0.11825, 0.04655, -0.01455, -0.00000, -0.00500, -0.05158, -0.13957, 0.01721, 0.12876, -0.01686, -0.00114, 0.05691, 0.00581, -0.01137, 0.04161, -0.01209, -0.03758, 0.01474, -0.03496, -0.02583, -0.04028, -0.02732, -0.01253, -0.07391, 0.03684, -0.02612, 0.00628, -0.09552, -0.04351, 0.00467, -0.02151, 0.05898, 0.06443, -0.01818, 0.00470, 0.01940, 0.02307, -0.08359, 0.02374, 0.00692, 0.02899, 0.04387, -0.07812, 0.02586, 0.05448, 0.02687, 0.01435, 0.00365, -0.05989, -0.07411, -0.02148, -0.01677, -0.02766, 0.09163, -0.02525, 0.01594, 0.02753, 0.03219, 0.08931, 0.03065, -0.02586, -0.02974, -0.08107, -0.05400, -0.03935, -0.00705, 0.02187, 0.02754]');   * <WRAP><code psql>INSERT INTO documents (content, embedding) VALUES ('PostgreSQL ist eine leistungsfähige Datenbank.', '[-0.03429, 0.06173, -0.03975, 0.04145, -0.13126, 0.08621, 0.00319, 0.03005, 0.02991, -0.05117, -0.04699, 0.04494, -0.06536, -0.11712, -0.05831, -0.03202, -0.03093, 0.04725, 0.07477, -0.04728, -0.08303, -0.09535, -0.07372, 0.06229, -0.01554, -0.03045, 0.03512, -0.03472, -0.00566, -0.05086, -0.03260, 0.02053, 0.00268, 0.00175, 0.01844, 0.04087, 0.07505, -0.06817, -0.00669, -0.04954, -0.06285, -0.02958, -0.03496, 0.00985, 0.00384, -0.00861, 0.01516, 0.05489, -0.10802, 0.05866, -0.04387, 0.01079, 0.04925, -0.04233, 0.06288, -0.00771, -0.05741, -0.00522, 0.02249, 0.02093, 0.01000, 0.02915, -0.07094, 0.00470, -0.04696, -0.05301, 0.08767, -0.00060, 0.05788, -0.03261, 0.00762, 0.01103, -0.05033, 0.00664, -0.12247, 0.07863, -0.01307, -0.00867, 0.00905, -0.07175, 0.01002, 0.00153, -0.05467, 0.03779, -0.04065, -0.06465, -0.00931, 0.06274, -0.01006, -0.03775, 0.00558, 0.07641, -0.01715, 0.01494, -0.02367, -0.08040, 0.01042, 0.02684, 0.09627, 0.07352, 0.02585, 0.11794, -0.01239, 0.08656, -0.09040, -0.05076, -0.04871, -0.10463, 0.00778, 0.01017, -0.00876, -0.00884, -0.01377, -0.09049, 0.05491, 0.02176, -0.01173, -0.05618, 0.06138, -0.06323, 0.05558, 0.01370, 0.00106, -0.03077, -0.01695, 0.00426, 0.11145, 0.00000, -0.01202, -0.04827, 0.13671, -0.06535, -0.01604, -0.06013, 0.00468, -0.00589, 0.01689, 0.07291, -0.03153, -0.03819, -0.02570, -0.11258, 0.05101, 0.06928, -0.01854, 0.03407, 0.10890, 0.00512, 0.03370, -0.05489, -0.00358, 0.10547, 0.07028, -0.03498, 0.01182, 0.00162, 0.01408, 0.02239, 0.05972, -0.03349, -0.06217, 0.03234, 0.06371, -0.00949, -0.04787, 0.04037, 0.02349, 0.02598, 0.05811, -0.04757, -0.02338, -0.07412, 0.05797, 0.06830, 0.01898, -0.00709, 0.08436, -0.01178, -0.08683, -0.01899, -0.05214, 0.02430, 0.02977, 0.03940, -0.02171, -0.03022, 0.03671, 0.04785, 0.01935, -0.04217, -0.05305, -0.02807, -0.04319, -0.00436, -0.00642, 0.02296, 0.03615, 0.05378, -0.03141, 0.01154, 0.05067, 0.03298, -0.01094, 0.00116, -0.02965, 0.08282, -0.01046, 0.03991, -0.03255, -0.02745, -0.00858, -0.01008, -0.02097, 0.06187, 0.02063, 0.06393, -0.01959, 0.01639, -0.06338, 0.06820, 0.04937, 0.05954, 0.05427, -0.00000, -0.03163, -0.03699, -0.06069, 0.06353, 0.00068, 0.00493, -0.02719, 0.08729, -0.00329, 0.05034, -0.02068, -0.01700, 0.07002, 0.00851, -0.00563, 0.07312, -0.00705, -0.02048, -0.12685, 0.04062, -0.05809, 0.05376, -0.06523, -0.00163, 0.11719, -0.02240, 0.04088, 0.03741, -0.05736, 0.05935, 0.03757, -0.07742, 0.03090, 0.03066, -0.06035, -0.05338, 0.07963, -0.04046, 0.05022, 0.08698, -0.09134, 0.07421, -0.02496, -0.02369, 0.06774, 0.09304, -0.06478, -0.02399, -0.01144, -0.05802, -0.03668, 0.00622, -0.03913, -0.05955, 0.08552, 0.00956, -0.04334, 0.05085, 0.00232, -0.01426, -0.04774, 0.02829, 0.09394, -0.00823, 0.07830, -0.09227, 0.07673, -0.00887, 0.06290, -0.06586, 0.09524, 0.02547, 0.00277, 0.05460, -0.10717, 0.01665, -0.02714, 0.10181, -0.05907, -0.01473, -0.04846, 0.06107, 0.02659, 0.07890, -0.00959, -0.02693, 0.04252, -0.03587, -0.06534, -0.05752, -0.02028, 0.01663, -0.11825, 0.04655, -0.01455, -0.00000, -0.00500, -0.05158, -0.13957, 0.01721, 0.12876, -0.01686, -0.00114, 0.05691, 0.00581, -0.01137, 0.04161, -0.01209, -0.03758, 0.01474, -0.03496, -0.02583, -0.04028, -0.02732, -0.01253, -0.07391, 0.03684, -0.02612, 0.00628, -0.09552, -0.04351, 0.00467, -0.02151, 0.05898, 0.06443, -0.01818, 0.00470, 0.01940, 0.02307, -0.08359, 0.02374, 0.00692, 0.02899, 0.04387, -0.07812, 0.02586, 0.05448, 0.02687, 0.01435, 0.00365, -0.05989, -0.07411, -0.02148, -0.01677, -0.02766, 0.09163, -0.02525, 0.01594, 0.02753, 0.03219, 0.08931, 0.03065, -0.02586, -0.02974, -0.08107, -0.05400, -0.03935, -0.00705, 0.02187, 0.02754]');
 </code></WRAP> </code></WRAP>
-  * <WRAP><code psql>Select count(*) from documents;</code></WRAP>+  * Nun sollten 4 Einträge vorhanden sein <WRAP><code psql>Select count(*) from documents;</code></WRAP> 
 +  * Setzen Sie folgendes SELECT-Statement ab, um die 3 nächsten Einträge zu finden, der am nächsten zum Satz "Katzen sind meine Lieblingstiere" ist <WRAP><code psql>SELECT id, content, embedding <=> '[-0.03493, 0.03568, 0.06867, 0.00082, -0.04072, 0.06786, 0.11940, -0.05452, 0.02797, -0.04935, 0.02574, 0.03369, -0.00755, -0.09016, -0.03898, -0.08418, -0.07572, 0.12806, -0.06438, -0.02141, 0.01308, -0.00135, 0.04206, -0.01135, -0.03226, 0.00674, 0.03916, -0.02778, -0.02183, -0.06194, 0.11493, 0.00412, -0.04840, -0.03430, 0.05279, -0.04752, -0.00842, -0.05732, -0.00380, 0.02335, -0.10179, -0.06320, -0.09921, -0.07888, -0.01643, 0.05722, -0.01505, 0.01265, -0.03972, -0.00492, -0.05816, -0.01095, 0.05496, -0.03182, 0.05747, -0.10006, -0.00392, 0.03742, 0.01361, 0.04257, 0.10364, -0.00892, -0.01067, -0.01833, 0.00142, -0.04466, 0.06020, -0.05770, -0.05920, 0.02491, 0.07516, -0.08650, -0.02995, 0.02948, -0.04823, -0.05966, -0.07892, -0.03719, -0.04004, -0.09690, 0.00099, -0.00529, 0.05824, 0.02274, -0.04542, -0.03596, 0.01114, 0.05981, 0.05816, 0.03222, -0.03906, -0.04377, -0.12412, 0.00144, 0.10311, -0.05397, 0.01379, -0.03965, -0.04770, 0.08296, -0.02025, 0.02099, 0.05772, 0.08974, -0.02686, -0.10557, 0.03211, -0.06085, -0.01258, -0.01620, 0.03423, 0.01051, 0.07322, -0.10282, 0.07545, 0.00329, 0.07935, -0.03416, -0.00551, -0.00736, 0.06363, 0.03952, 0.06159, 0.11851, 0.02391, -0.04287, -0.03800, 0.00000, -0.03656, -0.00219, -0.03037, -0.00321, 0.01003, -0.05004, -0.11151, 0.02934, -0.05327, 0.03419, -0.02941, -0.03520, 0.00116, -0.03742, 0.00228, 0.02429, 0.00155, 0.05357, 0.05857, -0.06630, -0.01104, -0.01960, 0.09703, 0.06629, 0.00076, -0.04037, 0.05239, -0.01468, -0.05098, 0.00862, 0.08488, -0.04264, -0.01979, -0.05946, 0.00002, 0.03357, -0.06341, 0.03716, -0.02466, 0.01536, 0.04432, -0.01202, -0.02409, -0.06403, 0.02127, 0.08715, -0.00143, -0.00101, 0.04289, 0.00666, -0.00493, 0.04477, -0.02715, 0.00680, -0.01724, 0.10950, -0.02329, 0.01558, -0.04293, -0.01325, 0.04967, -0.05981, -0.05935, -0.05094, -0.02633, -0.00977, 0.01927, -0.02305, -0.00257, 0.07690, -0.11992, -0.01335, 0.05334, 0.05576, 0.01851, 0.00626, -0.07686, 0.08395, -0.01366, -0.03389, -0.05128, -0.05843, -0.00856, -0.05903, 0.02409, 0.01240, -0.06948, -0.03939, -0.02406, 0.09140, 0.00454, -0.03415, 0.01524, -0.03230, -0.02853, -0.00000, -0.03648, 0.02080, -0.05858, 0.06433, 0.02325, 0.06574, -0.05850, 0.06955, -0.06247, 0.02721, 0.00924, -0.07342, 0.01695, 0.03598, -0.02073, 0.05871, 0.04333, -0.03323, 0.03020, 0.01873, -0.09406, 0.03331, -0.02906, -0.01306, -0.08289, 0.02105, 0.03742, 0.05806, -0.02792, 0.02196, 0.04866, -0.01016, -0.05985, -0.05076, 0.00396, 0.06116, 0.01258, 0.06670, -0.01775, 0.06748, -0.06249, 0.06749, -0.00955, 0.02280, 0.06887, -0.02375, -0.04198, -0.06005, -0.01574, -0.02914, -0.01564, 0.05372, 0.01805, -0.03720, 0.00938, -0.00115, -0.03708, -0.03602, -0.09096, 0.04249, 0.00143, 0.07988, 0.09154, 0.01241, 0.02756, -0.03852, -0.09470, 0.00696, 0.11326, 0.04225, 0.00439, -0.05702, 0.01846, -0.00595, -0.12662, 0.00903, 0.07057, 0.12596, -0.03087, 0.00775, 0.05668, 0.01745, -0.00602, 0.01471, 0.04832, -0.01996, 0.06925, 0.00526, -0.02115, -0.00283, 0.01880, 0.06725, 0.04957, -0.02828, -0.01660, -0.00000, -0.00526, -0.08733, -0.09355, 0.00189, 0.09745, -0.07254, -0.04005, 0.00660, -0.11776, -0.01369, -0.00677, 0.01250, -0.04336, 0.05627, 0.04264, 0.03474, -0.09913, 0.06409, 0.01374, 0.00799, 0.09462, -0.01017, 0.00585, -0.04287, -0.04398, 0.05375, 0.02274, -0.07671, -0.01552, 0.02560, 0.02374, 0.12028, -0.04550, -0.02612, -0.04541, -0.01518, -0.02856, 0.00332, -0.06168, 0.03811, 0.05920, 0.04857, 0.09972, -0.04516, -0.00653, -0.05994, -0.03416, -0.03662, 0.09364, 0.07119, -0.01380, 0.05634, 0.03041, 0.09184, 0.03038, 0.05970, 0.00352, -0.00548, -0.06134, 0.02853, 0.01593, 0.08125, 0.04185, -0.04225]' AS distance FROM documents ORDER BY distance ASC LIMIT 3;</code></WRAP>
  
      
  
  • de/modul/ffit/3-jahr/java/learningunits/lu11/aufgaben/b01.1763469656.txt.gz
  • Zuletzt geändert: 2025/11/18 13:40
  • von apeter