2 <!-- To view this file, download free mind mapping software FreeMind from http://freemind.sourceforge.net -->
3 <node BACKGROUND_COLOR="#ffff00" COLOR="#000000" CREATED="1346540430244" ID="ID_413943685" MODIFIED="1372099411892">
4 <richcontent TYPE="NODE"><html>
9 <p style="text-align: center">
10 <b>Local File Database - NG</b>
12 <p style="text-align: center">
13 <font size="4">Revision: <b>1</b></font>
15 <p style="text-align: center">
16 <font size="4">Short name: <b>LFDB2 </b></font>
18 <p style="text-align: center">
19 <i><font size="4" color="#ff0033"><b>Work in progress!</b></font></i>
24 <font NAME="Dialog" SIZE="20"/>
25 <hook NAME="accessories/plugins/RevisionPlugin.properties"/>
26 <hook NAME="accessories/plugins/AutomaticLayout.properties"/>
27 <node COLOR="#0033ff" CREATED="1346540670719" ID="ID_660363592" MODIFIED="1351543382024" POSITION="right" TEXT="Program design/concept">
28 <edge STYLE="sharp_bezier" WIDTH="8"/>
29 <font BOLD="true" NAME="Dialog" SIZE="18"/>
30 <node COLOR="#00b439" CREATED="1346541218691" ID="ID_1935672088" MODIFIED="1351543382028" TEXT="General class structure">
31 <edge STYLE="bezier" WIDTH="thin"/>
32 <font BOLD="true" NAME="Dialog" SIZE="16"/>
34 <node COLOR="#00b439" CREATED="1346541227155" ID="ID_1791161792" MODIFIED="1351543382044" TEXT="Used design patterns">
35 <edge STYLE="bezier" WIDTH="thin"/>
36 <font BOLD="true" NAME="Dialog" SIZE="16"/>
38 <node COLOR="#00b439" CREATED="1346541238307" ID="ID_861575201" MODIFIED="1351543382048" TEXT="Provided interface(s)">
39 <edge STYLE="bezier" WIDTH="thin"/>
40 <font BOLD="true" NAME="Dialog" SIZE="16"/>
41 <node COLOR="#990000" CREATED="1346542025714" ID="ID_1461673036" MODIFIED="1351543382061" TEXT="For "querying"">
42 <font NAME="Dialog" SIZE="14"/>
44 <node COLOR="#990000" CREATED="1346542040293" ID="ID_1420341059" MODIFIED="1351543382064" TEXT="For meta data retrieval">
45 <font NAME="Dialog" SIZE="14"/>
47 <node COLOR="#990000" CREATED="1346542075115" ID="ID_505926178" MODIFIED="1351543382066" TEXT="Other purposes">
48 <font NAME="Dialog" SIZE="14"/>
49 <icon BUILTIN="help"/>
53 <node COLOR="#0033ff" CREATED="1346540632815" ID="ID_1890914832" MODIFIED="1351543382068" POSITION="right" TEXT="General ideas/features">
54 <edge STYLE="sharp_bezier" WIDTH="8"/>
55 <font BOLD="true" NAME="Dialog" SIZE="18"/>
56 <node COLOR="#00b439" CREATED="1346540483730" ID="ID_581776449" MODIFIED="1351543382093" TEXT="Based on 2 files">
57 <edge STYLE="bezier" WIDTH="thin"/>
58 <font BOLD="true" NAME="Dialog" SIZE="16"/>
59 <node COLOR="#990000" CREATED="1346542687393" ID="ID_1172644330" MODIFIED="1351546072253" TEXT="Raw (structured) data">
60 <arrowlink DESTINATION="ID_1683424442" ENDARROW="Default" ENDINCLINATION="-354;-231;" ID="Arrow_ID_230622914" STARTARROW="None" STARTINCLINATION="1261;0;"/>
61 <font NAME="Dialog" SIZE="14"/>
63 <node COLOR="#990000" CREATED="1346542705504" ID="ID_1302915483" MODIFIED="1351543382104" TEXT="Index file">
64 <font NAME="Dialog" SIZE="14"/>
65 <node COLOR="#111111" CREATED="1346542717193" ID="ID_904326028" MODIFIED="1351543382105" TEXT="Allows faster access on raw data">
66 <font NAME="Dialog" SIZE="12"/>
68 <node COLOR="#111111" CREATED="1346542744989" ID="ID_305647790" MODIFIED="1351543382106" TEXT="Must be updated by every write access">
69 <font NAME="Dialog" SIZE="12"/>
71 <node COLOR="#111111" CREATED="1346542768626" ID="ID_1615794960" MODIFIED="1351543382107" TEXT="Contains data for all gaps">
72 <font NAME="Dialog" SIZE="12"/>
73 <node COLOR="#111111" CREATED="1346542837936" ID="ID_900314383" MODIFIED="1351543382108" TEXT="Faster compression">
74 <font NAME="Dialog" SIZE="12"/>
75 <node COLOR="#111111" CREATED="1351428429628" ID="ID_186273074" MODIFIED="1351543382108" TEXT="Can be archived by "NULL-ing" unused areas"/>
76 <node COLOR="#111111" CREATED="1351428551920" ID="ID_328508625" MODIFIED="1351543382109" TEXT="Then all NULL-ed areas can be ignored by next rebuild process"/>
79 <node COLOR="#111111" CREATED="1346542826853" ID="ID_967962336" MODIFIED="1351543382121" TEXT="Can be rebuild">
80 <font NAME="Dialog" SIZE="12"/>
83 <node COLOR="#990000" CREATED="1347915614137" ID="ID_1006501495" MODIFIED="1351543382123" TEXT="Depends on used storage engine">
84 <font NAME="Dialog" SIZE="14"/>
85 <icon BUILTIN="messagebox_warning"/>
88 <node COLOR="#00b439" CREATED="1346540517127" ID="ID_976750936" MODIFIED="1351543382135" TEXT="Distributable">
89 <edge STYLE="bezier" WIDTH="thin"/>
90 <font BOLD="true" NAME="Dialog" SIZE="16"/>
91 <node COLOR="#990000" CREATED="1346541373845" ID="ID_1907835503" MODIFIED="1351543382136" TEXT="Local master/slave">
92 <font NAME="Dialog" SIZE="14"/>
95 <node COLOR="#00b439" CREATED="1346540939490" ID="ID_853854853" MODIFIED="1351543382139" TEXT="Fail safety">
96 <edge STYLE="bezier" WIDTH="thin"/>
97 <font BOLD="true" NAME="Dialog" SIZE="16"/>
98 <node COLOR="#990000" CREATED="1346541447690" ID="ID_1331254269" MODIFIED="1351543382140" TEXT="Hashed data">
99 <font NAME="Dialog" SIZE="14"/>
100 <node COLOR="#111111" CREATED="1351428713020" ID="ID_301362575" MODIFIED="1351543382141" TEXT="Allows verification of stored data">
101 <node COLOR="#111111" CREATED="1351428736459" ID="ID_984604510" MODIFIED="1351543382142" TEXT="Recalculate hash and compare both"/>
103 <node COLOR="#111111" CREATED="1351428773488" ID="ID_1452255278" MODIFIED="1351543382149" TEXT="Redundancy becomes possible">
104 <node COLOR="#111111" CREATED="1351428794915" ID="ID_1165263400" MODIFIED="1351543382150" TEXT="As nodes will send/receive same data on same hash"/>
107 <node COLOR="#990000" CREATED="1346544247298" ID="ID_1331731103" MODIFIED="1351543382151" TEXT="Binary logfile">
108 <font NAME="Dialog" SIZE="14"/>
109 <node COLOR="#111111" CREATED="1347916697056" ID="ID_1378441227" MODIFIED="1351543382152" TEXT="Replay of transactions"/>
110 <node COLOR="#111111" CREATED="1347916753995" ID="ID_1381029962" MODIFIED="1351543382153" TEXT="Supports distribution over database cluster"/>
112 <node COLOR="#990000" CREATED="1347916658255" ID="ID_109448402" MODIFIED="1351543382155" TEXT="Redundancy">
113 <font NAME="Dialog" SIZE="14"/>
114 <node COLOR="#111111" CREATED="1347916667031" ID="ID_64976885" MODIFIED="1351543382156" TEXT="Depends on storage engine"/>
115 <node COLOR="#111111" CREATED="1347916672988" ID="ID_1386677073" MODIFIED="1351543382156" TEXT="And/or table/database structure"/>
118 <node COLOR="#00b439" CREATED="1346541497280" ID="ID_1637997890" MODIFIED="1351543382159" TEXT="Type-safe">
119 <edge STYLE="bezier" WIDTH="thin"/>
120 <font BOLD="true" NAME="Dialog" SIZE="16"/>
122 <node COLOR="#00b439" CREATED="1347915643904" ID="ID_6496282" MODIFIED="1351543382172" TEXT="Bottom->top organization:">
123 <edge STYLE="bezier" WIDTH="thin"/>
124 <font BOLD="true" NAME="Dialog" SIZE="16"/>
125 <node COLOR="#990000" CREATED="1347915680510" ID="ID_709798549" MODIFIED="1351543382173" TEXT="1.) Data entry">
126 <font NAME="Dialog" SIZE="14"/>
127 <node COLOR="#111111" CREATED="1351191077498" ID="ID_318086573" MODIFIED="1351543382174" TEXT="Is "atomic""/>
129 <node COLOR="#990000" CREATED="1347915700610" ID="ID_632069966" MODIFIED="1351543382176" TEXT="2.) Dataset">
130 <font NAME="Dialog" SIZE="14"/>
131 <node COLOR="#111111" CREATED="1351191035477" ID="ID_1962500729" MODIFIED="1351543382176" TEXT="n-n relation to entries"/>
133 <node COLOR="#990000" CREATED="1347915734366" ID="ID_653804154" MODIFIED="1351543382177" TEXT="3.) Table">
134 <font NAME="Dialog" SIZE="14"/>
135 <node COLOR="#111111" CREATED="1351191040147" ID="ID_1508237886" MODIFIED="1351543382179" TEXT="n-n relation to datasets"/>
137 <node COLOR="#990000" CREATED="1347916519589" ID="ID_167347179" MODIFIED="1351543382180" TEXT="4.) Database">
138 <font NAME="Dialog" SIZE="14"/>
139 <node COLOR="#111111" CREATED="1351191055736" ID="ID_1600520779" MODIFIED="1351543382181" TEXT="1-n relation to tables"/>
142 <node COLOR="#00b439" CREATED="1346608262353" ID="ID_584117157" MODIFIED="1351543382183" TEXT="Performance enhancements">
143 <edge STYLE="bezier" WIDTH="thin"/>
144 <font BOLD="true" NAME="Dialog" SIZE="16"/>
145 <node COLOR="#990000" CREATED="1346541901096" ID="ID_1357419168" MODIFIED="1351543382184" TEXT="Database compression">
146 <font BOLD="true" NAME="Dialog" SIZE="14"/>
147 <node COLOR="#111111" CREATED="1346541915248" ID="ID_63943962" MODIFIED="1351543382185" TEXT="Marking data as 'unused'">
148 <font NAME="Dialog" SIZE="12"/>
150 <node COLOR="#111111" CREATED="1346541954871" ID="ID_1494730149" MODIFIED="1351543382185" TEXT="Data file gap removal">
151 <font NAME="Dialog" SIZE="12"/>
153 <node COLOR="#111111" CREATED="1346544289803" ID="ID_335462598" MODIFIED="1351543382186" TEXT="Index compression/cleanup">
154 <font NAME="Dialog" SIZE="12"/>
156 <node COLOR="#111111" CREATED="1346544314340" ID="ID_898620191" MODIFIED="1351543382192" TEXT="Transparent file compression">
157 <font NAME="Dialog" SIZE="12"/>
159 <node COLOR="#111111" CREATED="1346544323084" ID="ID_618559935" MODIFIED="1351543382193" TEXT="Large data compression">
160 <font NAME="Dialog" SIZE="12"/>
163 <node COLOR="#990000" CREATED="1346608279539" ID="ID_288753607" MODIFIED="1351543382194" TEXT="Pre allocation of database files">
164 <font NAME="Dialog" SIZE="14"/>
165 <node COLOR="#111111" CREATED="1346608307613" ID="ID_958125601" MODIFIED="1351543382195" TEXT="A pre allocated file doesn't need to be extended">
166 <font NAME="Dialog" SIZE="12"/>
167 <node COLOR="#111111" CREATED="1346608332653" ID="ID_1374175180" MODIFIED="1351543382199" TEXT="JIT (just-in-time) expansion of database file should still be possible">
168 <font NAME="Dialog" SIZE="12"/>
171 <node COLOR="#111111" CREATED="1346608361081" ID="ID_338511677" MODIFIED="1351543382200" TEXT="Very performant write operations">
172 <font NAME="Dialog" SIZE="12"/>
174 <node COLOR="#111111" CREATED="1346617689040" ID="ID_1566834391" MODIFIED="1351543382201" TEXT="Whether or not to pre-allocate shall be configurable">
175 <font NAME="Dialog" SIZE="12"/>
176 <icon BUILTIN="messagebox_warning"/>
180 <node COLOR="#00b439" CREATED="1346542205341" ID="ID_1815282250" MODIFIED="1351543382203" TEXT="Backup">
181 <edge STYLE="bezier" WIDTH="thin"/>
182 <font BOLD="true" NAME="Dialog" SIZE="16"/>
184 <node COLOR="#00b439" CREATED="1351428245294" ID="ID_406151794" MODIFIED="1351543382205" TEXT="Restore">
185 <edge STYLE="bezier" WIDTH="thin"/>
186 <font BOLD="true" NAME="Dialog" SIZE="16"/>
188 <node COLOR="#00b439" CREATED="1346540984018" ID="ID_91063389" MODIFIED="1351543382207" TEXT="Repairing">
189 <edge STYLE="bezier" WIDTH="thin"/>
190 <font BOLD="true" NAME="Dialog" SIZE="16"/>
192 <node COLOR="#00b439" CREATED="1346542219500" ID="ID_1719264500" MODIFIED="1351543382210" TEXT="Export/import">
193 <edge STYLE="bezier" WIDTH="thin"/>
194 <font BOLD="true" NAME="Dialog" SIZE="16"/>
196 <node COLOR="#00b439" CREATED="1346542873181" ID="ID_1244214807" MODIFIED="1351543382219" TEXT="Access control lines (ACLs)">
197 <edge STYLE="bezier" WIDTH="thin"/>
198 <font BOLD="true" NAME="Dialog" SIZE="16"/>
199 <node COLOR="#990000" CREATED="1346543086304" ID="ID_715669246" MODIFIED="1351543382220" TEXT="Simple/efficient handling">
200 <font NAME="Dialog" SIZE="14"/>
201 <node COLOR="#111111" CREATED="1346543828043" ID="ID_1393579745" MODIFIED="1351543382221" TEXT="Easy to setup/understand">
202 <font NAME="Dialog" SIZE="12"/>
204 <node COLOR="#111111" CREATED="1346543833777" ID="ID_1666577328" MODIFIED="1351543382221" TEXT="Will be applied after user right is applied">
205 <font NAME="Dialog" SIZE="12"/>
207 <node COLOR="#111111" CREATED="1351194484514" ID="ID_1023883960" MODIFIED="1351543382222" TEXT="No inheriting of "deny"">
208 <node COLOR="#111111" CREATED="1351194496066" ID="ID_220472850" MODIFIED="1351543382223" TEXT="This allows a "deny" on a database but explicit "allow" on a specific table"/>
209 <node COLOR="#111111" CREATED="1351194524085" ID="ID_238013702" MODIFIED="1351543382223" TEXT="Inheriting is complex to most users">
210 <icon BUILTIN="messagebox_warning"/>
214 <node COLOR="#990000" CREATED="1346544634215" ID="ID_1252035348" MODIFIED="1351543382224" TEXT="Cannot be granted to users/groups">
215 <font NAME="Dialog" SIZE="14"/>
216 <node COLOR="#111111" CREATED="1346544652115" ID="ID_1409012789" MODIFIED="1351543382229" TEXT="ACLs are applied on actual data">
217 <font NAME="Dialog" SIZE="12"/>
218 <icon BUILTIN="idea"/>
220 <node COLOR="#111111" CREATED="1351194051755" ID="ID_258640474" MODIFIED="1351543382230" TEXT="Users/groups already have their rights"/>
222 <node COLOR="#990000" CREATED="1346542862886" ID="ID_1377944107" MODIFIED="1351543382231" TEXT="Allow/deny">
223 <font BOLD="true" NAME="Dialog" SIZE="14"/>
224 <node COLOR="#111111" CREATED="1351193968804" ID="ID_1284781899" MODIFIED="1351543382231" TEXT="!General">
225 <font BOLD="true" NAME="Dialog" SIZE="12"/>
227 <node COLOR="#111111" CREATED="1346543020963" ID="ID_1584034049" MODIFIED="1351543382232" TEXT="Per database">
228 <font NAME="Dialog" SIZE="12"/>
229 <node COLOR="#111111" CREATED="1351194207760" ID="ID_1114145881" MODIFIED="1351543382232" TEXT="Allow full access to database">
230 <node COLOR="#111111" CREATED="1351194258627" ID="ID_220793877" MODIFIED="1351543382232" TEXT="Including meta data"/>
231 <node COLOR="#111111" CREATED="1351194218730" ID="ID_569241974" MODIFIED="1351543382233" TEXT="Can be limited by individual deny-rules on table/dataset/meta data"/>
233 <node COLOR="#111111" CREATED="1351194275866" ID="ID_1067915243" MODIFIED="1351543382233" TEXT="Deny access to database">
234 <node COLOR="#111111" CREATED="1351194319254" ID="ID_1863319723" MODIFIED="1351543382234" TEXT="Can be explicitly lifted (allowed) to specific tables/datasets or meta data"/>
235 <node COLOR="#111111" CREATED="1351194362422" ID="ID_657979229" MODIFIED="1351543382234" TEXT="Need only to be given on databases where the user/group is assigned to"/>
238 <node COLOR="#111111" CREATED="1346544588545" ID="ID_1060603060" MODIFIED="1351543382234" TEXT="Per table">
239 <font NAME="Dialog" SIZE="12"/>
241 <node COLOR="#111111" CREATED="1346544593040" ID="ID_498987426" MODIFIED="1351543382235" TEXT="Per dataset">
242 <font NAME="Dialog" SIZE="12"/>
244 <node COLOR="#111111" CREATED="1346544597826" ID="ID_1489506665" MODIFIED="1351543382235" TEXT="On meta data">
245 <font NAME="Dialog" SIZE="12"/>
247 <node COLOR="#111111" CREATED="1346543051971" ID="ID_1181528770" MODIFIED="1351543382236" TEXT="Global locks">
248 <font NAME="Dialog" SIZE="12"/>
249 <icon BUILTIN="help"/>
253 <node COLOR="#00b439" CREATED="1346542946678" ID="ID_635141767" MODIFIED="1351543382238" TEXT="Credentials">
254 <edge STYLE="bezier" WIDTH="thin"/>
255 <font BOLD="true" NAME="Dialog" SIZE="16"/>
256 <node COLOR="#990000" CREATED="1351196679021" ID="ID_1304447645" MODIFIED="1351543382242" TEXT="!General">
257 <font BOLD="true" NAME="Dialog" SIZE="14"/>
258 <node COLOR="#111111" CREATED="1351194072214" ID="ID_551895161" MODIFIED="1351543382243" TEXT="Read/write permissions"/>
259 <node COLOR="#111111" CREATED="1351194859574" ID="ID_1266631298" MODIFIED="1351543382243" TEXT="A "write" always contains "read""/>
261 <node COLOR="#990000" CREATED="1346542967309" ID="ID_646140737" MODIFIED="1351543382244" TEXT="Users">
262 <font BOLD="true" NAME="Dialog" SIZE="14"/>
263 <icon BUILTIN="male2"/>
264 <node COLOR="#111111" CREATED="1346543214102" ID="ID_1848076613" MODIFIED="1351543382279" TEXT="Have login and password">
265 <font NAME="Dialog" SIZE="12"/>
266 <node COLOR="#111111" CREATED="1346544994599" ID="ID_1995049582" MODIFIED="1351543382280" TEXT="Logins are all lower-case">
267 <font NAME="Dialog" SIZE="12"/>
268 <node COLOR="#111111" CREATED="1346545017357" ID="ID_212018713" MODIFIED="1351543382281" TEXT="Upper-case will be converted">
269 <font NAME="Dialog" SIZE="12"/>
270 <icon BUILTIN="idea"/>
273 <node COLOR="#111111" CREATED="1346543256538" ID="ID_846939152" MODIFIED="1351543382286" TEXT="Passwords shall be hashed">
274 <font NAME="Dialog" SIZE="12"/>
275 <node COLOR="#111111" CREATED="1351193654941" ID="ID_627546410" MODIFIED="1351543382287" TEXT="And salted for better security">
276 <icon BUILTIN="messagebox_warning"/>
280 <node COLOR="#111111" CREATED="1346543274276" ID="ID_5506266" MODIFIED="1351543382288" TEXT="Can be locked by "manager" user">
281 <font NAME="Dialog" SIZE="12"/>
283 <node COLOR="#111111" CREATED="1346543292790" ID="ID_1559296603" MODIFIED="1351543382288" TEXT="Can be given individual rights">
284 <font NAME="Dialog" SIZE="12"/>
287 <node COLOR="#990000" CREATED="1346542969666" ID="ID_763972336" MODIFIED="1351543382289" TEXT="Groups">
288 <font BOLD="true" NAME="Dialog" SIZE="14"/>
289 <icon BUILTIN="group"/>
290 <node COLOR="#111111" CREATED="1346545053397" ID="ID_1141642632" MODIFIED="1351545177859" TEXT="A group "bundles" one or more users">
291 <font NAME="Dialog" SIZE="12"/>
293 <node COLOR="#111111" CREATED="1351197562371" ID="ID_749243651" MODIFIED="1351543382290" TEXT="Can be assigned to groups again"/>
294 <node COLOR="#111111" CREATED="1351197567598" ID="ID_1524054475" MODIFIED="1351543382291" TEXT="A "global" group exist for special purposes"/>
296 <node COLOR="#990000" CREATED="1346543178121" ID="ID_724029672" MODIFIED="1351543382297" TEXT="Organized in own database">
297 <font NAME="Dialog" SIZE="14"/>
298 <node COLOR="#111111" CREATED="1351192911199" ID="ID_1402804927" MODIFIED="1351543382298" TEXT="Which means that the credential data is stored in a database again">
299 <icon BUILTIN="idea"/>
301 <node COLOR="#111111" CREATED="1351544575025" ID="ID_1968809796" MODIFIED="1351544581416" TEXT="Easier handling (again)"/>
302 <node COLOR="#111111" CREATED="1351544936169" ID="ID_67061620" MODIFIED="1351544950397" TEXT="First initialization of database system?">
303 <icon BUILTIN="help"/>
304 <node COLOR="#111111" CREATED="1351544982793" ID="ID_6707182" MODIFIED="1351544996606" TEXT="Requires an "internal" user">
305 <node COLOR="#111111" CREATED="1351545001047" ID="ID_1394818716" MODIFIED="1351545008069" TEXT="That user must be assigned to global group"/>
306 <node COLOR="#111111" CREATED="1351545013868" ID="ID_507688498" MODIFIED="1351545043788" TEXT="Is only used by the database thread"/>
307 <node COLOR="#111111" CREATED="1351545065552" ID="ID_184880847" MODIFIED="1351545075565" TEXT="Possible name: lfdb">
308 <icon BUILTIN="help"/>
312 <node COLOR="#111111" CREATED="1351544164269" ID="ID_918353657" MODIFIED="1351544223107" TEXT="Possible database/table structure">
313 <node COLOR="#111111" CREATED="1346545100845" ID="ID_881426212" MODIFIED="1351544266194" TEXT=""user"">
314 <font NAME="Dialog" SIZE="12"/>
315 <node COLOR="#111111" CREATED="1351544236614" ID="ID_1451327618" MODIFIED="1351544340210" TEXT="Is the table storing user logins"/>
316 <node COLOR="#111111" CREATED="1351544381697" ID="ID_653321506" MODIFIED="1351544383283" TEXT="user_id"/>
317 <node COLOR="#111111" CREATED="1351544175968" ID="ID_1966019432" MODIFIED="1351544178285" TEXT="login"/>
318 <node COLOR="#111111" CREATED="1351544178825" ID="ID_405484122" MODIFIED="1351544181131" TEXT="password"/>
319 <node COLOR="#111111" CREATED="1351544250857" ID="ID_492400481" MODIFIED="1351544253226" TEXT="email"/>
321 <node COLOR="#111111" CREATED="1351544211817" ID="ID_1700400171" MODIFIED="1351544271204" TEXT=""user_group"">
322 <node COLOR="#111111" CREATED="1351544361570" ID="ID_1212060506" MODIFIED="1351544370413" TEXT="Is the table storing user->group assignments"/>
323 <node COLOR="#111111" CREATED="1351544373396" ID="ID_1481968391" MODIFIED="1351544379254" TEXT="user_id"/>
324 <node COLOR="#111111" CREATED="1351544384984" ID="ID_1459577988" MODIFIED="1351544387008" TEXT="group_id"/>
326 <node COLOR="#111111" CREATED="1346545111187" ID="ID_1152871136" MODIFIED="1351544268479" TEXT=""group"">
327 <font NAME="Dialog" SIZE="12"/>
328 <node COLOR="#111111" CREATED="1351544342338" ID="ID_1293481973" MODIFIED="1351544349398" TEXT="Is the table storing group data"/>
329 <node COLOR="#111111" CREATED="1351544613213" ID="ID_1243612439" MODIFIED="1351544624664" TEXT="Does NOT include the global group">
330 <node COLOR="#111111" CREATED="1351544626040" ID="ID_265048068" MODIFIED="1351544634074" TEXT="As it is a virtual and not a real group"/>
332 <node COLOR="#111111" CREATED="1351544393019" ID="ID_1726325943" MODIFIED="1351544395159" TEXT="group_id"/>
333 <node COLOR="#111111" CREATED="1351544395739" ID="ID_635178451" MODIFIED="1351544397888" TEXT="group_name"/>
334 <node COLOR="#111111" CREATED="1351544398216" ID="ID_382786843" MODIFIED="1351544403299" TEXT="group_description"/>
336 <node COLOR="#111111" CREATED="1351544216504" ID="ID_1738453623" MODIFIED="1351544269904" TEXT=""group_group"">
337 <node COLOR="#111111" CREATED="1351544351181" ID="ID_599303970" MODIFIED="1351544360330" TEXT="Is the table storing group->group assignments"/>
338 <node COLOR="#111111" CREATED="1351544406965" ID="ID_1615516830" MODIFIED="1351544411052" TEXT="group_id"/>
339 <node COLOR="#111111" CREATED="1351544411256" ID="ID_1460964222" MODIFIED="1351544414789" TEXT="group_parent_id"/>
344 <node COLOR="#00b439" CREATED="1346543357333" ID="ID_1568958248" MODIFIED="1351543382305" TEXT="Rights management">
345 <edge STYLE="bezier" WIDTH="thin"/>
346 <font BOLD="true" NAME="Dialog" SIZE="16"/>
347 <node COLOR="#990000" CREATED="1351197505756" ID="ID_1907836084" MODIFIED="1351543382306" TEXT="!All rights">
348 <font BOLD="true" NAME="Dialog" SIZE="14"/>
349 <node COLOR="#111111" CREATED="1351417335847" ID="ID_423508453" MODIFIED="1351543382306" TEXT="Administrative rights">
350 <node COLOR="#111111" CREATED="1351414431711" ID="ID_919298037" MODIFIED="1351543382307" TEXT="Admin right">
351 <node COLOR="#111111" CREATED="1351414439390" ID="ID_1303579675" MODIFIED="1351543382307" TEXT="Allows granting of "grant" right"/>
352 <node COLOR="#111111" CREATED="1351414455058" ID="ID_1840004900" MODIFIED="1351543382314" TEXT="Also allows granting of all other rights"/>
353 <node COLOR="#111111" CREATED="1351414526309" ID="ID_1172358466" MODIFIED="1351543382314" TEXT="Allows "raw" access on "users" and "groups" tables"/>
355 <node COLOR="#111111" CREATED="1351417508141" ID="ID_1318972262" MODIFIED="1351543382315" TEXT="Backup/restore">
356 <node COLOR="#111111" CREATED="1351197520411" ID="ID_1639171411" MODIFIED="1351543382315" TEXT="Backup">
357 <node COLOR="#111111" CREATED="1351197529585" ID="ID_713102458" MODIFIED="1351543382316" TEXT="Is alias for global read"/>
358 <node COLOR="#111111" CREATED="1351197586410" ID="ID_774969103" MODIFIED="1351543382316" TEXT="Assigns user with "global" group and grants "read""/>
360 <node COLOR="#111111" CREATED="1351197522904" ID="ID_622438885" MODIFIED="1351543382317" TEXT="Restore">
361 <node COLOR="#111111" CREATED="1351197619098" ID="ID_1955108181" MODIFIED="1351543382322" TEXT="Is alias for global write"/>
362 <node COLOR="#111111" CREATED="1351197628366" ID="ID_498643774" MODIFIED="1351543382323" TEXT="Assigns user with "global" group and grants "write" but denies "read""/>
363 <node COLOR="#111111" CREATED="1351197658864" ID="ID_97541972" MODIFIED="1351543382324" TEXT="Depends on "enable overwrite existing data" flag">
364 <node COLOR="#111111" CREATED="1351197724171" ID="ID_362869875" MODIFIED="1351543382324" TEXT="Enabled means overwrite existing data on restore"/>
365 <node COLOR="#111111" CREATED="1351197737846" ID="ID_1126935405" MODIFIED="1351543382325" TEXT="Disabled means abort (throw exception) on already existing data"/>
369 <node COLOR="#111111" CREATED="1351197850490" ID="ID_526181073" MODIFIED="1351543382325" TEXT="Grant">
370 <node COLOR="#111111" CREATED="1351414356302" ID="ID_984587275" MODIFIED="1351543382326" TEXT="Allows a user/group to grant rights to other groups/user"/>
371 <node COLOR="#111111" CREATED="1351414378568" ID="ID_293085540" MODIFIED="1351543382332" TEXT="Group-granting and user-granting are separated "sub rights""/>
372 <node COLOR="#111111" CREATED="1351414409838" ID="ID_1420073018" MODIFIED="1351543382332" TEXT="Grant cannot be granted by this right"/>
374 <node COLOR="#111111" CREATED="1351417722510" ID="ID_420712883" MODIFIED="1351543382333" TEXT="Manager">
375 <node COLOR="#111111" CREATED="1351417725984" ID="ID_1034578317" MODIFIED="1351543382333" TEXT="Can perform user operations">
376 <node COLOR="#111111" CREATED="1351417757906" ID="ID_633511292" MODIFIED="1351543382334" TEXT="Create new user"/>
377 <node COLOR="#111111" CREATED="1351417763157" ID="ID_679917616" MODIFIED="1351543382335" TEXT="Change user login/password"/>
378 <node COLOR="#111111" CREATED="1351438181271" ID="ID_236433799" MODIFIED="1351543382335" TEXT="Lock user accounts"/>
379 <node COLOR="#111111" CREATED="1351417774930" ID="ID_1135136157" MODIFIED="1351543382336" TEXT="Delete user"/>
381 <node COLOR="#111111" CREATED="1351417849819" ID="ID_526335003" MODIFIED="1351543382340" TEXT="Can perform group operations">
382 <node COLOR="#111111" CREATED="1351417768294" ID="ID_170780309" MODIFIED="1351543382341" TEXT="Create new group"/>
383 <node COLOR="#111111" CREATED="1351417778585" ID="ID_574094456" MODIFIED="1351543382341" TEXT="Change group data">
384 <node COLOR="#111111" CREATED="1351417800291" ID="ID_870367924" MODIFIED="1351543382342" TEXT="Not granting/revoking rights"/>
386 <node COLOR="#111111" CREATED="1351417868683" ID="ID_1771074246" MODIFIED="1351543382346" TEXT="Assign user to groups"/>
387 <node COLOR="#111111" CREATED="1351417881593" ID="ID_1078420209" MODIFIED="1351543382347" TEXT="Assign groups to groups"/>
389 <node COLOR="#111111" CREATED="1351417906687" ID="ID_732338375" MODIFIED="1351543382348" TEXT="May be allowed to grant some rights">
390 <node COLOR="#111111" CREATED="1351417926773" ID="ID_1982721061" MODIFIED="1351543382348" TEXT="Only operational rights as read/write"/>
391 <node COLOR="#111111" CREATED="1351417946633" ID="ID_1912508768" MODIFIED="1351543382349" TEXT="This must be granted by account with 'admin' right"/>
392 <node COLOR="#111111" CREATED="1351418015596" ID="ID_195318139" MODIFIED="1351543382349" TEXT="Backup/restore or maintenance are "administrator tasks""/>
393 <node COLOR="#111111" CREATED="1351418061584" ID="ID_1698857234" MODIFIED="1351543382350" TEXT="This also effects creating new users/groups"/>
397 <node COLOR="#111111" CREATED="1351417309178" ID="ID_1420038864" MODIFIED="1351543382351" TEXT="Maintenance rights">
398 <node COLOR="#111111" CREATED="1351197861354" ID="ID_806552195" MODIFIED="1351543382352" TEXT="Maintenance">
399 <node COLOR="#111111" CREATED="1351197883240" ID="ID_1166059936" MODIFIED="1351543382353" TEXT="Is like "repair""/>
400 <node COLOR="#111111" CREATED="1351198028347" ID="ID_465537829" MODIFIED="1352492373136" TEXT="Try to fix all organization units and data">
401 <node COLOR="#111111" CREATED="1351198080749" ID="ID_427816349" MODIFIED="1351543382354" TEXT="On data itself mean low-level "bitwise" repair"/>
402 <node COLOR="#111111" CREATED="1351198097306" ID="ID_1960293341" MODIFIED="1351543382355" TEXT="Rebuild indexes"/>
403 <node COLOR="#111111" CREATED="1351198109510" ID="ID_526103275" MODIFIED="1351543382355" TEXT="Try to fix invalid markers or discard entry"/>
404 <node COLOR="#111111" CREATED="1351198133437" ID="ID_1474526350" MODIFIED="1351543382356" TEXT="Reporting">
405 <node COLOR="#111111" CREATED="1351198158876" ID="ID_671863662" MODIFIED="1351543382356" TEXT="Default is report only unrecoverable errors"/>
406 <node COLOR="#111111" CREATED="1351198141092" ID="ID_1921812325" MODIFIED="1351543382357" TEXT="Successes are reported if enabled"/>
407 <node COLOR="#111111" CREATED="1351198203194" ID="ID_625284350" MODIFIED="1351543382358" TEXT="Healthy data is only reported if enabled"/>
410 <node COLOR="#111111" CREATED="1351197890663" ID="ID_1386333189" MODIFIED="1351543382359" TEXT="Does NOT include backup/restore">
411 <node COLOR="#111111" CREATED="1351197900552" ID="ID_1165271873" MODIFIED="1351543382360" TEXT="As they are very "fatal" rights"/>
412 <node COLOR="#111111" CREATED="1351416230234" ID="ID_959928302" MODIFIED="1351543382360" TEXT="Repairing a database/table/dataset is not creating a backup or restoring it from a backup"/>
413 <node COLOR="#111111" CREATED="1351416021686" ID="ID_843955993" MODIFIED="1351543382361" TEXT="Rights are granted for a specific purpose">
414 <icon BUILTIN="idea"/>
418 <node COLOR="#111111" CREATED="1351417556730" ID="ID_249764778" MODIFIED="1351543382362" TEXT="Change meta data">
419 <node COLOR="#111111" CREATED="1351417571149" ID="ID_373360318" MODIFIED="1351543382362" TEXT="Change comments"/>
420 <node COLOR="#111111" CREATED="1351417576628" ID="ID_277109768" MODIFIED="1351543382363" TEXT="Operations on organization units">
421 <node COLOR="#111111" CREATED="1351417605358" ID="ID_1367076513" MODIFIED="1352492404537" TEXT="Create new OU"/>
422 <node COLOR="#111111" CREATED="1351417608041" ID="ID_96066195" MODIFIED="1351543382364" TEXT="Assign to existing OUs"/>
423 <node COLOR="#111111" CREATED="1351417613075" ID="ID_979158335" MODIFIED="1351543382365" TEXT="Remove assignments"/>
424 <node COLOR="#111111" CREATED="1351418446614" ID="ID_869049608" MODIFIED="1351543382366" TEXT="Shall it be possible to allow "sub rights"?">
425 <icon BUILTIN="idea"/>
426 <icon BUILTIN="help"/>
427 <node COLOR="#111111" CREATED="1351418498628" ID="ID_644876629" MODIFIED="1351543382367" TEXT="These rights then can be explicitly granted"/>
428 <node COLOR="#111111" CREATED="1351419720614" ID="ID_713553345" MODIFIED="1351543382371" TEXT="This allows that users/groups can be allowed to create a new OU but not remove assignments"/>
430 <node COLOR="#111111" CREATED="1351419155624" ID="ID_261825491" MODIFIED="1351543382384" TEXT="Examples">
431 <font ITALIC="true" NAME="Dialog" SIZE="12"/>
432 <node COLOR="#111111" CREATED="1351419124431" ID="ID_1802983353" MODIFIED="1351543382394" TEXT="Allows the maintainer to remove wrongly assigned dataset->table relations"/>
437 <node COLOR="#111111" CREATED="1351417359445" ID="ID_138100526" MODIFIED="1351543382395" STYLE="fork" TEXT="Operational rights">
438 <node COLOR="#111111" CREATED="1351420366875" ID="ID_1925185006" MODIFIED="1351543382395" TEXT="!General">
439 <font BOLD="true" NAME="Dialog" SIZE="12"/>
440 <node COLOR="#111111" CREATED="1351420371817" ID="ID_516129886" MODIFIED="1351543382396" TEXT="Are mostly "hidden" in other rights">
441 <node COLOR="#111111" CREATED="1351420416605" ID="ID_1116610850" MODIFIED="1351543382396" TEXT="The "backup" right needs reading all data"/>
442 <node COLOR="#111111" CREATED="1351420431521" ID="ID_740599145" MODIFIED="1351543382397" TEXT="The "restore" right needs writing all data"/>
443 <node COLOR="#111111" CREATED="1351420514165" ID="ID_113690582" MODIFIED="1351543382397" TEXT="Are "hidden rights""/>
445 <node COLOR="#111111" CREATED="1351420383087" ID="ID_736004299" MODIFIED="1351543382398" TEXT="But still can be revoked for dataset/table/database if an other right grants it indirectly ("hidden right")"/>
447 <node COLOR="#111111" CREATED="1351197515935" ID="ID_1621561435" MODIFIED="1351543382417" TEXT="Read">
448 <node COLOR="#111111" CREATED="1351197810067" ID="ID_354306674" MODIFIED="1351543382417" TEXT="Is "read-only" access on data"/>
449 <node COLOR="#111111" CREATED="1351416089887" ID="ID_1905193486" MODIFIED="1351543382418" TEXT="This right "hides" write access to some meta data as it is required to update them ">
450 <icon BUILTIN="messagebox_warning"/>
451 <node COLOR="#111111" CREATED="1351416104837" ID="ID_1762222867" MODIFIED="1351543382419" TEXT="Indexes"/>
452 <node COLOR="#111111" CREATED="1351416124856" ID="ID_235376383" MODIFIED="1351543382419" TEXT="Read/write Counters">
453 <node COLOR="#111111" CREATED="1351422130014" ID="ID_144976403" MODIFIED="1351543382427" TEXT="Amount of read operations can be updated"/>
454 <node COLOR="#111111" CREATED="1351422142022" ID="ID_1456878712" MODIFIED="1351543382428" TEXT="All other counters may only be read"/>
455 <node COLOR="#111111" CREATED="1351416149741" ID="ID_647032878" MODIFIED="1351543382428" TEXT="Only if statistics is enabled"/>
456 <node COLOR="#111111" CREATED="1351416160133" ID="ID_157111861" MODIFIED="1351543382429" TEXT="Are "expensive" in resources"/>
458 <node COLOR="#111111" CREATED="1351416128996" ID="ID_1890290411" MODIFIED="1351543382429" TEXT="Read timestamps">
459 <node COLOR="#111111" CREATED="1351422105292" ID="ID_1747401087" MODIFIED="1351543382429" TEXT="Inserted"/>
460 <node COLOR="#111111" CREATED="1351416134462" ID="ID_1723745972" MODIFIED="1351543382430" TEXT="Last updated"/>
461 <node COLOR="#111111" CREATED="1351416139106" ID="ID_292505836" MODIFIED="1351543382430" TEXT="Last deleted?">
462 <icon BUILTIN="help"/>
467 <node COLOR="#111111" CREATED="1351197518197" ID="ID_1201922776" MODIFIED="1351543382431" TEXT="Write">
468 <node COLOR="#111111" CREATED="1351422753457" ID="ID_440643089" MODIFIED="1351543382431" TEXT="Allows only writing data to OU "data entry""/>
469 <node COLOR="#111111" CREATED="1351422775123" ID="ID_1449157566" MODIFIED="1351543382432" TEXT="Hides updating meta data">
470 <icon BUILTIN="yes"/>
474 <node COLOR="#111111" CREATED="1351417375404" ID="ID_505268897" MODIFIED="1351543382432" TEXT="Virtual rights">
475 <node COLOR="#111111" CREATED="1351418920662" ID="ID_601695034" MODIFIED="1351543382439" TEXT="!General">
476 <font BOLD="true" NAME="Dialog" SIZE="12"/>
477 <node COLOR="#111111" CREATED="1351418924366" ID="ID_1224339320" MODIFIED="1351543382440" TEXT="Are like some rights grouped together"/>
478 <node COLOR="#111111" CREATED="1351422285487" ID="ID_1732190247" MODIFIED="1351543382441" TEXT="Easier granting of detailed rights"/>
479 <node COLOR="#111111" CREATED="1351422388826" ID="ID_1718814417" MODIFIED="1351543382441" TEXT="May be managed in distinct database table?">
480 <icon BUILTIN="idea"/>
481 <icon BUILTIN="help"/>
484 <node COLOR="#111111" CREATED="1351198479888" ID="ID_1895327534" MODIFIED="1351543382442" TEXT="All rights">
485 <font NAME="Dialog" SIZE="12"/>
486 <node COLOR="#111111" CREATED="1351198483566" ID="ID_173413782" MODIFIED="1351543382442" TEXT="Includes all above rights ("super" user/group)"/>
487 <node COLOR="#111111" CREATED="1351416203435" ID="ID_1608302725" MODIFIED="1351543382443" TEXT="More rights can be added on a as-needed basis"/>
489 <node COLOR="#111111" CREATED="1351420574492" ID="ID_693228780" MODIFIED="1351543382443" TEXT="Operational right">
490 <node COLOR="#111111" CREATED="1351420577097" ID="ID_1390685016" MODIFIED="1351543382451" TEXT="Grants "read"/"write" rights together"/>
491 <node COLOR="#111111" CREATED="1351420586275" ID="ID_646378564" MODIFIED="1351543382452" TEXT="Mostly desired for web applications that "needs an access to database""/>
495 <node COLOR="#990000" CREATED="1346543367263" ID="ID_291953306" MODIFIED="1351543382454" TEXT="For users and groups separately">
496 <font NAME="Dialog" SIZE="14"/>
497 <node COLOR="#111111" CREATED="1346543562255" ID="ID_191993514" MODIFIED="1351543382454" TEXT="Group right has highest check priority">
498 <font NAME="Dialog" SIZE="12"/>
499 <node COLOR="#111111" CREATED="1346543652003" ID="ID_3658619" MODIFIED="1351543382455" TEXT="Always checked first">
500 <font NAME="Dialog" SIZE="12"/>
502 <node COLOR="#111111" CREATED="1346543656385" ID="ID_325140622" MODIFIED="1351543382455" TEXT="Users may have no group">
503 <font NAME="Dialog" SIZE="12"/>
504 <icon BUILTIN="help"/>
507 <node COLOR="#111111" CREATED="1346543618004" ID="ID_898889501" MODIFIED="1351543382456" TEXT="User right has high check priority">
508 <font NAME="Dialog" SIZE="12"/>
509 <node COLOR="#111111" CREATED="1346543640203" ID="ID_1000432904" MODIFIED="1351543382457" TEXT="Always checked after group right is checked">
510 <font NAME="Dialog" SIZE="12"/>
512 <node COLOR="#111111" CREATED="1346543695896" ID="ID_522972973" MODIFIED="1351543382457" TEXT="May grant/deny already granted/denied group right">
513 <font NAME="Dialog" SIZE="12"/>
515 <node COLOR="#111111" CREATED="1346543716511" ID="ID_1897248161" MODIFIED="1351543382458" TEXT="Overwrites group right">
516 <font NAME="Dialog" SIZE="12"/>
518 <node COLOR="#111111" CREATED="1346543751887" ID="ID_848139857" MODIFIED="1351543382458" TEXT="ACLs may further restrict/open access to data">
519 <font NAME="Dialog" SIZE="12"/>
523 <node COLOR="#990000" CREATED="1346543480076" ID="ID_1946578818" MODIFIED="1351543382459" TEXT="Rights are organized in own database system">
524 <font NAME="Dialog" SIZE="14"/>
525 <node COLOR="#111111" CREATED="1351419909291" ID="ID_1894390823" MODIFIED="1351544885112" TEXT="This allows easier maintenance of the system">
526 <icon BUILTIN="button_ok"/>
528 <node COLOR="#111111" CREATED="1351419958176" ID="ID_1718154974" MODIFIED="1351544891624" TEXT="Separated systems must be maintained separately">
529 <icon BUILTIN="button_cancel"/>
530 <node COLOR="#111111" CREATED="1351419994894" ID="ID_430624148" MODIFIED="1351543382461" TEXT="This may lead to more complex code"/>
531 <node COLOR="#111111" CREATED="1351420005877" ID="ID_116597279" MODIFIED="1351543382461" TEXT="Adds "overhead""/>
534 <node COLOR="#990000" CREATED="1351197472604" ID="ID_1401721994" MODIFIED="1351543382481" TEXT="Rights are granted for specific purposes">
535 <font BOLD="true" NAME="Dialog" SIZE="14"/>
536 <node COLOR="#111111" CREATED="1351415169578" ID="ID_1938086114" MODIFIED="1351543382481" TEXT="Other rights are only explicitly included">
537 <node COLOR="#111111" CREATED="1351415194273" ID="ID_1694444359" MODIFIED="1351543382482" TEXT="For example, 'admin' right does not include all rights"/>
539 <node COLOR="#111111" CREATED="1351420264253" ID="ID_1910938880" MODIFIED="1351543382483" TEXT="A user has only specific jobs to perform"/>
542 <node COLOR="#00b439" CREATED="1346543397785" ID="ID_1513377166" MODIFIED="1351543382484" TEXT="File format upgrade">
543 <edge STYLE="bezier" WIDTH="thin"/>
544 <font BOLD="true" NAME="Dialog" SIZE="16"/>
547 <node COLOR="#0033ff" CREATED="1346544139878" ID="ID_830024329" MODIFIED="1351543382501" POSITION="right" TEXT="Database modes">
548 <edge STYLE="sharp_bezier" WIDTH="8"/>
549 <font BOLD="true" NAME="Dialog" SIZE="18"/>
550 <node COLOR="#00b439" CREATED="1346544156427" ID="ID_762269377" MODIFIED="1351543382503" TEXT="Host-only mode">
551 <edge STYLE="bezier" WIDTH="thin"/>
552 <font BOLD="true" NAME="Dialog" SIZE="16"/>
554 <node COLOR="#00b439" CREATED="1346544171378" ID="ID_1639603684" MODIFIED="1351543382505" TEXT="Distributed mode">
555 <edge STYLE="bezier" WIDTH="thin"/>
556 <font BOLD="true" NAME="Dialog" SIZE="16"/>
558 <node COLOR="#00b439" CREATED="1346544177053" ID="ID_634850175" MODIFIED="1351543382514" TEXT="Master/slave mode">
559 <edge STYLE="bezier" WIDTH="thin"/>
560 <font BOLD="true" NAME="Dialog" SIZE="16"/>
563 <node COLOR="#0033ff" CREATED="1346541018575" ID="ID_1636290985" MODIFIED="1351543382515" POSITION="left" TEXT="Database layout">
564 <edge STYLE="sharp_bezier" WIDTH="8"/>
565 <font BOLD="true" NAME="Dialog" SIZE="18"/>
566 <node COLOR="#00b439" CREATED="1346541583143" ID="ID_1683424442" MODIFIED="1351546072253" TEXT="File layout/structure">
567 <edge STYLE="bezier" WIDTH="thin"/>
568 <linktarget COLOR="#b0b0b0" DESTINATION="ID_1683424442" ENDARROW="Default" ENDINCLINATION="-354;-231;" ID="Arrow_ID_230622914" SOURCE="ID_1172644330" STARTARROW="None" STARTINCLINATION="1261;0;"/>
569 <linktarget COLOR="#ff3333" DESTINATION="ID_1683424442" ENDARROW="Default" ENDINCLINATION="597;-489;" ID="Arrow_ID_453516147" SOURCE="ID_1188869385" STARTARROW="None" STARTINCLINATION="561;-255;"/>
570 <font BOLD="true" NAME="Dialog" SIZE="16"/>
571 <node COLOR="#990000" CREATED="1346541664448" ID="ID_822294662" MODIFIED="1351543382517" TEXT="Markers">
572 <font NAME="Dialog" SIZE="14"/>
574 <node COLOR="#990000" CREATED="1346541672628" ID="ID_583905834" MODIFIED="1351543382519" TEXT="Hashes">
575 <font NAME="Dialog" SIZE="14"/>
577 <node COLOR="#990000" CREATED="1346541859266" ID="ID_1734291476" MODIFIED="1351543382520" TEXT="Semi-transparent encryption">
578 <font NAME="Dialog" SIZE="14"/>
579 <icon BUILTIN="help"/>
581 <node COLOR="#990000" CREATED="1347804496515" ID="ID_529016713" MODIFIED="1351543382521" TEXT="In full binary format">
582 <font NAME="Dialog" SIZE="14"/>
585 <node COLOR="#00b439" CREATED="1346541645366" ID="ID_1921915270" MODIFIED="1351543382522" TEXT="Logical layers">
586 <edge STYLE="bezier" WIDTH="thin"/>
587 <font BOLD="true" NAME="Dialog" SIZE="16"/>
588 <node COLOR="#990000" CREATED="1349471389103" ID="ID_706206162" MODIFIED="1351543382522" TEXT="Data operation layer">
589 <font BOLD="true" NAME="Dialog" SIZE="14"/>
590 <node COLOR="#111111" CREATED="1349471456154" ID="ID_76306014" MODIFIED="1351543382523" TEXT="General ideas">
591 <font BOLD="true" NAME="Dialog" SIZE="12"/>
592 <node COLOR="#111111" CREATED="1349471465077" ID="ID_501648829" MODIFIED="1351543382524" TEXT="Allows the actual operations be performed on the underlaying layers"/>
593 <node COLOR="#111111" CREATED="1349471490973" ID="ID_1380474657" MODIFIED="1351543382524" TEXT=""Sees" the data in an abstract view from top"/>
594 <node COLOR="#111111" CREATED="1349471588889" ID="ID_337384700" MODIFIED="1351543382525" TEXT="Provides interfaces for database wrappers">
595 <node COLOR="#111111" CREATED="1349471613777" ID="ID_1475235292" MODIFIED="1351543382525" TEXT="Wrappers are like "communicators" or "translators" between programs logic and database system"/>
596 <node COLOR="#111111" CREATED="1349471691014" ID="ID_844553793" MODIFIED="1351543382531" TEXT="Makes rest of the application's logic unaware of how data is being stored"/>
599 <node COLOR="#111111" CREATED="1349471759169" ID="ID_1098844139" MODIFIED="1351543382531" TEXT="Reading operations">
600 <font BOLD="true" NAME="Dialog" SIZE="12"/>
601 <node COLOR="#111111" CREATED="1349471769180" ID="ID_309985267" MODIFIED="1351543382532" TEXT=""SELECT query"">
602 <node COLOR="#111111" CREATED="1349472068669" ID="ID_510859274" MODIFIED="1351543382532" TEXT="Reads data for given criteria"/>
604 <node COLOR="#111111" CREATED="1349471797957" ID="ID_431891804" MODIFIED="1351543382532" TEXT="Statistical "query"">
605 <node COLOR="#111111" CREATED="1349472178578" ID="ID_385531939" MODIFIED="1351543382533" TEXT="Is a special "SELECT" on statistical data structures"/>
606 <node COLOR="#111111" CREATED="1349472196310" ID="ID_54846469" MODIFIED="1351543382533" TEXT="Returns only statistical informations about the database">
607 <node COLOR="#111111" CREATED="1349472209113" ID="ID_841501457" MODIFIED="1351543382534" TEXT="Performance data"/>
608 <node COLOR="#111111" CREATED="1349472217426" ID="ID_10031981" MODIFIED="1351543382534" TEXT="Reliability data"/>
609 <node COLOR="#111111" CREATED="1349472235852" ID="ID_911956209" MODIFIED="1351543382535" TEXT="Cluster data"/>
613 <node COLOR="#111111" CREATED="1349471762461" ID="ID_885836001" MODIFIED="1351543382535" TEXT="Writing operations">
614 <font BOLD="true" NAME="Dialog" SIZE="12"/>
615 <node COLOR="#111111" CREATED="1349471830663" ID="ID_1011868420" MODIFIED="1351543382536" TEXT=""INSERT query"">
616 <node COLOR="#111111" CREATED="1349471867013" ID="ID_1139715779" MODIFIED="1351543382536" TEXT="Inserts new data into database"/>
617 <node COLOR="#111111" CREATED="1349472360681" ID="ID_1826680669" MODIFIED="1351543382536" TEXT="Can only be executed on tables"/>
619 <node COLOR="#111111" CREATED="1349471838097" ID="ID_1177546241" MODIFIED="1351543382537" TEXT=""UPDATE query"">
620 <node COLOR="#111111" CREATED="1349471887552" ID="ID_457519060" MODIFIED="1351543382537" TEXT="Updates tables to point to other datasets"/>
621 <node COLOR="#111111" CREATED="1349473559010" ID="ID_1756257034" MODIFIED="1351543382538" TEXT="Depends on "search criteria" and "update sets""/>
622 <node COLOR="#111111" CREATED="1349471907419" ID="ID_1538524835" MODIFIED="1351543382539" TEXT="The updated data will be inserted as new and then linked in the old table by removing links to old datasets"/>
624 <node COLOR="#111111" CREATED="1349471842169" ID="ID_18344331" MODIFIED="1351543382545" TEXT=""DELETE query"">
625 <node COLOR="#111111" CREATED="1349471988121" ID="ID_1473407996" MODIFIED="1351543382545" TEXT="Removes links in tables to desired datasets">
626 <node COLOR="#111111" CREATED="1349472867831" ID="ID_1114550090" MODIFIED="1351543382546" TEXT="This dataset may become orphaned as no table links to it"/>
628 <node COLOR="#111111" CREATED="1349473086909" ID="ID_1667737921" MODIFIED="1351543382546" TEXT="Can only be executed on tables and datasets">
629 <node COLOR="#111111" CREATED="1349473102816" ID="ID_154381298" MODIFIED="1351543382547" TEXT="Data entries cannot be deleted"/>
630 <node COLOR="#111111" CREATED="1349473122283" ID="ID_1465374495" MODIFIED="1351543382547" TEXT="Tables and datasets contain references, these can be safely deleted"/>
631 <node COLOR="#111111" CREATED="1349473145583" ID="ID_297113642" MODIFIED="1351543382547" TEXT="The actual data in entries is to risky to be deleted"/>
634 <node COLOR="#111111" CREATED="1349471851280" ID="ID_1734557834" MODIFIED="1351543382548" TEXT=""CREATE query"">
635 <node COLOR="#111111" CREATED="1349472792029" ID="ID_673029660" MODIFIED="1351543382548" TEXT="Creates new tables and their datasets including data entries"/>
636 <node COLOR="#111111" CREATED="1349472814141" ID="ID_287860817" MODIFIED="1351543382549" TEXT="Can only be executed on databases"/>
638 <node COLOR="#111111" CREATED="1349471861327" ID="ID_901246685" MODIFIED="1351543382549" TEXT=""ALTER query"">
639 <node COLOR="#111111" CREATED="1349472823216" ID="ID_119971166" MODIFIED="1351543382549" TEXT="Alters already existing meta data"/>
640 <node COLOR="#111111" CREATED="1349472838300" ID="ID_677610658" MODIFIED="1351543382550" TEXT="Can be executed on tables, datasets and data entries"/>
644 <node COLOR="#990000" CREATED="1348606511728" ID="ID_510434232" MODIFIED="1351543382550" TEXT="Data organization layer">
645 <font BOLD="true" NAME="Dialog" SIZE="14"/>
646 <node COLOR="#111111" CREATED="1348606958087" ID="ID_209767319" MODIFIED="1351543382551" TEXT="General ideas">
647 <font BOLD="true" NAME="Dialog" SIZE="12"/>
648 <node COLOR="#111111" CREATED="1351195467440" ID="ID_1963267153" MODIFIED="1351543382551" TEXT="Data "visibility windows"">
649 <font BOLD="true" NAME="Dialog" SIZE="12"/>
651 <node COLOR="#111111" CREATED="1348607025908" ID="ID_227286047" MODIFIED="1351543382552" TEXT="Organizes the data logically"/>
652 <node COLOR="#111111" CREATED="1348607120119" ID="ID_268845790" MODIFIED="1351543382552" TEXT="Is also a presentation layer"/>
653 <node COLOR="#111111" CREATED="1351196567613" ID="ID_1536278276" MODIFIED="1351543382552" TEXT="ACLs can be assigned from database to dataset"/>
655 <node COLOR="#111111" CREATED="1346541759057" ID="ID_1585210346" MODIFIED="1351543382553" TEXT="Databases">
656 <font NAME="Dialog" SIZE="12"/>
657 <node COLOR="#111111" CREATED="1347903412502" ID="ID_1372845377" MODIFIED="1351543382553" TEXT="Binded to storage engine"/>
658 <node COLOR="#111111" CREATED="1347909321412" ID="ID_863479559" MODIFIED="1351543382554" TEXT="Widest data-organizational unit">
659 <node COLOR="#111111" CREATED="1347909421889" ID="ID_439913085" MODIFIED="1351543382554" TEXT="Reduces the "view" on the datasets to a more narrow window"/>
660 <node COLOR="#111111" CREATED="1347913688217" ID="ID_122339721" MODIFIED="1351543382555" TEXT="Does not actually "frame"/reference datasets"/>
661 <node COLOR="#111111" CREATED="1347913713902" ID="ID_1362507526" MODIFIED="1351543382555" TEXT="Is like a "table set"">
662 <icon BUILTIN="idea"/>
665 <node COLOR="#111111" CREATED="1347909509562" ID="ID_1182941178" MODIFIED="1351543382555" TEXT="May be referenced by one or more tables">
666 <node COLOR="#111111" CREATED="1347909972081" ID="ID_1924830814" MODIFIED="1351543382556" TEXT="Loosely tied to tables"/>
667 <node COLOR="#111111" CREATED="1347910628050" ID="ID_714324325" MODIFIED="1351543382556" TEXT="May also reference one or more tables">
668 <node COLOR="#111111" CREATED="1347910657885" ID="ID_177348442" MODIFIED="1351543382557" TEXT="Must reference at least one table">
669 <icon BUILTIN="messagebox_warning"/>
672 <node COLOR="#111111" CREATED="1347913594401" ID="ID_1774040074" MODIFIED="1351543382557" TEXT="This allows redundancy independently from used storage engine">
673 <icon BUILTIN="idea"/>
676 <node COLOR="#111111" CREATED="1347910049440" ID="ID_1020368928" MODIFIED="1351543382558" TEXT="Names must be unique">
677 <node COLOR="#111111" CREATED="1347910742215" ID="ID_1950884571" MODIFIED="1351543382558" TEXT="Must be checked before creation"/>
678 <node COLOR="#111111" CREATED="1347910753733" ID="ID_884520385" MODIFIED="1351543382559" TEXT="Throws exception if already created"/>
679 <node COLOR="#111111" CREATED="1347910767254" ID="ID_1430258062" MODIFIED="1351543382559" TEXT="May result in delay/network load in distributed storage engines/modes"/>
681 <node COLOR="#111111" CREATED="1347910288552" ID="ID_402206776" MODIFIED="1351543382560" TEXT="Has unique descriptor">
682 <node COLOR="#111111" CREATED="1347910303396" ID="ID_79524194" MODIFIED="1351543382560" TEXT="Access hash">
683 <node COLOR="#111111" CREATED="1347911099129" ID="ID_600086806" MODIFIED="1351543382561" TEXT="Will be used to "loosely connect" to tables"/>
684 <node COLOR="#111111" CREATED="1347911116683" ID="ID_1207299244" MODIFIED="1351543382561" TEXT="Is the reference "key""/>
685 <node COLOR="#111111" CREATED="1347911511806" ID="ID_609124064" MODIFIED="1351543382561" TEXT="On backup, it will be renamed to name"/>
687 <node COLOR="#111111" CREATED="1347910329483" ID="ID_447818120" MODIFIED="1351543382562" TEXT="Database name">
688 <linktarget COLOR="#006600" DESTINATION="ID_447818120" ENDARROW="Default" ENDINCLINATION="602;0;" ID="Arrow_ID_1348995776" SOURCE="ID_636886196" STARTARROW="None" STARTINCLINATION="602;0;"/>
689 <node COLOR="#111111" CREATED="1347911129624" ID="ID_1190653673" MODIFIED="1351543382562" TEXT="Is an alias for the access hash"/>
690 <node COLOR="#111111" CREATED="1347911152786" ID="ID_687255923" MODIFIED="1351543382563" TEXT="Shall be used instead of access hash"/>
691 <node COLOR="#111111" CREATED="1347911173489" ID="ID_1903262880" MODIFIED="1351543382563" TEXT="Easier to remember"/>
692 <node COLOR="#111111" CREATED="1347911176927" ID="ID_1395998657" MODIFIED="1351543382564" TEXT="More compatibility with other engines"/>
693 <node COLOR="#111111" CREATED="1347911466507" ID="ID_1286712473" MODIFIED="1351543382564" TEXT="Hash may be different on other database nodes"/>
694 <node COLOR="#111111" CREATED="1347911497208" ID="ID_392374407" MODIFIED="1351543382565" TEXT="Will not be stored to backup"/>
696 <node COLOR="#111111" CREATED="1347910334182" ID="ID_1416170724" MODIFIED="1351543382565" TEXT="Used storage engine">
697 <node COLOR="#111111" CREATED="1347911698927" ID="ID_733668834" MODIFIED="1351543382565" TEXT="Depending on engine, includes more data">
698 <node COLOR="#111111" CREATED="1347911721828" ID="ID_304015451" MODIFIED="1351543382566" TEXT="For example storing nodes (federated)"/>
700 <node COLOR="#111111" CREATED="1347912377864" ID="ID_1882832880" MODIFIED="1351543382566" TEXT="Configuration entry per created database (name)"/>
702 <node COLOR="#111111" CREATED="1347914059340" ID="ID_1159292448" MODIFIED="1351543382567" TEXT="Handling flags">
703 <node COLOR="#111111" CREATED="1347914067226" ID="ID_1952362953" MODIFIED="1351543382567" TEXT="Crashed">
704 <node COLOR="#111111" CREATED="1347914143123" ID="ID_290890902" MODIFIED="1351543382567" TEXT="May be used if database file(s) is/are corrupted"/>
706 <node COLOR="#111111" CREATED="1347914083874" ID="ID_616495706" MODIFIED="1351543382568" TEXT="Locked">
707 <node COLOR="#111111" CREATED="1347914085358" ID="ID_1894484919" MODIFIED="1351543382568" TEXT="If supported by engine">
708 <icon BUILTIN="yes"/>
710 <node COLOR="#111111" CREATED="1347914124264" ID="ID_1553769192" MODIFIED="1351543382569" TEXT="Including lock owner"/>
712 <node COLOR="#111111" CREATED="1347914191205" ID="ID_1897033849" MODIFIED="1351543382569" TEXT="Disconnected">
713 <node COLOR="#111111" CREATED="1347914194446" ID="ID_482703840" MODIFIED="1351543382570" TEXT="If the storing node has disappeared"/>
714 <node COLOR="#111111" CREATED="1347914213558" ID="ID_1125895894" MODIFIED="1351543382570" TEXT="Exact timestamp of disconnection"/>
718 <node COLOR="#111111" CREATED="1347910365769" ID="ID_942539464" MODIFIED="1351543382571" TEXT="Comments"/>
720 <node COLOR="#111111" CREATED="1346541679742" ID="ID_807168097" MODIFIED="1351543382571" TEXT="Tables">
721 <font NAME="Dialog" SIZE="12"/>
722 <node COLOR="#111111" CREATED="1347909352134" ID="ID_884064974" MODIFIED="1351543382571" TEXT="Is not tied/connected to database"/>
723 <node COLOR="#111111" CREATED="1347909578469" ID="ID_490591838" MODIFIED="1351543382572" TEXT="Datasets/entries are loosely tied to it">
724 <node COLOR="#111111" CREATED="1347909590787" ID="ID_1725722751" MODIFIED="1351543382572" TEXT="Allows an other table to be created with same parts of first table"/>
725 <node COLOR="#111111" CREATED="1347909613555" ID="ID_330505832" MODIFIED="1351543382573" TEXT="Is based on hashing data entries/sets"/>
727 <node COLOR="#111111" CREATED="1347909748675" ID="ID_1135617270" MODIFIED="1351543382573" TEXT="Contains hashes to datasets">
728 <node COLOR="#111111" CREATED="1347909774238" ID="ID_1814781423" MODIFIED="1351543382575" TEXT="May NOT contain data set hashes">
729 <node COLOR="#111111" CREATED="1347909805034" ID="ID_458052280" MODIFIED="1351543382576" TEXT="This adds overload to updating table index">
730 <icon BUILTIN="idea"/>
734 <node COLOR="#111111" CREATED="1347909410931" ID="ID_1018281677" MODIFIED="1351543382576" TEXT="Middle-wide organizational unit">
735 <node COLOR="#111111" CREATED="1347915444065" ID="ID_795920292" MODIFIED="1351543382577" TEXT="Organizes one or more datasets in a logical unit"/>
737 <node COLOR="#111111" CREATED="1347909929666" ID="ID_1831742927" MODIFIED="1351543382577" TEXT="May be referenced by one or more datasets"/>
738 <node COLOR="#111111" CREATED="1347910055292" ID="ID_490425881" MODIFIED="1351543382578" TEXT="Names must be unique within one database">
739 <node COLOR="#111111" CREATED="1347910075894" ID="ID_1953611992" MODIFIED="1351543382578" TEXT="It is a good advice to have unique names across all databases"/>
740 <node COLOR="#111111" CREATED="1347910103335" ID="ID_159279786" MODIFIED="1351543382579" TEXT="- as this allows to create federated databases very easily"/>
742 <node COLOR="#111111" CREATED="1347912407520" ID="ID_1512499455" MODIFIED="1351543382579" TEXT="Has unique descriptor">
743 <node COLOR="#111111" CREATED="1347912420810" ID="ID_328184064" MODIFIED="1351543382579" TEXT="Access hash">
744 <node COLOR="#111111" CREATED="1347912959028" ID="ID_1203260813" MODIFIED="1351543382580" TEXT="Will be used to "loosely connect" to datasets/databases">
745 <node COLOR="#111111" CREATED="1347912975139" ID="ID_299885802" MODIFIED="1351543382580" TEXT="Connecting a table to multiple databases must be supported by underlaying storage engine">
746 <icon BUILTIN="messagebox_warning"/>
747 <icon BUILTIN="idea"/>
749 <node COLOR="#111111" CREATED="1347913002915" ID="ID_711015421" MODIFIED="1351543382581" TEXT="Allows n-n relations">
750 <icon BUILTIN="button_ok"/>
753 <node COLOR="#111111" CREATED="1347913129784" ID="ID_1589418518" MODIFIED="1351543382581" TEXT="Is the reference "key""/>
755 <node COLOR="#111111" CREATED="1347912425798" ID="ID_389669567" MODIFIED="1351543382582" TEXT="Table name">
756 <node COLOR="#111111" CREATED="1347914456696" ID="ID_536845262" MODIFIED="1351543382582" TEXT="Alias for access hash"/>
757 <node COLOR="#111111" CREATED="1347914465540" ID="ID_1180493687" MODIFIED="1351543382583" TEXT="Easier to remember"/>
758 <node COLOR="#111111" CREATED="1347914472610" ID="ID_636886196" MODIFIED="1351543382583" TEXT="... (see database descriptor)">
759 <arrowlink COLOR="#006600" DESTINATION="ID_447818120" ENDARROW="Default" ENDINCLINATION="602;0;" ID="Arrow_ID_1348995776" STARTARROW="None" STARTINCLINATION="602;0;"/>
762 <node COLOR="#111111" CREATED="1347913495090" ID="ID_1084668033" MODIFIED="1351543382584" TEXT="Inherited storage engine">
763 <node COLOR="#111111" CREATED="1347913500355" ID="ID_995520298" MODIFIED="1351543382584" TEXT="May be overwritten to allow e.g. heap tables within a database"/>
764 <node COLOR="#111111" CREATED="1347913524808" ID="ID_112416737" MODIFIED="1351543382585" TEXT="Default is storage engine from database"/>
765 <node COLOR="#111111" CREATED="1347913536355" ID="ID_762518114" MODIFIED="1351543382585" TEXT="If multiple databases are referenced all engines must be the same"/>
767 <node COLOR="#111111" CREATED="1347914588516" ID="ID_845951830" MODIFIED="1351543382585" TEXT="Handling flags">
768 <node COLOR="#111111" CREATED="1347914593059" ID="ID_228689757" MODIFIED="1351543382586" TEXT="Crashed">
769 <node COLOR="#111111" CREATED="1347914875589" ID="ID_765081704" MODIFIED="1351543382586" TEXT="May cause crashed database">
770 <node COLOR="#111111" CREATED="1347914937872" ID="ID_46849301" MODIFIED="1351543382587" TEXT="On supporting engines only"/>
771 <node COLOR="#111111" CREATED="1347914950883" ID="ID_1530777026" MODIFIED="1351543382587" TEXT="Some kind of "database-happiness" causes this">
772 <icon BUILTIN="idea"/>
776 <node COLOR="#111111" CREATED="1347914600903" ID="ID_54493191" MODIFIED="1351543382587" TEXT="Locked">
777 <node COLOR="#111111" CREATED="1347992053241" ID="ID_1762530151" MODIFIED="1351543382588" TEXT="If supported by engine">
778 <icon BUILTIN="yes"/>
780 <node COLOR="#111111" CREATED="1347992066867" ID="ID_212030811" MODIFIED="1351543382588" TEXT="Including lock owner"/>
782 <node COLOR="#111111" CREATED="1347914618280" ID="ID_324201180" MODIFIED="1351543382589" TEXT="Why no "disconnected"?">
783 <icon BUILTIN="idea"/>
784 <node COLOR="#111111" CREATED="1347914634435" ID="ID_133989367" MODIFIED="1351543382589" TEXT="Databases get disconnected"/>
785 <node COLOR="#111111" CREATED="1347914651390" ID="ID_1263760458" MODIFIED="1351543382590" TEXT="- but not single tables as they depend loosely on databases"/>
786 <node COLOR="#111111" CREATED="1347914678162" ID="ID_1109836570" MODIFIED="1351543382590" TEXT="A redundant stored table is possible"/>
790 <node COLOR="#111111" CREATED="1347912951313" ID="ID_1766851891" MODIFIED="1351543382591" TEXT="Comments"/>
792 <node COLOR="#111111" CREATED="1347897050289" ID="ID_423424642" MODIFIED="1351543382591" TEXT="Datasets">
793 <node COLOR="#111111" CREATED="1347994815641" ID="ID_950571320" MODIFIED="1351543382592" TEXT="Is not tied/connected to tables"/>
794 <node COLOR="#111111" CREATED="1347994843470" ID="ID_1796989963" MODIFIED="1351543382592" TEXT="Tables/entries are loosely tied to it"/>
795 <node COLOR="#111111" CREATED="1347994919830" ID="ID_889594764" MODIFIED="1351543382592" TEXT="Contains hashes to data entries">
796 <node COLOR="#111111" CREATED="1348089051854" ID="ID_1770939207" MODIFIED="1351543382593" TEXT="All data entries referenced by used datasets must have same "row" count (n)">
797 <arrowlink COLOR="#006600" DESTINATION="ID_366585032" ENDARROW="Default" ENDINCLINATION="696;38;" ID="Arrow_ID_928969794" STARTARROW="None" STARTINCLINATION="781;176;"/>
798 <icon BUILTIN="messagebox_warning"/>
801 <node COLOR="#111111" CREATED="1347994934200" ID="ID_946163151" MODIFIED="1351543382593" TEXT="Narrow organization unit">
802 <node COLOR="#111111" CREATED="1347994965280" ID="ID_1052420685" MODIFIED="1351543382594" TEXT="Organized one or more data entries in a logical unit"/>
803 <node COLOR="#111111" CREATED="1347994987506" ID="ID_1636405144" MODIFIED="1351543382594" TEXT="Is part of a complete "data row"">
804 <node COLOR="#111111" CREATED="1348088984977" ID="ID_1198804684" MODIFIED="1351543382595" TEXT="Data rows are organized by tables"/>
807 <node COLOR="#111111" CREATED="1347995046025" ID="ID_72430445" MODIFIED="1351543382595" TEXT="Is only referenced by tables, not data entries"/>
808 <node COLOR="#111111" CREATED="1347995075495" ID="ID_520335872" MODIFIED="1351543382596" TEXT="Doesn't have a name">
809 <node COLOR="#111111" CREATED="1347995089456" ID="ID_30278784" MODIFIED="1351543382596" TEXT="As rows are not identified by names"/>
810 <node COLOR="#111111" CREATED="1347995105327" ID="ID_1702201481" MODIFIED="1351543382596" TEXT="But may has an incremental counter"/>
812 <node COLOR="#111111" CREATED="1347995143139" ID="ID_1531730507" MODIFIED="1351543382597" TEXT="Has unique descriptor">
813 <node COLOR="#111111" CREATED="1347995209997" ID="ID_1057513287" MODIFIED="1351543382597" TEXT="Access hash">
814 <node COLOR="#111111" CREATED="1347995570918" ID="ID_438030226" MODIFIED="1351543382598" TEXT="Will be used to "loosely connect" to tables/data entries"/>
815 <node COLOR="#111111" CREATED="1347995593391" ID="ID_1336753453" MODIFIED="1351543382598" TEXT="Is the reference "key""/>
817 <node COLOR="#111111" CREATED="1348088717509" ID="ID_564622859" MODIFIED="1351543382598" TEXT="Is not being numbered">
818 <icon BUILTIN="messagebox_warning"/>
820 <node COLOR="#111111" CREATED="1347995222215" ID="ID_1382110935" MODIFIED="1351543382599" TEXT="No storage engine is inherited">
821 <icon BUILTIN="messagebox_warning"/>
822 <node COLOR="#111111" CREATED="1347995748654" ID="ID_535496562" MODIFIED="1351543382599" TEXT="As the "controlling" unit is the table"/>
823 <node COLOR="#111111" CREATED="1347995772251" ID="ID_203743846" MODIFIED="1351543382600" TEXT="This makes the dataset independent from used storage engine"/>
825 <node COLOR="#111111" CREATED="1347995242773" ID="ID_1025533836" MODIFIED="1351543382601" TEXT="Has no handling flags">
826 <node COLOR="#111111" CREATED="1347995249004" ID="ID_106008300" MODIFIED="1351543382601" TEXT="As the "controlling" unit is the table"/>
827 <node COLOR="#111111" CREATED="1347995274254" ID="ID_672154567" MODIFIED="1351543382602" TEXT="If a row would "crash" the whole table should better crash to forbid further access attempts"/>
830 <node COLOR="#111111" CREATED="1347995317205" ID="ID_834619381" MODIFIED="1351543382602" TEXT="May have comments?">
831 <icon BUILTIN="xmag"/>
834 <node COLOR="#111111" CREATED="1347898618286" ID="ID_678684482" MODIFIED="1351543382606" TEXT="Data entries">
835 <node COLOR="#111111" CREATED="1348089165715" ID="ID_282023791" MODIFIED="1351543382606" TEXT="Is not tied/connected to datasets"/>
836 <node COLOR="#111111" CREATED="1348089770229" ID="ID_1429207106" MODIFIED="1351543382607" TEXT="Smallest organization unit"/>
837 <node COLOR="#111111" CREATED="1348090829077" ID="ID_311462320" MODIFIED="1351543382607" TEXT="Is referenced by datasets"/>
838 <node COLOR="#111111" CREATED="1348090835240" ID="ID_1699811207" MODIFIED="1351543382608" TEXT="Maybe referenced by tables?">
839 <icon BUILTIN="xmag"/>
841 <node COLOR="#111111" CREATED="1348090967993" ID="ID_366585032" MODIFIED="1351543382608" TEXT="Same entry can exist n times">
842 <linktarget COLOR="#006600" DESTINATION="ID_366585032" ENDARROW="Default" ENDINCLINATION="696;38;" ID="Arrow_ID_928969794" SOURCE="ID_1770939207" STARTARROW="None" STARTINCLINATION="781;176;"/>
844 <node COLOR="#111111" CREATED="1348089929274" ID="ID_75125078" MODIFIED="1351543382609" TEXT="Has a "name" (or key)">
845 <node COLOR="#111111" CREATED="1348089942712" ID="ID_1416598036" MODIFIED="1351543382610" TEXT="Is an alias on access hash"/>
846 <node COLOR="#111111" CREATED="1348090452219" ID="ID_496761357" MODIFIED="1351543382610" TEXT="As entries are numbered it doesn't need to be unique"/>
847 <node COLOR="#111111" CREATED="1348090609780" ID="ID_447742923" MODIFIED="1351543382610" TEXT="Several entries with same "name" will be handled as "rows""/>
849 <node COLOR="#111111" CREATED="1348088659937" ID="ID_448080189" MODIFIED="1351543382611" TEXT="Has unique descriptor">
850 <node COLOR="#111111" CREATED="1348088782719" ID="ID_96553416" MODIFIED="1351543382611" TEXT="Access hash">
851 <node COLOR="#111111" CREATED="1348090310966" ID="ID_1139835514" MODIFIED="1351543382611" TEXT="Is the reference "key""/>
853 <node COLOR="#111111" CREATED="1347995216150" ID="ID_1931457260" MODIFIED="1351543382612" TEXT=""Row" number">
854 <node COLOR="#111111" CREATED="1347995681302" ID="ID_1295644459" MODIFIED="1351543382612" TEXT="Whenever a data entry is created, the number increments"/>
855 <node COLOR="#111111" CREATED="1347995699266" ID="ID_626496182" MODIFIED="1351543382613" TEXT="Deleting/updating of "row" numbers is not possible"/>
856 <node COLOR="#111111" CREATED="1347995715735" ID="ID_1079888298" MODIFIED="1351543382613" TEXT="Deleting a data entry doesn't decrement number count"/>
858 <node COLOR="#111111" CREATED="1348089856484" ID="ID_1041510385" MODIFIED="1351543382613" TEXT="Defines a data type which the data has"/>
859 <node COLOR="#111111" CREATED="1348088825289" ID="ID_1402142183" MODIFIED="1351543382614" TEXT="Does not inherit storage engine or handling flags"/>
861 <node COLOR="#111111" CREATED="1348166473883" ID="ID_432965480" MODIFIED="1351543382614" TEXT="Single data entry is made of ...">
862 <node COLOR="#111111" CREATED="1348166534327" ID="ID_42823569" MODIFIED="1351543382615" TEXT="Access hash"/>
863 <node COLOR="#111111" CREATED="1348166483509" ID="ID_885692020" MODIFIED="1351543382615" TEXT="Entry "name" or "key""/>
864 <node COLOR="#111111" CREATED="1348166539285" ID="ID_1845181339" MODIFIED="1351543382616" TEXT="Data type">
865 <node COLOR="#111111" CREATED="1348168340484" ID="ID_1318284868" MODIFIED="1351543382616" TEXT="Type safety is important">
866 <icon BUILTIN="yes"/>
868 <node COLOR="#111111" CREATED="1348168361740" ID="ID_938684564" MODIFIED="1351543382617" TEXT="Mismatching types will cause an exception"/>
869 <node COLOR="#111111" CREATED="1348168390174" ID="ID_1040366120" MODIFIED="1351543382617" TEXT="Is represented as hexadecimal number"/>
871 <node COLOR="#111111" CREATED="1348166558784" ID="ID_602013127" MODIFIED="1351543382617" TEXT="Data value"/>
872 <node COLOR="#111111" CREATED="1348088848688" ID="ID_1827228403" MODIFIED="1351543382618" TEXT="Comments"/>
875 <node COLOR="#111111" CREATED="1346541744578" ID="ID_1112036236" MODIFIED="1351543382618" TEXT="Data types">
876 <font NAME="Dialog" SIZE="12"/>
877 <node COLOR="#111111" CREATED="1348164733507" ID="ID_408959225" MODIFIED="1351543382618" TEXT="Are tied to data entries"/>
878 <node COLOR="#111111" CREATED="1348164742879" ID="ID_402066301" MODIFIED="1351543382619" TEXT="Is not an organization unit"/>
879 <node COLOR="#111111" CREATED="1348164754345" ID="ID_555748717" MODIFIED="1351543382619" TEXT="Is always referenced by data entries"/>
880 <node COLOR="#111111" CREATED="1348164784500" ID="ID_1059405754" MODIFIED="1351543382620" TEXT="Has no "name" or key"/>
881 <node COLOR="#111111" CREATED="1348164797658" ID="ID_664340195" MODIFIED="1351543382620" TEXT="Has no descriptor">
882 <node COLOR="#111111" CREATED="1348166709503" ID="ID_336179657" MODIFIED="1351543382621" TEXT="As it is no organization unit"/>
884 <node COLOR="#111111" CREATED="1348164812073" ID="ID_1291865594" MODIFIED="1351543382622" TEXT="Supported data types">
885 <node COLOR="#111111" CREATED="1348164901610" ID="ID_426520936" MODIFIED="1351543382622" TEXT="Tiny integer">
886 <node COLOR="#111111" CREATED="1348605506502" ID="ID_1026175374" MODIFIED="1351543382622" TEXT="String identifier: ti">
887 <font NAME="Dialog" SIZE="12"/>
890 <node COLOR="#111111" CREATED="1348164887086" ID="ID_33596741" MODIFIED="1351543382623" TEXT="Small integer">
891 <node COLOR="#111111" CREATED="1348605526128" ID="ID_1645132967" MODIFIED="1351543382623" TEXT="String identifier: si"/>
893 <node COLOR="#111111" CREATED="1348164821176" ID="ID_1666670329" MODIFIED="1351543382623" TEXT="Integer">
894 <node COLOR="#111111" CREATED="1348605529428" ID="ID_1964125386" MODIFIED="1351543382624" TEXT="String identifier: in"/>
896 <node COLOR="#111111" CREATED="1348164890958" ID="ID_774607474" MODIFIED="1351543382624" TEXT="Big integer">
897 <node COLOR="#111111" CREATED="1348605544996" ID="ID_894617379" MODIFIED="1351543382625" TEXT="String identifier: bi"/>
899 <node COLOR="#111111" CREATED="1348164823809" ID="ID_240092736" MODIFIED="1351543382625" TEXT="Float">
900 <node COLOR="#111111" CREATED="1348605558719" ID="ID_481618045" MODIFIED="1351543382636" TEXT="String identifier: fl"/>
902 <node COLOR="#111111" CREATED="1348164835569" ID="ID_95771098" MODIFIED="1351543382637" TEXT="Char">
903 <node COLOR="#111111" CREATED="1348605563110" ID="ID_176711801" MODIFIED="1351543382638" TEXT="String identifier: ch"/>
905 <node COLOR="#111111" CREATED="1348164828048" ID="ID_1968458177" MODIFIED="1351543382638" TEXT="String">
906 <node COLOR="#111111" CREATED="1348605566687" ID="ID_1109438228" MODIFIED="1351543382638" TEXT="String identifier: st"/>
908 <node COLOR="#111111" CREATED="1348164825299" ID="ID_839405785" MODIFIED="1351543382639" TEXT="Boolean">
909 <node COLOR="#111111" CREATED="1348605570445" ID="ID_327726408" MODIFIED="1351543382650" TEXT="String identifier: bo"/>
911 <node COLOR="#111111" CREATED="1348164830871" ID="ID_259473311" MODIFIED="1351543382651" TEXT="Array">
912 <node COLOR="#111111" CREATED="1348605573884" ID="ID_1353175990" MODIFIED="1351543382651" TEXT="String identifier: ar"/>
916 <node COLOR="#111111" CREATED="1346542103803" ID="ID_312384374" MODIFIED="1351543382651" TEXT="No indexes or primary/unique keys">
917 <font NAME="Dialog" SIZE="12"/>
918 <icon BUILTIN="messagebox_warning"/>
920 <node COLOR="#111111" CREATED="1346542422821" ID="ID_1395690062" MODIFIED="1351543382652" TEXT="Comments">
921 <font NAME="Dialog" SIZE="12"/>
924 <node COLOR="#990000" CREATED="1348606650551" ID="ID_1432508732" MODIFIED="1351543382652" TEXT="Data storage layer">
925 <font BOLD="true" NAME="Dialog" SIZE="14"/>
926 <node COLOR="#111111" CREATED="1348607368044" ID="ID_1522509826" MODIFIED="1351543382653" TEXT="General ideas">
927 <font BOLD="true" NAME="Dialog" SIZE="12"/>
928 <node COLOR="#111111" CREATED="1348607381294" ID="ID_354358196" MODIFIED="1351543382653" TEXT="Is responsible for storing the data"/>
929 <node COLOR="#111111" CREATED="1348607394230" ID="ID_650558677" MODIFIED="1351543382653" TEXT="Storage of data is independent from above layers">
930 <node COLOR="#111111" CREATED="1348607426234" ID="ID_532285228" MODIFIED="1351543382654" TEXT="It doesn't matter how the data is organized"/>
932 <node COLOR="#111111" CREATED="1348770959605" ID="ID_1668693936" MODIFIED="1355617597896" TEXT="Classes in storage layer act as front-ends">
933 <arrowlink DESTINATION="ID_1609252931" ENDARROW="Default" ENDINCLINATION="158;-6;" ID="Arrow_ID_10442914" STARTARROW="None" STARTINCLINATION="158;-6;"/>
936 <node COLOR="#111111" CREATED="1347894952478" ID="ID_553489596" MODIFIED="1351543382654" TEXT="Storage engines">
937 <font NAME="Dialog" SIZE="12"/>
938 <node COLOR="#111111" CREATED="1347910800390" ID="ID_361666086" MODIFIED="1351543382655" TEXT="For all engines">
939 <font BOLD="true" NAME="Dialog" SIZE="12"/>
940 <node COLOR="#111111" CREATED="1347910806204" ID="ID_80593214" MODIFIED="1351543382655" TEXT="Are not the same as database modes"/>
941 <node COLOR="#111111" CREATED="1347910821704" ID="ID_267957144" MODIFIED="1351543382656" TEXT="Are only available for databases"/>
942 <node COLOR="#111111" CREATED="1347910884420" ID="ID_1293131147" MODIFIED="1351543382656" TEXT="Not all are compatible to all modes"/>
943 <node COLOR="#111111" CREATED="1348168548900" ID="ID_1647356270" MODIFIED="1351543382669" TEXT="Identified by hexadecimal number"/>
944 <node COLOR="#111111" CREATED="1348866591562" ID="ID_1609252931" MODIFIED="1355617597896" TEXT="Are the file IO frontends">
945 <linktarget COLOR="#b0b0b0" DESTINATION="ID_1609252931" ENDARROW="Default" ENDINCLINATION="158;-6;" ID="Arrow_ID_10442914" SOURCE="ID_1668693936" STARTARROW="None" STARTINCLINATION="158;-6;"/>
946 <font BOLD="true" NAME="Dialog" SIZE="12"/>
949 <node COLOR="#111111" CREATED="1347895238929" ID="ID_1019946403" MODIFIED="1351543382670" TEXT="Blob file">
950 <node COLOR="#111111" CREATED="1347895312295" ID="ID_888594780" MODIFIED="1351543382670" TEXT="Stored on local file system">
951 <node COLOR="#111111" CREATED="1347898337240" ID="ID_1188869385" MODIFIED="1351543382670" TEXT="Is this file fomat">
952 <arrowlink COLOR="#ff3333" DESTINATION="ID_1683424442" ENDARROW="Default" ENDINCLINATION="597;-489;" ID="Arrow_ID_453516147" STARTARROW="None" STARTINCLINATION="561;-255;"/>
955 <node COLOR="#111111" CREATED="1347895325286" ID="ID_237065568" MODIFIED="1351543382671" TEXT="Supports all operations"/>
956 <node COLOR="#111111" CREATED="1347895346593" ID="ID_1778738094" MODIFIED="1351543382671" TEXT="Is persistent"/>
958 <node COLOR="#111111" CREATED="1347898288611" ID="ID_42030705" MODIFIED="1351543382672" TEXT="Hash file">
959 <node COLOR="#111111" CREATED="1347898303862" ID="ID_1359778918" MODIFIED="1351543382672" TEXT="Stored on local file system">
960 <node COLOR="#111111" CREATED="1347898419343" ID="ID_487696928" MODIFIED="1351543382673" TEXT="Is the previous file format">
961 <icon BUILTIN="idea"/>
964 <node COLOR="#111111" CREATED="1347898309637" ID="ID_756266110" MODIFIED="1351543382673" TEXT="Supports all operations"/>
965 <node COLOR="#111111" CREATED="1347898314127" ID="ID_1060169944" MODIFIED="1351543382673" TEXT="Is persistent"/>
967 <node COLOR="#111111" CREATED="1347895254752" ID="ID_1163540267" MODIFIED="1351543382674" TEXT="Heap">
968 <node COLOR="#111111" CREATED="1347895330976" ID="ID_276897050" MODIFIED="1351543382680" TEXT="Stored in memory"/>
969 <node COLOR="#111111" CREATED="1347895340294" ID="ID_145826147" MODIFIED="1351543382680" TEXT="Supports all operations"/>
970 <node COLOR="#111111" CREATED="1347895351785" ID="ID_1164721835" MODIFIED="1351543382681" TEXT="Is non-persistent">
971 <node COLOR="#111111" CREATED="1347895572689" ID="ID_1039529514" MODIFIED="1351543382681" TEXT="Looses all data on power loss/shutdown"/>
974 <node COLOR="#111111" CREATED="1347895263967" ID="ID_1213358823" MODIFIED="1351543382681" TEXT="Blackhole">
975 <node COLOR="#111111" CREATED="1347895360870" ID="ID_463622164" MODIFIED="1351543382682" TEXT="Stored nowhere">
976 <node COLOR="#111111" CREATED="1347895751946" ID="ID_620019901" MODIFIED="1351543382682" TEXT="Except table names and structure">
977 <icon BUILTIN="idea"/>
980 <node COLOR="#111111" CREATED="1347895380120" ID="ID_1029660130" MODIFIED="1351543382683" TEXT="Supports all operations">
981 <node COLOR="#111111" CREATED="1347895398743" ID="ID_920096783" MODIFIED="1351543382683" TEXT=""Write" operations are not stored">
982 <node COLOR="#111111" CREATED="1347895436895" ID="ID_23365602" MODIFIED="1351543382683" TEXT=""Affected" rows are always zero!">
983 <icon BUILTIN="messagebox_warning"/>
986 <node COLOR="#111111" CREATED="1347895417025" ID="ID_1305980085" MODIFIED="1351543382684" TEXT=""Read" operations will always return zero result"/>
987 <node COLOR="#111111" CREATED="1347895485557" ID="ID_1921852746" MODIFIED="1351543382684" TEXT="Even if the result is misleading, no warning is triggered"/>
989 <node COLOR="#111111" CREATED="1347895386590" ID="ID_206929226" MODIFIED="1351543382685" TEXT="Is virtual">
990 <node COLOR="#111111" CREATED="1347895502000" ID="ID_43451927" MODIFIED="1351543382685" TEXT="It is a non-existent "storage""/>
991 <node COLOR="#111111" CREATED="1347895518478" ID="ID_1791822351" MODIFIED="1351543382686" TEXT="All sent data is discarded"/>
992 <node COLOR="#111111" CREATED="1347895530242" ID="ID_1072830374" MODIFIED="1351543382686" TEXT="Similar to send data to /dev/null">
993 <icon BUILTIN="idea"/>
997 <node COLOR="#111111" CREATED="1347895288156" ID="ID_1016970381" MODIFIED="1351543382687" TEXT="Archive">
998 <node COLOR="#111111" CREATED="1347895708233" ID="ID_400868272" MODIFIED="1351543382687" TEXT="Stored on local file system"/>
999 <node COLOR="#111111" CREATED="1347895663394" ID="ID_1767525606" MODIFIED="1351543382688" TEXT="Supports not all operations">
1000 <node COLOR="#111111" CREATED="1347895673303" ID="ID_35746771" MODIFIED="1351543382688" TEXT=""Insert" operations work"/>
1001 <node COLOR="#111111" CREATED="1347895690866" ID="ID_757910127" MODIFIED="1351543382688" TEXT=""Update" or "delete" are not permitted"/>
1002 <node COLOR="#111111" CREATED="1347895809167" ID="ID_737807217" MODIFIED="1351543382689" TEXT=""Read" operations are supported"/>
1003 <node COLOR="#111111" CREATED="1347895900655" ID="ID_1086418246" MODIFIED="1351543382689" TEXT="May not support indexes">
1004 <icon BUILTIN="help"/>
1007 <node COLOR="#111111" CREATED="1347895916986" ID="ID_1965965364" MODIFIED="1351543382690" TEXT="Is persistent"/>
1009 <node COLOR="#111111" CREATED="1347896088464" ID="ID_1773711046" MODIFIED="1351543382690" TEXT="Federated">
1010 <node COLOR="#111111" CREATED="1347896094616" ID="ID_210176852" MODIFIED="1351543382690" TEXT="Stored distributed">
1011 <node COLOR="#111111" CREATED="1347896220059" ID="ID_160460838" MODIFIED="1351543382691" TEXT="Database is distributed on several physical nodes"/>
1012 <node COLOR="#111111" CREATED="1347896237087" ID="ID_353156748" MODIFIED="1351543382691" TEXT="It appears as one logical database"/>
1014 <node COLOR="#111111" CREATED="1347896102116" ID="ID_1430910538" MODIFIED="1351543382704" TEXT="Supports all operations"/>
1015 <node COLOR="#111111" CREATED="1347896107026" ID="ID_616654450" MODIFIED="1351543382705" TEXT="Is persistant and redundant"/>
1016 <node COLOR="#111111" CREATED="1347896126051" ID="ID_781772212" MODIFIED="1351543382705" TEXT="Is not compatible with all modes">
1017 <icon BUILTIN="messagebox_warning"/>
1018 <node COLOR="#111111" CREATED="1347896148283" ID="ID_5700806" MODIFIED="1351543382706" TEXT=""Host-only" is supported"/>
1019 <node COLOR="#111111" CREATED="1347896201841" ID="ID_208145467" MODIFIED="1351543382706" TEXT="Distributed is NOT supported"/>
1020 <node COLOR="#111111" CREATED="1347896209348" ID="ID_797343960" MODIFIED="1351543382707" TEXT="Master/slave is NOT supported"/>
1023 <node COLOR="#111111" CREATED="1347896609323" ID="ID_790775394" MODIFIED="1351543382707" TEXT="Peer-To-Peer">
1024 <icon BUILTIN="idea"/>
1025 <icon BUILTIN="xmag"/>
1026 <node COLOR="#111111" CREATED="1347896615542" ID="ID_1809443672" MODIFIED="1351543382707" TEXT="Stored decentralized"/>
1027 <node COLOR="#111111" CREATED="1347896633801" ID="ID_1256115067" MODIFIED="1351543382708" TEXT="Supports all operations"/>
1028 <node COLOR="#111111" CREATED="1347896639372" ID="ID_1364051912" MODIFIED="1351543382708" TEXT="Is persistant and redundant"/>
1032 <node COLOR="#990000" CREATED="1348607776611" ID="ID_601635228" MODIFIED="1351543382721" TEXT="Raw data access layer">
1033 <font BOLD="true" NAME="Dialog" SIZE="14"/>
1034 <node COLOR="#111111" CREATED="1348607891753" ID="ID_1912251373" MODIFIED="1351543382722" TEXT="General ideas">
1035 <font BOLD="true" NAME="Dialog" SIZE="12"/>
1036 <node COLOR="#111111" CREATED="1348762795482" ID="ID_642646697" MODIFIED="1351543382722" TEXT="Is the "storage backend"">
1037 <font BOLD="true" NAME="Dialog" SIZE="12"/>
1038 <node COLOR="#111111" CREATED="1348770976729" ID="ID_1262887982" MODIFIED="1351543382723" TEXT="Backend classes lift of the heavy work"/>
1040 <node COLOR="#111111" CREATED="1348608033387" ID="ID_211987598" MODIFIED="1351543382723" TEXT="Depends on the selected storage engine">
1041 <node COLOR="#111111" CREATED="1348770777328" ID="ID_237843856" MODIFIED="1351543382726" TEXT="An engine based on files (both binary and text formats) will write to hard drive">
1042 <node COLOR="#111111" CREATED="1348770849306" ID="ID_182856009" MODIFIED="1351543382727" TEXT="Both indexes and data packets are kept on disk"/>
1044 <node COLOR="#111111" CREATED="1348770803538" ID="ID_61658429" MODIFIED="1351543382727" TEXT="A networked engine will write into a TCP/UDP stream">
1045 <node COLOR="#111111" CREATED="1348770886854" ID="ID_539482397" MODIFIED="1351543382728" TEXT="A DHT is recommended to keep track of the data"/>
1046 <node COLOR="#111111" CREATED="1348770918175" ID="ID_1502537954" MODIFIED="1351543382728" TEXT="The receiving nodes will store both on disk"/>
1050 <node COLOR="#111111" CREATED="1348772276127" ID="ID_330882598" MODIFIED="1351543382729" TEXT="File IO backend">
1051 <font BOLD="true" NAME="Dialog" SIZE="12"/>
1053 <node COLOR="#111111" CREATED="1348772336935" ID="ID_1946725400" MODIFIED="1351543382729" TEXT="Network IO backend">
1054 <font BOLD="true" NAME="Dialog" SIZE="12"/>
1058 <node COLOR="#00b439" CREATED="1346545137974" ID="ID_260747112" MODIFIED="1351543382732" TEXT="Naming scheme">
1059 <edge STYLE="bezier" WIDTH="thin"/>
1060 <font BOLD="true" NAME="Dialog" SIZE="16"/>
1063 <node COLOR="#0033ff" CREATED="1346541827596" ID="ID_417587233" MODIFIED="1351543382733" POSITION="left" TEXT=""Query language"">
1064 <edge STYLE="sharp_bezier" WIDTH="8"/>
1065 <font BOLD="true" NAME="Dialog" SIZE="18"/>
1067 <node COLOR="#0033ff" CREATED="1347920245821" ID="ID_93482239" MODIFIED="1351543382735" POSITION="left" TEXT="License">
1068 <edge STYLE="sharp_bezier" WIDTH="8"/>
1069 <font BOLD="true" NAME="Dialog" SIZE="18"/>
1070 <node COLOR="#00b439" CREATED="1347920258821" ID="ID_1719359335" MODIFIED="1351543382755" TEXT="This work is licensed under the Creative Commons Attribution-ShareAlike 3.0 Germany License. To view a copy of this license, visit next link.">
1071 <edge STYLE="bezier" WIDTH="thin"/>
1072 <font NAME="Dialog" SIZE="16"/>
1074 <node COLOR="#00b439" CREATED="1347920284551" ID="ID_1012683220" LINK="http://creativecommons.org/licenses/by-sa/3.0/de/" MODIFIED="1351543382761" TEXT="http://creativecommons.org/licenses/by-sa/3.0/de/">
1075 <edge STYLE="bezier" WIDTH="thin"/>
1076 <font NAME="Dialog" SIZE="16"/>