October 2024
Intermediate to advanced
974 pages
27h 14m
Spanish
Content preview from Libro de cocina de MySQL, 4ª ediciónBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Capítulo 19. Trabajar con JSON
Este trabajo se ha traducido utilizando IA. Agradecemos tus opiniones y comentarios: translation-feedback@oreilly.com
19.0 Introducción
Las bases de datos relacionales han demostrado su eficacia durante décadas. Evitan que se dupliquen y se pierdan datos y permiten un acceso rápido a los valores almacenados. Sin embargo, las empresas inventan continuamente nuevos escenarios en los que los datos deben ser más flexibles de lo que permite el modelo relacional.
Por ejemplo, consideremos el registro de un usuario que puede acceder a contenidos digitales sólo por suscripción y dejar comentarios. Para un usuario de este tipo, tener sólo la información básica -su nombre, dirección de correo electrónico y contraseña- es suficiente para empezar. Sin embargo, una vez que los usuarios empiecen a explorar más opciones (por ejemplo, exigir la entrega), es posible que necesiten que se almacene su dirección postal. La dirección postal podría ser distinta de la dirección de facturación. Puede que el usuario quiera añadir una cuenta de red social o unas cuantas.
Una forma de almacenar datos flexibles en la base de datos relacional es almacenar datos adicionales en la tabla referenciada que comparte detalles de cada usuario. Ya hablamos de esta técnica en las Recetas 16.5 y 16.6.
Sin embargo, esta técnica puede no ser la mejor en las siguientes situaciones:
- Cuando sólo unos pocos elementos de la tabla principal tienen detalles en la tabla referenciada
Si aún necesitas ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.