Good point, Ashlie. I have not thought about that! Thanks LV From: Ashlie Jeter [mailto:[email protected]] Sent: Wednesday, January 26, 2011 1:11 PM To: Vu, Lynn Cc: [email protected] Subject: Re: [EDI-L] GIS/SI mapping question: xml or positional format?
I've seen one XML file that's so large that a schema won't even load...so definitely make sure you get the specifics on how large the files could be (regardless of maintenance plan, it will rear up and bite you). Flat files (ideally positional) are the way to go if you can choose. -Ashlie ----- Original Message ----- From: Vu, Lynn<mailto:[email protected]> To: Samantha Scott<mailto:[email protected]> ; Dhiraj Patil<mailto:[email protected]> Cc: [email protected]<mailto:[email protected]> Sent: Tuesday, January 25, 2011 9:36 PM Subject: RE: [EDI-L] GIS/SI mapping question: xml or positional format? Space should not be a problem. We do archive/maintenance data very often... However, slow performance would be a big issue...I will consider all your suggestions, run some test them make decision. Again, thank you all for your time. Best Regards LV From: Samantha Scott [mailto:[email protected]<mailto:[email protected]>] Sent: Tuesday, January 25, 2011 12:13 PM To: Dhiraj Patil Cc: [email protected]<mailto:[email protected]>; Vu, Lynn Subject: Re: [EDI-L] GIS/SI mapping question: xml or positional format? Nice analysis. I'm in the flat file camp too and I was asking myself if there were legitimate reasons for that. Now I remember, there are. When I use XML its because I have to for one reason or another. I've not yet ever found a reason to deliberately switch from flat file to XML. Its probably why companies with mature EDI systems haven't chucked it all in for XML instead. Why fix what isn't broken? Why send the SWAT team when the county sheriff's deputy and a soda can get the job done? On Tue, Jan 25, 2011 at 10:25 AM, Dhiraj Patil <[email protected]<mailto:dhiraj_patil%40yahoo.com><mailto:[email protected]<mailto:dhiraj_patil%40yahoo.com>>> wrote: It depends on many factors.. As others said 1. Storage space - XML will need enormous disk space due to size of data. 2. Maintainability - its tedious to maintain XML maps unless they have very similar format with the respective input/output data 3. Performance: As XML map is larger, and data goes through XML parser, it will need few more milliseconds to complete than that of flat-file 4. Readability: XML is more readable than that of positonal.. (How many times you need to read the data? Error report will anyway tell you where the problem is.) 5. XSLT: XML->Flat file and vice versa, I wonder if you'll use it much in short.. if you have loads of money to spend, go for XML otherwise stick with good old flat-file format. my 5 Cents . Regards, Dhiraj --- On Mon, 1/24/11, vu.lynn <[email protected]<mailto:vu.lynn%40remypowerproducts.com><mailto:vu.lynn%40remypowerproducts.com>> wrote: From: vu.lynn <[email protected]<mailto:vu.lynn%40remypowerproducts.com><mailto:vu.lynn%40remypowerproducts.com>> Subject: [EDI-L] GIS/SI mapping question: xml or positional format? To: [email protected]<mailto:EDI-L%40yahoogroups.com><mailto:EDI-L%40yahoogroups.com> Date: Monday, January 24, 2011, 1:58 PM EDI environment: SI 5.06 (GIS) with Oracle database. We're going to migrate our EDI/GIS system in which we need to remap all GIS maps. Currently we are using both xml and positional formats. In the new system, we need to choose one standard mapping format. My question to SI (GIS) experts in EDI-L group: What format do you prefer (xml or positional format)? And what is advantage of chosing one format over the other? TIA, LV [Non-text portions of this message have been removed] ---------------------------------------------------------- Please access the attached hyperlink for an important electronic communications disclaimer: http://www.remyinc.com/emaildisclaimer.html [Non-text portions of this message have been removed] ---------------------------------------------------------------------- Please access the attached hyperlink for an important electronic communications disclaimer: http://www.remyinc.com/emaildisclaimer.html [Non-text portions of this message have been removed] ------------------------------------ ... Please use the following Message Identifiers as your subject prefix: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>, <OFF-TOPIC> Job postings are welcome, but for job postings or requests for work: <JOBS> IS REQUIRED in the subject line as a prefix.Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/EDI-L/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/EDI-L/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
