Dynamic Table Generation

by

Looks like that you have unstructured, or at best semi-structured data. Classic relational DB tables are not ideal for this, unless you use XML as storage. You may consider coming up with an intermediate report-definition language and then storing that in a DB, usually as XML.
MS SQL server, Oracle, and DB2 support storage and query of XML data.

After some thinking..
You could also look into the observation pattern and see if you could adapt it to this example. Although the pattern is OO, it can be done in SQL.
It is a bit long explanation, but I have published a simplified model here; hope you find this useful.

observation_model_01

More Related Contents:

  1. Should I use EAV model?
  2. Why do I get this error on first load of website?
  3. How to check checboxes in a php table?
  4. Need assistance with regards to htaccess
  5. If Else Not Work in PHP Script
  6. PHP multidimensional array search by value
  7. How to sum all column values in multi-dimensional array?
  8. file_get_contents(): SSL operation failed with code 1, Failed to enable crypto
  9. What does a \ (backslash) do in PHP (5.3+)?
  10. Get the Last Inserted Id Using Laravel Eloquent
  11. A numeric string as array key in PHP
  12. What is ::class in PHP?
  13. Merging two images with PHP
  14. How do I get the HTML code of a web page in PHP?
  15. PHP: If internet explorer 6, 7, 8 , or 9
  16. Error logging, in a smooth way
  17. Get entire URL, including query string and anchor
  18. How can I use PHP to check if a directory is empty?
  19. How to enable mysqlnd for php?
  20. Mysql event error using php
  21. How to reduce the image size without losing quality in PHP [closed]
  22. Print newline in PHP in single quotes
  23. Is there a way to fetch associative array grouped by the values of a specified column with PDO?
  24. php – get numeric index of associative array
  25. Accessing an associative array by integer index in PHP
  26. setcookie() does not set cookie in Google Chrome
  27. How to install Imagick/imagemagick PHP extension on windows 7
  28. Mysqli prepared statements build INSERT query dynamically from array
  29. original variable name passed to function? [duplicate]
  30. Any php code to detect the browser with version and operating system?

Leave a Comment