{"id":"https://openalex.org/W2229313173","doi":null,"title":"Mastering Oracle SQL, 2nd Edition","display_name":"Mastering Oracle SQL, 2nd Edition","alternate_titles":[],"publication_year":2004,"publication_date":"2004-06-01","ids":{"openalex":"https://openalex.org/W2229313173","mag":"2229313173"},"language":"en","primary_location":{"id":"mag:2229313173","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=1096113","pdf_url":null,"source":{"id":"https://openalex.org/S4306477235","display_name":"O'Reilly Media, Inc. 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":null,"is_accepted":false,"is_published":false,"raw_source_name":"O'Reilly Media, Inc. eBooks","raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W2229313173"],"child_works_count":0,"type":"book","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/A5017134251","display_name":"Sanjay M. Mishra","orcid":"https://orcid.org/0000-0002-4984-8198","observed_orcids":["https://orcid.org/0000-0002-4984-8198"]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Sanjay Mishra","raw_affiliation_strings":[],"raw_orcid":"https://orcid.org/0000-0002-4984-8198","affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5061006421","display_name":"Alan Beaulieu","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Alan Beaulieu","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.157,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.62988115,"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":null,"last_page":null},"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.9961000084877014,"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.9961000084877014,"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.002300000051036477,"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/T11106","display_name":"Data Management and Algorithms","score":0.00019999999494757503,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/oracle-sql","display_name":"Oracle SQL","score":0.996999979019165},{"id":"https://openalex.org/keywords/oracle-database-10g","display_name":"Oracle 10g","score":0.8769999742507935},{"id":"https://openalex.org/keywords/database-programming","display_name":"database programming","score":0.6460000276565552},{"id":"https://openalex.org/keywords/oracle-database","display_name":"Oracle database","score":0.41600000858306885},{"id":"https://openalex.org/keywords/query-optimization","display_name":"query optimization","score":0.5669999718666077}],"concepts":[{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.8829394578933716},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.874679684638977},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.7444201707839966},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6839553117752075},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.603885293006897},{"id":"https://openalex.org/C22664368","wikidata":"https://www.wikidata.org/wiki/Q4045949","display_name":"Oracle Unified Method","level":5,"score":0.49895262718200684},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.42920389771461487},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3794897794723511},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.25511687994003296},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.23108509182929993},{"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/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:2229313173","doi":null,"is_oa":false,"landing_page_url":"https://dl.acm.org/citation.cfm?id=1096113","pdf_url":null,"source":{"id":"https://openalex.org/S4306477235","display_name":"O'Reilly Media, Inc. 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":null,"is_accepted":false,"is_published":false,"raw_source_name":"O'Reilly Media, Inc. eBooks","raw_type":null}],"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/W2321393648","https://openalex.org/W4253488555","https://openalex.org/W2339210100","https://openalex.org/W207326370","https://openalex.org/W4312142150","https://openalex.org/W2327539013","https://openalex.org/W604962236","https://openalex.org/W82726918","https://openalex.org/W589814810","https://openalex.org/W2290904476"],"abstract_inverted_index":{"Updated":[0],"to":[1,39,57],"cover":[2],"Oracle":[3,13,48,55],"10g,":[4],"this":[5,50],"new":[6],"edition":[7],"of":[8,47],"the":[9,33,41],"highly":[10],"regarded":[11],"Mastering":[12],"SQL":[14,26,56],"has":[15],"a":[16],"stronger":[17],"focus":[18],"on":[19,24,32],"practical,":[20],"expert":[21],"best-practices":[22],"and":[23],"Oracle-specific":[25],"technique":[27],"than":[28],"any":[29],"other":[30],"book":[31],"market.":[34],"For":[35],"those":[36],"who":[37],"want":[38],"harness":[40],"untapped":[42],"(and":[43],"often":[44],"overlooked)":[45],"power":[46],"SQL,":[49],"essential":[51],"guide":[52],"for":[53],"putting":[54],"work":[58],"will":[59],"prove":[60],"invaluable.":[61]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2229313173","counts_by_year":[{"year":2026,"cited_by_count":1}],"updated_date":"2026-11-16T12:05:36.265796","created_date":"2016-06-24T00:00:00"}
