Classic database normalization would say to create a pizza table, and then a many-to-many table relating pizza IDs to topping IDs.
典型的数据库标准会建议需要先创建一张比萨表,然后再创建一张将比萨id与浇头id关联起来的多对多表。
Note that this is an extremely informal discussion of the topic of database normalization, and does not cover all of the issues in depth.
注意这是对数据库规范化的一个非常不正式的讨论,并且也没有深入讨论所有的主题。
Database normalization is a data design and organization process applied to data structures based on rules that help building relational databases.
数据库规范化是一种基于规则的,施加于数据结构之上的数据设计和组织过程,这种规则有助于建立关系型数据库。
To demonstrate, let's apply a little database normalization to the previous example, splitting the owner field of PhoneNumber into a separate person table.
作为演示,我们将一个小的数据库规范化(normalization)应用于上一示例,将PhoneNumber的owner字段分割到单独的person表中。
Suffice it to say that anyone wanting to create a database system must be familiar with the concept of normalization.
任何想要创建数据库系统的人们必需熟悉标准化的概念,只要说明这个就够了。
Normalization is also left by the wayside (as it usually is in any large database in which performance is a major concern).
标准化也被抛到了脑后(因为通常在大型的数据库中,性能是主要关注点)。
The reason: Normalization requires more tables, table joins, keys and indexes and thus more internal database operations for implement queries.
其原因是:规范化需要更多的表,连接等操作,主键、索引,从而需要更多的内部操作。
Normalization usually involves dividing a database into two or more tables and defining relationships between the tables.
规范化通常包括:将一个数据库拆分为两个或更多的表,并定义表之间的依赖关系。
In relational database design, the process of organizing data to minimize redundancy is called normalization.
在关系型数据库设计中,这种组织数据以减少冗余的过程,被称为规范化。
In normalization theory of relation database, finding candidate key and primary attribute is always a difficult problem.
在关系数据库规范化理论中,求解后选关键字和主属性一直是一个棘手的问题。
In this paper, the application of normalization and denormalization in the optimization of relational database design are discussed.
讨论了在大型关系数据库优化设计中关系的规范化和逆规范化的应用。
With connection to the proposed database table, the processing methods and techniques for normalization, ranking and inquiry on fuzzy information are also discussed.
结合所提出的数据库表,探讨了模糊数据的归一化、排序、查询等处理方法与技术。
Remember, these normalization guidelines are cumulative. For a database to be in 3NF, it must first fulfill all the criteria of a 2NF and 1NF database.
记住,这些规范化准则是渐增的。如果一个数据库满足第三范式,那么它必须先满足了第二范式和第一范式的条件。
The problem of normalization for object is the kernel problem in normalization theory for object-oriented database.
对象规范化问题是面向对象规范化理论中的核心问题。
Research and realizaion of data structure and database design of commerce information processing system is disscused, take warehouse for example, based on normalization theory of data structure.
以数据结构规范化理论为基础,以数据仓库为例,讨论了商务信息处理系统数据结构和数据库结构的合理设计。
It is refer to normalization of data in building of spatial database of soil and water loss assessing.
在水土流失评价数据库的建立研究中,涉及到数据的标准化问题。
This paper introduces the appliance of anti-normalization in database design, which gives some examples based on the implement of anti-normalization to optimize the database design.
本文在简要介绍了数据库中反规范化的应用后,详细地举出了一个用反规范化设计的数据库来讨论如何通过反规范化进行数据库设计优化。
This paper introduces the appliance of anti-normalization in database design, which gives some examples based on the implement of anti-normalization to optimize the database design.
本文在简要介绍了数据库中反规范化的应用后,详细地举出了一个用反规范化设计的数据库来讨论如何通过反规范化进行数据库设计优化。
应用推荐