{"id":"https://openalex.org/W1984420914","doi":"https://doi.org/10.1145/2661829.2661834","title":"A Demonstration of SearchonTS","display_name":"A Demonstration of SearchonTS","publication_year":2014,"publication_date":"2014-11-03","ids":{"openalex":"https://openalex.org/W1984420914","doi":"https://doi.org/10.1145/2661829.2661834","mag":"1984420914"},"language":"en","primary_location":{"id":"doi:10.1145/2661829.2661834","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2661829.2661834","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 23rd ACM International Conference on Conference on Information and Knowledge Management","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5010060406","display_name":"Xiaomin Xu","orcid":"https://orcid.org/0000-0003-2432-3106"},"institutions":[{"id":"https://openalex.org/I4210126794","display_name":"IBM Research (China)","ror":"https://ror.org/02yg1pf55","country_code":"CN","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115","https://openalex.org/I4210126794"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Xiaomin Xu","raw_affiliation_strings":["IBM China Research Laboratory, Shang Hai, China"],"affiliations":[{"raw_affiliation_string":"IBM China Research Laboratory, Shang Hai, China","institution_ids":["https://openalex.org/I4210126794"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102752342","display_name":"Sheng Huang","orcid":"https://orcid.org/0009-0001-4692-5522"},"institutions":[{"id":"https://openalex.org/I4210126794","display_name":"IBM Research (China)","ror":"https://ror.org/02yg1pf55","country_code":"CN","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115","https://openalex.org/I4210126794"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Sheng Huang","raw_affiliation_strings":["IBM China Research Laboratory, Shang Hai, China"],"affiliations":[{"raw_affiliation_string":"IBM China Research Laboratory, Shang Hai, China","institution_ids":["https://openalex.org/I4210126794"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055794991","display_name":"Yaoliang Chen","orcid":"https://orcid.org/0000-0002-9763-7803"},"institutions":[{"id":"https://openalex.org/I4210126794","display_name":"IBM Research (China)","ror":"https://ror.org/02yg1pf55","country_code":"CN","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115","https://openalex.org/I4210126794"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yaoliang Chen","raw_affiliation_strings":["IBM China Research Laboratory, Shang Hai, China"],"affiliations":[{"raw_affiliation_string":"IBM China Research Laboratory, Shang Hai, China","institution_ids":["https://openalex.org/I4210126794"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100337643","display_name":"Chen Wang","orcid":"https://orcid.org/0000-0003-0204-2362"},"institutions":[{"id":"https://openalex.org/I4210126794","display_name":"IBM Research (China)","ror":"https://ror.org/02yg1pf55","country_code":"CN","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115","https://openalex.org/I4210126794"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chen Wang","raw_affiliation_strings":["IBM China Research Laboratory, Bei Jing, China"],"affiliations":[{"raw_affiliation_string":"IBM China Research Laboratory, Bei Jing, China","institution_ids":["https://openalex.org/I4210126794"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5025391208","display_name":"Inge Halilovic","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Inge Halilovic","raw_affiliation_strings":["IBM Informix Product Team, San Francisco, CA, USA"],"affiliations":[{"raw_affiliation_string":"IBM Informix Product Team, San Francisco, CA, USA","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5013448232","display_name":"Kevin Brown","orcid":"https://orcid.org/0000-0002-6891-4189"},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kevin Brown","raw_affiliation_strings":["IBM Informix Product Team, San Francisco, CA, USA"],"affiliations":[{"raw_affiliation_string":"IBM Informix Product Team, San Francisco, CA, USA","institution_ids":["https://openalex.org/I1341412227"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5067820257","display_name":"Mark Ashworth","orcid":"https://orcid.org/0000-0001-6514-9904"},"institutions":[{"id":"https://openalex.org/I4210113654","display_name":"IBM (Canada)","ror":"https://ror.org/025sxka56","country_code":"CA","type":"company","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210113654"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Mark Ashworth","raw_affiliation_strings":["IBM Informix Product Team, Tronto, Canada"],"affiliations":[{"raw_affiliation_string":"IBM Informix Product Team, Tronto, Canada","institution_ids":["https://openalex.org/I4210113654"]}]}],"institutions":[],"countries_distinct_count":3,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5010060406"],"corresponding_institution_ids":["https://openalex.org/I4210126794"],"apc_list":null,"apc_paid":null,"fwci":0.5885,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.6538001,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"2015","last_page":"2017"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12205","display_name":"Time Series Analysis and Forecasting","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T12205","display_name":"Time Series Analysis and Forecasting","score":0.9998000264167786,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9908000230789185,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9850999712944031,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8084828853607178},{"id":"https://openalex.org/keywords/pattern-search","display_name":"Pattern search","score":0.5760634541511536},{"id":"https://openalex.org/keywords/series","display_name":"Series (stratigraphy)","score":0.5571423172950745},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.5492725372314453},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.510536789894104},{"id":"https://openalex.org/keywords/database-index","display_name":"Database index","score":0.4955660104751587},{"id":"https://openalex.org/keywords/ibm","display_name":"IBM","score":0.49364006519317627},{"id":"https://openalex.org/keywords/usability","display_name":"Usability","score":0.4905666708946228},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.44874733686447144},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.44859492778778076},{"id":"https://openalex.org/keywords/time-series","display_name":"Time series","score":0.4400988817214966},{"id":"https://openalex.org/keywords/index","display_name":"Index (typography)","score":0.4361977279186249},{"id":"https://openalex.org/keywords/inverted-index","display_name":"Inverted index","score":0.43321770429611206},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.35783615708351135},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3446110188961029},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.2023700773715973},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.10485318303108215},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.0962429940700531},{"id":"https://openalex.org/keywords/human\u2013computer-interaction","display_name":"Human\u2013computer interaction","score":0.08856213092803955}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8084828853607178},{"id":"https://openalex.org/C82691427","wikidata":"https://www.wikidata.org/wiki/Q4291856","display_name":"Pattern search","level":2,"score":0.5760634541511536},{"id":"https://openalex.org/C143724316","wikidata":"https://www.wikidata.org/wiki/Q312468","display_name":"Series (stratigraphy)","level":2,"score":0.5571423172950745},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.5492725372314453},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.510536789894104},{"id":"https://openalex.org/C59276292","wikidata":"https://www.wikidata.org/wiki/Q580427","display_name":"Database index","level":3,"score":0.4955660104751587},{"id":"https://openalex.org/C70388272","wikidata":"https://www.wikidata.org/wiki/Q5968558","display_name":"IBM","level":2,"score":0.49364006519317627},{"id":"https://openalex.org/C170130773","wikidata":"https://www.wikidata.org/wiki/Q216378","display_name":"Usability","level":2,"score":0.4905666708946228},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.44874733686447144},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.44859492778778076},{"id":"https://openalex.org/C151406439","wikidata":"https://www.wikidata.org/wiki/Q186588","display_name":"Time series","level":2,"score":0.4400988817214966},{"id":"https://openalex.org/C2777382242","wikidata":"https://www.wikidata.org/wiki/Q6017816","display_name":"Index (typography)","level":2,"score":0.4361977279186249},{"id":"https://openalex.org/C130590232","wikidata":"https://www.wikidata.org/wiki/Q1671754","display_name":"Inverted index","level":3,"score":0.43321770429611206},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.35783615708351135},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3446110188961029},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2023700773715973},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.10485318303108215},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.0962429940700531},{"id":"https://openalex.org/C107457646","wikidata":"https://www.wikidata.org/wiki/Q207434","display_name":"Human\u2013computer interaction","level":1,"score":0.08856213092803955},{"id":"https://openalex.org/C171250308","wikidata":"https://www.wikidata.org/wiki/Q11468","display_name":"Nanotechnology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2661829.2661834","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2661829.2661834","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 23rd ACM International Conference on Conference on Information and Knowledge Management","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/9","score":0.4300000071525574,"display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":7,"referenced_works":["https://openalex.org/W1970013651","https://openalex.org/W1982107955","https://openalex.org/W2033832147","https://openalex.org/W2099302229","https://openalex.org/W2110704543","https://openalex.org/W2119323564","https://openalex.org/W2128061541"],"related_works":["https://openalex.org/W2573939812","https://openalex.org/W2120098008","https://openalex.org/W1639806124","https://openalex.org/W4366145086","https://openalex.org/W2902831276","https://openalex.org/W2540682188","https://openalex.org/W4385834214","https://openalex.org/W3022423983","https://openalex.org/W12347151","https://openalex.org/W2957025774"],"abstract_inverted_index":{"In":[0],"recent":[1],"years,":[2],"time":[3,17,54,77,89,104,115],"series":[4,18,55,78,90,105,110,116],"data":[5,19,79],"are":[6],"everywhere":[7],"across":[8],"different":[9],"industry,":[10],"which":[11,141],"creates":[12],"a":[13,46,109,127,143,153,193],"huge":[14],"demand":[15,61],"on":[16,53,88,103,139],"analysis,":[20],"such":[21],"as":[22,136],"pattern":[23,33,65,86,101,119,163,186],"search.":[24],"Meanwhile,":[25],"it":[26],"is":[27,134,142,179],"increasingly":[28],"realized":[29],"that":[30,62,114,189],"only":[31],"when":[32],"search":[34,66,102,120,164,187],"results":[35],"together":[36],"with":[37],"information":[38],"from":[39],"relational":[40],"tables":[41],"could":[42,67],"be":[43,68,122],"used":[44],"in":[45,126,146],"programming-free":[47],"way,":[48],"can":[49,121,191],"they":[50],"perform":[51,85],"analysis":[52],"conveniently.":[56],"Hence,":[57],"casual":[58],"users":[59,190],"highly":[60],"queries":[63],"involving":[64,185],"performed":[69,125],"via":[70,168],"SQLs.":[71],"However,":[72],"existing":[73],"database":[74,144],"products":[75],"supporting":[76],"type":[80],"lack":[81],"the":[82,198],"capability":[83],"to":[84,170,182],"searches":[87],"data.":[91,106],"This":[92],"paper":[93],"presents":[94],"SearchonTS,":[95],"an":[96,137],"extendable":[97],"framework":[98],"for":[99,165,174],"in-database":[100],"It":[107,151],"provides":[108],"of":[111,156,197],"interfaces":[112],"so":[113,188],"index":[117],"and":[118,124,129],"added":[123],"uniformed":[128],"query":[130],"optimized":[131],"manner.":[132],"SearchonTS":[133],"implemented":[135,161],"extension":[138],"Informix,":[140],"product":[145,149],"IBM":[147,157],"software":[148],"series.":[150],"targets":[152],"future":[154],"release":[155],"Informix.":[158],"We":[159],"have":[160,192],"index-based":[162],"Euclid":[166],"Distance(ED)":[167],"SearhonTS":[169],"demonstrate":[171],"its":[172],"usability":[173],"developers.":[175],"And":[176],"real":[177],"scenario":[178],"also":[180],"provided":[181],"show":[183],"SQL":[184],"more":[194],"clear":[195],"experience":[196],"convenience.":[199]},"counts_by_year":[{"year":2017,"cited_by_count":2}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}