1# Copyright (c) 2003-2004 The Regents of The University of Michigan
2# All rights reserved.
3#
4# Redistribution and use in source and binary forms, with or without
5# modification, are permitted provided that the following conditions are
6# met: redistributions of source code must retain the above copyright
7# notice, this list of conditions and the following disclaimer;
8# redistributions in binary form must reproduce the above copyright

--- 86 unchanged lines hidden (view full) ---

95 rn_project VARCHAR(100) NOT NULL,
96 rn_date TIMESTAMP NOT NULL,
97 rn_expire TIMESTAMP NOT NULL,
98 PRIMARY KEY (rn_id),
99 UNIQUE (rn_name,rn_sample)
100 ) TYPE=InnoDB''')
101
102 #
103 # The stat table gives us all of the data for a particular stat.
104 #
105 # COLUMNS:
106 # 'stat' is a unique identifier for each stat to be used in other
107 # tables for references.
108 # 'name' is simply the simulator derived name for a given
109 # statistic.
110 # 'descr' is the description of the statistic and what it tells

--- 84 unchanged lines hidden (view full) ---

195 # -5: maximum value
196 # -6: underflow
197 # -7: overflow
198 # 'y' is used by a VECTORDIST and the VECTOR2D to describe the second
199 # dimension.
200 # 'run' is the run that the data was generated from. Details up in
201 # the run table
202 # 'tick' is a timestamp generated by the simulator.
203 # 'data' is the actual stat value.
204 #
205 # INDEXES:
206 # 'stat' is indexed so that a user can find all of the data for a
207 # particular stat. It is not unique, because that specific stat
208 # can be found in many runs and samples, in addition to
209 # having entries for the mulidimensional cases.
210 # 'run' is indexed to allow a user to remove all of the data for a
211 # particular execution run. It can also be used to allow the
212 # user to print out all of the data for a given run.
213 #
214 self.query('''
215 CREATE TABLE data(
216 dt_stat SMALLINT UNSIGNED NOT NULL,
217 dt_x SMALLINT NOT NULL,
218 dt_y SMALLINT NOT NULL,
219 dt_run SMALLINT UNSIGNED NOT NULL,
220 dt_tick BIGINT UNSIGNED NOT NULL,
221 dt_data DOUBLE NOT NULL,
222 INDEX (dt_stat),
223 INDEX (dt_run),
224 UNIQUE (dt_stat,dt_x,dt_y,dt_run,dt_tick)
225 ) TYPE=InnoDB;''')
226
227 #
228 # Names and descriptions for multi-dimensional stats (vectors, etc.)
229 # are stored here instead of having their own entry in the statistics
230 # table. This allows all parts of a single stat to easily share a
231 # single id.
232 #

--- 135 unchanged lines hidden (view full) ---

368
369 self.query('''
370 DELETE subdata
371 FROM subdata
372 LEFT JOIN data ON sd_stat=dt_stat
373 WHERE dt_stat IS NULL''')
374
375 self.query('''
376 DELETE events
377 FROM events
378 LEFT JOIN runs ON ev_run=rn_id
379 WHERE rn_id IS NULL''')
380
381 self.query('''
382 DELETE event_names
383 FROM event_names
384 LEFT JOIN events ON en_id=ev_event
385 WHERE ev_event IS NULL''')