{"id":65343,"date":"2024-11-01T16:48:26","date_gmt":"2024-11-01T14:48:26","guid":{"rendered":"https:\/\/www.techopedia.com\/es\/?post_type=definition&p=65343"},"modified":"2024-11-01T17:22:22","modified_gmt":"2024-11-01T15:22:22","slug":"registro","status":"publish","type":"definition","link":"https:\/\/www.techopedia.com\/es\/definicion\/registro","title":{"rendered":"Registro"},"content":{"rendered":"

\u00bfQu\u00e9 significa registro?<\/span><\/h2>\n

En las bases de datos<\/a> relacionales, un registro es un grupo de datos<\/a> relacionados que se mantienen dentro de la misma estructura.<\/strong> M\u00e1s concretamente, un registro es una agrupaci\u00f3n de campos dentro de una tabla que hacen referencia a un objeto concreto. El t\u00e9rmino registro se utiliza frecuentemente como sin\u00f3nimo de fila.<\/p>\n

Por ejemplo, un registro de cliente puede incluir elementos como el nombre, la direcci\u00f3n f\u00edsica, la direcci\u00f3n de correo electr\u00f3nico, la fecha de nacimiento y el sexo.<\/p>\n

Un registro tambi\u00e9n se conoce como tupla.<\/strong><\/p>\n

Definici\u00f3n de registro<\/span><\/h2>\n

Las tablas contienen columnas y filas que, para simplificar, tienen una estructura similar a la de Microsoft Excel<\/a>. Las tablas relacionales tienen una estructura muy similar pero m\u00e1s compleja<\/strong>, ya que cada columna de la tabla representa una determinada propiedad de la tabla.<\/p>\n

Supongamos que existe una tabla denominada CLIENTE_MASTER, que almacena datos b\u00e1sicos de clientes. Puede contener una columna APELLIDOS_CLIENTES, que se utiliza para almacenar los apellidos de los clientes. Esta columna puede tener ciertos par\u00e1metros, por ejemplo, cada apellido debe tener 30 caracteres o menos y estar compuesto s\u00f3lo por caracteres alfab\u00e9ticos. As\u00ed, cada apellido de cliente a\u00f1adido a la tabla CUSTOMER_MASTER debe cumplir estos par\u00e1metros.<\/p>\n

Sin embargo, cada fila o registro completo de cliente tambi\u00e9n incluye otros elementos<\/strong>, como el nombre, la direcci\u00f3n f\u00edsica, la direcci\u00f3n de correo electr\u00f3nico, la fecha de nacimiento y el sexo, etc. Cada elemento se clasifica en su columna correspondiente designada. As\u00ed, cada fila o registro de cliente es una l\u00ednea horizontal de datos que contiene una colecci\u00f3n de elementos.<\/p>\n","protected":false},"excerpt":{"rendered":"

\u00bfQu\u00e9 significa registro? En las bases de datos relacionales, un registro es un grupo de datos relacionados que se mantienen dentro de la misma estructura. M\u00e1s concretamente, un registro es una agrupaci\u00f3n de campos dentro de una tabla que hacen referencia a un objeto concreto. El t\u00e9rmino registro se utiliza frecuentemente como sin\u00f3nimo de fila. […]<\/p>\n","protected":false},"author":7813,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_acf_changed":false,"_lmt_disableupdate":"no","_lmt_disable":"","footnotes":""},"definitioncat":[31],"class_list":["post-65343","definition","type-definition","status-publish","format-standard","hentry","definitioncat-gestion-datos"],"acf":[],"yoast_head":"\n\u00bfQu\u00e9 es un registro en inform\u00e1tica? Clasificaci\u00f3n y tipos<\/title>\n<meta name=\"description\" content=\"Mediante algunos ejemplos te mosstramos c\u00f3mo funcionan los registros en el contexto de una base de datos relacional.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.techopedia.com\/es\/definicion\/registro\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Registro\" \/>\n<meta property=\"og:description\" content=\"Mediante algunos ejemplos te mosstramos c\u00f3mo funcionan los registros en el contexto de una base de datos relacional.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.techopedia.com\/es\/definicion\/registro\" \/>\n<meta property=\"og:site_name\" content=\"Techopedia Espa\u00f1ol\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-01T15:22:22+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.techopedia.com\/es\/definicion\/registro#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.techopedia.com\/es\/definicion\/registro\"},\"author\":{\"name\":\"Margaret Rouse\",\"@id\":\"https:\/\/www.techopedia.com\/es\/#\/schema\/person\/f5dd538e31ee352d105b8af36c4268a5\"},\"headline\":\"Registro\",\"datePublished\":\"2024-11-01T14:48:26+00:00\",\"dateModified\":\"2024-11-01T15:22:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.techopedia.com\/es\/definicion\/registro\"},\"wordCount\":287,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.techopedia.com\/es\/#organization\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.techopedia.com\/es\/definicion\/registro#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.techopedia.com\/es\/definicion\/registro\",\"url\":\"https:\/\/www.techopedia.com\/es\/definicion\/registro\",\"name\":\"\u00bfQu\u00e9 es un registro en inform\u00e1tica? Clasificaci\u00f3n y tipos\",\"isPartOf\":{\"@id\":\"https:\/\/www.techopedia.com\/es\/#website\"},\"datePublished\":\"2024-11-01T14:48:26+00:00\",\"dateModified\":\"2024-11-01T15:22:22+00:00\",\"description\":\"Mediante algunos ejemplos te mosstramos c\u00f3mo funcionan los registros en el contexto de una base de datos relacional.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.techopedia.com\/es\/definicion\/registro#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.techopedia.com\/es\/definicion\/registro\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.techopedia.com\/es\/definicion\/registro#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Inicio\",\"item\":\"https:\/\/www.techopedia.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Term\",\"item\":\"https:\/\/www.techopedia.com\/es\/definicion\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Registro\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.techopedia.com\/es\/#website\",\"url\":\"https:\/\/www.techopedia.com\/es\/\",\"name\":\"Techopedia\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.techopedia.com\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.techopedia.com\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.techopedia.com\/es\/#organization\",\"name\":\"Techopedia en Espa\u00f1ol\",\"url\":\"https:\/\/www.techopedia.com\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.techopedia.com\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.techopedia.com\/es\/wp-content\/uploads\/sites\/4\/2023\/09\/techopedia-light.svg\",\"contentUrl\":\"https:\/\/www.techopedia.com\/es\/wp-content\/uploads\/sites\/4\/2023\/09\/techopedia-light.svg\",\"width\":209,\"height\":37,\"caption\":\"Techopedia en Espa\u00f1ol\"},\"image\":{\"@id\":\"https:\/\/www.techopedia.com\/es\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.techopedia.com\/es\/#\/schema\/person\/f5dd538e31ee352d105b8af36c4268a5\",\"name\":\"Margaret Rouse\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.techopedia.com\/es\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/www.techopedia.com\/wp-content\/uploads\/2023\/02\/margaret-rouse-headshot.jpeg\",\"contentUrl\":\"https:\/\/www.techopedia.com\/wp-content\/uploads\/2023\/02\/margaret-rouse-headshot.jpeg\",\"caption\":\"Margaret Rouse\"},\"description\":\"Margaret is an award-winning writer and educator known for her ability to explain complex technical topics to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles in the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret\u2019s idea of \u200b\u200ba fun day is to help IT and business professionals to learn to speak each other\u2019s highly specialized languages.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/margaretrouse\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/@techdefinitions\"],\"knowsAbout\":[\"Technology expert\"],\"url\":\"https:\/\/www.techopedia.com\/es\/autor\/margaret-rouse\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u00bfQu\u00e9 es un registro en inform\u00e1tica? Clasificaci\u00f3n y tipos","description":"Mediante algunos ejemplos te mosstramos c\u00f3mo funcionan los registros en el contexto de una base de datos relacional.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.techopedia.com\/es\/definicion\/registro","og_locale":"es_ES","og_type":"article","og_title":"Registro","og_description":"Mediante algunos ejemplos te mosstramos c\u00f3mo funcionan los registros en el contexto de una base de datos relacional.","og_url":"https:\/\/www.techopedia.com\/es\/definicion\/registro","og_site_name":"Techopedia Espa\u00f1ol","article_modified_time":"2024-11-01T15:22:22+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.techopedia.com\/es\/definicion\/registro#article","isPartOf":{"@id":"https:\/\/www.techopedia.com\/es\/definicion\/registro"},"author":{"name":"Margaret Rouse","@id":"https:\/\/www.techopedia.com\/es\/#\/schema\/person\/f5dd538e31ee352d105b8af36c4268a5"},"headline":"Registro","datePublished":"2024-11-01T14:48:26+00:00","dateModified":"2024-11-01T15:22:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.techopedia.com\/es\/definicion\/registro"},"wordCount":287,"commentCount":0,"publisher":{"@id":"https:\/\/www.techopedia.com\/es\/#organization"},"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.techopedia.com\/es\/definicion\/registro#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.techopedia.com\/es\/definicion\/registro","url":"https:\/\/www.techopedia.com\/es\/definicion\/registro","name":"\u00bfQu\u00e9 es un registro en inform\u00e1tica? Clasificaci\u00f3n y tipos","isPartOf":{"@id":"https:\/\/www.techopedia.com\/es\/#website"},"datePublished":"2024-11-01T14:48:26+00:00","dateModified":"2024-11-01T15:22:22+00:00","description":"Mediante algunos ejemplos te mosstramos c\u00f3mo funcionan los registros en el contexto de una base de datos relacional.","breadcrumb":{"@id":"https:\/\/www.techopedia.com\/es\/definicion\/registro#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.techopedia.com\/es\/definicion\/registro"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.techopedia.com\/es\/definicion\/registro#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Inicio","item":"https:\/\/www.techopedia.com\/es\/"},{"@type":"ListItem","position":2,"name":"Term","item":"https:\/\/www.techopedia.com\/es\/definicion"},{"@type":"ListItem","position":3,"name":"Registro"}]},{"@type":"WebSite","@id":"https:\/\/www.techopedia.com\/es\/#website","url":"https:\/\/www.techopedia.com\/es\/","name":"Techopedia","description":"","publisher":{"@id":"https:\/\/www.techopedia.com\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.techopedia.com\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.techopedia.com\/es\/#organization","name":"Techopedia en Espa\u00f1ol","url":"https:\/\/www.techopedia.com\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.techopedia.com\/es\/#\/schema\/logo\/image\/","url":"https:\/\/www.techopedia.com\/es\/wp-content\/uploads\/sites\/4\/2023\/09\/techopedia-light.svg","contentUrl":"https:\/\/www.techopedia.com\/es\/wp-content\/uploads\/sites\/4\/2023\/09\/techopedia-light.svg","width":209,"height":37,"caption":"Techopedia en Espa\u00f1ol"},"image":{"@id":"https:\/\/www.techopedia.com\/es\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.techopedia.com\/es\/#\/schema\/person\/f5dd538e31ee352d105b8af36c4268a5","name":"Margaret Rouse","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.techopedia.com\/es\/#\/schema\/person\/image\/","url":"https:\/\/www.techopedia.com\/wp-content\/uploads\/2023\/02\/margaret-rouse-headshot.jpeg","contentUrl":"https:\/\/www.techopedia.com\/wp-content\/uploads\/2023\/02\/margaret-rouse-headshot.jpeg","caption":"Margaret Rouse"},"description":"Margaret is an award-winning writer and educator known for her ability to explain complex technical topics to a non-technical business audience. Over the past twenty years, her IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles in the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret\u2019s idea of \u200b\u200ba fun day is to help IT and business professionals to learn to speak each other\u2019s highly specialized languages.","sameAs":["https:\/\/www.linkedin.com\/in\/margaretrouse\/","https:\/\/x.com\/https:\/\/twitter.com\/@techdefinitions"],"knowsAbout":["Technology expert"],"url":"https:\/\/www.techopedia.com\/es\/autor\/margaret-rouse"}]}},"_links":{"self":[{"href":"https:\/\/www.techopedia.com\/es\/wp-json\/wp\/v2\/definition\/65343"}],"collection":[{"href":"https:\/\/www.techopedia.com\/es\/wp-json\/wp\/v2\/definition"}],"about":[{"href":"https:\/\/www.techopedia.com\/es\/wp-json\/wp\/v2\/types\/definition"}],"author":[{"embeddable":true,"href":"https:\/\/www.techopedia.com\/es\/wp-json\/wp\/v2\/users\/7813"}],"replies":[{"embeddable":true,"href":"https:\/\/www.techopedia.com\/es\/wp-json\/wp\/v2\/comments?post=65343"}],"version-history":[{"count":3,"href":"https:\/\/www.techopedia.com\/es\/wp-json\/wp\/v2\/definition\/65343\/revisions"}],"predecessor-version":[{"id":65357,"href":"https:\/\/www.techopedia.com\/es\/wp-json\/wp\/v2\/definition\/65343\/revisions\/65357"}],"wp:attachment":[{"href":"https:\/\/www.techopedia.com\/es\/wp-json\/wp\/v2\/media?parent=65343"}],"wp:term":[{"taxonomy":"definitioncat","embeddable":true,"href":"https:\/\/www.techopedia.com\/es\/wp-json\/wp\/v2\/definitioncat?post=65343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}