<> <http://www.w3.org/2000/01/rdf-schema#comment> "The repository administrator has not yet configured an RDF license."^^<http://www.w3.org/2001/XMLSchema#string> . <> <http://xmlns.com/foaf/0.1/primaryTopic> <https://discovery.ucl.ac.uk/id/eprint/10122956> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/ontology/bibo/Article> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://purl.org/dc/terms/title> "Optimising SQL Queries Using Genetic Improvement"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://purl.org/ontology/bibo/abstract> "Structured Query Language (SQL) queries are ubiquitous in modern software engineering. These queries can be costly when run on large databases with many entries and tables to consider. We propose using Genetic Improvement (GI) to explore patches for these queries, with the aim of optimising their execution time, whilst maintaining the functionality of the program in which they are utilised. Specifically, we propose three ways in which SQL JOIN statements can be mutated in order to improve performance. We also discuss the requirements of software being improved in this manner and the potential challenges of our approach."^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://purl.org/dc/terms/date> "2021-07-07" . <https://discovery.ucl.ac.uk/id/document/1275422> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/ontology/bibo/Document> . <https://discovery.ucl.ac.uk/id/org/ext-af0a9a5baed87c407844a3f5db44597c> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Organization> . <https://discovery.ucl.ac.uk/id/org/ext-af0a9a5baed87c407844a3f5db44597c> <http://xmlns.com/foaf/0.1/name> "IEEE"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://purl.org/dc/terms/publisher> <https://discovery.ucl.ac.uk/id/org/ext-af0a9a5baed87c407844a3f5db44597c> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://purl.org/ontology/bibo/status> <http://purl.org/ontology/bibo/status/published> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://purl.org/dc/terms/creator> <https://discovery.ucl.ac.uk/id/person/ext-cbbccf58186469cb15be420c6eba536a> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://purl.org/ontology/bibo/authorList> <https://discovery.ucl.ac.uk/id/eprint/10122956#authors> . <https://discovery.ucl.ac.uk/id/eprint/10122956#authors> <http://www.w3.org/1999/02/22-rdf-syntax-ns#_1> <https://discovery.ucl.ac.uk/id/person/ext-cbbccf58186469cb15be420c6eba536a> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://purl.org/dc/terms/creator> <https://discovery.ucl.ac.uk/id/person/ext-041214cc60efa790dc2902084a21fe6e> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://purl.org/ontology/bibo/authorList> <https://discovery.ucl.ac.uk/id/eprint/10122956#authors> . <https://discovery.ucl.ac.uk/id/eprint/10122956#authors> <http://www.w3.org/1999/02/22-rdf-syntax-ns#_2> <https://discovery.ucl.ac.uk/id/person/ext-041214cc60efa790dc2902084a21fe6e> . <https://discovery.ucl.ac.uk/id/person/ext-cbbccf58186469cb15be420c6eba536a> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> . <https://discovery.ucl.ac.uk/id/person/ext-cbbccf58186469cb15be420c6eba536a> <http://xmlns.com/foaf/0.1/givenName> "J"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/person/ext-cbbccf58186469cb15be420c6eba536a> <http://xmlns.com/foaf/0.1/familyName> "Callan"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/person/ext-cbbccf58186469cb15be420c6eba536a> <http://xmlns.com/foaf/0.1/name> "J Callan"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/person/ext-041214cc60efa790dc2902084a21fe6e> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://xmlns.com/foaf/0.1/Person> . <https://discovery.ucl.ac.uk/id/person/ext-041214cc60efa790dc2902084a21fe6e> <http://xmlns.com/foaf/0.1/givenName> "J"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/person/ext-041214cc60efa790dc2902084a21fe6e> <http://xmlns.com/foaf/0.1/familyName> "Petke"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/person/ext-041214cc60efa790dc2902084a21fe6e> <http://xmlns.com/foaf/0.1/name> "J Petke"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/ontology/bibo/Article> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://purl.org/ontology/bibo/presentedAt> <https://discovery.ucl.ac.uk/id/event/ext-ea3b1c58b87a5eeb8b1af966019ebff1> . <https://discovery.ucl.ac.uk/id/event/ext-ea3b1c58b87a5eeb8b1af966019ebff1> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://purl.org/ontology/bibo/Conference> . <https://discovery.ucl.ac.uk/id/event/ext-ea3b1c58b87a5eeb8b1af966019ebff1> <http://purl.org/dc/terms/title> "The 10th International Workshop on Genetic Improvement @ ICSE 2021"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://eprints.org/ontology/EPrint> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://eprints.org/ontology/ProceedingsSectionEPrint> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://purl.org/dc/terms/isPartOf> <https://discovery.ucl.ac.uk/id/repository> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://eprints.org/ontology/hasDocument> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275422> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://eprints.org/ontology/Document> . <https://discovery.ucl.ac.uk/id/document/1275422> <http://www.w3.org/2000/01/rdf-schema#label> "Optimising SQL Queries Using Genetic Improvement (Text)"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://purl.org/dc/elements/1.1/hasVersion> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://eprints.org/ontology/hasAccepted> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275422> <http://eprints.org/ontology/hasFile> <https://discovery.ucl.ac.uk/id/eprint/10122956/1/main.pdf> . <https://discovery.ucl.ac.uk/id/document/1275422> <http://purl.org/dc/terms/hasPart> <https://discovery.ucl.ac.uk/id/eprint/10122956/1/main.pdf> . <https://discovery.ucl.ac.uk/id/eprint/10122956/1/main.pdf> <http://www.w3.org/2000/01/rdf-schema#label> "main.pdf"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://eprints.org/ontology/hasDocument> <https://discovery.ucl.ac.uk/id/document/1275423> . <https://discovery.ucl.ac.uk/id/document/1275423> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://eprints.org/ontology/Document> . <https://discovery.ucl.ac.uk/id/document/1275423> <http://www.w3.org/2000/01/rdf-schema#label> "Optimising SQL Queries Using Genetic Improvement (Other)"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/document/1275423> <http://eprints.org/relation/isVersionOf> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275423> <http://eprints.org/relation/isVolatileVersionOf> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275423> <http://eprints.org/relation/islightboxThumbnailVersionOf> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275423> <http://eprints.org/ontology/hasFile> <https://discovery.ucl.ac.uk/id/eprint/10122956/2/lightbox.jpg> . <https://discovery.ucl.ac.uk/id/document/1275423> <http://purl.org/dc/terms/hasPart> <https://discovery.ucl.ac.uk/id/eprint/10122956/2/lightbox.jpg> . <https://discovery.ucl.ac.uk/id/eprint/10122956/2/lightbox.jpg> <http://www.w3.org/2000/01/rdf-schema#label> "lightbox.jpg"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://eprints.org/ontology/hasDocument> <https://discovery.ucl.ac.uk/id/document/1275424> . <https://discovery.ucl.ac.uk/id/document/1275424> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://eprints.org/ontology/Document> . <https://discovery.ucl.ac.uk/id/document/1275424> <http://www.w3.org/2000/01/rdf-schema#label> "Optimising SQL Queries Using Genetic Improvement (Other)"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/document/1275424> <http://eprints.org/relation/isVersionOf> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275424> <http://eprints.org/relation/isVolatileVersionOf> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275424> <http://eprints.org/relation/ispreviewThumbnailVersionOf> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275424> <http://eprints.org/ontology/hasFile> <https://discovery.ucl.ac.uk/id/eprint/10122956/3/preview.jpg> . <https://discovery.ucl.ac.uk/id/document/1275424> <http://purl.org/dc/terms/hasPart> <https://discovery.ucl.ac.uk/id/eprint/10122956/3/preview.jpg> . <https://discovery.ucl.ac.uk/id/eprint/10122956/3/preview.jpg> <http://www.w3.org/2000/01/rdf-schema#label> "preview.jpg"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://eprints.org/ontology/hasDocument> <https://discovery.ucl.ac.uk/id/document/1275425> . <https://discovery.ucl.ac.uk/id/document/1275425> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://eprints.org/ontology/Document> . <https://discovery.ucl.ac.uk/id/document/1275425> <http://www.w3.org/2000/01/rdf-schema#label> "Optimising SQL Queries Using Genetic Improvement (Other)"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/document/1275425> <http://eprints.org/relation/isVersionOf> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275425> <http://eprints.org/relation/isVolatileVersionOf> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275425> <http://eprints.org/relation/ismediumThumbnailVersionOf> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275425> <http://eprints.org/ontology/hasFile> <https://discovery.ucl.ac.uk/id/eprint/10122956/4/medium.jpg> . <https://discovery.ucl.ac.uk/id/document/1275425> <http://purl.org/dc/terms/hasPart> <https://discovery.ucl.ac.uk/id/eprint/10122956/4/medium.jpg> . <https://discovery.ucl.ac.uk/id/eprint/10122956/4/medium.jpg> <http://www.w3.org/2000/01/rdf-schema#label> "medium.jpg"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://eprints.org/ontology/hasDocument> <https://discovery.ucl.ac.uk/id/document/1275426> . <https://discovery.ucl.ac.uk/id/document/1275426> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://eprints.org/ontology/Document> . <https://discovery.ucl.ac.uk/id/document/1275426> <http://www.w3.org/2000/01/rdf-schema#label> "Optimising SQL Queries Using Genetic Improvement (Other)"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/document/1275426> <http://eprints.org/relation/isVersionOf> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275426> <http://eprints.org/relation/isVolatileVersionOf> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275426> <http://eprints.org/relation/issmallThumbnailVersionOf> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275426> <http://eprints.org/ontology/hasFile> <https://discovery.ucl.ac.uk/id/eprint/10122956/5/small.jpg> . <https://discovery.ucl.ac.uk/id/document/1275426> <http://purl.org/dc/terms/hasPart> <https://discovery.ucl.ac.uk/id/eprint/10122956/5/small.jpg> . <https://discovery.ucl.ac.uk/id/eprint/10122956/5/small.jpg> <http://www.w3.org/2000/01/rdf-schema#label> "small.jpg"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://eprints.org/ontology/hasDocument> <https://discovery.ucl.ac.uk/id/document/1275427> . <https://discovery.ucl.ac.uk/id/document/1275427> <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://eprints.org/ontology/Document> . <https://discovery.ucl.ac.uk/id/document/1275427> <http://www.w3.org/2000/01/rdf-schema#label> "Optimising SQL Queries Using Genetic Improvement (Other)"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/document/1275427> <http://eprints.org/relation/isVersionOf> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275427> <http://eprints.org/relation/isVolatileVersionOf> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275427> <http://eprints.org/relation/isIndexCodesVersionOf> <https://discovery.ucl.ac.uk/id/document/1275422> . <https://discovery.ucl.ac.uk/id/document/1275427> <http://eprints.org/ontology/hasFile> <https://discovery.ucl.ac.uk/id/eprint/10122956/6/indexcodes.txt> . <https://discovery.ucl.ac.uk/id/document/1275427> <http://purl.org/dc/terms/hasPart> <https://discovery.ucl.ac.uk/id/eprint/10122956/6/indexcodes.txt> . <https://discovery.ucl.ac.uk/id/eprint/10122956/6/indexcodes.txt> <http://www.w3.org/2000/01/rdf-schema#label> "indexcodes.txt"^^<http://www.w3.org/2001/XMLSchema#string> . <https://discovery.ucl.ac.uk/id/eprint/10122956> <http://www.w3.org/2000/01/rdf-schema#seeAlso> <https://discovery.ucl.ac.uk/id/eprint/10122956/> . <https://discovery.ucl.ac.uk/id/eprint/10122956/> <http://purl.org/dc/elements/1.1/title> "HTML Summary of #10122956 \n\nOptimising SQL Queries Using Genetic Improvement\n\n" . <https://discovery.ucl.ac.uk/id/eprint/10122956/> <http://purl.org/dc/elements/1.1/format> "text/html" . <https://discovery.ucl.ac.uk/id/eprint/10122956/> <http://xmlns.com/foaf/0.1/primaryTopic> <https://discovery.ucl.ac.uk/id/eprint/10122956> .