Question

what is XML and list advantages

what is JSON and list advantages

compare and contrast XML vs JSON vs Flat File

convert below xml to json

<address>
   <billing>
       <street>westchester park dr</street>
       <city>college park</city>
       <state>MD</state>
       <zip>20020</zip>
   </billing>
   <shipping>
       <street>westchester park dr</street>
       <city>college park</city>
       <state>MD</state>
       <zip>20020</zip>
   </shipping>
</address>

correct below xml documents:

   <shipping>
       <street>westchester park dr</street>
       <city>college park</city>
       <state>MD</state>
       <zip>20020</zip>
   <shipping>

   <shipping>
       <street>westchester park dr</street>
       <city>college park</city>
       <state>MD</state>
       <zip>20020</zip>
   </Shipping>

   <shipping>
       <street>westchester park dr</street>
       <CITY>college park</city>
       <state>MD</state>
       <zip>20020</zip>
   </shipping>

convert below xml to any of your favorite flat file format

   <shipping>
       <street>westchester park dr</street>
       <CITY>college park</city>
       <state>MD</state>
       <zip>20020</zip>
   </shipping>

correct below json message:

{msg: "hello there"}

["hello there";"hello again"]

Answer 1

XML:-

XML stands for Extensible Markup Language. XML is a software- and hardware-independent tool for storing and transporting data. It is a text-based markup language derived from Standard Generalized Markup Language (SGML). XML tags identify the data and are used to store and organize the data, instead of displaying the data like html XML can not replace HTML in the near future, but it introduces new possibilities by adopting many successful features of HTML.

Advantages of xml:-

1. XML is platform independent and programming language independent, thus it can be used on any system and supports the technology change when that happens. Any application that can process XML can use your information, regardless of platform.

2.XML supports unicode.  This feature allows XML to transmit any information written in any human language.

3. XML is extendable. Create your own tags, or use tags created by others, that use the natural language of your domain, that have the attributes you need, and that makes sense to you and your users.

4.The data stored and transported using XML can be changed at any point of time without affecting the data presentation.

5.XML is readable and understandable, and no more difficult to code than HTML.

6. XML allows validation using DTD and Schema. This validation ensures that the XML document is free from any syntax error.

JSON:-

JSON (JavaScript Object Notation) stands for Javascript Object Notation which is light-weighted designed such that humans can easily read data interchange and its execution.

Advantages:-

1.JSON syntax is very small and light weighted that’s the reason it is faster language.

2 .It has wide range of supported browser compatibility with the operating systems so the applications made with the coding of JSON doesn't require much effort to make it all browser compatible.

3.JSON stores the data in the arrays so data transfer makes easier. It is the best tool for the sharing data of any size even audio, video etc.

4.JSON is a superior file format for web APIs and for web development.

5.JSON server side parsing is fast and becomes strong point that indicates us to use the JSON on server side.

comparision between xml json and flat file:-

xml:-

1 It is Extensible markup language.

2.It is derived from SGML.

3. It is a markup language and uses tag structure to represent data items.

4.It is more secured than JSON.

5.It supports namespaces.

6. It doesn’t supports array.

7. Its documents when compare to json and flat files are  difficult to read and interpret.

8. It has start and end tags.

9. It supports various encoding.

JSON:-

1. It is JavaScript Object Notation

2. It is based on JavaScript language.

3. It is a way of representing objects.

4. It is less secured than xml.

5.It does not provides any support for namespaces.

6. It supports array.

7. Its files are very easy to read as compared to XML.

8. It doesn’t use end tag.

9. It supports only UTF-8 encoding.

Text Files:-

1 Flat file is mostly used when data has to be exchanged between legacy systems where delimited text file are the most common mode of data transfer.

2.Flat files are easier to analyse.

3. Flat file syndication involves a lot of manual intervention in terms of Fields creation for mapping.setting their properties individually etc.

4. No particular structure can be maintained as all fields are maintained one after .Unlike in XML where we have Segments and fields inside segments.

5.Cannot be used for large data imports.

6. Very less secure

XML to JSON

{
"address": {
"billing": {
"street": "westchester park dr",
"city": "college park",
"state": "MD",
"zip": "20020"
},
"shipping": {
"street": "westchester park dr",
"city": "college park",
"state": "MD",
"zip": "20020"
}
}
}

--------------------------------

<billing>
       <street>westchester park dr</street>
       <city>college park</city>
       <state>MD</state>
       <zip>20020</zip>
   </billing>

   <shipping>
       <street>westchester park dr</street>
       <city>college park</city>
       <state>MD</state>
       <zip>20020</zip>
   </shipping>

   <shipping>
       <street>westchester park dr</street>
       <city>college park</city>
       <state>MD</state>
       <zip>20020</zip>
   </shipping>

-------------------------------------------

shiiping address ina any text file:-

westchester park dr

college park

MD

20020

----------------------------------------

{"msg":[

{"hello there"},

{"hello there"},

{"hello again"}

]

}