Publication Information

{'id': 'https://openalex.org/W2249589203', 'doi': None, 'title': 'Beginning Oracle SQL: For Oracle Database 12c', 'display_name': 'Beginning Oracle SQL: For Oracle Database 12c', 'publication_year': 2014, 'publication_date': '2014-03-10', 'ids': {'openalex': 'https://openalex.org/W2249589203', 'mag': '2249589203'}, 'language': 'en', 'primary_location': {'is_oa': False, 'landing_page_url': 'https://openlibrary.org/books/OL26838377M/Beginning_Oracle_SQL_For_Oracle_Database_12c', 'pdf_url': None, 'source': None, 'license': None, 'license_id': None, 'version': None, 'is_accepted': False, 'is_published': False}, 'type': 'book', 'type_crossref': 'book', 'indexed_in': [], 'open_access': {'is_oa': False, 'oa_status': 'closed', 'oa_url': None, 'any_repository_has_fulltext': False}, 'authorships': [{'author_position': 'first', 'author': {'id': 'https://openalex.org/A5026196657', 'display_name': 'Tim Gorman', 'orcid': None}, 'institutions': [], 'countries': [], 'is_corresponding': False, 'raw_author_name': 'Tim Gorman', 'raw_affiliation_strings': [], 'affiliations': []}, {'author_position': 'middle', 'author': {'id': 'https://openalex.org/A5072657184', 'display_name': 'Inger Jrgensen', 'orcid': None}, 'institutions': [], 'countries': [], 'is_corresponding': False, 'raw_author_name': 'Inger Jrgensen', 'raw_affiliation_strings': [], 'affiliations': []}, {'author_position': 'last', 'author': {'id': 'https://openalex.org/A5021120923', 'display_name': 'Melanie Caffrey', 'orcid': None}, 'institutions': [], 'countries': [], 'is_corresponding': False, 'raw_author_name': 'Melanie Caffrey', 'raw_affiliation_strings': [], 'affiliations': []}], 'institution_assertions': [], 'countries_distinct_count': 0, 'institutions_distinct_count': 0, 'corresponding_author_ids': [], 'corresponding_institution_ids': [], 'apc_list': None, 'apc_paid': None, 'fwci': 0.0, 'has_fulltext': False, 'cited_by_count': 1, 'citation_normalized_percentile': {'value': 0.467184, 'is_in_top_1_percent': False, 'is_in_top_10_percent': False}, 'cited_by_percentile_year': {'min': 66, 'max': 73}, 'biblio': {'volume': None, 'issue': None, 'first_page': None, 'last_page': None}, 'is_retracted': False, 'is_paratext': False, 'primary_topic': {'id': 'https://openalex.org/T10101', 'display_name': 'Cloud Computing and Big Data Technologies', 'score': 0.606, '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/T10101', 'display_name': 'Cloud Computing and Big Data Technologies', 'score': 0.606, '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/pl/sql', 'display_name': 'PL/SQL', 'score': 0.8904809}, {'id': 'https://openalex.org/keywords/stored-procedure', 'display_name': 'Stored procedure', 'score': 0.7687401}, {'id': 'https://openalex.org/keywords/sql/psm', 'display_name': 'SQL/PSM', 'score': 0.7173811}, {'id': 'https://openalex.org/keywords/data-definition-language', 'display_name': 'Data definition language', 'score': 0.66934246}, {'id': 'https://openalex.org/keywords/sql-injection', 'display_name': 'SQL injection', 'score': 0.64554465}, {'id': 'https://openalex.org/keywords/autocommit', 'display_name': 'Autocommit', 'score': 0.6193541}, {'id': 'https://openalex.org/keywords/oracle-unified-method', 'display_name': 'Oracle Unified Method', 'score': 0.6029464}, {'id': 'https://openalex.org/keywords/open-database-connectivity', 'display_name': 'Open Database Connectivity', 'score': 0.45710334}, {'id': 'https://openalex.org/keywords/table', 'display_name': 'Table (database)', 'score': 0.44499576}, {'id': 'https://openalex.org/keywords/scalability', 'display_name': 'Scalability', 'score': 0.4318}], 'concepts': [{'id': 'https://openalex.org/C32145003', 'wikidata': 'https://www.wikidata.org/wiki/Q47607', 'display_name': 'PL/SQL', 'level': 5, 'score': 0.8904809}, {'id': 'https://openalex.org/C41008148', 'wikidata': 'https://www.wikidata.org/wiki/Q21198', 'display_name': 'Computer science', 'level': 0, 'score': 0.8301682}, {'id': 'https://openalex.org/C154420247', 'wikidata': 'https://www.wikidata.org/wiki/Q846619', 'display_name': 'Stored procedure', 'level': 5, 'score': 0.7687401}, {'id': 'https://openalex.org/C167544706', 'wikidata': 'https://www.wikidata.org/wiki/Q360842', 'display_name': 'SQL/PSM', 'level': 5, 'score': 0.7173811}, {'id': 'https://openalex.org/C510870499', 'wikidata': 'https://www.wikidata.org/wiki/Q47607', 'display_name': 'SQL', 'level': 2, 'score': 0.7135209}, {'id': 'https://openalex.org/C194222762', 'wikidata': 'https://www.wikidata.org/wiki/Q114486', 'display_name': 'Query by Example', 'level': 4, 'score': 0.69708157}, {'id': 'https://openalex.org/C55596503', 'wikidata': 'https://www.wikidata.org/wiki/Q1431648', 'display_name': 'Data definition language', 'level': 3, 'score': 0.66934246}, {'id': 'https://openalex.org/C77088390', 'wikidata': 'https://www.wikidata.org/wiki/Q8513', 'display_name': 'Database', 'level': 1, 'score': 0.6644408}, {'id': 'https://openalex.org/C150451098', 'wikidata': 'https://www.wikidata.org/wiki/Q506059', 'display_name': 'SQL injection', 'level': 5, 'score': 0.64554465}, {'id': 'https://openalex.org/C33882796', 'wikidata': 'https://www.wikidata.org/wiki/Q4826222', 'display_name': 'Autocommit', 'level': 5, 'score': 0.6193541}, {'id': 'https://openalex.org/C22664368', 'wikidata': 'https://www.wikidata.org/wiki/Q4045949', 'display_name': 'Oracle Unified Method', 'level': 5, 'score': 0.6029464}, {'id': 'https://openalex.org/C55166926', 'wikidata': 'https://www.wikidata.org/wiki/Q2892946', 'display_name': 'Oracle', 'level': 2, 'score': 0.5986085}, {'id': 'https://openalex.org/C123327596', 'wikidata': 'https://www.wikidata.org/wiki/Q212606', 'display_name': 'Open Database Connectivity', 'level': 5, 'score': 0.45710334}, {'id': 'https://openalex.org/C61423126', 'wikidata': 'https://www.wikidata.org/wiki/Q187432', 'display_name': 'Scripting language', 'level': 2, 'score': 0.45615992}, {'id': 'https://openalex.org/C45235069', 'wikidata': 'https://www.wikidata.org/wiki/Q278425', 'display_name': 'Table (database)', 'level': 2, 'score': 0.44499576}, {'id': 'https://openalex.org/C199360897', 'wikidata': 'https://www.wikidata.org/wiki/Q9143', 'display_name': 'Programming language', 'level': 1, 'score': 0.3760671}, {'id': 'https://openalex.org/C136764020', 'wikidata': 'https://www.wikidata.org/wiki/Q466', 'display_name': 'World Wide Web', 'level': 1, 'score': 0.29782942}, {'id': 'https://openalex.org/C164120249', 'wikidata': 'https://www.wikidata.org/wiki/Q995982', 'display_name': 'Web search query', 'level': 3, 'score': 0.098264456}, {'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': [{'is_oa': False, 'landing_page_url': 'https://openlibrary.org/books/OL26838377M/Beginning_Oracle_SQL_For_Oracle_Database_12c', 'pdf_url': None, 'source': None, 'license': None, 'license_id': None, 'version': None, 'is_accepted': False, 'is_published': False}], 'best_oa_location': None, 'sustainable_development_goals': [{'id': 'https://metadata.un.org/sdg/9', 'score': 0.41, 'display_name': 'Industry, innovation and infrastructure'}], 'grants': [], 'datasets': [], 'versions': [], 'referenced_works_count': 0, 'referenced_works': [], 'related_works': ['https://openalex.org/W640867714', 'https://openalex.org/W621362137', 'https://openalex.org/W604962236', 'https://openalex.org/W589814810', 'https://openalex.org/W2891927824', 'https://openalex.org/W2756130066', 'https://openalex.org/W2747291389', 'https://openalex.org/W2739056448', 'https://openalex.org/W2477178274', 'https://openalex.org/W2463360381', 'https://openalex.org/W2290904476', 'https://openalex.org/W2282389522', 'https://openalex.org/W2277188403', 'https://openalex.org/W2249221713', 'https://openalex.org/W2157377560', 'https://openalex.org/W2132932188', 'https://openalex.org/W207326370', 'https://openalex.org/W1603956012', 'https://openalex.org/W1542124386', 'https://openalex.org/W105399545'], 'abstract_inverted_index': {'Beginning': [0, 144, 279], 'Oracle': [1, 18, 33, 96, 112, 145, 167, 261, 280, 298], 'SQL': [2, 15, 25, 54, 97, 146, 161, 180, 188, 243, 281, 292, 304], 'is': [3, 28, 44, 56, 67, 81, 89, 147, 277, 282, 305], 'your': [4, 221], 'introduction': [5], 'to': [6, 50, 115, 134, 158, 186, 192, 204, 220, 270, 294], 'the': [7, 29, 69, 128, 135, 148, 156, 182, 249], 'interactive': [8], 'query': [9, 183, 201, 271], 'tools': [10, 21, 184], 'and': [11, 24, 42, 63, 122, 130, 141, 163, 175, 181, 199, 214, 225, 239, 251, 255, 286], 'specific': [12], 'dialect': [13, 72], 'of': [14, 73, 119, 127, 253, 260, 303], 'used': [16, 46, 83, 185], 'with': [17, 111, 173, 197], 'Database.': [19, 168], 'These': [20], 'include': [22], 'SQL*Plus': [23, 27], 'Developer.': [26], 'one': [30], 'tool': [31], 'any': [32], 'developer': [34, 107], 'or': [35, 108], 'database': [36, 79, 212, 230, 287], 'administrator': [37], 'can': [38, 113], 'always': [39], 'count': [40], 'on,': [41], 'it': [43], 'widely': [45, 82], 'in': [47, 84, 92, 103, 138, 241], 'creating': [48], 'scripts': [49], 'automate': [51], 'routine': [52], 'tasks.': [53], 'Developer': [55], 'a': [57, 75], 'powerful,': [58], 'graphical': [59], 'environment': [60], 'for': [61, 264, 278], 'developing': [62], 'debugging': [64], 'queries.': [65], "Oracle's": [66, 78], 'possibly': [68], 'most': [70], 'valuable': [71], 'SQLfrom': [74], 'career': [76], 'standpoint.': [77], 'engine': [80], 'corporate': [85], 'environments': [86], 'worldwide.': [87], 'It': [88], 'also': [90], 'found': [91, 102], 'many': [93, 99], 'government': [94], 'applications.': [95], 'implements': [98], 'features': [100, 121], 'not': [101], 'competing': [104], 'products.': [105], 'No': [106, 300], 'DBA': [109], 'working': [110], 'afford': [114], 'be': [116], 'without': [117], 'knowledge': [118, 302], 'these': [120], 'how': [123, 191], 'they': [124, 132], 'work,': [125], 'because': [126], 'performance': [129, 250], 'expressiveness': [131, 252], 'bring': [133], 'table.': [136], 'Written': [137], 'an': [139, 170, 297], 'easygoing': [140], 'example-based': [142, 171], 'style,': [143], 'book': [149, 276], 'that': [150, 202, 227, 232], 'will': [151], 'get': [152], 'you': [153], 'started': [154], 'down': [155], 'path': [157], 'successfully': [159], 'writing': [160, 242], 'statements': [162, 189, 293], 'getting': [164], 'results': [165, 207], 'from': [166, 246], 'Takes': [169], 'approach,': [172], 'clear': [174], 'authoritative': [176], 'explanations': [177], 'Introduces': [178], 'both': [179], 'execute': [187, 295], 'Shows': [190], 'create': [193], 'tables,': [194], 'populate': [195], 'them': [196], 'data,': [198], 'then': [200], 'data': [203, 219], 'generate': [205, 233], 'business': [206], 'What': [208], 'youll': [209], 'learn': [210], 'Create': [211], 'tables': [213], 'define': [215], 'their': [216], 'relationships.': [217], 'Add': [218], 'tables.': [222], 'Then': [223], 'change': [224], 'delete': [226], 'data.': [228, 273], 'Write': [229, 267], 'queries': [231, 269], 'accurate': [234], 'results.': [235], 'Avoid': [236], 'common': [237], 'traps': [238], 'pitfalls': [240], 'queries,': [244], 'especially': [245], 'nulls.': [247], 'Reap': [248], 'analytic': [254], 'window': [256], 'functions.': [257], 'Make': [258], 'use': [259], "Database's": [262], 'support': [263], 'object': [265], 'types.': [266], 'recursive': [268], 'hierarchical': [272], 'Who': [274], 'this': [275], 'aimed': [283], 'at': [284], 'developers': [285], 'administrators': [288], 'who': [289], 'must': [290], 'write': [291], 'against': [296], 'database.': [299], 'prior': [301], 'assumed.': [306]}, 'cited_by_api_url': 'https://api.openalex.org/works?filter=cites:W2249589203', 'counts_by_year': [{'year': 2019, 'cited_by_count': 1}], 'updated_date': '2024-09-19T00:55:00.611704', 'created_date': '2016-06-24'}