JSON and the Moon Landing скачать в хорошем качестве

JSON and the Moon Landing

JSON has gained a lot of popularity as a backend data model in recent years. But since JSON is a hierarchical data model certain use cases are hard to map to JSON. This session focusses on JSON design and modeling questions. Learn about the differences of the relational and JSON data models, how to avoid mistakes when modeling JSON and how to combine JSON with relational features. Video Highlights: 3:50 - LiveSQL location 4:25 - First example 6:00 - Entity Relationship Model 8:20 - Create tables 12:05 - Insert data 13:30 - Insert fails 15:00 - Update 15:15 - Schema changes 17:55 - Hierachical data models 18:15 - IBM IMS 21:30 - Pure JSON Data model 22:50 - LiveSQL example 25:30 - Update multiple JSON documents 26:15 - Update course name function 28:30 - Find all teachers for a given student 30:50 - Schema flexability 32:00 - JSON model summary 33:30 - The relational data model is born (Larry Elison creates the Oracle Database) 34:20 - JSON combined with Relational model 36:45 - LiveSQL example 39:00 - Blob vs Clob question 41:05 - Use JSON_MergePatch to update object 42:35 - Query student with no courses 43:00 - Query teachers for a student 45:10 - Use Query to generate new JSON object 46:05 - Constraints 47:00 - Virtual column 49:45 - Validate course IDs in an array 51:05 - Evolution of data management 52:10 - Conclusion 53:35 - SODA 54:10 - Questions 59:55 - Link to LiveSQL presentation - https://livesql.oracle.com/apex/lives... AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit