Database » History » Version 8

Marcus Pearce, 2014-03-05 11:27 AM

1 2 Jeremy Gow
h1. Database management
2 1 Jeremy Gow
3 7 Jeremy Gow
Having [[start|started IDyOM]] and connected to a database, you can examine read and edit its contents.  The [[Installation]] page explains how to create a database.
4 1 Jeremy Gow
5 6 Jeremy Gow
{{>toc}}
6 1 Jeremy Gow
7 6 Jeremy Gow
h2. Describing the database  
8 6 Jeremy Gow
9 4 Jeremy Gow
A quick way of listing the database contents is:
10 4 Jeremy Gow
11 1 Jeremy Gow
<pre>
12 8 Marcus Pearce
CL-USER> (mtp-admin:describe-database)
13 5 Jeremy Gow
0    Songs and ballads from Nova Scotia, Canada.
14 5 Jeremy Gow
1    Chorale melodies harmonised by J.S. Bach.
15 5 Jeremy Gow
2    Chorale soprano melodies harmonised by J.S. Bach.
16 5 Jeremy Gow
3    Alsatian folk songs from the Essen Folk Song Collection.
17 4 Jeremy Gow
...
18 4 Jeremy Gow
</pre>
19 1 Jeremy Gow
20 8 Marcus Pearce
Datasets can be examine in more detail using the verbose option in <code>describe-database</code> and <code>describe-dataset</code>:
21 4 Jeremy Gow
<pre>
22 8 Marcus Pearce
CL-USER> (mtp-admin:describe-database :verbose t)
23 1 Jeremy Gow
24 1 Jeremy Gow
 Songs and ballads from Nova Scotia, Canada.
25 1 Jeremy Gow
 -----------------------------------------------------------------------------
26 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
27 1 Jeremy Gow
 0          152                  8552                 56.263157           
28 1 Jeremy Gow
 -----------------------------------------------------------------------------
29 1 Jeremy Gow
30 1 Jeremy Gow
 Chorale melodies harmonised by J.S. Bach.
31 1 Jeremy Gow
 -----------------------------------------------------------------------------
32 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
33 1 Jeremy Gow
 1          185                  9227                 49.875675           
34 1 Jeremy Gow
 -----------------------------------------------------------------------------
35 1 Jeremy Gow
36 1 Jeremy Gow
 Chorale soprano melodies harmonised by J.S. Bach.
37 1 Jeremy Gow
 -----------------------------------------------------------------------------
38 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
39 1 Jeremy Gow
 2          100                  4693                 46.93               
40 1 Jeremy Gow
 -----------------------------------------------------------------------------
41 1 Jeremy Gow
42 1 Jeremy Gow
 Alsatian folk songs from the Essen Folk Song Collection.
43 1 Jeremy Gow
 -----------------------------------------------------------------------------
44 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
45 1 Jeremy Gow
 3          91                   4496                 49.406593           
46 1 Jeremy Gow
 -----------------------------------------------------------------------------
47 1 Jeremy Gow
48 1 Jeremy Gow
... 
49 1 Jeremy Gow
50 8 Marcus Pearce
 Pop melodies used in a segmentation experiment with Daniel Muellensiefen.
51 1 Jeremy Gow
 -----------------------------------------------------------------------------
52 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
53 1 Jeremy Gow
 29         15                   1265                 84.333336           
54 1 Jeremy Gow
 -----------------------------------------------------------------------------
55 1 Jeremy Gow
56 1 Jeremy Gow
 Hymn melodies from Hymns Ancient and Modern.
57 1 Jeremy Gow
 -----------------------------------------------------------------------------
58 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
59 1 Jeremy Gow
 30         120                  4280                 35.666668           
60 1 Jeremy Gow
 -----------------------------------------------------------------------------
61 1 Jeremy Gow
(0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30)
62 1 Jeremy Gow
</pre> 
63 1 Jeremy Gow
64 1 Jeremy Gow
<pre> 
65 1 Jeremy Gow
CL-USER> (mtp-admin:describe-dataset 0 :verbose t)
66 1 Jeremy Gow
67 1 Jeremy Gow
 Songs and ballads from Nova Scotia, Canada.
68 1 Jeremy Gow
 -----------------------------------------------------------------------------
69 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
70 1 Jeremy Gow
 0          152                  8552                 56.263157           
71 1 Jeremy Gow
 -----------------------------------------------------------------------------
72 1 Jeremy Gow
 CPITCH (26):     (54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
73 1 Jeremy Gow
                   72 73 74 75 76 77 79 81)
74 1 Jeremy Gow
 MPITCH (17):     (31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47)
75 1 Jeremy Gow
 ACCIDENTAL (3):  (-1 0 1)
76 1 Jeremy Gow
 DUR (14):        (3 4 6 8 12 16 18 24 36 48 60 72 96 120)
77 1 Jeremy Gow
 DELTAST (7):     (0 12 24 36 48 60 72)
78 1 Jeremy Gow
 BIOI (17):       (1 3 4 6 8 12 16 18 24 30 36 48 60 72 84 96 120)
79 1 Jeremy Gow
 KEYSIG (9):      (-4 -3 -2 -1 0 1 2 3 4)
80 1 Jeremy Gow
 MODE (2):        (0 9)
81 1 Jeremy Gow
 BARLENGTH (7):   (36 48 72 96 120 144 168)
82 1 Jeremy Gow
 PULSES (6):      (2 3 4 5 6 7)
83 1 Jeremy Gow
 PHRASE (3):      (-1 0 1)
84 1 Jeremy Gow
 DYN (1):         (NIL)
85 1 Jeremy Gow
 TEMPO (19):      (52 54 60 64 76 80 82 84 92 96 100 108 110 112 120 132
86 1 Jeremy Gow
                   144 152 172)
87 1 Jeremy Gow
 VOICE (1):       (1)
88 1 Jeremy Gow
 -----------------------------------------------------------------------------NIL
89 1 Jeremy Gow
CL-USER> 
90 1 Jeremy Gow
91 1 Jeremy Gow
</pre> 
92 1 Jeremy Gow
93 1 Jeremy Gow
94 6 Jeremy Gow
h2. Importing data  
95 1 Jeremy Gow
96 1 Jeremy Gow
Before you can do this you will need to import some data. Methods exist for **kern files and midi files.
97 1 Jeremy Gow
98 1 Jeremy Gow
<pre> 
99 1 Jeremy Gow
CL-USER> (mtp-admin:import-data :krn "/home/mas01mtp/research/data/kern/shanxi237/" "A test dataset" 31)
100 1 Jeremy Gow
Inserting data into database: dataset 31.
101 1 Jeremy Gow
NIL
102 1 Jeremy Gow
CL-USER> (mtp-admin:describe-dataset 31)
103 1 Jeremy Gow
104 1 Jeremy Gow
 A test dataset
105 1 Jeremy Gow
 -----------------------------------------------------------------------------
106 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
107 1 Jeremy Gow
 31         237                  11056                46.649788           
108 1 Jeremy Gow
 -----------------------------------------------------------------------------NIL
109 1 Jeremy Gow
CL-USER> 
110 1 Jeremy Gow
</pre>
111 1 Jeremy Gow
112 1 Jeremy Gow
<pre> 
113 8 Marcus Pearce
CL-USER> (mtp-admin:import-data :mid "/home/marcusp/research/data/midi/Witchcraft/" "Melodies used in an experiment by de Noojier et al. (2008)" 32)
114 1 Jeremy Gow
115 1 Jeremy Gow
Inserting data into database: dataset 32.NIL
116 1 Jeremy Gow
CL-USER> (mtp-admin:describe-dataset 32)
117 1 Jeremy Gow
118 1 Jeremy Gow
 Melodies used in de Noojier et al. (2008)
119 1 Jeremy Gow
 -----------------------------------------------------------------------------
120 1 Jeremy Gow
 ID         No. Compositions     No. events           Mean events/composition
121 1 Jeremy Gow
 32         10                   313                  31.3                
122 1 Jeremy Gow
 -----------------------------------------------------------------------------
123 1 Jeremy Gow
</pre> 
124 1 Jeremy Gow
125 6 Jeremy Gow
h2. Exporting data  
126 1 Jeremy Gow
127 1 Jeremy Gow
<pre>
128 1 Jeremy Gow
CL-USER> (mtp-admin:export-data (mtp-admin:get-composition 31 0) :mid "/tmp/")
129 1 Jeremy Gow
NIL
130 1 Jeremy Gow
</pre> 
131 1 Jeremy Gow
132 1 Jeremy Gow
Produces a midi file.
133 1 Jeremy Gow
134 1 Jeremy Gow
<pre>
135 1 Jeremy Gow
CL-USER> (mtp-admin:export-data (mtp-admin:get-composition 31 0) :lisp "/tmp/")
136 1 Jeremy Gow
NIL
137 1 Jeremy Gow
</pre> 
138 1 Jeremy Gow
139 1 Jeremy Gow
Produces a lisp readable representation of the dataset.
140 1 Jeremy Gow
141 1 Jeremy Gow
<pre>
142 1 Jeremy Gow
CL-USER> (mtp-admin:export-data (mtp-admin:get-composition 31 0) :ly "/tmp/")
143 1 Jeremy Gow
NIL
144 1 Jeremy Gow
</pre> 
145 1 Jeremy Gow
146 1 Jeremy Gow
Produces a lilypond file.
147 1 Jeremy Gow
148 1 Jeremy Gow
<pre>
149 1 Jeremy Gow
CL-USER> (mtp-admin:export-data (mtp-admin:get-composition 31 0) :pdf "/tmp/")
150 1 Jeremy Gow
NIL
151 1 Jeremy Gow
</pre> 
152 1 Jeremy Gow
153 1 Jeremy Gow
Produces a pdf score (via lilypond).
154 1 Jeremy Gow
155 1 Jeremy Gow
h2. Deleting a dataset  
156 1 Jeremy Gow
157 1 Jeremy Gow
<pre>
158 1 Jeremy Gow
CL-USER> (mtp-admin:delete-dataset 735)
159 1 Jeremy Gow
</pre>
160 1 Jeremy Gow
161 1 Jeremy Gow
deletes dataset 735 from the database.