{"id":"https://openalex.org/W2115372154","doi":"https://doi.org/10.1109/ccis.2011.6045079","title":"The research and design of SQL processing in a data-mining system based on MapReduce","display_name":"The research and design of SQL processing in a data-mining system based on MapReduce","publication_year":2011,"publication_date":"2011-09-01","ids":{"openalex":"https://openalex.org/W2115372154","doi":"https://doi.org/10.1109/ccis.2011.6045079","mag":"2115372154"},"language":"en","primary_location":{"id":"doi:10.1109/ccis.2011.6045079","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ccis.2011.6045079","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2011 IEEE International Conference on Cloud Computing and Intelligence Systems","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/A5100603174","display_name":"Lei Zhang","orcid":"https://orcid.org/0000-0001-8074-906X"},"institutions":[{"id":"https://openalex.org/I139759216","display_name":"Beijing University of Posts and Telecommunications","ror":"https://ror.org/04w9fbh59","country_code":"CN","type":"education","lineage":["https://openalex.org/I139759216"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Lei Zhang","raw_affiliation_strings":["Beijing Key Laboratory of Intelligent Telecommunications Software and Multimedia, Beijing University of Posts and Telecommunications, Beijing, China","Beijing Key Laboratory of Intelligent Telecommunications Software and Multimedia, Beijing University of Posts and Telecommunications, Beijing, China#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Beijing Key Laboratory of Intelligent Telecommunications Software and Multimedia, Beijing University of Posts and Telecommunications, Beijing, China","institution_ids":["https://openalex.org/I139759216"]},{"raw_affiliation_string":"Beijing Key Laboratory of Intelligent Telecommunications Software and Multimedia, Beijing University of Posts and Telecommunications, Beijing, China#TAB#","institution_ids":["https://openalex.org/I139759216"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5114310114","display_name":"Kaiping Li","orcid":"https://orcid.org/0000-0002-6465-7445"},"institutions":[{"id":"https://openalex.org/I139759216","display_name":"Beijing University of Posts and Telecommunications","ror":"https://ror.org/04w9fbh59","country_code":"CN","type":"education","lineage":["https://openalex.org/I139759216"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Kaiping Li","raw_affiliation_strings":["Beijing Key Laboratory of Intelligent Telecommunications Software and Multimedia, Beijing University of Posts and Telecommunications, Beijing, China","Beijing Key Laboratory of Intelligent Telecommunications Software and Multimedia, Beijing University of Posts and Telecommunications, Beijing, China#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Beijing Key Laboratory of Intelligent Telecommunications Software and Multimedia, Beijing University of Posts and Telecommunications, Beijing, China","institution_ids":["https://openalex.org/I139759216"]},{"raw_affiliation_string":"Beijing Key Laboratory of Intelligent Telecommunications Software and Multimedia, Beijing University of Posts and Telecommunications, Beijing, China#TAB#","institution_ids":["https://openalex.org/I139759216"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101432128","display_name":"Bin Wu","orcid":"https://orcid.org/0000-0002-7112-126X"},"institutions":[{"id":"https://openalex.org/I139759216","display_name":"Beijing University of Posts and Telecommunications","ror":"https://ror.org/04w9fbh59","country_code":"CN","type":"education","lineage":["https://openalex.org/I139759216"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Bin Wu","raw_affiliation_strings":["Beijing Key Laboratory of Intelligent Telecommunications Software and Multimedia, Beijing University of Posts and Telecommunications, Beijing, China","Beijing Key Laboratory of Intelligent Telecommunications Software and Multimedia, Beijing University of Posts and Telecommunications, Beijing, China#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Beijing Key Laboratory of Intelligent Telecommunications Software and Multimedia, Beijing University of Posts and Telecommunications, Beijing, China","institution_ids":["https://openalex.org/I139759216"]},{"raw_affiliation_string":"Beijing Key Laboratory of Intelligent Telecommunications Software and Multimedia, Beijing University of Posts and Telecommunications, Beijing, China#TAB#","institution_ids":["https://openalex.org/I139759216"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.7641,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.83876984,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"301","last_page":"305"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9973999857902527,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9973999857902527,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.9965999722480774,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9850000143051147,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8751693964004517},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.8072803020477295},{"id":"https://openalex.org/keywords/in-memory-processing","display_name":"In-Memory Processing","score":0.6296996474266052},{"id":"https://openalex.org/keywords/user-defined-function","display_name":"User-defined function","score":0.5880845189094543},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.5856911540031433},{"id":"https://openalex.org/keywords/data-processing","display_name":"Data processing","score":0.5768041014671326},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5425139665603638},{"id":"https://openalex.org/keywords/point","display_name":"Point (geometry)","score":0.4565048813819885},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.4446672201156616},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.41531819105148315},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.35828423500061035},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.18204239010810852},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.15437737107276917},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.06919381022453308}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8751693964004517},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8072803020477295},{"id":"https://openalex.org/C123593499","wikidata":"https://www.wikidata.org/wiki/Q6008583","display_name":"In-Memory Processing","level":5,"score":0.6296996474266052},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.5880845189094543},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5856911540031433},{"id":"https://openalex.org/C138827492","wikidata":"https://www.wikidata.org/wiki/Q6661985","display_name":"Data processing","level":2,"score":0.5768041014671326},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5425139665603638},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.4565048813819885},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.4446672201156616},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.41531819105148315},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.35828423500061035},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.18204239010810852},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.15437737107276917},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.06919381022453308},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/ccis.2011.6045079","is_oa":false,"landing_page_url":"https://doi.org/10.1109/ccis.2011.6045079","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2011 IEEE International Conference on Cloud Computing and Intelligence Systems","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320311089","display_name":"National Security Agency","ror":"https://ror.org/0047bvr32"},{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":6,"referenced_works":["https://openalex.org/W2005112390","https://openalex.org/W2042852274","https://openalex.org/W2044490410","https://openalex.org/W2061601738","https://openalex.org/W2125775320","https://openalex.org/W2157355837"],"related_works":["https://openalex.org/W1488984669","https://openalex.org/W2614112517","https://openalex.org/W2108932068","https://openalex.org/W2240099544","https://openalex.org/W2512476881","https://openalex.org/W1890845846","https://openalex.org/W4381745637","https://openalex.org/W66203700","https://openalex.org/W2362753095","https://openalex.org/W2183669956"],"abstract_inverted_index":{"SQL":[0,100],"as":[1],"a":[2,39,68,92,105,115],"database":[3],"language":[4],"has":[5],"been":[6],"widely":[7],"used":[8,24],"in":[9,25],"the":[10,18,29,55,61,76],"modern":[11],"society.":[12],"Its":[13],"function":[14],"mainly":[15,80],"focuses":[16],"on":[17,103],"data":[19,35,56,62,85],"processing,":[20],"which":[21,95],"can":[22,47,66,96],"be":[23,67],"data-mining.":[26],"Due":[27],"to":[28,53,59,74,81],"rapid":[30],"growth":[31],"of":[32,42],"data,":[33],"large-scale":[34,84],"processing":[36,101],"is":[37,79],"becoming":[38],"focal":[40],"point":[41],"information":[43],"techniques.":[44],"Though":[45],"we":[46,90,112],"still":[48],"use":[49],"SQL,":[50],"but":[51],"where":[52],"store":[54,107],"and":[57,108],"how":[58],"get":[60],"efficiently,":[63],"cost":[64],"effectively,":[65],"tricky":[69],"problem.":[70,77],"Cloud":[71],"computing":[72,109],"emerges":[73],"solve":[75],"It":[78],"deal":[82,98],"with":[83,99],"processing.":[86],"In":[87],"this":[88],"paper,":[89],"design":[91],"data-mining":[93],"system":[94],"directly":[97],"based":[102],"Hadoop,":[104],"parallel":[106],"platform.":[110],"Then":[111],"will":[113],"have":[114],"discussion":[116],"about":[117],"running":[118],"time's":[119],"efficiencies.":[120]},"counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}