Publication Information

{'id': 'https://openalex.org/W2282389522', 'doi': None, 'title': 'Oracle Database 11g SQL', 'display_name': 'Oracle Database 11g SQL', 'publication_year': 2007, 'publication_date': '2007-11-05', 'ids': {'openalex': 'https://openalex.org/W2282389522', 'mag': '2282389522'}, 'language': 'en', 'primary_location': {'is_oa': False, 'landing_page_url': 'http://elib.polban.ac.id/index.php?p=show_detail&id=12691&keywords=', 'pdf_url': None, 'source': {'id': 'https://openalex.org/S4306475711', 'display_name': 'McGraw-Hill, Inc. eBooks', 'issn_l': None, 'issn': None, 'is_oa': False, 'is_in_doaj': False, 'is_core': False, 'host_organization': None, 'host_organization_name': None, 'host_organization_lineage': [], 'host_organization_lineage_names': [], 'type': 'ebook platform'}, '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/A5013211627', 'display_name': 'Jason Price', 'orcid': 'https://orcid.org/0000-0002-7421-4955'}, 'institutions': [], 'countries': [], 'is_corresponding': True, 'raw_author_name': 'Jason Price', 'raw_affiliation_strings': [], 'affiliations': []}], 'institution_assertions': [], 'countries_distinct_count': 0, 'institutions_distinct_count': 0, 'corresponding_author_ids': ['https://openalex.org/A5013211627'], 'corresponding_institution_ids': [], 'apc_list': None, 'apc_paid': None, 'fwci': 0.0, 'has_fulltext': False, 'cited_by_count': 8, 'citation_normalized_percentile': {'value': 0.522213, 'is_in_top_1_percent': False, 'is_in_top_10_percent': False}, 'cited_by_percentile_year': {'min': 81, 'max': 82}, 'biblio': {'volume': None, 'issue': None, 'first_page': '656', 'last_page': '656'}, 'is_retracted': False, 'is_paratext': False, 'primary_topic': {'id': 'https://openalex.org/T10101', 'display_name': 'Cloud Computing and Big Data Technologies', 'score': 0.0612, '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.0612, '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.8876717}, {'id': 'https://openalex.org/keywords/sql/psm', 'display_name': 'SQL/PSM', 'score': 0.8586935}, {'id': 'https://openalex.org/keywords/stored-procedure', 'display_name': 'Stored procedure', 'score': 0.7913823}, {'id': 'https://openalex.org/keywords/autocommit', 'display_name': 'Autocommit', 'score': 0.65815043}, {'id': 'https://openalex.org/keywords/sql-injection', 'display_name': 'SQL injection', 'score': 0.644964}, {'id': 'https://openalex.org/keywords/data-definition-language', 'display_name': 'Data definition language', 'score': 0.59286046}, {'id': 'https://openalex.org/keywords/data-transformation-services', 'display_name': 'Data Transformation Services', 'score': 0.569118}, {'id': 'https://openalex.org/keywords/open-database-connectivity', 'display_name': 'Open Database Connectivity', 'score': 0.49534455}, {'id': 'https://openalex.org/keywords/scalability', 'display_name': 'Scalability', 'score': 0.434967}, {'id': 'https://openalex.org/keywords/null', 'display_name': 'Null (SQL)', 'score': 0.4222131}], 'concepts': [{'id': 'https://openalex.org/C32145003', 'wikidata': 'https://www.wikidata.org/wiki/Q47607', 'display_name': 'PL/SQL', 'level': 5, 'score': 0.8876717}, {'id': 'https://openalex.org/C167544706', 'wikidata': 'https://www.wikidata.org/wiki/Q360842', 'display_name': 'SQL/PSM', 'level': 5, 'score': 0.8586935}, {'id': 'https://openalex.org/C41008148', 'wikidata': 'https://www.wikidata.org/wiki/Q21198', 'display_name': 'Computer science', 'level': 0, 'score': 0.8471669}, {'id': 'https://openalex.org/C154420247', 'wikidata': 'https://www.wikidata.org/wiki/Q846619', 'display_name': 'Stored procedure', 'level': 5, 'score': 0.7913823}, {'id': 'https://openalex.org/C77088390', 'wikidata': 'https://www.wikidata.org/wiki/Q8513', 'display_name': 'Database', 'level': 1, 'score': 0.68874365}, {'id': 'https://openalex.org/C510870499', 'wikidata': 'https://www.wikidata.org/wiki/Q47607', 'display_name': 'SQL', 'level': 2, 'score': 0.6781825}, {'id': 'https://openalex.org/C33882796', 'wikidata': 'https://www.wikidata.org/wiki/Q4826222', 'display_name': 'Autocommit', 'level': 5, 'score': 0.65815043}, {'id': 'https://openalex.org/C150451098', 'wikidata': 'https://www.wikidata.org/wiki/Q506059', 'display_name': 'SQL injection', 'level': 5, 'score': 0.644964}, {'id': 'https://openalex.org/C194222762', 'wikidata': 'https://www.wikidata.org/wiki/Q114486', 'display_name': 'Query by Example', 'level': 4, 'score': 0.63247085}, {'id': 'https://openalex.org/C55596503', 'wikidata': 'https://www.wikidata.org/wiki/Q1431648', 'display_name': 'Data definition language', 'level': 3, 'score': 0.59286046}, {'id': 'https://openalex.org/C141589383', 'wikidata': 'https://www.wikidata.org/wiki/Q644775', 'display_name': 'Data Transformation Services', 'level': 5, 'score': 0.569118}, {'id': 'https://openalex.org/C55166926', 'wikidata': 'https://www.wikidata.org/wiki/Q2892946', 'display_name': 'Oracle', 'level': 2, 'score': 0.5346009}, {'id': 'https://openalex.org/C123327596', 'wikidata': 'https://www.wikidata.org/wiki/Q212606', 'display_name': 'Open Database Connectivity', 'level': 5, 'score': 0.49534455}, {'id': 'https://openalex.org/C203763787', 'wikidata': 'https://www.wikidata.org/wiki/Q371029', 'display_name': 'Null (SQL)', 'level': 2, 'score': 0.4222131}, {'id': 'https://openalex.org/C114724005', 'wikidata': 'https://www.wikidata.org/wiki/Q5001740', 'display_name': 'Business Intelligence Markup Language', 'level': 5, 'score': 0.4110751}, {'id': 'https://openalex.org/C199360897', 'wikidata': 'https://www.wikidata.org/wiki/Q9143', 'display_name': 'Programming language', 'level': 1, 'score': 0.39546475}, {'id': 'https://openalex.org/C136764020', 'wikidata': 'https://www.wikidata.org/wiki/Q466', 'display_name': 'World Wide Web', 'level': 1, 'score': 0.30024526}, {'id': 'https://openalex.org/C164120249', 'wikidata': 'https://www.wikidata.org/wiki/Q995982', 'display_name': 'Web search query', 'level': 3, 'score': 0.067810744}, {'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': 'http://elib.polban.ac.id/index.php?p=show_detail&id=12691&keywords=', 'pdf_url': None, 'source': {'id': 'https://openalex.org/S4306475711', 'display_name': 'McGraw-Hill, Inc. eBooks', 'issn_l': None, 'issn': None, 'is_oa': False, 'is_in_doaj': False, 'is_core': False, 'host_organization': None, 'host_organization_name': None, 'host_organization_lineage': [], 'host_organization_lineage_names': [], 'type': 'ebook platform'}, 'license': None, 'license_id': None, 'version': None, 'is_accepted': False, 'is_published': False}], 'best_oa_location': None, 'sustainable_development_goals': [], 'grants': [], 'datasets': [], 'versions': [], 'referenced_works_count': 0, 'referenced_works': [], 'related_works': ['https://openalex.org/W638381921', 'https://openalex.org/W621362137', 'https://openalex.org/W580797181', 'https://openalex.org/W2891927824', 'https://openalex.org/W2756130066', 'https://openalex.org/W2747291389', 'https://openalex.org/W2739056448', 'https://openalex.org/W2738342198', 'https://openalex.org/W2496921138', 'https://openalex.org/W2463360381', 'https://openalex.org/W2336094686', 'https://openalex.org/W2290904476', 'https://openalex.org/W2277188403', 'https://openalex.org/W2249589203', 'https://openalex.org/W2249485044', 'https://openalex.org/W2249221713', 'https://openalex.org/W2240099544', 'https://openalex.org/W2157377560', 'https://openalex.org/W2132932188', 'https://openalex.org/W1603956012'], 'abstract_inverted_index': {'Write': [0], 'powerful': [1], 'SQL': [2, 12, 32, 42, 45, 66, 88, 91, 93, 142], 'statements': [3, 13, 143], 'and': [4, 14, 37, 44, 54, 68, 77, 90, 97, 106, 116, 130, 166, 170], 'PL/SQL': [5, 16, 52, 100], 'programs\r\n\r\nLearn': [6], 'to': [7, 35, 85, 118, 124, 134, 144], 'access': [8, 135], 'Oracle': [9, 21, 27, 29, 137, 154, 159], 'databases': [10], 'through': [11], 'construct': [15], 'programs': [17, 133], 'with': [18, 48], 'guidance': [19], 'from': [20], 'expert,': [22], 'Jason': [23], 'Price.': [24], 'Published': [25], 'by': [26], 'Press,': [28], 'Database': [30, 138, 160], '11g': [31, 161], 'explains': [33], 'how': [34], 'retrieve': [36], 'modify': [38], 'database': [39, 49, 114], 'information,': [40], 'use': [41], 'Plus': [43, 89], 'Developer,': [46], 'work': [47], 'objects,': [50], 'write': [51], 'programs,': [53], 'much': [55, 171], 'more.': [56], 'Inside,': [57], "you'll": [58], 'find': [59], 'in-depth': [60], 'coverage': [61], 'of': [62, 152], 'the': [63, 149, 153, 156], 'very': [64, 157], 'latest': [65, 158], 'features': [67], 'tools,': [69], 'performance': [70], 'optimization': [71], 'techniques,': [72], 'advanced': [73, 108], 'queries,': [74], 'Java': [75, 132], 'support,': [76], 'XML.': [78], 'This': [79], 'book': [80], 'contains': [81], 'everything': [82], 'you': [83], 'need': [84], 'master': [86], 'SQL.\r\n\r\nExplore': [87], 'Developer\r\nUse': [92], 'SELECT,': [94], 'INSERT,': [95], 'UPDATE,': [96], 'DELETE': [98], 'statements\r\nWrite': [99], 'programs\r\nCreate': [101], 'tables,': [102], 'sequences,': [103], 'indexes,': [104], 'views,': [105], 'triggers\r\nWrite': [107], 'queries': [109], 'containing': [110, 128], 'complex': [111], 'analytical': [112], 'functions\r\nCreate': [113], 'objects': [115, 123], 'collections': [117], 'handle': [119, 125], 'abstract': [120], 'data\r\nUse': [121], 'large': [122], 'multimedia': [126], 'files': [127], 'music': [129], 'movies\r\nWrite': [131], 'an': [136], 'using': [139], 'JDBC\r\nTune': [140], 'your': [141], 'make': [145], 'them': [146], 'execute': [147], 'faster\r\nExplore': [148], 'XML': [150], 'capabilities': [151], 'Database\r\nMaster': [155], 'features,': [162], 'such': [163], 'as': [164], 'PIVOT': [165], 'UNPIVOT,': [167], 'flashback': [168], 'archives,': [169], 'more': [172]}, 'cited_by_api_url': 'https://api.openalex.org/works?filter=cites:W2282389522', 'counts_by_year': [{'year': 2016, 'cited_by_count': 1}, {'year': 2015, 'cited_by_count': 1}, {'year': 2013, 'cited_by_count': 1}, {'year': 2012, 'cited_by_count': 1}], 'updated_date': '2024-09-15T00:12:04.070358', 'created_date': '2016-06-24'}