Difference Between Generalization and Specialization in DBMS

Advertisement

Main Difference

Generalization in DBMS becomes known as the process in which all the sets of objects get viewed as the same class focused on the characteristics they have in common and ignores the differences between them. Specialization in DBMS becomes known as the process in which all the sets of objects get viewed as individual sets based on their characteristics that make them different from others and ignores the similarities between them.

Advertisement

Comparison Chart

Basis of DistinctionGeneralization in DBMSSpecialization in DBMS
DefinitionThe process in which all the sets of objects get viewed as the same class focused on the characteristics they have in common and ignores the differences between them.The process in which all the sets of objects get viewed as individual sets based on their characteristics that make them different from others and ignores the similarities between them.
ApproachBottom-upTop-down
WorkingTakes all the information that have universal nature within the entities and then forms a new entity.Creates new objects based on the difference between the existing ones and have some features of the parents.

Generalization in DBMS

Generalization in DBMS becomes known as the process in which all the sets of objects get viewed as the same class focused on the characteristics they have in common and ignores the differences between them. Generalization is a procedure of separating common attributes from at least two categories and joining them into a summed-up superclass. In this way, it is a base up approach as at least two lower lever substances are joined to shape a more elevated amount element. In the DBMS, Generalization is a method of separating standard attributes starting at least two classes and goes along with them into a far-reaching super class. Along these lines, it is a base up move in the method for as two or lower lever body is joint to shape a senior level element. It becomes a base up approach in which two lower level substances consolidate to develop a larger amount part. In speculation, the more elevated amount content can likewise combine with another lower level detail to make advance more elevated amount element. All DBMSs give a few information approvals; for instance, they can dismiss invalid dates or alphabetic information gone into cash fields. Be that as it may, most approval is surrendered over to the application programs. Insightful databases give more permission; for instance, table queries can dismiss terrible spelling or coding of things. Basic calculations can likewise be utilized, for example, one that registers deals assess for a request given postal district. At the point when approval is surrendered over to every application program, one program could enable a thing to be entered while another program rejects it. Information uprightness is better off when information approval is done in just a single place. Centralized computer DBMSs were the first to end up plainly canny, and all the others stuck to this same pattern.

Advertisement

Specialization in DBMS

Specialization in DBMS becomes known as the process in which all the sets of objects get viewed as individual sets based on their characteristics that make them different from others and ignores the similarities between them. The way toward summing up substances, where the summed-up elements contain the properties of all the summed-up elements, is called speculation. In prediction, various materials are united into one summed up feature considering their comparable attributes. For instance, pigeon, house sparrow, crow, and dove can all be summed up as Birds. Specialization is the inverse of speculation. In specialty, a gathering of substances is separated into sub-bunches considering their attributes. Take a collection “Individual” for instance. A man has a name, date of birth, sexual orientation, and so forth. These properties are regular in all people, individuals. Be that as it may, in an organization, people can get recognized as a worker, manager, client, or seller, given what part they play in the organization. Specialization might get perceived as the switch procedure of Generalization. Specialization is the abstracting method of acquainting new qualities with a current class of items to make at least one new categories of articles. In straightforward terms, a gathering of elements in specialization can arrange into sub-bunches given their qualities. It is a top-down approach in which one more high amount substance can separate into two lower level elements. It characterizes at least one subtypes of the super types and shaping supertype/subtype connections.

Advertisement

Key Differences

  • Generalization in DBMS becomes known as the process in which all the sets of objects get viewed as the same class focused on the characteristics they have in common and ignores the differences between them.
  • Specialization in DBMS becomes known as the process in which all the sets of objects get viewed as individual sets based on their characteristics that make them different from others and ignores the similarities between them.
  • The way the generalization in DBMS occurs always has a bottom-up approach, on the other hand, the process in which the specialization in DBMS occurs mostly has a top-down approach.
  • The generalization process takes all the information that have universal nature within the entities and then forms a new entity. On the other hand, the specialization creates new objects based on the difference between the existing ones and have some features of the parents.
  • A higher-level entity that exists in the generalization always has a lower level object with it so help manage the system. On the other hand, for specialization, the higher-level entity does not always have a lower level object.
  • One new entity from several existing entities becomes synonymous with generalization, on the other hand, several new entities from one entity become synonymous with specialization.

Video Explanation