Mercurial > hg > ltpda

comparison m-toolbox/html_help/help/ug/repo_whatis.html @ 0:f0afece42f48

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Import.
author Daniele Nicolodi <nicolodi@science.unitn.it>
date Wed, 23 Nov 2011 19:22:13 +0100
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:f0afece42f48
1 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
2 "http://www.w3.org/TR/1999/REC-html401-19991224/loose.dtd">
3
4 <html lang="en">
5 <head>
6 <meta name="generator" content=
7 "HTML Tidy for Mac OS X (vers 1st December 2004), see www.w3.org">
8 <meta http-equiv="Content-Type" content=
9 "text/html; charset=us-ascii">
10
11 <title>What is an LTPDA Repository (LTPDA Toolbox)</title>
12 <link rel="stylesheet" href="docstyle.css" type="text/css">
13 <meta name="generator" content="DocBook XSL Stylesheets V1.52.2">
14 <meta name="description" content=
15 "Presents an overview of the features, system requirements, and starting the toolbox.">
16 </head>
17
18 <body>
19 <a name="top_of_page" id="top_of_page"></a>
20
21 <p style="font-size:1px;">&nbsp;</p>
22
23 <table class="nav" summary="Navigation aid" border="0" width=
24 "100%" cellpadding="0" cellspacing="0">
25 <tr>
26 <td valign="baseline"><b>LTPDA Toolbox</b></td><td><a href="../helptoc.html">contents</a></td>
27
28 <td valign="baseline" align="right"><a href=
29 "repo.html"><img src="b_prev.gif" border="0" align=
30 "bottom" alt="Working with an LTPDA Repository"></a>&nbsp;&nbsp;&nbsp;<a href=
31 "repo_connect.html"><img src="b_next.gif" border="0" align=
32 "bottom" alt="Connecting to an LTPDA Repository"></a></td>
33 </tr>
34 </table>
35
36 <h1 class="title"><a name="f3-12899" id="f3-12899"></a>What is an LTPDA Repository</h1>
37 <hr>
38
39 <p>
40 <h2>Introduction</h2>
41
42 <p>
43 An LTPDA repository has at its core a database server (in fact, a <a href="matlab:web('http://www.mysql.com')">MySQL server</a>).
44 A single MySQL server can host multiple databases (LTPDA repositories).
45 A single database/repository comprises a particular set of database tables. These tables hold meta-data
46 about the objects stored in the database.
47 </p>
48
49 <p> Since the core engine is a MySQL database, in principle any MySQL client can be used to interface
50 with the repository. In order to submit and retrieve objects in the proper way (entering all expected
51 meta-data), it is strongly suggested that you use the LTPDA Toolbox client commands <tt>submit</tt> and
52 the <tt>From Repository</tt> constructors, or the <a href="workspaceBrowser.html">LTPDA Workspace Browser</a>.. In
53 addition, the LTPDA Workbench has full built-in support for interacting with LTPDA Repositories.
54 </p>
55
56 <p>
57 Any standard MySQL client can be used to query and search an LTPDA repository.
58 For example, using a web-client or the standard MySQL command-line interface.
59 In addition, the LTPDA Toolbox provides two ways to search the database: using the
60 workspace browser, or the LTPDA Workbench..
61 It is also possible to use the Visual Query Builder provided with the MATLAB Database Toolbox
62 for interacting with a repository.
63 </p>
64
65 <h2>Database primer</h2>
66
67 <p>
68 A MySQL database comprises a collection of tables. Each table has a number of fields.
69 Each field describes the type of data stored in that field (numerical, string, date, etc).
70 When an entry is made in a table a new row is created. Interaction with MySQL databases
71 is done using Structured Query Language (SQL) statements. For examples
72 see <a href="matlab:web('http://dev.mysql.com/doc/refman/5.1/en/examples.html')">MySQL Common Queries</a>.
73 </p>
74
75 <h2>Database design</h2>
76 <p>
77 The database for a single repository uses the tables as shown below:
78 </p>
79
80 <img src="images/db_tables.png" alt="DB Tables">
81
82 <p> As you can see, each object that is submitted to a repository receives a unique ID number. This ID
83 number is used to link together the various pieces of meta-data that are collected about each object. In
84 addition, each object that is submitted is check-summed using the <a
85 href="matlab:web('http://en.wikipedia.org/wiki/MD5')">MD5 algorithm</a>. That way, the integrity of each object can be
86 checked upon retrieval.
87 </p>
88
89 <p>
90 In order to access a particular repository you need:
91 <ul>
92 <li>The IP address of the MySQL host server</li>
93 <li>The name of the repository (the database name)</li>
94 <li>An account on the MySQL host server</li>
95 <li>Permissions to access the desired database/repository</li>
96 </ul>
97 </p>
98
99 <h2>The main database tables</h2>
100
101 <p>An LTPDA repository consists of the following database tables:</p>
102
103 <!-- OBJS table -->
104 <h3><tt>objs</tt> table</h3>
105 <p>The <tt>objs</tt> table stores the XML representation of the submitted object. At this point, each
106 object in the database is assigned a unique identifier. Together with the database name and hostname/ip
107 of the server, this forms a unique tag for all LTPDA objects.</p>
108 <p>
109 <table cellspacing="0" class="body" cellpadding="2" border="1" width="80%">
110 <colgroup>
111 <col width="10%"/>
112 <col width="10%"/>
113 <col width="80%"/>
114 </colgroup>
115 <thead>
116 <tr valign="top">
117 <th class="categorylist">Field</th>
118 <th class="categorylist">Data Type</th>
119 <th class="categorylist">Description</th>
120 </tr>
121 </thead>
122 <tbody>
123 <!-- Field: 'id' -->
124 <tr valign="top">
125 <td bgcolor="#f3f4f5">
126 <p><tt>id</tt></p>
127 </td>
128 <td bgcolor="#f3f4f5">
129 <p><tt>int(11)</tt></p>
130 </td>
131 <td bgcolor="#f3f4f5">
132 <p>A unique identification number for all LTPDA objects in this database. This value is the link between
133 all database tables.</p>
134 </td>
135 </tr>
136 <!-- Field: 'hash' -->
137 <tr valign="top">
138 <td bgcolor="#e3e4e5">
139 <p><tt>hash</tt></p>
140 </td>
141 <td bgcolor="#e3e4e5">
142 <p><tt>text</tt></p>
143 </td>
144 <td bgcolor="#e3e4e5">
145 <p>An MD5 hash of the XML representation of the object.</p>
146 </td>
147 </tr>
148 <!-- Field: 'xml' -->
149 <tr valign="top">
150 <td bgcolor="#f3f4f5">
151 <p><tt>xml</tt></p>
152 </td>
153 <td bgcolor="#f3f4f5">
154 <p><tt>longtext</tt></p>
155 </td>
156 <td bgcolor="#f3f4f5">
157 <p>The XML representation of the object. This field can be dumped directly to an XML file and
158 should be readable in LTPDA.</p>
159 </td>
160 </tr>
161 </tbody>
162 </table>
163 </p>
164
165 <!-- OBJMETA table -->
166 <h3><tt>objmeta</tt> table</h3>
167
168 <p>The <tt>objmeta</tt> table stores various pieces of information associated with the object
169 being submitted. The aim of this table is to provide a lot of useful fields on which to perform
170 searches and queries.</p>
171
172 <p>
173 <table cellspacing="0" class="body" cellpadding="2" border="1" width="80%">
174 <colgroup>
175 <col width="10%"/>
176 <col width="10%"/>
177 <col width="80%"/>
178 </colgroup>
179 <thead>
180 <tr valign="top">
181 <th class="categorylist">Field</th>
182 <th class="categorylist">Data Type</th>
183 <th class="categorylist">Description</th>
184 </tr>
185 </thead>
186 <tbody>
187 <!-- Field: 'id' -->
188 <tr valign="top">
189 <td bgcolor="#f3f4f5">
190 <p><tt>id</tt></p>
191 </td>
192 <td bgcolor="#f3f4f5">
193 <p><tt>int(11)</tt></p>
194 </td>
195 <td bgcolor="#f3f4f5">
196 <p>A unique identification for all entries in this table.</p>
197 </td>
198 </tr>
199 <!-- Field: 'obj_id' -->
200 <tr valign="top">
201 <td bgcolor="#e3e4e5">
202 <p><tt>obj_id</tt></p>
203 </td>
204 <td bgcolor="#e3e4e5">
205 <p><tt>int(11)</tt></p>
206 </td>
207 <td bgcolor="#e3e4e5">
208 <p>The object id of the object in the <tt>objs</tt> table.</p>
209 </td>
210 </tr>
211 <!-- Field: 'obj_type' -->
212 <tr valign="top">
213 <td bgcolor="#f3f4f5">
214 <p><tt>obj_type</tt></p>
215 </td>
216 <td bgcolor="#f3f4f5">
217 <p><tt>text</tt></p>
218 </td>
219 <td bgcolor="#f3f4f5">
220 <p>The (LTPDA) class of this object.</p>
221 </td>
222 </tr>
223 <!-- Field: 'name' -->
224 <tr valign="top">
225 <td bgcolor="#e3e4e5">
226 <p><tt>name</tt></p>
227 </td>
228 <td bgcolor="#e3e4e5">
229 <p><tt>text</tt></p>
230 </td>
231 <td bgcolor="#e3e4e5">
232 <p>The user-assigned name of this object.</p>
233 </td>
234 </tr>
235 <!-- Field: 'created' -->
236 <tr valign="top">
237 <td bgcolor="#f3f4f5">
238 <p><tt>created</tt></p>
239 </td>
240 <td bgcolor="#f3f4f5">
241 <p><tt>datetime</tt></p>
242 </td>
243 <td bgcolor="#f3f4f5">
244 <p>The date and time this object was created.</p>
245 </td>
246 </tr>
247 <!-- Field: 'version' -->
248 <tr valign="top">
249 <td bgcolor="#e3e4e5">
250 <p><tt>version</tt></p>
251 </td>
252 <td bgcolor="#e3e4e5">
253 <p><tt>text</tt></p>
254 </td>
255 <td bgcolor="#e3e4e5">
256 <p>The CVS tag of the object constructor code.</p>
257 </td>
258 </tr>
259 <!-- Field: 'ip' -->
260 <tr valign="top">
261 <td bgcolor="#f3f4f5">
262 <p><tt>ip</tt></p>
263 </td>
264 <td bgcolor="#f3f4f5">
265 <p><tt>text</tt></p>
266 </td>
267 <td bgcolor="#f3f4f5">
268 <p>The IP address of the machine which submitted the object.</p>
269 </td>
270 </tr>
271 <!-- Field: 'hostname' -->
272 <tr valign="top">
273 <td bgcolor="#e3e4e5">
274 <p><tt>hostname</tt></p>
275 </td>
276 <td bgcolor="#e3e4e5">
277 <p><tt>text</tt></p>
278 </td>
279 <td bgcolor="#e3e4e5">
280 <p>The hostname of the machine which submitted the object.</p>
281 </td>
282 </tr>
283 <!-- Field: 'os' -->
284 <tr valign="top">
285 <td bgcolor="#f3f4f5">
286 <p><tt>os</tt></p>
287 </td>
288 <td bgcolor="#f3f4f5">
289 <p><tt>text</tt></p>
290 </td>
291 <td bgcolor="#f3f4f5">
292 <p>The operating system of the machine which submitted the object.</p>
293 </td>
294 </tr>
295 <!-- Field: 'submitted' -->
296 <tr valign="top">
297 <td bgcolor="#e3e4e5">
298 <p><tt>submitted</tt></p>
299 </td>
300 <td bgcolor="#e3e4e5">
301 <p><tt>datetime</tt></p>
302 </td>
303 <td bgcolor="#e3e4e5">
304 <p>The date and time the object was submitted.</p>
305 </td>
306 </tr>
307 <!-- Field: 'experiment_title' -->
308 <tr valign="top">
309 <td bgcolor="#f3f4f5">
310 <p><tt>experiment_title</tt></p>
311 </td>
312 <td bgcolor="#f3f4f5">
313 <p><tt>text</tt></p>
314 </td>
315 <td bgcolor="#f3f4f5">
316 <p>A title for the experiment associated with the object.</p>
317 </td>
318 </tr>
319 <!-- Field: 'experiment_desc' -->
320 <tr valign="top">
321 <td bgcolor="#e3e4e5">
322 <p><tt>experiment_desc</tt></p>
323 </td>
324 <td bgcolor="#e3e4e5">
325 <p><tt>text</tt></p>
326 </td>
327 <td bgcolor="#e3e4e5">
328 <p>A description of the experiment associated with the object.</p>
329 </td>
330 </tr>
331 <!-- Field: 'analysis_desc' -->
332 <tr valign="top">
333 <td bgcolor="#f3f4f5">
334 <p><tt>analysis_desc</tt></p>
335 </td>
336 <td bgcolor="#f3f4f5">
337 <p><tt>text</tt></p>
338 </td>
339 <td bgcolor="#f3f4f5">
340 <p>A description of the analysis associated with the object.</p>
341 </td>
342 </tr>
343 <!-- Field: 'quantity' -->
344 <tr valign="top">
345 <td bgcolor="#e3e4e5">
346 <p><tt>quantity</tt></p>
347 </td>
348 <td bgcolor="#e3e4e5">
349 <p><tt>text</tt></p>
350 </td>
351 <td bgcolor="#e3e4e5">
352 <p>If applicable, the physical quantity associated with the data in the object.</p>
353 </td>
354 </tr>
355 <!-- Field: 'additional_authors' -->
356 <tr valign="top">
357 <td bgcolor="#f3f4f5">
358 <p><tt>additional_authors</tt></p>
359 </td>
360 <td bgcolor="#f3f4f5">
361 <p><tt>text</tt></p>
362 </td>
363 <td bgcolor="#f3f4f5">
364 <p>Any additional people involved in creating this object.</p>
365 </td>
366 </tr>
367 <!-- Field: 'additional_comments' -->
368 <tr valign="top">
369 <td bgcolor="#e3e4e5">
370 <p><tt>additional_comments</tt></p>
371 </td>
372 <td bgcolor="#e3e4e5">
373 <p><tt>text</tt></p>
374 </td>
375 <td bgcolor="#e3e4e5">
376 <p>A free-form field of additional comments.</p>
377 </td>
378 </tr>
379 <!-- Field: 'keywords' -->
380 <tr valign="top">
381 <td bgcolor="#f3f4f5">
382 <p><tt>keywords</tt></p>
383 </td>
384 <td bgcolor="#f3f4f5">
385 <p><tt>text</tt></p>
386 </td>
387 <td bgcolor="#f3f4f5">
388 <p>A list of keywords associated with the object.</p>
389 </td>
390 </tr>
391 <!-- Field: 'reference_ids' -->
392 <tr valign="top">
393 <td bgcolor="#e3e4e5">
394 <p><tt>reference_ids</tt></p>
395 </td>
396 <td bgcolor="#e3e4e5">
397 <p><tt>text</tt></p>
398 </td>
399 <td bgcolor="#e3e4e5">
400 <p>ID numbers of any other objects associated with this object.</p>
401 </td>
402 </tr>
403 <!-- Field: 'validated' -->
404 <tr valign="top">
405 <td bgcolor="#f3f4f5">
406 <p><tt>validated</tt></p>
407 </td>
408 <td bgcolor="#f3f4f5">
409 <p><tt>tinyint(1)</tt></p>
410 </td>
411 <td bgcolor="#f3f4f5">
412 <p>A boolean field indended to indicate validated objects.</p>
413 </td>
414 </tr>
415 <!-- Field: 'vdate' -->
416 <tr valign="top">
417 <td bgcolor="#e3e4e5">
418 <p><tt>vdate</tt></p>
419 </td>
420 <td bgcolor="#e3e4e5">
421 <p><tt>datetime</tt></p>
422 </td>
423 <td bgcolor="#e3e4e5">
424 <p>The date/time the object was validated.</p>
425 </td>
426 </tr>
427 </tbody>
428 </table>
429 </p>
430
431
432 <!-- TRANSACTIONS table -->
433 <h3><tt>transactions</tt> table</h3>
434 <p>The <tt>transactions</tt> table records all user transactions. A transaction corresponds to
435 submitting or retrieving a single or a collection of LTPDA objects.</p>
436 <p>
437 <table cellspacing="0" class="body" cellpadding="2" border="1" width="80%">
438 <colgroup>
439 <col width="10%"/>
440 <col width="10%"/>
441 <col width="80%"/>
442 </colgroup>
443 <thead>
444 <tr valign="top">
445 <th class="categorylist">Field</th>
446 <th class="categorylist">Data Type</th>
447 <th class="categorylist">Description</th>
448 </tr>
449 </thead>
450 <tbody>
451 <!-- Field: 'id' -->
452 <tr valign="top">
453 <td bgcolor="#f3f4f5">
454 <p><tt>id</tt></p>
455 </td>
456 <td bgcolor="#f3f4f5">
457 <p><tt>int(11)</tt></p>
458 </td>
459 <td bgcolor="#f3f4f5">
460 <p>A unique identification number this table entry.</p>
461 </td>
462 </tr>
463 <!-- Field: 'obj_id' -->
464 <tr valign="top">
465 <td bgcolor="#e3e4e5">
466 <p><tt>obj_id</tt></p>
467 </td>
468 <td bgcolor="#e3e4e5">
469 <p><tt>int(11)</tt></p>
470 </td>
471 <td bgcolor="#e3e4e5">
472 <p>The object id of the object in the <tt>objs</tt> table.</p>
473 </td>
474 </tr>
475 <!-- Field: 'user_id' -->
476 <tr valign="top">
477 <td bgcolor="#f3f4f5">
478 <p><tt>user_id</tt></p>
479 </td>
480 <td bgcolor="#f3f4f5">
481 <p><tt>int(11)</tt></p>
482 </td>
483 <td bgcolor="#f3f4f5">
484 <p>The unique ID number of the user who carried out the transaction.</p>
485 </td>
486 </tr>
487 <!-- Field: 'transdate' -->
488 <tr valign="top">
489 <td bgcolor="#e3e4e5">
490 <p><tt>transdate</tt></p>
491 </td>
492 <td bgcolor="#e3e4e5">
493 <p><tt>datetime</tt></p>
494 </td>
495 <td bgcolor="#e3e4e5">
496 <p>The date/time of the transaction.</p>
497 </td>
498 </tr>
499 <!-- Field: 'direction' -->
500 <tr valign="top">
501 <td bgcolor="#f3f4f5">
502 <p><tt>direction</tt></p>
503 </td>
504 <td bgcolor="#f3f4f5">
505 <p><tt>text</tt></p>
506 </td>
507 <td bgcolor="#f3f4f5">
508 <p>The direction of the transaction: 'in' or 'out'.</p>
509 </td>
510 </tr>
511 </tbody>
512 </table>
513 </p>
514
515 <!-- USERS table -->
516 <h3><tt>users</tt> table</h3>
517 <p>The <tt>users</tt> table stores information about the users allowed to access the database.</p>
518 <p>
519 <table cellspacing="0" class="body" cellpadding="2" border="1" width="80%">
520 <colgroup>
521 <col width="10%"/>
522 <col width="10%"/>
523 <col width="80%"/>
524 </colgroup>
525 <thead>
526 <tr valign="top">
527 <th class="categorylist">Field</th>
528 <th class="categorylist">Data Type</th>
529 <th class="categorylist">Description</th>
530 </tr>
531 </thead>
532 <tbody>
533 <!-- Field: 'id' -->
534 <tr valign="top">
535 <td bgcolor="#f3f4f5">
536 <p><tt>id</tt></p>
537 </td>
538 <td bgcolor="#f3f4f5">
539 <p><tt>int(11)</tt></p>
540 </td>
541 <td bgcolor="#f3f4f5">
542 <p>A unique identification number for all entries in this table.</p>
543 </td>
544 </tr>
545 <!-- Field: 'firstname' -->
546 <tr valign="top">
547 <td bgcolor="#e3e4e5">
548 <p><tt>firstname</tt></p>
549 </td>
550 <td bgcolor="#e3e4e5">
551 <p><tt>text</tt></p>
552 </td>
553 <td bgcolor="#e3e4e5">
554 <p>The firstname of the user.</p>
555 </td>
556 </tr>
557 <!-- Field: 'familyname' -->
558 <tr valign="top">
559 <td bgcolor="#f3f4f5">
560 <p><tt>familyname</tt></p>
561 </td>
562 <td bgcolor="#f3f4f5">
563 <p><tt>text</tt></p>
564 </td>
565 <td bgcolor="#f3f4f5">
566 <p>The family name of the user.</p>
567 </td>
568 </tr>
569 <!-- Field: 'username' -->
570 <tr valign="top">
571 <td bgcolor="#e3e4e5">
572 <p><tt>username</tt></p>
573 </td>
574 <td bgcolor="#e3e4e5">
575 <p><tt>text</tt></p>
576 </td>
577 <td bgcolor="#e3e4e5">
578 <p>The username (login name) of the user.</p>
579 </td>
580 </tr>
581 <!-- Field: 'email' -->
582 <tr valign="top">
583 <td bgcolor="#f3f4f5">
584 <p><tt>email</tt></p>
585 </td>
586 <td bgcolor="#f3f4f5">
587 <p><tt>text</tt></p>
588 </td>
589 <td bgcolor="#f3f4f5">
590 <p>A valid e-mail address for the user.</p>
591 </td>
592 </tr>
593 <!-- Field: 'telephone' -->
594 <tr valign="top">
595 <td bgcolor="#e3e4e5">
596 <p><tt>telephone</tt></p>
597 </td>
598 <td bgcolor="#e3e4e5">
599 <p><tt>text</tt></p>
600 </td>
601 <td bgcolor="#e3e4e5">
602 <p>A telephone numnber for the user.</p>
603 </td>
604 </tr>
605 <!-- Field: 'institution' -->
606 <tr valign="top">
607 <td bgcolor="#f3f4f5">
608 <p><tt>institution</tt></p>
609 </td>
610 <td bgcolor="#f3f4f5">
611 <p><tt>text</tt></p>
612 </td>
613 <td bgcolor="#f3f4f5">
614 <p>The institution of the user.</p>
615 </td>
616 </tr>
617 </tbody>
618 </table>
619 </p>
620
621 <!-- COLLECTIONS table -->
622 <h3><tt>collections</tt> table</h3>
623 <p>The <tt>collections</tt> table stores virtual collections of objects submitted to the database.
624 When the user submits one or more objects at the same time, this constitutes a collection. In this
625 case a collection ID number is assigned next to a list of the object IDs in the collection. This
626 allows the user to retrieve collections of objects based on the collection ID alone; no information
627 about the individual object IDs is required.</p>
628 <p>
629 <table cellspacing="0" class="body" cellpadding="2" border="1" width="80%">
630 <colgroup>
631 <col width="10%"/>
632 <col width="10%"/>
633 <col width="80%"/>
634 </colgroup>
635 <thead>
636 <tr valign="top">
637 <th class="categorylist">Field</th>
638 <th class="categorylist">Data Type</th>
639 <th class="categorylist">Description</th>
640 </tr>
641 </thead>
642 <tbody>
643 <!-- Field: 'id' -->
644 <tr valign="top">
645 <td bgcolor="#f3f4f5">
646 <p><tt>id</tt></p>
647 </td>
648 <td bgcolor="#f3f4f5">
649 <p><tt>int(11)</tt></p>
650 </td>
651 <td bgcolor="#f3f4f5">
652 <p>A unique identification number for this collection of objects.</p>
653 </td>
654 </tr>
655 <!-- Field: 'nobjs' -->
656 <tr valign="top">
657 <td bgcolor="#e3e4e5">
658 <p><tt>nobjs</tt></p>
659 </td>
660 <td bgcolor="#e3e4e5">
661 <p><tt>int</tt></p>
662 </td>
663 <td bgcolor="#e3e4e5">
664 <p>The number of objects in the collection.</p>
665 </td>
666 </tr>
667 <!-- Field: 'obj_ids' -->
668 <tr valign="top">
669 <td bgcolor="#f3f4f5">
670 <p><tt>obj_ids</tt></p>
671 </td>
672 <td bgcolor="#f3f4f5">
673 <p><tt>text</tt></p>
674 </td>
675 <td bgcolor="#f3f4f5">
676 <p>A comma separated list of object IDs.</p>
677 </td>
678 </tr>
679 </tbody>
680 </table>
681 </p>
682
683
684 <h2>Additional database tables</h2>
685
686 <p>As well as the main database tables, additional meta-data tables are used to capture extra meta-data
687 about some of the LTPDA objects.</p>
688
689 <!-- AO table -->
690 <h3><tt>ao</tt> table</h3>
691 <p>The <tt>ao</tt> table stores additional meta-data specific to analysis objects.</p>
692 <p>
693 <table cellspacing="0" class="body" cellpadding="2" border="1" width="80%">
694 <colgroup>
695 <col width="10%"/>
696 <col width="10%"/>
697 <col width="80%"/>
698 </colgroup>
699 <thead>
700 <tr valign="top">
701 <th class="categorylist">Field</th>
702 <th class="categorylist">Data Type</th>
703 <th class="categorylist">Description</th>
704 </tr>
705 </thead>
706 <tbody>
707 <!-- Field: 'id' -->
708 <tr valign="top">
709 <td bgcolor="#f3f4f5">
710 <p><tt>id</tt></p>
711 </td>
712 <td bgcolor="#f3f4f5">
713 <p><tt>int(11)</tt></p>
714 </td>
715 <td bgcolor="#f3f4f5">
716 <p>A unique identification number for all entries in the table.</p>
717 </td>
718 </tr>
719 <!-- Field: 'obj_id' -->
720 <tr valign="top">
721 <td bgcolor="#e3e4e5">
722 <p><tt>obj_id</tt></p>
723 </td>
724 <td bgcolor="#e3e4e5">
725 <p><tt>int(11)</tt></p>
726 </td>
727 <td bgcolor="#e3e4e5">
728 <p>The unique ID of the object.</p>
729 </td>
730 </tr>
731 <!-- Field: 'data_type' -->
732 <tr valign="top">
733 <td bgcolor="#f3f4f5">
734 <p><tt>data_type</tt></p>
735 </td>
736 <td bgcolor="#f3f4f5">
737 <p><tt>text</tt></p>
738 </td>
739 <td bgcolor="#f3f4f5">
740 <p>The type/class of the data stored in the AO.</p>
741 </td>
742 </tr>
743 <!-- Field: 'data_id' -->
744 <tr valign="top">
745 <td bgcolor="#e3e4e5">
746 <p><tt>data_id</tt></p>
747 </td>
748 <td bgcolor="#e3e4e5">
749 <p><tt>int(11)</tt></p>
750 </td>
751 <td bgcolor="#e3e4e5">
752 <p>The unique ID of the data object listed in one of the data meta-data tables.</p>
753 </td>
754 </tr>
755 <!-- Field: 'description' -->
756 <tr valign="top">
757 <td bgcolor="#f3f4f5">
758 <p><tt>description</tt></p>
759 </td>
760 <td bgcolor="#f3f4f5">
761 <p><tt>text</tt></p>
762 </td>
763 <td bgcolor="#f3f4f5">
764 <p>The description property of the AO.</p>
765 </td>
766 </tr>
767 <!-- Field: 'mfilename' -->
768 <tr valign="top">
769 <td bgcolor="#e3e4e5">
770 <p><tt>mfilename</tt></p>
771 </td>
772 <td bgcolor="#e3e4e5">
773 <p><tt>text</tt></p>
774 </td>
775 <td bgcolor="#e3e4e5">
776 <p>The filename of any m-file attached to the AO.</p>
777 </td>
778 </tr>
779 <!-- Field: 'mdlfilename' -->
780 <tr valign="top">
781 <td bgcolor="#f3f4f5">
782 <p><tt>mdlfilename</tt></p>
783 </td>
784 <td bgcolor="#f3f4f5">
785 <p><tt>text</tt></p>
786 </td>
787 <td bgcolor="#f3f4f5">
788 <p>The filename of any SIMULINK model file attached to the AO.</p>
789 </td>
790 </tr>
791 </tbody>
792 </table>
793 </p>
794
795 <!-- MIIR table -->
796 <h3><tt>miir</tt> table</h3>
797 <p>The <tt>miir</tt> table stores additional meta-data specific to miir filter objects.</p>
798 <p>
799 <table cellspacing="0" class="body" cellpadding="2" border="1" width="80%">
800 <colgroup>
801 <col width="10%"/>
802 <col width="10%"/>
803 <col width="80%"/>
804 </colgroup>
805 <thead>
806 <tr valign="top">
807 <th class="categorylist">Field</th>
808 <th class="categorylist">Data Type</th>
809 <th class="categorylist">Description</th>
810 </tr>
811 </thead>
812 <tbody>
813 <!-- Field: 'id' -->
814 <tr valign="top">
815 <td bgcolor="#f3f4f5">
816 <p><tt>id</tt></p>
817 </td>
818 <td bgcolor="#f3f4f5">
819 <p><tt>int(11)</tt></p>
820 </td>
821 <td bgcolor="#f3f4f5">
822 <p>A unique identification number for all entries in the table.</p>
823 </td>
824 </tr>
825 <!-- Field: 'obj_id' -->
826 <tr valign="top">
827 <td bgcolor="#e3e4e5">
828 <p><tt>obj_id</tt></p>
829 </td>
830 <td bgcolor="#e3e4e5">
831 <p><tt>int(11)</tt></p>
832 </td>
833 <td bgcolor="#e3e4e5">
834 <p>The unique ID of the object.</p>
835 </td>
836 </tr>
837 <!-- Field: 'in_file' -->
838 <tr valign="top">
839 <td bgcolor="#f3f4f5">
840 <p><tt>in_file</tt></p>
841 </td>
842 <td bgcolor="#f3f4f5">
843 <p><tt>text</tt></p>
844 </td>
845 <td bgcolor="#f3f4f5">
846 <p>The input filename (if applicable) used to create the filter object</p>
847 </td>
848 </tr>
849 <!-- Field: 'fs' -->
850 <tr valign="top">
851 <td bgcolor="#e3e4e5">
852 <p><tt>fs</tt></p>
853 </td>
854 <td bgcolor="#e3e4e5">
855 <p><tt>int(11)</tt></p>
856 </td>
857 <td bgcolor="#e3e4e5">
858 <p>The sample rate of the data the filter is designed for.</p>
859 </td>
860 </tr>
861 </tbody>
862 </table>
863 </p>
864
865 <!-- MFIR table -->
866 <h3><tt>mfir</tt> table</h3>
867 <p>The <tt>mfir</tt> table stores additional meta-data specific to mfir filter objects.</p>
868 <p>
869 <table cellspacing="0" class="body" cellpadding="2" border="1" width="80%">
870 <colgroup>
871 <col width="10%"/>
872 <col width="10%"/>
873 <col width="80%"/>
874 </colgroup>
875 <thead>
876 <tr valign="top">
877 <th class="categorylist">Field</th>
878 <th class="categorylist">Data Type</th>
879 <th class="categorylist">Description</th>
880 </tr>
881 </thead>
882 <tbody>
883 <!-- Field: 'id' -->
884 <tr valign="top">
885 <td bgcolor="#f3f4f5">
886 <p><tt>id</tt></p>
887 </td>
888 <td bgcolor="#f3f4f5">
889 <p><tt>int(11)</tt></p>
890 </td>
891 <td bgcolor="#f3f4f5">
892 <p>A unique identification number for all entries in the table.</p>
893 </td>
894 </tr>
895 <!-- Field: 'obj_id' -->
896 <tr valign="top">
897 <td bgcolor="#e3e4e5">
898 <p><tt>obj_id</tt></p>
899 </td>
900 <td bgcolor="#e3e4e5">
901 <p><tt>int(11)</tt></p>
902 </td>
903 <td bgcolor="#e3e4e5">
904 <p>The unique ID of the object.</p>
905 </td>
906 </tr>
907 <!-- Field: 'in_file' -->
908 <tr valign="top">
909 <td bgcolor="#f3f4f5">
910 <p><tt>in_file</tt></p>
911 </td>
912 <td bgcolor="#f3f4f5">
913 <p><tt>text</tt></p>
914 </td>
915 <td bgcolor="#f3f4f5">
916 <p>The input filename (if applicable) used to create the filter object</p>
917 </td>
918 </tr>
919 <!-- Field: 'fs' -->
920 <tr valign="top">
921 <td bgcolor="#e3e4e5">
922 <p><tt>fs</tt></p>
923 </td>
924 <td bgcolor="#e3e4e5">
925 <p><tt>int(11)</tt></p>
926 </td>
927 <td bgcolor="#e3e4e5">
928 <p>The sample rate of the data the filter is designed for.</p>
929 </td>
930 </tr>
931 </tbody>
932 </table>
933 </p>
934
935 <!-- TSDATA table -->
936 <h3><tt>tsdata</tt> table</h3>
937 <p>The <tt>tsdata</tt> table stores additional meta-data specific to tsdata (time-series data) objects.</p>
938 <p>
939 <table cellspacing="0" class="body" cellpadding="2" border="1" width="80%">
940 <colgroup>
941 <col width="10%"/>
942 <col width="10%"/>
943 <col width="80%"/>
944 </colgroup>
945 <thead>
946 <tr valign="top">
947 <th class="categorylist">Field</th>
948 <th class="categorylist">Data Type</th>
949 <th class="categorylist">Description</th>
950 </tr>
951 </thead>
952 <tbody>
953 <!-- Field: 'id' -->
954 <tr valign="top">
955 <td bgcolor="#f3f4f5">
956 <p><tt>id</tt></p>
957 </td>
958 <td bgcolor="#f3f4f5">
959 <p><tt>int(11)</tt></p>
960 </td>
961 <td bgcolor="#f3f4f5">
962 <p>A unique identification number for all entries in the table.</p>
963 </td>
964 </tr>
965 <!-- Field: 'xunits' -->
966 <tr valign="top">
967 <td bgcolor="#e3e4e5">
968 <p><tt>xunits</tt></p>
969 </td>
970 <td bgcolor="#e3e4e5">
971 <p><tt>text</tt></p>
972 </td>
973 <td bgcolor="#e3e4e5">
974 <p>The X-units associated with this time-series.</p>
975 </td>
976 </tr>
977 <!-- Field: 'yunits' -->
978 <tr valign="top">
979 <td bgcolor="#f3f4f5">
980 <p><tt>yunits</tt></p>
981 </td>
982 <td bgcolor="#f3f4f5">
983 <p><tt>text</tt></p>
984 </td>
985 <td bgcolor="#f3f4f5">
986 <p>The Y-units associated with this time-series.</p>
987 </td>
988 </tr>
989 <!-- Field: 'fs' -->
990 <tr valign="top">
991 <td bgcolor="#e3e4e5">
992 <p><tt>fs</tt></p>
993 </td>
994 <td bgcolor="#e3e4e5">
995 <p><tt>int(11)</tt></p>
996 </td>
997 <td bgcolor="#e3e4e5">
998 <p>The sample rate of the data the filter is designed for.</p>
999 </td>
1000 </tr>
1001 <!-- Field: 'nsecs' -->
1002 <tr valign="top">
1003 <td bgcolor="#f3f4f5">
1004 <p><tt>nsecs</tt></p>
1005 </td>
1006 <td bgcolor="#f3f4f5">
1007 <p><tt>int</tt></p>
1008 </td>
1009 <td bgcolor="#f3f4f5">
1010 <p>The duration (number of seconds) of data in the object.</p>
1011 </td>
1012 </tr>
1013 <!-- Field: 't0' -->
1014 <tr valign="top">
1015 <td bgcolor="#e3e4e5">
1016 <p><tt>t0</tt></p>
1017 </td>
1018 <td bgcolor="#e3e4e5">
1019 <p><tt>datetime</tt></p>
1020 </td>
1021 <td bgcolor="#e3e4e5">
1022 <p>The date/time associated with the start (first sample) of the time-series.</p>
1023 </td>
1024 </tr>
1025 </tbody>
1026 </table>
1027 </p>
1028
1029 <!-- FSDATA table -->
1030 <h3><tt>fsdata</tt> table</h3>
1031 <p>The <tt>fsdata</tt> table stores additional meta-data specific to fsdata (frequency-series data) objects.</p>
1032 <p>
1033 <table cellspacing="0" class="body" cellpadding="2" border="1" width="80%">
1034 <colgroup>
1035 <col width="10%"/>
1036 <col width="10%"/>
1037 <col width="80%"/>
1038 </colgroup>
1039 <thead>
1040 <tr valign="top">
1041 <th class="categorylist">Field</th>
1042 <th class="categorylist">Data Type</th>
1043 <th class="categorylist">Description</th>
1044 </tr>
1045 </thead>
1046 <tbody>
1047 <!-- Field: 'id' -->
1048 <tr valign="top">
1049 <td bgcolor="#f3f4f5">
1050 <p><tt>id</tt></p>
1051 </td>
1052 <td bgcolor="#f3f4f5">
1053 <p><tt>int(11)</tt></p>
1054 </td>
1055 <td bgcolor="#f3f4f5">
1056 <p>A unique identification number for all entries in the table.</p>
1057 </td>
1058 </tr>
1059 <!-- Field: 'xunits' -->
1060 <tr valign="top">
1061 <td bgcolor="#e3e4e5">
1062 <p><tt>xunits</tt></p>
1063 </td>
1064 <td bgcolor="#e3e4e5">
1065 <p><tt>text</tt></p>
1066 </td>
1067 <td bgcolor="#e3e4e5">
1068 <p>The X-units associated with this time-series.</p>
1069 </td>
1070 </tr>
1071 <!-- Field: 'yunits' -->
1072 <tr valign="top">
1073 <td bgcolor="#f3f4f5">
1074 <p><tt>yunits</tt></p>
1075 </td>
1076 <td bgcolor="#f3f4f5">
1077 <p><tt>text</tt></p>
1078 </td>
1079 <td bgcolor="#f3f4f5">
1080 <p>The Y-units associated with this time-series.</p>
1081 </td>
1082 </tr>
1083 <!-- Field: 'fs' -->
1084 <tr valign="top">
1085 <td bgcolor="#e3e4e5">
1086 <p><tt>fs</tt></p>
1087 </td>
1088 <td bgcolor="#e3e4e5">
1089 <p><tt>int(11)</tt></p>
1090 </td>
1091 <td bgcolor="#e3e4e5">
1092 <p>The sample rate of the data the filter is designed for.</p>
1093 </td>
1094 </tr>
1095 </tbody>
1096 </table>
1097 </p>
1098
1099 <!-- CDATA table -->
1100 <h3><tt>cdata</tt> table</h3>
1101 <p>The <tt>cdata</tt> table stores additional meta-data specific to cdata (1D data) objects.</p>
1102 <p>
1103 <table cellspacing="0" class="body" cellpadding="2" border="1" width="80%">
1104 <colgroup>
1105 <col width="10%"/>
1106 <col width="10%"/>
1107 <col width="80%"/>
1108 </colgroup>
1109 <thead>
1110 <tr valign="top">
1111 <th class="categorylist">Field</th>
1112 <th class="categorylist">Data Type</th>
1113 <th class="categorylist">Description</th>
1114 </tr>
1115 </thead>
1116 <tbody>
1117 <!-- Field: 'id' -->
1118 <tr valign="top">
1119 <td bgcolor="#f3f4f5">
1120 <p><tt>id</tt></p>
1121 </td>
1122 <td bgcolor="#f3f4f5">
1123 <p><tt>int(11)</tt></p>
1124 </td>
1125 <td bgcolor="#f3f4f5">
1126 <p>A unique identification number for all entries in the table.</p>
1127 </td>
1128 </tr>
1129 <!-- Field: 'xunits' -->
1130 <tr valign="top">
1131 <td bgcolor="#e3e4e5">
1132 <p><tt>xunits</tt></p>
1133 </td>
1134 <td bgcolor="#e3e4e5">
1135 <p><tt>text</tt></p>
1136 </td>
1137 <td bgcolor="#e3e4e5">
1138 <p>The X-units associated with this time-series.</p>
1139 </td>
1140 </tr>
1141 <!-- Field: 'yunits' -->
1142 <tr valign="top">
1143 <td bgcolor="#f3f4f5">
1144 <p><tt>yunits</tt></p>
1145 </td>
1146 <td bgcolor="#f3f4f5">
1147 <p><tt>text</tt></p>
1148 </td>
1149 <td bgcolor="#f3f4f5">
1150 <p>The Y-units associated with this time-series.</p>
1151 </td>
1152 </tr>
1153 </tbody>
1154 </table>
1155 </p>
1156
1157 <!-- CDATA table -->
1158 <h3><tt>xydata</tt> table</h3>
1159 <p>The <tt>xydata</tt> table stores additional meta-data specific to xydata (2D data) objects.</p>
1160 <p>
1161 <table cellspacing="0" class="body" cellpadding="2" border="1" width="80%">
1162 <colgroup>
1163 <col width="10%"/>
1164 <col width="10%"/>
1165 <col width="80%"/>
1166 </colgroup>
1167 <thead>
1168 <tr valign="top">
1169 <th class="categorylist">Field</th>
1170 <th class="categorylist">Data Type</th>
1171 <th class="categorylist">Description</th>
1172 </tr>
1173 </thead>
1174 <tbody>
1175 <!-- Field: 'id' -->
1176 <tr valign="top">
1177 <td bgcolor="#f3f4f5">
1178 <p><tt>id</tt></p>
1179 </td>
1180 <td bgcolor="#f3f4f5">
1181 <p><tt>int(11)</tt></p>
1182 </td>
1183 <td bgcolor="#f3f4f5">
1184 <p>A unique identification number for all entries in the table.</p>
1185 </td>
1186 </tr>
1187 <!-- Field: 'xunits' -->
1188 <tr valign="top">
1189 <td bgcolor="#e3e4e5">
1190 <p><tt>xunits</tt></p>
1191 </td>
1192 <td bgcolor="#e3e4e5">
1193 <p><tt>text</tt></p>
1194 </td>
1195 <td bgcolor="#e3e4e5">
1196 <p>The X-units associated with this time-series.</p>
1197 </td>
1198 </tr>
1199 <!-- Field: 'yunits' -->
1200 <tr valign="top">
1201 <td bgcolor="#f3f4f5">
1202 <p><tt>yunits</tt></p>
1203 </td>
1204 <td bgcolor="#f3f4f5">
1205 <p><tt>text</tt></p>
1206 </td>
1207 <td bgcolor="#f3f4f5">
1208 <p>The Y-units associated with this time-series.</p>
1209 </td>
1210 </tr>
1211 </tbody>
1212 </table>
1213 </p>
1214
1215 </p>
1216
1217 <br>
1218 <br>
1219 <table class="nav" summary="Navigation aid" border="0" width=
1220 "100%" cellpadding="0" cellspacing="0">
1221 <tr valign="top">
1222 <td align="left" width="20"><a href="repo.html"><img src=
1223 "b_prev.gif" border="0" align="bottom" alt=
1224 "Working with an LTPDA Repository"></a>&nbsp;</td>
1225
1226 <td align="left">Working with an LTPDA Repository</td>
1227
1228 <td>&nbsp;</td>
1229
1230 <td align="right">Connecting to an LTPDA Repository</td>
1231
1232 <td align="right" width="20"><a href=
1233 "repo_connect.html"><img src="b_next.gif" border="0" align=
1234 "bottom" alt="Connecting to an LTPDA Repository"></a></td>
1235 </tr>
1236 </table><br>
1237
1238 <p class="copy">&copy;LTP Team</p>
1239 </body>
1240 </html>