{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2022,4,2]],"date-time":"2022-04-02T16:29:28Z","timestamp":1648916968303},"reference-count":30,"publisher":"Elsevier BV","issue":"4","license":[{"start":{"date-parts":[[1989,2,1]],"date-time":"1989-02-01T00:00:00Z","timestamp":602294400000},"content-version":"tdm","delay-in-days":0,"URL":"https:\/\/www.elsevier.com\/tdm\/userlicense\/1.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Data & Knowledge Engineering"],"published-print":{"date-parts":[[1989,2]]},"DOI":"10.1016\/0169-023x(89)90015-3","type":"journal-article","created":{"date-parts":[[2003,3,14]],"date-time":"2003-03-14T17:15:20Z","timestamp":1047662120000},"page":"303-322","source":"Crossref","is-referenced-by-count":2,"title":["Some aspects of a physical database design and reorganisation tool (PDRT)"],"prefix":"10.1016","volume":"3","author":[{"given":"P.M.","family":"Stewart","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"D.A.","family":"Bell","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"F.J.","family":"McErlean","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"78","reference":[{"issue":"No. 2","key":"10.1016\/0169-023X(89)90015-3_BIB1","doi-asserted-by":"crossref","first-page":"181","DOI":"10.1016\/0306-4379(85)90035-3","article-title":"DATAID-1: A database design methodology","volume":"Vol. 10","author":"De Antonellis","year":"1985","journal-title":"Information Systems"},{"issue":"No. 2","key":"10.1016\/0169-023X(89)90015-3_BIB2","doi-asserted-by":"crossref","first-page":"97","DOI":"10.1145\/320455.320457","article-title":"SYSTEM R: Relational approach to database management","volume":"Vol. 1","author":"Astrahan","year":"1976","journal-title":"ACM Transactions on Database Systems"},{"key":"10.1016\/0169-023X(89)90015-3_BIB3","doi-asserted-by":"crossref","first-page":"31","DOI":"10.1108\/eb005671","article-title":"Physical record clustering in databases","volume":"Vol. 13","author":"Bell","year":"1984","journal-title":"Kybernetes"},{"issue":"No. 4","key":"10.1016\/0169-023X(89)90015-3_BIB4","doi-asserted-by":"crossref","first-page":"315","DOI":"10.1093\/comjnl\/27.4.315","article-title":"Difficult data placement problems","volume":"Vol. 27","author":"Bell","year":"1984","journal-title":"Computer J."},{"key":"10.1016\/0169-023X(89)90015-3_BIB5","first-page":"25","article-title":"Capture and analysis of data placement requirements","author":"Bell","year":"1986"},{"issue":"No. 3","key":"10.1016\/0169-023X(89)90015-3_BIB6","doi-asserted-by":"crossref","DOI":"10.1093\/comjnl\/31.3.253","article-title":"Clustering related tuples in databases","volume":"Vol. 31","author":"Bell","year":"1988","journal-title":"Computer J."},{"key":"10.1016\/0169-023X(89)90015-3_BIB7","series-title":"Proc. ISDBMS Conference","article-title":"Some issues in database performance","author":"Bell","year":"1987"},{"key":"10.1016\/0169-023X(89)90015-3_BIB8","article-title":"The application of simulated annealing to clustering tuples in databases","author":"Bell","year":"1989","journal-title":"J. American Soc. Information Sci. (JASIS)"},{"key":"10.1016\/0169-023X(89)90015-3_BIB9","series-title":"Proc. IEEE Conf. on Data Engineering","article-title":"Piecewise uniform technique for relational size estimation during database query evaluation","author":"Bell","year":"1989"},{"key":"10.1016\/0169-023X(89)90015-3_BIB10","series-title":"Proc. ICOD1","first-page":"99","article-title":"Automatic Generation of storage structures for a DBTG data base system","author":"Blanken","year":"1980"},{"issue":"No. 3","key":"10.1016\/0169-023X(89)90015-3_BIB11","doi-asserted-by":"crossref","first-page":"209","DOI":"10.2307\/1269076","article-title":"Generalised simulated annealing for function optimisation","volume":"Vol. 28","author":"Bohachevsky","year":"1986","journal-title":"Technometrics"},{"key":"10.1016\/0169-023X(89)90015-3_BIB12","first-page":"3","article-title":"Query optimisation in relational database systems","author":"Ceri","year":"1984"},{"key":"10.1016\/0169-023X(89)90015-3_BIB13","series-title":"Proc. ACM SIGMOD Int. Con. \u2018Management of Data\u2019 (ACM)","first-page":"110","article-title":"A procedure for the determination of attribute access probabilities","author":"Clark","year":"1978"},{"key":"10.1016\/0169-023X(89)90015-3_BIB14","doi-asserted-by":"crossref","unstructured":"D. Comer, The ubiquitous B-tree, ACM Computing Surveys Vol. 11, No. 2, 121\u2013137","DOI":"10.1145\/356770.356776"},{"key":"10.1016\/0169-023X(89)90015-3_BIB15","doi-asserted-by":"crossref","first-page":"560","DOI":"10.1145\/1994.2022","article-title":"Principles of database buffer management","volume":"9, 4","author":"Effelsberg","year":"1984","journal-title":"ACM Trans. Database Systems"},{"key":"10.1016\/0169-023X(89)90015-3_BIB16","doi-asserted-by":"crossref","unstructured":"M. Hatzopoulos and J. Kollias, On the selection of a reduced set of indexes, Computer J., Vol. 28, No. 4, pp. 406\u2013408.","DOI":"10.1093\/comjnl\/28.4.406"},{"key":"10.1016\/0169-023X(89)90015-3_BIB17","article-title":"Optimal performance of inverted files","author":"Hoffer","year":"1981","journal-title":"Operations Research"},{"issue":"No. 2","key":"10.1016\/0169-023X(89)90015-3_BIB18","doi-asserted-by":"crossref","first-page":"111","DOI":"10.1145\/356924.356928","article-title":"Query optimisation in database systems","volume":"Vol. 16","author":"Jarke","year":"1984","journal-title":"Computing Surveys"},{"key":"10.1016\/0169-023X(89)90015-3_BIB19","series-title":"Query Processing in Database Systems","author":"Kim","year":"1985"},{"key":"10.1016\/0169-023X(89)90015-3_BIB20","article-title":"Using the piecewise uniform query optimisation technique in Experimental Distributed Database System (EDDS)","author":"Ling","year":"1987","journal-title":"Database Technology"},{"key":"10.1016\/0169-023X(89)90015-3_BIB21","series-title":"Proc. Int. Conf. \u2018Databases: Improving Reliability and Responsiveness\u2019","article-title":"Storage allocation for access path minimisation in network structured databases","author":"Malmquist","year":"1978"},{"issue":"No. 6","key":"10.1016\/0169-023X(89)90015-3_BIB22","doi-asserted-by":"crossref","DOI":"10.1063\/1.1699114","article-title":"Equation of state calculation by fast computing machines","volume":"Vol. 21","author":"Metropolis","year":"1953","journal-title":"J. Chemical Physics"},{"key":"10.1016\/0169-023X(89)90015-3_BIB23","first-page":"131","article-title":"Performance-oriented database design laboratory","author":"Orlando","year":"1984"},{"key":"10.1016\/0169-023X(89)90015-3_BIB24","doi-asserted-by":"crossref","DOI":"10.1016\/0306-4379(75)90003-4","article-title":"Optimal selection of secondary indices for files","volume":"Vol. 1","author":"Schkolnick","year":"1975","journal-title":"Information Systems"},{"key":"10.1016\/0169-023X(89)90015-3_BIB25","series-title":"Proc. ACM SIGMOD Conf. \u2018Management of Data\u2019","article-title":"Access path selection in a relational database management system","author":"Selinger","year":"1979"},{"key":"10.1016\/0169-023X(89)90015-3_BIB26","series-title":"Proc. 7th. Conf. \u2018Very Large Databases\u2019","article-title":"Database system performance prediction using an analytical model","author":"Sevcik","year":"1981"},{"key":"10.1016\/0169-023X(89)90015-3_BIB27","article-title":"Development of a load analysis methodology for a physical database design tool","author":"Stewart","year":"1987","journal-title":"University of Ulster report"},{"key":"10.1016\/0169-023X(89)90015-3_BIB28","unstructured":"J.D. Ullman, B-trees, Principles of Database Systems, Chpt. 2.4 58\u201364, (Computer Science Press)."},{"key":"10.1016\/0169-023X(89)90015-3_BIB29","series-title":"Proc. Int. Conf. \u2018Foundations of Data Organisation\u2019","article-title":"Index selection in relational databases","author":"Whang","year":"1985"},{"key":"10.1016\/0169-023X(89)90015-3_BIB30","series-title":"Relational Database Language (SQL)","author":"X\/OPEN Portability Guide: Data Management","year":"1987"}],"container-title":["Data & Knowledge Engineering"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:0169023X89900153?httpAccept=text\/xml","content-type":"text\/xml","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/api.elsevier.com\/content\/article\/PII:0169023X89900153?httpAccept=text\/plain","content-type":"text\/plain","content-version":"vor","intended-application":"text-mining"}],"deposited":{"date-parts":[[2019,3,26]],"date-time":"2019-03-26T15:26:10Z","timestamp":1553613970000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/0169023X89900153"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1989,2]]},"references-count":30,"journal-issue":{"issue":"4","published-print":{"date-parts":[[1989,2]]}},"alternative-id":["0169023X89900153"],"URL":"https:\/\/doi.org\/10.1016\/0169-023x(89)90015-3","relation":{},"ISSN":["0169-023X"],"issn-type":[{"value":"0169-023X","type":"print"}],"subject":[],"published":{"date-parts":[[1989,2]]}}}