{"id":"https://openalex.org/W46119896","doi":"https://doi.org/10.1007/978-1-4302-6742-3_2","title":"Memory Performance Analysis","display_name":"Memory Performance Analysis","alternate_titles":[],"publication_year":2014,"publication_date":"2014-08-27","ids":{"openalex":"https://openalex.org/W46119896","doi":"https://doi.org/10.1007/978-1-4302-6742-3_2","mag":"46119896"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4302-6742-3_2","doi":"https://doi.org/10.1007/978-1-4302-6742-3_2","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-6742-3_2","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"SQL Server Query Performance Tuning","raw_type":"book-chapter"},"parent_works":[{"id":"https://openalex.org/W2479662415","display_name":"SQL Server Query Performance Tuning","relationship":"volume"}],"lineage":["https://openalex.org/W46119896","https://openalex.org/W2479662415"],"child_works_count":0,"type":"book-chapter","is_traditional":true,"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/A5064569577","display_name":"Grant Fritchey","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Grant Fritchey","raw_affiliation_strings":["MA, US","Grafton, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MA, US","institution_ids":[]},{"raw_affiliation_string":"Grafton, USA","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5064569577"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"17","last_page":"34"},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9771000146865845,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9771000146865845,"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.012299999594688416,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/T12127","display_name":"Software System Performance and Reliability","score":0.005900000222027302,"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/sql-server","display_name":"SQL Server","score":0.9390000104904175},{"id":"https://openalex.org/keywords/memory-performance","display_name":"memory performance","score":0.7239999771118164},{"id":"https://openalex.org/keywords/memory-management","display_name":"memory management","score":0.800000011920929},{"id":"https://openalex.org/keywords/query-performance","display_name":"query performance","score":0.7229999899864197},{"id":"https://openalex.org/keywords/disk-i-o","display_name":"disk I/O","score":0.6539999842643738},{"id":"https://openalex.org/keywords/central-processing-unit","display_name":"CPU","score":0.6959999799728394}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8240506649017334},{"id":"https://openalex.org/C74426580","wikidata":"https://www.wikidata.org/wiki/Q719484","display_name":"Memory map","level":3,"score":0.6665130853652954},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.4856042265892029},{"id":"https://openalex.org/C123593499","wikidata":"https://www.wikidata.org/wiki/Q6008583","display_name":"In-Memory Processing","level":5,"score":0.46191906929016113},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.4305677115917206},{"id":"https://openalex.org/C111696304","wikidata":"https://www.wikidata.org/wiki/Q2303697","display_name":"Sorting","level":2,"score":0.42749008536338806},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.420623779296875},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.40372341871261597},{"id":"https://openalex.org/C133875982","wikidata":"https://www.wikidata.org/wiki/Q764810","display_name":"Shared memory","level":2,"score":0.23208537697792053},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.20745545625686646},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.18667832016944885},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.18472972512245178},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.08756065368652344},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0664827823638916}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-1-4302-6742-3_2","doi":"https://doi.org/10.1007/978-1-4302-6742-3_2","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-6742-3_2","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"SQL Server Query Performance Tuning","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W175221152","https://openalex.org/W2385079608","https://openalex.org/W4291130775","https://openalex.org/W163653278","https://openalex.org/W2275898399","https://openalex.org/W211658065","https://openalex.org/W2041803160","https://openalex.org/W2392467230","https://openalex.org/W141342222","https://openalex.org/W7126395840"],"abstract_inverted_index":{"A":[0],"system":[1],"can":[2],"directly":[3],"impact":[4],"SQL":[5,40],"Server":[6,41],"and":[7,19],"the":[8,59,75,80,113,116],"queries":[9],"running":[10],"on":[11],"it":[12],"in":[13,28,31,39,79,91],"three":[14],"primary":[15],"places:":[16],"memory,":[17],"disk,":[18],"CPU.":[20],"You\u2019re":[21],"going":[22],"to":[23,51,64,67,86,94,97],"explore":[24],"each":[25],"of":[26,74,77,106,115],"these":[27],"turn":[29],"starting,":[30],"this":[32,108],"chapter,":[33],"with":[34],"memory.":[35,48],"Queries":[36],"retrieving":[37],"data":[38,46,52,84],"must":[42],"first":[43,54],"load":[44],"that":[45,120],"into":[47,56],"Any":[49],"changes":[50],"are":[53,61],"loaded":[55],"memory":[57,78,114,124],"where":[58],"modifications":[60],"made,":[62],"prior":[63],"writing":[65],"them":[66],"disk.":[68],"Many":[69],"other":[70],"operations":[71],"take":[72],"advantage":[73],"speed":[76],"system,":[81,117],"from":[82],"sorting":[83],"due":[85],"an":[87],"ORDER":[88],"BY":[89],"clause":[90],"a":[92],"query":[93],"performing":[95],"calculations":[96],"create":[98],"hash":[99],"tables":[100],"for":[101],"joining":[102],"two":[103],"tables.":[104],"Because":[105],"all":[107],"work":[109],"being":[110,126],"done":[111],"within":[112],"it\u2019s":[118],"important":[119],"you":[121],"understand":[122],"how":[123],"is":[125],"managed.":[127]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W46119896","counts_by_year":[],"updated_date":"2026-11-15T12:55:33.944570","created_date":"2016-06-24T00:00:00"}
