Schema generally defines the data entities

josepoh943@hide

The word schema comes from the Greek word meaning 'form' or 'shape'. However, the way to specifically define schema is classified and varies depending on the context or context of what is being said, so depending on the meaning and situation, it can be classified into 'data science', 'education', 'marketing and *SEO (search engine optimization)' Or, it is closely related to a field such as 'psychology' and is actually written in that field.  If you would like to know more information about SEO (Search Engine Optimization), please refer to ‘here ’. The same goes for 'schema psychology', which appears as a related search word when you search for the word schema in the search box. In the case of psychology, the concept of schema theory, which can be applied to cognitive behavioral therapy in mental health medicine, is different from the database-based schema in computer science, which we will talk about today, so I think you can distinguish this point.


What is a database schema? What is database schema? Image Hedley Digital Image of database schema So Cambodia Phone Number Data let's talk about computer database schema, which is what we're going to talk about today . As briefly mentioned above, schema, if defined in one word, means ‘data structure’ or ‘database design’. A database schema is a kind of skeletal structure that represents a logical view, and all constraints applied to data in the database are designed using this skeletal structure. , attributes, relationships, and constraints that data values ​​have when manipulating the data that make up the database. In summary, when users, that is, people who search search with various questions, they reach the database stored at the bottom and obtain information, the series of structures. The data processing process and the overall cooperative relationship between data move very closely, and this refers to the structure of the database expressed in a 'formal language'. This is explained as a set of metadata that describes the overall specifications of the database structure and constraints .




Schema Blueprint Image Hedley Digital Schema blueprint image Since a schema is a structure that defines the data structure, expression method, and relationships between data in a formal language, the database management system creates a database schema according to the 'given settings'. Since commands are performed by referring to the database schema you created, there are ideal requirements for schema integration, which are called 'general characteristics of schema' . The four requirements listed below affect the detailed structure of the generated schema. Although not all of these conditions must be met in a particular application, they are referred to as meeting these requirements will produce the most ideal results. Duplicate preservation Each nested element specified in the input mapping also has a database schema relationship.