Databases
StackOverflow2013
Postsdbo
POUsing XML field Vs. creating a table for unstable organization
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUsing XML field Vs. creating a table for unstable organization
    primarykey
    data
    text
    <p>I am in the middle of design an application to issue and store invoices for an organization. The problem is the organization is not stable at all. There are many types of invoices and they may increase and change.</p> <p>First, I tried to use tables in my DAL, one table to store invoices, one for invoice fields, and one for invoice field values. The problem was, this way needs Reflection to detect fields later, and this may slow the application when invoice contains plenty items.</p> <p>Second, I tried to keep core of invoice data as two tables: invoices and invoice items. Other fields are fully catchable from other tables. I mean, Business Layer should provide different results per invoice type. It should choose the right queries, and process the results according to the type of invoice. Two problems with this solution are:</p> <ol> <li><p>I still have lots of join between other tables when I want to show an invoice, for per invoice item. I should recalculate everything every time for every invoice item.</p></li> <li><p>What if the invoice items table doesn’t support a new type of invoice? Then I probably should add a new table to store that kind of invoices items.</p></li> <li><p>My client asked me to keep all data related to an invoice, they do not want me to recalculate it every time. They want something like a snapshot of related data at the time invoice is creating.</p></li> </ol> <p>Now, what I’m think can I use the benefit of XML in table? I can save the invoice, with whatever fields as xml.</p> <ul> <li>I can save the different version of their invoices.</li> <li>On changes, I only update my Business.dll and no DAL change required.</li> <li>Linq to XML is not slow.</li> </ul> <p>What do you suggest?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USReza Owliaei
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUsing XML field Vs. creating a table for unstable organization
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

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