{"id":"https://openalex.org/W32921960","doi":null,"title":"The SQL Programmer's Reference, with CD","display_name":"The SQL Programmer's Reference, with CD","publication_year":1998,"publication_date":"1998-02-01","ids":{"openalex":"https://openalex.org/W32921960","mag":"32921960"},"language":"en","primary_location":{"id":"mag:32921960","doi":null,"is_oa":false,"landing_page_url":"https://www.amazon.com/SQL-Programmers-Reference-Windows-Unix/dp/1566047609","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},"volume":null,"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/A5016258386","display_name":"Wayne S. Freeze","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Wayne S. Freeze","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5016258386"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.4506,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.69350649,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.8521000146865845,"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.8521000146865845,"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.14229999482631683,"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/T11734","display_name":"Decision Support System Applications","score":0.0006000000284984708,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.9490000009536743},{"id":"https://openalex.org/keywords/database-management-systems","display_name":"database management systems","score":0.6949999928474426},{"id":"https://openalex.org/keywords/microsoft-access-97","display_name":"Microsoft Access 97","score":0.9259999990463257},{"id":"https://openalex.org/keywords/sql-server","display_name":"SQL Server","score":0.8859999775886536},{"id":"https://openalex.org/keywords/ibm-db2","display_name":"DB2","score":0.9679999947547913},{"id":"https://openalex.org/keywords/informix","display_name":"Informix","score":0.9700000286102295},{"id":"https://openalex.org/keywords/database-programming","display_name":"database programming","score":0.6549999713897705}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.809821367263794},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.7185608148574829},{"id":"https://openalex.org/C114724005","wikidata":"https://www.wikidata.org/wiki/Q5001740","display_name":"Business Intelligence Markup Language","level":5,"score":0.6493762731552124},{"id":"https://openalex.org/C2777315864","wikidata":"https://www.wikidata.org/wiki/Q15853013","display_name":"Visual Basic","level":3,"score":0.6104210615158081},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.603805422782898},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.5685133934020996},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.5680838227272034},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5483412146568298},{"id":"https://openalex.org/C32145003","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"PL/SQL","level":5,"score":0.5307089686393738},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5273165106773376},{"id":"https://openalex.org/C2984286706","wikidata":"https://www.wikidata.org/wiki/Q400708","display_name":"Sql server","level":2,"score":0.5058462619781494},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.45203083753585815},{"id":"https://openalex.org/C112968700","wikidata":"https://www.wikidata.org/wiki/Q11368","display_name":"Unix","level":3,"score":0.4464937746524811},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.43957725167274475},{"id":"https://openalex.org/C2778514511","wikidata":"https://www.wikidata.org/wiki/Q1374194","display_name":"Programmer","level":2,"score":0.4239666163921356},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3175407648086548},{"id":"https://openalex.org/C94925161","wikidata":"https://www.wikidata.org/wiki/Q6666854","display_name":"Log shipping","level":4,"score":0.2578476071357727},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.23843833804130554},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.20079892873764038},{"id":"https://openalex.org/C166930804","wikidata":"https://www.wikidata.org/wiki/Q573731","display_name":"Internet Authentication Service","level":3,"score":0.143986314535141},{"id":"https://openalex.org/C164554305","wikidata":"https://www.wikidata.org/wiki/Q71550","display_name":"Application server","level":2,"score":0.0834067165851593},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:32921960","doi":null,"is_oa":false,"landing_page_url":"https://www.amazon.com/SQL-Programmers-Reference-Windows-Unix/dp/1566047609","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/W1530112783","https://openalex.org/W2409869228"],"related_works":["https://openalex.org/W2338081051","https://openalex.org/W7022019006","https://openalex.org/W4234537680","https://openalex.org/W2738771389","https://openalex.org/W2521335221","https://openalex.org/W7068530220","https://openalex.org/W560308870","https://openalex.org/W647002924","https://openalex.org/W2612068935","https://openalex.org/W2738342198"],"abstract_inverted_index":{"From":[0],"the":[1,11,46,49,52,75,88,127,137],"Publisher:\r\nThe":[2],"SQL":[3,20,27,37,81,90,98,105,158],"Programmer's":[4,169],"Reference":[5,170],"provides":[6],"all":[7],"critical":[8],"information":[9],"on":[10],"most":[12],"popular":[13,150],"database":[14],"systems:":[15],"Oracle":[16],"8":[17],"SQL,":[18,96],"Sybase":[19,97],"Server":[21,28,99,106],"1.1,":[22],"Microsoft":[23,26,101,104],"Access":[24,102],"97,":[25,103],"6.5,":[29,107],"IMB":[30],"DB2":[31,109],"5.0,":[32,110],"Informix":[33,111],"7,":[34],"and":[35,43,65,123,178],"ANSI":[36,89],"Standard.":[38],"Covering":[39],"UNIX,":[40],"Windows":[41,44],"95,":[42],"NT,":[45],"book":[47],"explains":[48],"differences":[50],"among":[51],"various":[53],"vendors'":[54],"implementations":[55],"of":[56,71,126,139,148],"SQL.":[57,72],"The":[58,165],"encyclopedic":[59,115],"organization,":[60],"with":[61,92,159],"thumbtabs,":[62],"enables":[63],"easy":[64,118],"quick":[66],"access":[67],"to":[68,79],"every":[69],"aspect":[70],"Icons":[73],"identify":[74],"features":[76],"that":[77],"apply":[78],"each":[80,93],"implementation.\r\n\r\nContains":[82],"a":[83,132,149],"complete":[84],"reference":[85],"for":[86,117,136],"SQL.\r\nCompares":[87],"Standard":[91],"implementation":[94],"(Oracle8":[95],"11,":[100],"IBM":[108],"7.2).\r\nOrganized":[112],"in":[113],"an":[114],"format":[116],"reference.\r\nFeatures":[119],"examples,":[120],"tips,":[121],"tricks,":[122],"warnings.\r\n\r\nHyperlinked":[124],"version":[125],"book\r\n\r\nWayne":[128],"S.":[129],"Freeze":[130],"is":[131],"technical":[133],"support":[134],"manager":[135],"University":[138],"Maryland":[140],"at":[141],"College":[142],"Park's":[143],"Administrative":[144],"Computer":[145],"Center.":[146],"Author":[147],"shareware":[151],"program":[152],"called":[153],"Car":[154],"Collector,":[155],"which":[156],"uses":[157],"Visual":[160,166,173,182],"Basic,":[161],"he":[162],"also":[163],"wrote":[164],"Basic":[167,174,183],"5":[168,184],"(Ventana),":[171],"Leveraging":[172],"With":[175,181],"ActiveX":[176],"Controls,":[177],"Programming":[179],"ISAPI":[180],"(both":[185],"by":[186],"Prima":[187],"Publishing).":[188]},"counts_by_year":[],"updated_date":"2026-08-08T07:41:36.138363","created_date":"2016-06-24T00:00:00"}