DZone.com
Follow
One Database, Two Models: Building AI-Friendly Java Applications With MySQL JSON Duality Views
MySQL can now hand your application a complete JSON document, such as an order with its customer and line items, while the data stays in normal relational tables. You can even send the document back, and MySQL updates the right rows. I built a small Java app to see how far that goes. Reading got much simpler. Writing works too, but it comes with a few sharp edges you should know about before you use it.
Four Tables, One ScreenPicture a support screen for a small online shop. When a customer calls, the agent needs the order's customer, items, prices, and status in one place.