{"id":"https://openalex.org/W198059675","doi":null,"title":"MySQL Stored Procedure Programming","display_name":"MySQL Stored Procedure Programming","publication_year":2006,"publication_date":"2006-03-28","ids":{"openalex":"https://openalex.org/W198059675","mag":"198059675"},"language":"en","primary_location":{"id":"pmh:oai:cds.cern.ch:1509862","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/1509862","pdf_url":null,"source":{"id":"https://openalex.org/S4306402195","display_name":"CERN Document Server (European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},"volume":null,"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/A5081977331","display_name":"Guy Harrison","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Guy Harrison","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5058571386","display_name":"Steven Feuerstein","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Steven Feuerstein","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":1.1891,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.83534469,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":97},"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.9082000255584717,"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.9082000255584717,"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.07620000094175339,"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/T10533","display_name":"Teaching and Learning Programming","score":0.0015999999595806003,"subfield":{"id":"https://openalex.org/subfields/1706","display_name":"Computer Science Applications"},"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/mysql","display_name":"MySQL","score":0.8949999809265137},{"id":"https://openalex.org/keywords/stored-procedures","display_name":"stored procedures","score":0.996999979019165},{"id":"https://openalex.org/keywords/precipitating-factors","display_name":"precipitating factors","score":0.8009999990463257},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"transaction processing","score":0.7749999761581421},{"id":"https://openalex.org/keywords/sql-tuning","display_name":"SQL tuning","score":0.5820000171661377},{"id":"https://openalex.org/keywords/error-handling","display_name":"error handling","score":0.5720000267028809},{"id":"https://openalex.org/keywords/database-application-development","display_name":"database application development","score":0.41600000858306885},{"id":"https://openalex.org/keywords/php","display_name":"PHP","score":0.31200000643730164},{"id":"https://openalex.org/keywords/java","display_name":"Java","score":0.625},{"id":"https://openalex.org/keywords/perl","display_name":"Perl","score":0.5519999861717224},{"id":"https://openalex.org/keywords/python","display_name":"Python","score":0.9860000014305115},{"id":"https://openalex.org/keywords/c","display_name":"C++","score":0.8820000290870667},{"id":"https://openalex.org/keywords/vb-net","display_name":"Visual Basic .NET","score":0.9350000023841858},{"id":"https://openalex.org/keywords/database-security","display_name":"database security","score":0.5619999766349792},{"id":"https://openalex.org/keywords/open-source-databases","display_name":"open-source database","score":0.5410000085830688}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8058790564537048},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.6468391418457031},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5903064608573914},{"id":"https://openalex.org/C2777002779","wikidata":"https://www.wikidata.org/wiki/Q42478","display_name":"Perl","level":2,"score":0.5890881419181824},{"id":"https://openalex.org/C519991488","wikidata":"https://www.wikidata.org/wiki/Q28865","display_name":"Python (programming language)","level":2,"score":0.5792109966278076},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.531184196472168},{"id":"https://openalex.org/C548217200","wikidata":"https://www.wikidata.org/wiki/Q251","display_name":"Java","level":2,"score":0.5093141794204712},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.49752047657966614},{"id":"https://openalex.org/C2778514511","wikidata":"https://www.wikidata.org/wiki/Q1374194","display_name":"Programmer","level":2,"score":0.49044105410575867},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4534884989261627},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4394076466560364},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.37967798113822937},{"id":"https://openalex.org/C115903868","wikidata":"https://www.wikidata.org/wiki/Q80993","display_name":"Software engineering","level":1,"score":0.3256767988204956},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.0},{"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":2,"locations":[{"id":"pmh:oai:cds.cern.ch:1509862","doi":null,"is_oa":false,"landing_page_url":"http://cds.cern.ch/record/1509862","pdf_url":null,"source":{"id":"https://openalex.org/S4306402195","display_name":"CERN Document Server (European Organization for Nuclear Research)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I67311998","host_organization_name":"European Organization for Nuclear Research","host_organization_lineage":["https://openalex.org/I67311998"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":null},{"id":"mag:198059675","doi":null,"is_oa":false,"landing_page_url":"http://ci.nii.ac.jp/ncid/BA85416656","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":0,"referenced_works":[],"related_works":["https://openalex.org/W4206932598","https://openalex.org/W4210641557","https://openalex.org/W2741803885","https://openalex.org/W2608893385","https://openalex.org/W2724743063","https://openalex.org/W1545366303","https://openalex.org/W2956019476","https://openalex.org/W2286785853","https://openalex.org/W4210856349","https://openalex.org/W2625998371"],"abstract_inverted_index":{"The":[0],"implementation":[1],"of":[2,22,39,71,110,129,131,204,275,277,290,310,329,388],"stored":[3,52,72,138,194,207,216,222,229,233,239,252,262,319],"procedures":[4,53],"in":[5,143,185,215,235],"MySQL":[6,27,81,91,124,144,146,187,221,251,303,344,384],"5.0":[7],"a":[8,76,160,297,340],"huge":[9],"milestone":[10],"--":[11,55,210,224,237,254],"one":[12],"that":[13,78,279,350],"is":[14,75,125,287,307,379],"expected":[15],"to":[16,18,44,47,58,67,85,166,175,283,353,366,369,383],"lead":[17],"widespread":[19],"enterprise":[20,154],"adoption":[21],"the":[23,35,40,61,69,88,94,99,127,148,186,308,314,380],"already":[24],"extremely":[25],"popular":[26],"database.":[28],"If":[29],"you":[30,42,280],"are":[31],"serious":[32],"about":[33],"building":[34,368],"web-based":[36],"database":[37,332],"applications":[38,236],"future,":[41],"need":[43],"get":[45],"up":[46],"speed":[48],"quickly":[49],"on":[50,93,302],"how":[51,57],"work":[54],"and":[56,106,116,122,141,181,199,218,231,246,249,257,265,296,300,334,360,372],"build":[59],"them":[60,336],"right":[62],"way.":[63],"This":[64],"book,":[65],"destined":[66],"be":[68],"bible":[70],"procedure":[73],"development,":[74],"resource":[77],"no":[79],"real":[80],"programmer":[82],"can":[83,281],"afford":[84],"do":[86],"without.In":[87],"decade":[89],"since":[90],"burst":[92],"scene,":[95],"it":[96,164],"has":[97,159],"become":[98],"dominant":[100],"open":[101],"source":[102],"database,":[103],"with":[104,120,135,193,241,357],"capabilities":[105],"performance":[107],"rivaling":[108],"those":[109],"commercial":[111],"RDBMS":[112],"offerings":[113],"like":[114],"Oracle":[115,311,318],"SQL":[117,214,259],"Server.":[118],"Along":[119],"Linux":[121],"PHP,":[123,242],"at":[126,293],"heart":[128],"millions":[130],"applications.":[132],"And":[133],"now,":[134],"support":[136],"for":[137,152,317,321],"procedures,":[139,195],"functions,":[140,228,230],"triggers":[142],"5.0,":[145],"offers":[147],"programming":[149,208,266,320],"power":[150],"needed":[151],"true":[153],"use.MySQL's":[155],"new":[156],"procedural":[157],"language":[158,364],"straightforward":[161],"syntax,":[162],"making":[163],"easy":[165,174],"write":[167,176],"simple":[168],"programs.":[169,183],"But":[170],"it's":[171],"not":[172],"so":[173],"secure,":[177],"easily":[178],"maintained,":[179],"high-performance,":[180],"bug-free":[182],"Few":[184],"world":[188],"have":[189,202,327,338],"substantial":[190],"experience":[191,330,352],"yet":[192],"but":[196],"Guy":[197],"Harrison":[198,286],"Steven":[200,305],"Feuerstein":[201,306],"decades":[203,328],"combined":[205],"expertise.MySQL":[206],"fundamentals":[209],"tutorial,":[211],"basic":[212,256],"statements,":[213],"programs,":[217],"error":[219],"handlingBuilding":[220],"programs":[223,234,240,253],"transaction":[225],"handling,":[226],"built-in":[227],"triggersMySQL":[232],"using":[238],"Java,":[243],"Perl,":[244],"Python,":[245],".NET":[247],"(C#":[248],"VB.NET)Optimizing":[250],"security,":[255],"advanced":[258,370],"tuning,":[260],"optimizing":[261],"program":[263],"code,":[264,278],"best":[267,373],"practicesA":[268],"companion":[269],"web":[270],"site":[271],"contains":[272],"many":[273],"thousands":[274],"lines":[276],"put":[282,349],"use":[284],"immediately.Guy":[285],"Chief":[288],"Architect":[289],"Database":[291],"Solutions":[292],"Quest":[294],"Software":[295],"frequent":[298],"speaker":[299],"writer":[301],"topics.":[304],"author":[309],"PL/SQL":[312],"Programming,":[313,347],"classic":[315],"reference":[316],"more":[322],"than":[323],"ten":[324],"years.":[325],"Both":[326],"as":[331],"developers,":[333],"between":[335],"they":[337,348],"authored":[339],"dozen":[341],"books.":[342],"In":[343],"Stored":[345],"Procedure":[346],"hard-won":[351],"good":[354],"use.":[355],"Packed":[356],"code":[358],"examples":[359],"covering":[361],"everything":[362],"from":[363],"basics":[365],"application":[367],"tuning":[371],"practices,":[374],"this":[375],"highly":[376],"readable":[377],"book":[378],"one-stop":[381],"guide":[382],"development.":[385],"It":[386],"consists":[387],"four":[389],"major":[390],"sections:":[391]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":2},{"year":2015,"cited_by_count":1},{"year":2013,"cited_by_count":1}],"updated_date":"2026-11-04T10:54:05.112534","created_date":"2016-06-24T00:00:00"}