Hi,
I am trying to get info on any XML notation which can handle the business rules for a number of MySql tables.
i.e.
I get some XML in, use XSLT to filter and associate the data to the table it needs to be inserted into. Then I look at my "XML rules file" for that "table" to see if the record should be inserted or if I need to perform a test to see if this unique key value (passed as part of the XML) already exists in the DB table in another record etc.
Oh, I will be developing outside the XML/XSLT in PHP.
Should these rules be at DB schema level?
XML seems quite versatile and it keeps the DB simple.
Is this a huge coding/design challenge?
Any advice/pointers welcome.
Joseppic.
I am trying to get info on any XML notation which can handle the business rules for a number of MySql tables.
i.e.
I get some XML in, use XSLT to filter and associate the data to the table it needs to be inserted into. Then I look at my "XML rules file" for that "table" to see if the record should be inserted or if I need to perform a test to see if this unique key value (passed as part of the XML) already exists in the DB table in another record etc.
Oh, I will be developing outside the XML/XSLT in PHP.
Should these rules be at DB schema level?
XML seems quite versatile and it keeps the DB simple.
Is this a huge coding/design challenge?
Any advice/pointers welcome.
Joseppic.