{"id":"https://openalex.org/W2188435073","doi":null,"title":"Exploring the Undocumented PROC SQL _METHOD Option","display_name":"Exploring the Undocumented PROC SQL _METHOD Option","alternate_titles":[],"publication_year":2008,"publication_date":"2008-01-01","ids":{"openalex":"https://openalex.org/W2188435073","mag":"2188435073"},"language":"en","primary_location":{"id":"mag:2188435073","doi":null,"is_oa":false,"landing_page_url":"https://support.sas.com/resources/papers/proceedings09/063-2009.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W2188435073"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"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/A5026255237","display_name":"Kirk Paul Lafler","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Kirk Paul Lafler","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5026255237"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.2185,"has_fulltext":false,"cited_by_count":4,"citation_normalized_percentile":{"value":0.81970204,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":92,"max":95},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13820","display_name":"SAS software applications and methods","score":0.7372999787330627,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/T13820","display_name":"SAS software applications and methods","score":0.7372999787330627,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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.23690000176429749,"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/T13681","display_name":"Engineering and Information Technology","score":0.0031999999191612005,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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/proc-sql","display_name":"PROC SQL","score":0.9049999713897705},{"id":"https://openalex.org/keywords/query-processing","display_name":"query processing","score":0.7210000157356262},{"id":"https://openalex.org/keywords/query-tuning","display_name":"query tuning","score":0.781000018119812}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7750208377838135},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6106876730918884},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.49007880687713623},{"id":"https://openalex.org/C150451098","wikidata":"https://www.wikidata.org/wiki/Q506059","display_name":"SQL injection","level":5,"score":0.44569703936576843},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.43937239050865173},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.43406182527542114},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.42522525787353516},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.349279522895813},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.32804322242736816},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.21798953413963318},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.08859509229660034},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:2188435073","doi":null,"is_oa":false,"landing_page_url":"https://support.sas.com/resources/papers/proceedings09/063-2009.pdf","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":2,"referenced_works":["https://openalex.org/W2111400712","https://openalex.org/W2129884316"],"related_works":["https://openalex.org/W7099738040","https://openalex.org/W2185211776","https://openalex.org/W2129884316","https://openalex.org/W7095358854","https://openalex.org/W2185719075","https://openalex.org/W2184130383","https://openalex.org/W7099883873","https://openalex.org/W2184780789","https://openalex.org/W7097777304","https://openalex.org/W2187384491"],"abstract_inverted_index":{"The":[0],"SQL":[1,11],"Procedure":[2],"contains":[3],"many":[4],"powerful":[5,39],"and":[6,27,38,44],"elegant":[7],"language":[8],"features":[9],"for":[10],"users":[12],"to":[13,34,41],"take":[14],"advantage":[15],"of.":[16],"This":[17],"paper":[18],"explores":[19],"the":[20],"_METHOD":[21],"option":[22,40],"as":[23],"an":[24],"applications":[25],"development":[26],"tuning":[28],"tool.":[29],"Attendees":[30],"will":[31],"learn":[32],"how":[33,46],"use":[35],"this":[36],"undocumented":[37],"better":[42],"understand":[43],"control":[45],"a":[47],"query":[48],"processes.":[49]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2188435073","counts_by_year":[{"year":2013,"cited_by_count":2}],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2016-06-24T00:00:00"}
