A dynamic model for the optimal selection of secondary indexes

Hatzopoulos, M; Kollias, JG

dc.contributor.author	Hatzopoulos, M	en
dc.contributor.author	Kollias, JG	en
dc.date.accessioned	2014-03-01T01:06:07Z
dc.date.available	2014-03-01T01:06:07Z
dc.date.issued	1983	en
dc.identifier.issn	0306-4379	en
dc.identifier.uri	https://dspace.lib.ntua.gr/xmlui/handle/123456789/9175
dc.subject	Dynamic Model	en
dc.subject	Indexation	en
dc.subject.classification	Computer Science, Information Systems	en
dc.subject.other	INFORMATION SCIENCE - Indexing	en
dc.subject.other	DATA PROCESSING	en
dc.title	A dynamic model for the optimal selection of secondary indexes	en
heal.type	journalArticle	en
heal.identifier.primary	10.1016/0306-4379(83)90002-9	en
heal.identifier.secondary	http://dx.doi.org/10.1016/0306-4379(83)90002-9	en
heal.language	English	en
heal.publicationDate	1983	en
heal.abstract	A model is presented which determines the optimal degree of secondary indexing for data processing requirements which follow variations over different time periods in a manner known in advance. The paper proves a number of properties which characterize the model and develops an algorithm which greatly reduces the solution space to be searched. The algorithm uses dynamic programming techniques and it may be used by Database Administrators to determine the time at which the entering and dropping of secondary indexes to and from the database should take place. © 1983.	en
heal.publisher	PERGAMON-ELSEVIER SCIENCE LTD	en
heal.journalName	Information Systems	en
dc.identifier.doi	10.1016/0306-4379(83)90002-9	en
dc.identifier.isi	ISI:A1983RV82300002	en
dc.identifier.volume	8	en
dc.identifier.issue	3	en
dc.identifier.spage	159	en
dc.identifier.epage	164	en