Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>From the <a href="http://en.wikipedia.org/wiki/Office_Open_XML" rel="nofollow noreferrer">OpenXML article on wikipedia</a>:</p> <blockquote> <p>An Office Open XML file is a ZIP-compatible OPC package containing XML documents and other resources.</p> </blockquote> <p>In other words, OpenXML files are actually zip files with XML files in them. Compression or encryption "scrambles" the data, sabotaging subversion's ability to generate deltas between revisions. This is not related to the <code>svn:mimetype</code>. Subversion considers all files to be binary when generating deltas.</p> <p>In Dutch we have a saying "measuring is knowing". The graph below shows the results of an experiment where I imported a 500K OpenXML document in a SVN 1.6 repository (revision 1). I then added a paragraph from another document, saved and committed. This was repeated 5 times (revision 2 to 6).</p> <p><img src="https://dl.getdropbox.com/u/119154/permalink/openxmlsvn.png"/></p> <p>As you can see, committing a new docx revision that just adds a paragraph will cost you about 150K disk space. This is still much more efficient than just storing a copy of each revision without the help of a version control system.</p> <p>I also repeated the experiment with a separate test repository by uncompressing each revision of the docx. As you can see, the storage of the document revisions would be much more efficient if it wasn't compressed. It's also interesting to see that <strong>subversion's own data compression is about as efficient as zip</strong>. Storing the first revision of an uncompressed docx in subversion takes about the same space as the original docx.</p> <p>YMMV.</p>
    singulars
    1. This table or related slice is empty.
    1. POWill Subversion efficiently store OpenXML Office documents?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USWim Coenen
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWill Subversion efficiently store OpenXML Office documents?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. CONice experiment! In Word 2007, if I choose Save As.. -> Other Formats, one of the options is Word XML Document (*.xml). This option saves the file as an XML document that can be viewed in WordPad. Word XML format appears to be different than uncompressing the DOCX OPC package. Anyone have input on the pros / cons of using Word XML format? I will repeat wcoenen's experiment with documents in the Word XML format, just to be sure.
      singulars
      1. PO
      1. USRjOllos
    2. COFrom my experience in the past few weeks of working with OpenXML packages, the key difference is that .docx can store arbitrary (read: OLE) or OpenXML Package (read: other .docx & .xlsx) data within the container. You will not have this ability with WordprocessingML alone.
      singulars
      1. PO
      1. UStechnomalogical
    3. CO@technomalogical That is not correct. The Open XML Flat Package Format can store binary parts perfectly fine -- they are serialized as base64. Take a look for yourself. Everything a .docx package can do, an OPC can do as well. It may be the Word 2003 WordprocessingML format that you're thinking of (the two are not the same).
      singulars
      1. PO
      1. USBrainSlugs83
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload