Data exchange formats

Data modelling is a process that involves creating a conceptual representation of data and its relationships within a specific domain or system.

Standard data exchange systems play a crucial role in facilitating efficient and seamless communication and collaboration between various entities within an organization or across different organizations. By adhering to commonly accepted formats, protocols, and standards, these systems ensure that data can be easily shared, understood, and processed by different applications, platforms, and users. They enable interoperability and compatibility, allowing data to flow seamlessly across different systems, regardless of their underlying technologies. Standard data exchange systems promote data consistency, accuracy, and reliability, as they provide a common framework for data representation, validation, and transformation. They enhance productivity and reduce errors by automating data exchange processes, eliminating the need for manual data entry and translation. Moreover, these systems facilitate integration and scalability, enabling organizations to connect disparate systems, exchange data in real-time, and adapt to evolving business needs. Overall, standard data exchange systems streamline information flow, enhance collaboration, and drive operational efficiency, thereby empowering organizations to make informed decisions and achieve their goals effectively.

JSON

Acronym:  Not applicable

Organisation responsible: Not applicable

Official web page:  https://www.json.org/json-en.html

Description: JSON is a lightweight and easy-to-read format for representing data as key-value pairs. It is commonly used for data interchange between web services and applications.

Current Version:  2012-12

Schema location:  https://www.json.org/json-en.html

Standard:  Not applicable

Type of data:  JSON

Primary purpose :  Data exchange

API available:  Not applicable

License details:  No license required / Open format

Data model (Power BI):  Available on request

XML

Acronym:  Not applicable

Organisation responsible: World Wide Web Consortium (W3C)

Official web page:  https://www.w3.org/XML/

Description: XML is a widely used format for structuring and representing data in a human-readable and machine-readable format. It allows for the exchange of data between different systems and applications.

Current Version:  1.1

Schema location:  https://www.w3.org/TR/NOTE-xml-schema-req

Standard: https://www.w3.org/TR/xmlschema11-1/https://www.json.org/json-en.html and https://www.w3.org/TR/xmlschema11-2/

Type of data:  XML

Primary purpose :  Data exchange

API available:  Not applicable

License details:  No license required / Open format

Data model (Power BI):  Available on request

Comma-Separated Values

Acronym:  NCSV

Organisation responsible:  Not applicable

Official web page:  Not applicable

Description: CSV is a simple format for storing tabular data, where each line represents a record, and the values within the record are separated by commas. It is commonly used for data exchange between spreadsheets and databases.

Current Version:  1.1

Schema location:  https://datatracker.ietf.org/doc/html/rfc4180

Standard:  RFC4180

Type of data:  CSV

Primary purpose :  Data exchange

API available:  Not applicable

License details:  No license required / Open format

Data model (Power BI):  Not applicable

Structured Query Language

Acronym:  SQL

Organisation responsible:  Not applicable

Official web page:  Not applicable

Description:  SQL is a standard language for managing relational databases. It is used for querying, manipulating, and exchanging structured data in databases.

Current Version:  2023

Schema location:  https://datatracker.ietf.org/doc/html/rfc4180

Standard:  By 1986, ANSI and ISO standard groups officially adopted the standard "Database Language SQL" language definition. New versions of the standard were published in 1989, 1992, 1996, 1999, 2003, 2006, 2008, 2011,[12] 2016 and most recently, 2023.

Type of data:  SQL

Primary purpose :  Data exchange

API available:  Not applicable

License details:  Not applicable

Data model (Power BI):  Not applicable

Electronic Data Interchange

Acronym:  EDI

Organisation responsible:  x12 (USA)

Official web page:  https://x12.org/

Description:  X12 is a specific implementation of the EDI standard, primarily used in the United States for business-to-business transactions.

Current Version:  Various versions

Schema location:  Various schemas

Standard:  There are many EDI standards (including X12EDIFACTODETTE, etc.), some of which address the needs of specific industries or regions

Type of data:  EDI

Primary purpose :  Document exchange

API available:  Not applicable

License details:  Not applicable / Open standard

Data model (Power BI):  Not applicable

eXtensible Business Reporting Language

Acronym: XBRL

Organisation responsible:  Maintained by a consortium

Official web page:  https://www.xbrl.org/

Description: XBRL is an XML-based standard for the exchange and reporting of business and financial information. It is commonly used in financial reporting and regulatory filings.

Current Version:  2.1 - February 20, 2013; 10 years ago

Schema location:  https://specifications.xbrl.org/

Standard:  Extended from XML

Type of data:  XML

Primary purpose :  Data exchange

API available:  Not applicable

License details:  Freely available

Data model (Power BI):  Available on request

Portable Document Format

Acronym: PDF

Organisation responsible:  Adobe

Official web page:  https://www.adobe.com

Description:  PDF is a file format designed to present documents in a consistent and device-independent manner. Although primarily used for document exchange and viewing, PDF can also contain structured data.

Current Version:  2.0

Schema location:  Not applicable

Standard:  ISO 32000-2

Type of data:  PDF

Primary purpose :  Document exchange

API available:  Not applicable

License details:  Open format

Data model (Power BI):  Not applicable

Resource Description Framework

Acronym:  RDF

Organisation responsible: World Wide Web Consortium (W3C)

Official web page:  https://www.w3.org/RDF/

Description: RDF is a framework for representing information about resources in a machine-readable format. It is commonly used for sharing and linking data on the web.

Current Version:  1.2 - W3C First Public Working Draft 16 May 2023

Schema location:  https://www.w3.org/TR/rdf12-schema/

Standard:  Not applicable

API available:  Not applicable

License details:  No license required / Open format

Data model (Power BI):  Available on request

Need help with data models, ontologies, metadata management, asset systems or data classification frameworks?

Scroll to Top