JSONDiscoverer: Visualizing the schema lurking behind JSON documents

The so-called API economy is pushing more and more companies to provide open Web APIs to access their data, typically using the JavaScript Object Notation (JSON) as interchange data format. While JSON has been designed to be easy to read and parse, their structure is implicit. This poses a serious p...

Ausführliche Beschreibung

Gespeichert in:

Bibliographische Detailangaben
Veröffentlicht in:	Knowledge-based systems Jg. 103; S. 52 - 55
Hauptverfasser:	Cánovas Izquierdo, Javier Luis, Cabot, Jordi
Format:	Journal Article
Sprache:	Englisch
Veröffentlicht:	Elsevier B.V 01.07.2016 Knowledge-Based Systems
Schlagworte:	Application program interfaces (Computer software) coincidencia de conceptos coincidència de conceptes Concept matching Consumption detecció d'esquema detección de esquema Economics Format Interfaces de programación de aplicaciones (Software) Interfícies de programació d'aplicacions (Programari) Java (programming language) JSON Knowledge base Links Pushing Schema discovery Web API Websites Schema discovery Concept matching Web API JSON
ISSN:	0950-7051, 1872-7409
Online-Zugang:	Volltext
Tags:	Tag hinzufügen Keine Tags, Fügen Sie den ersten Tag hinzu!

Abstract	The so-called API economy is pushing more and more companies to provide open Web APIs to access their data, typically using the JavaScript Object Notation (JSON) as interchange data format. While JSON has been designed to be easy to read and parse, their structure is implicit. This poses a serious problem when consuming and integrating Web APIs from different sources since it forces us to manually analyze each individual API in detail. This paper presents JSONDiscoverer, a tool that alleviates this problem by discovering (and visualizing) the implicit schema of JSON documents as well as possible composition links among JSON-based Web APIs. Tool website: http://som-research.uoc.edu/tools/jsonDiscoverer
AbstractList	The so-called API economy is pushing more and more companies to provide open Web APIs to access their data, typically using the JavaScript Object Notation (JSON) as interchange data format. While JSON has been designed to be easy to read and parse, their structure is implicit. This poses a serious problem when consuming and integrating Web APIs from different sources since it forces us to manually analyze each individual API in detail. This paper presents JSONDiscoverer, a tool that alleviates this problem by discovering (and visualizing) the implicit schema of JSON documents as well as possible composition links among JSON-based Web APIs. Tool website: http://som-research.uoc.edu/tools/jsonDiscoverer The so-called API economy is pushing more and more companies to provide open Web APIs to access their data, typically using the JavaScript Object Notation (JSON) as interchange data format. While JSON has been designed to be easy to read and parse, their structure is implicit. This poses a serious problem when consuming and integrating Web APIs from different sources since it forces us to manually analyze each individual API in detail. This paper presents JSONDiscoverer, a tool that alleviates this problem by discovering (and visualizing) the implicit schema of JSON documents as well as possible composition links among JSON-based Web APIs. The so-called API economy is pushing more and more companies to provide open Web APIs to access their data, typically using the JavaScript Object Notation (JSON) as interchange data format. While JSON has been designed to be easy to read and parse, their structure is implicit. This poses a serious problem when consuming and integrating Web APIs from different sources since it forces us to manually analyze each individual API in detail. This paper presents JSONDiscoverer, a tool that alleviates this problem by discovering (and visualizing) the implicit schema of JSON documents as well as possible composition links among JSON-based Web APIs. Tool website: http://som-research.uoc.edu/tools/jsonDiscoverer
Author	Cabot, Jordi Cánovas Izquierdo, Javier Luis
Author_xml	– sequence: 1 givenname: Javier Luis orcidid: 0000-0002-2326-1700 surname: Cánovas Izquierdo fullname: Cánovas Izquierdo, Javier Luis email: jcanovasi@uoc.edu organization: UOC, Barcelona, Spain – sequence: 2 givenname: Jordi orcidid: 0000-0003-2418-2489 surname: Cabot fullname: Cabot, Jordi email: jordi.cabot@icrea.cat organization: ICREA – UOC, Barcelona, Spain
BookMark	eNqFkE1LxDAQhoMouH78Aw89emmdJO229SCI3yJ68OMapumsm7WbaJIK-uttWUHwoIdhmGGeF-bZYuvWWWJsj0PGgU8PFtmLdeEjZGKYMpAZCFhjE16VIi1zqNfZBOoC0hIKvsm2QlgAgBC8mrDT6_u721MTtHsnT_4weTKhx858GvucxDklQc9piUnX-5dx1dDc2DYZqaR1ul-SjWGHbcywC7T73bfZ4_nZw8llenN3cXVyfJPqXJQxlTUWTZVjU6GoSVItEbEBaFGWTS5km095JaFtqK1mUBDNGl3ygoNsUOSlkNuMr3J16LXypMlrjMqh-RnGElAKJXnNxcjsr5hX7956ClEth2-p69CS64PiFZ-CzOW0Gk7z73jvQvA0U6_eLNF_KA5qFK0WaiVajaIVSDWIHrDDX5g2EaNxNno03X_w0Qqmwdu7Ia-CNmQ1tWZ4KarWmb8DvgDulp4k
CitedBy_id	crossref_primary_10_1016_j_datak_2022_102003 crossref_primary_10_3390_data5040095 crossref_primary_10_4018_JDM_2019070103 crossref_primary_10_1145_3665323 crossref_primary_10_1007_s10270_021_00945_3 crossref_primary_10_1109_TVCG_2024_3388556 crossref_primary_10_1186_s40537_022_00645_9
ContentType	Journal Article
Contributor	Universitat Oberta de Catalunya (UOC)
Contributor_xml	– sequence: 1 fullname: Universitat Oberta de Catalunya (UOC)
Copyright	2016 Elsevier B.V. CC BY-NC-ND info:eu-repo/semantics/openAccess http://creativecommons.org/licenses/by-nc-nd/3.0/es
Copyright_xml	– notice: 2016 Elsevier B.V. – notice: CC BY-NC-ND info:eu-repo/semantics/openAccess <a href="http://creativecommons.org/licenses/by-nc-nd/3.0/es/">http://creativecommons.org/licenses/by-nc-nd/3.0/es/</a>
DBID	AAYXX CITATION 7SC 8FD JQ2 L7M L~C L~D XX2
DOI	10.1016/j.knosys.2016.03.020
DatabaseName	CrossRef Computer and Information Systems Abstracts Technology Research Database ProQuest Computer Science Collection Advanced Technologies Database with Aerospace Computer and Information Systems Abstracts Academic Computer and Information Systems Abstracts Professional Recercat
DatabaseTitle	CrossRef Computer and Information Systems Abstracts Technology Research Database Computer and Information Systems Abstracts – Academic Advanced Technologies Database with Aerospace ProQuest Computer Science Collection Computer and Information Systems Abstracts Professional
DatabaseTitleList	Computer and Information Systems Abstracts
DeliveryMethod	fulltext_linktorsrc
Discipline	Computer Science Economics
EISSN	1872-7409
EndPage	55
ExternalDocumentID	oai_recercat_cat_2072_319122 10_1016_j_knosys_2016_03_020 S0950705116300119
GroupedDBID	--K --M .DC .~1 0R~ 1B1 1~. 1~5 4.4 457 4G. 5VS 7-5 71M 77K 8P~ 9JN AACTN AAEDT AAEDW AAIAV AAIKJ AAKOC AALRI AAOAW AAQFI AAXUO AAYFN ABAOU ABBOA ABIVO ABJNI ABMAC ABYKQ ACAZW ACDAQ ACGFS ACRLP ACZNC ADBBV ADEZE ADGUI ADTZH AEBSH AECPX AEKER AENEX AFKWA AFTJW AGHFR AGUBO AGYEJ AHHHB AHJVU AHZHX AIALX AIEXJ AIKHN AITUG AJBFU AJOXV ALMA_UNASSIGNED_HOLDINGS AMFUW AMRAJ AOUOD ARUGR AXJTR BJAXD BKOJK BLXMC CS3 DU5 EBS EFJIC EFLBG EJD EO8 EO9 EP2 EP3 FDB FIRID FNPLU FYGXN G-Q GBLVA GBOLZ IHE J1W JJJVA KOM LG9 LY7 M41 MHUIS MO0 N9A O-L O9- OAUVE OZT P-8 P-9 P2P PC. PQQKQ Q38 RIG ROL RPZ SDF SDG SDP SES SPC SPCBC SST SSV SSW SSZ T5K WH7 XPP ZMT ~02 ~G- 29L 77I 9DU AAQXK AATTM AAXKI AAYWO AAYXX ABDPE ABWVN ABXDB ACLOT ACNNM ACRPL ACVFH ADCNI ADJOM ADMUD ADNMO AEIPS AEUPX AFJKZ AFPUW AGQPQ AIGII AIIUN AKBMS AKRWK AKYEP ANKPU APXCP ASPBG AVWKF AZFZN CITATION EFKBS FEDTE FGOYB G-2 HLZ HVGLF HZ~ R2- SBC SET SEW UHS WUQ ~HD 7SC 8FD JQ2 L7M L~C L~D XX2
ID	FETCH-LOGICAL-c427t-39a5b84ab8a29e3e93aaab00da37b423d461830dbed8f05eefbc715103ba24723
ISICitedReferencesCount	26
ISICitedReferencesURI	http://www.webofscience.com/api/gateway?GWVersion=2&SrcApp=Summon&SrcAuth=ProQuest&DestLinkType=CitingArticles&DestApp=WOS_CPL&KeyUT=000376840000005&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D
ISSN	0950-7051
IngestDate	Fri Nov 07 13:46:43 EST 2025 Thu Oct 02 05:47:09 EDT 2025 Tue Nov 18 22:33:39 EST 2025 Sat Nov 29 06:41:29 EST 2025 Fri Feb 23 02:28:20 EST 2024
IsDoiOpenAccess	true
IsOpenAccess	true
IsPeerReviewed	true
IsScholarly	true
Keywords	Schema discovery Concept matching Web API JSON
Language	English
LinkModel	OpenURL
MergedId	FETCHMERGED-LOGICAL-c427t-39a5b84ab8a29e3e93aaab00da37b423d461830dbed8f05eefbc715103ba24723
Notes	ObjectType-Article-1 SourceType-Scholarly Journals-1 ObjectType-Feature-2 content type line 23
ORCID	0000-0003-2418-2489 0000-0002-2326-1700
OpenAccessLink	https://recercat.cat/handle/2072/319122
PQID	1816034368
PQPubID	23500
PageCount	4
ParticipantIDs	csuc_recercat_oai_recercat_cat_2072_319122 proquest_miscellaneous_1816034368 crossref_primary_10_1016_j_knosys_2016_03_020 crossref_citationtrail_10_1016_j_knosys_2016_03_020 elsevier_sciencedirect_doi_10_1016_j_knosys_2016_03_020
PublicationCentury	2000
PublicationDate	2016-07-01 2016-07-00 20160701 2016-07
PublicationDateYYYYMMDD	2016-07-01
PublicationDate_xml	– month: 07 year: 2016 text: 2016-07-01 day: 01
PublicationDecade	2010
PublicationTitle	Knowledge-based systems
PublicationYear	2016
Publisher	Elsevier B.V Knowledge-Based Systems
Publisher_xml	– name: Elsevier B.V – name: Knowledge-Based Systems
References	Klettke, Störl, Scherzinger (bib0002) 2015 IETF, JSON Schema Specification. Cánovas Izquierdo, Cabot (bib0004) 2013; vol. 7977 . Sevilla, Feliciano, Molina (bib0003) 2015 Cánovas Izquierdo, Cabot (bib0005) 2014; vol. 8541 Cánovas Izquierdo (10.1016/j.knosys.2016.03.020_bib0005) 2014; vol. 8541 10.1016/j.knosys.2016.03.020_bib0001 Sevilla (10.1016/j.knosys.2016.03.020_bib0003) 2015 Cánovas Izquierdo (10.1016/j.knosys.2016.03.020_bib0004) 2013; vol. 7977 Klettke (10.1016/j.knosys.2016.03.020_bib0002) 2015
References_xml	– reference: IETF, JSON Schema Specification. – volume: vol. 7977 start-page: 68 year: 2013 end-page: 83 ident: bib0004 article-title: Discovering implicit schemas in JSON data publication-title: ICWE Conference – start-page: 467 year: 2015 end-page: 480 ident: bib0003 article-title: Inferring versioned schemas from NoSQL databases and its applications publication-title: ER Conference – reference: . – start-page: 425 year: 2015 end-page: 444 ident: bib0002 article-title: Schema extraction and structural outlier detection for JSON-based NoSQL data stores publication-title: BTW Conference – volume: vol. 8541 start-page: 390 year: 2014 end-page: 399 ident: bib0005 article-title: Composing JSON-based Web APIs publication-title: ICWE Conference – volume: vol. 7977 start-page: 68 year: 2013 ident: 10.1016/j.knosys.2016.03.020_bib0004 article-title: Discovering implicit schemas in JSON data – start-page: 467 year: 2015 ident: 10.1016/j.knosys.2016.03.020_bib0003 article-title: Inferring versioned schemas from NoSQL databases and its applications – start-page: 425 year: 2015 ident: 10.1016/j.knosys.2016.03.020_bib0002 article-title: Schema extraction and structural outlier detection for JSON-based NoSQL data stores – ident: 10.1016/j.knosys.2016.03.020_bib0001 – volume: vol. 8541 start-page: 390 year: 2014 ident: 10.1016/j.knosys.2016.03.020_bib0005 article-title: Composing JSON-based Web APIs
SSID	ssj0002218
Score	2.3002498
Snippet	The so-called API economy is pushing more and more companies to provide open Web APIs to access their data, typically using the JavaScript Object Notation...
SourceID	csuc proquest crossref elsevier
SourceType	Open Access Repository Aggregation Database Enrichment Source Index Database Publisher
StartPage	52
SubjectTerms	Application program interfaces (Computer software) coincidencia de conceptos coincidència de conceptes Concept matching Consumption detecció d'esquema detección de esquema Economics Format Interfaces de programación de aplicaciones (Software) Interfícies de programació d'aplicacions (Programari) Java (programming language) JSON Knowledge base Links Pushing Schema discovery Web API Websites
Title	JSONDiscoverer: Visualizing the schema lurking behind JSON documents
URI	https://dx.doi.org/10.1016/j.knosys.2016.03.020 https://www.proquest.com/docview/1816034368 https://recercat.cat/handle/2072/319122
Volume	103
WOSCitedRecordID	wos000376840000005&url=https%3A%2F%2Fcvtisr.summon.serialssolutions.com%2F%23%21%2Fsearch%3Fho%3Df%26include.ft.matches%3Dt%26l%3Dnull%26q%3D
hasFullText	1
inHoldings	1
isFullTextHit
isPrint
journalDatabaseRights	– providerCode: PRVESC databaseName: Elsevier SD Freedom Collection Journals 2021 customDbUrl: eissn: 1872-7409 dateEnd: 99991231 omitProxy: false ssIdentifier: ssj0002218 issn: 0950-7051 databaseCode: AIEXJ dateStart: 19950201 isFulltext: true titleUrlDefault: https://www.sciencedirect.com providerName: Elsevier
link	http://cvtisr.summon.serialssolutions.com/2.0.0/link/0/eLvHCXMwtV1Lj9MwELZQlwMX3ojyUpA4UQU5dhLH3Fa7i9gFFaRdUG-WY7tS95EuTYNW--uZiZ20pYcFJA6NmiiveqYzn8cz3xDyJnNmystcx0Vi0jhNyzIuqXOxBtcjC8ucdbZtNiHG42IykV9Dnm7dthMQVVVcXcnL_ypqOAbCxtLZvxB3f1M4AN9B6LAFscP2jwR_dPxlvD-rDeZmurYJ5PdZjaWT111lFExo3YUenTdtnBwr9WFiPsLrRnZumouO3qkDrZ-6uFuMPs8G9ucejO-1i-0JdletR4fXPxrwtNYv6Oi2mOVzM1udDErnlz9g1jtbjzkkeZ-fGgJhW8UwIaJIY0EDf6zz9rQQAOBTKjcMLuVrJtMT2Abn6yl7t8y6jzCcvjur5vATMSEvb6lpGV25sT658BhfBN8jQTqxBDlhd5jIJJjtnd3Dg8lR76kZa-O__Yt3pZVt_t_2szagy8DUjdlAML_58hagnNwnd8PMItr1GvGA3HLVQ3Kv69oRBSP-iOxvKsj7aE09IlCPyKtHFNQj8uoR4VVRrx6PybcPByd7H-PQSyM2KRPLmEudlUWqy0Iz6biTXGsNJtdqLkqA1DbNwbhTWzpbTGnm3LQ0IkG6xVKzVDD-hAyqeeWekohNC2klGHvKZToFiJkaSQFlZ0xaYWwyJLwbJmUC0Tz2OzlXXUbhqfKDq3BwFeUKBndI4v6qS0-0csP5b1ECCnCBWxi9VMiT3u_gh1HBFHiYhLEhEZ2cVECWHjEq0LAbHvO6E6sCw4urabpy86ZWAI1zyrGBw7N_vvtzcmf193pBBstF416S2-bnclYvXgV1_QV2OKpw
linkProvider	Elsevier
openUrl	ctx_ver=Z39.88-2004&ctx_enc=info%3Aofi%2Fenc%3AUTF-8&rfr_id=info%3Asid%2Fsummon.serialssolutions.com&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=JSONDiscoverer%3A+Visualizing+the+schema+lurking+behind+JSON+documents&rft.jtitle=Knowledge-based+systems&rft.au=C%C3%A1novas+Izquierdo%2C+Javier+Luis&rft.au=Cabot%2C+Jordi&rft.date=2016-07-01&rft.pub=Elsevier+B.V&rft.issn=0950-7051&rft.eissn=1872-7409&rft.volume=103&rft.spage=52&rft.epage=55&rft_id=info:doi/10.1016%2Fj.knosys.2016.03.020&rft.externalDocID=S0950705116300119
thumbnail_l	http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/lc.gif&issn=0950-7051&client=summon
thumbnail_m	http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/mc.gif&issn=0950-7051&client=summon
thumbnail_s	http://covers-cdn.summon.serialssolutions.com/index.aspx?isbn=/sc.gif&issn=0950-7051&client=summon