Skip to main content

Three schema Architecture | Internal Level | Conceptual Level | External Level

Image
By

Three schema Architecture

DBMS Three schema Architecture

  • Internal Level 
  • Conceptual Level 
  • External Level 

Three schema Architecture 

  • Three schema architecture is also called ANSI / SPARC architecture or three-level architecture.
  • This framework is used to describe the structure of a specific database system.
  • The three schema architecture is also used to separate user applications and physical databases.
  • There are three levels in the three schema architecture. It breaks the database into three different categories.

The three-schema architecture is as follows:

Three schema Architecture

In the above diagram:

  • It shows the DBMS architecture.
  • Mapping is used to convert request and response between different database levels of the architecture.
  • Mapping is not good for small DBMS as it takes more time.
  • External / conceptual mapping, it is necessary to convert the link from the external level to the conceptual schema.
  • Conceptual / internal mapping converts DBMS requests from conceptual to internal level.

1. Internal Level

  • This level contains an internal schema that describes the physical storage structure of the database.
  • Internal schema is also known as physical schema.
  • It uses the physical data model. It is used to define how the data will be stored in the block.
  • Physical level is used to describe complex low level data structures in detail.

2. Conceptual Level

  • Conceptual schema describes the design of a database at the conceptual level. The conceptual level is also known as the logical level.
  • This schema describes the structure of the entire database.
  • Conceptual level tells what data will be stored in the database and also tells what are the relationships between those data.
  • In the conceptual level, the internal details such as the structure of the data implementation are hidden.
  • Programmers and database administrators are working on such level.

3. External Level

  • At the external level, a database consists of several schemas which are sometimes called subschemas. Subschema is used to describe different views of the database.
  • External schema is also known as view schema.
  • A view schema describes the database portion that a particular user group is interested in and hides the remaining databases from that user group.
  • The View schema describes the end user interaction with the database system.
Labels:

Comments

Post a Comment

Popular posts from this blog

Biography of Manohar Joshi

By
Biography of Manohar Joshi: Manohar Gajanan Joshi is an Indian politician who has played a significant role in Maharashtra state politics. Born on December 2, 1937, in a middle-class family in a village called Ganeshpeth in Ratnagiri district, Maharashtra, Joshi's journey into politics was marked by his association with the Shiv Sena, a right-wing regional political party in India. Joshi's political career began in the late 1960s when he joined the Shiv Sena, which was then led by its founder, Bal Thackeray. He quickly rose through the ranks of the party due to his organizational skills, dedication, and ideological alignment with the party's principles, which advocated for the interests of the Marathi-speaking population of Maharashtra. In 1972, Manohar Joshi won his first election to the Brihanmumbai Municipal Corporation (BMC), marking the beginning of his electoral career. He served as a corporator in the BMC and later became the Mayor of Mumbai in 1976. Joshi's tenu...
Post a Comment
Read more

Professor Cheiro Prophecies about India | 5 predictions Professor Kiro - Kiro made these amazing predictions for India

By
Professor Cheiro Prophecies:  Here is Kiro made these amazing predictions for India: Professor Kiro was born in November 1866 in England. At the age of 17, Kiro came to Mumbai and met astrologer Vednarayan Joshi. With his advice, he will reach the Himalayas, Kashmir, Ladakh and Varanasi. From here, he studied astrology extensively. Kiro made many predictions in his life, which we are giving you here. Cheiro, whose real name was William John Warner, was a prominent Irish astrologer and palmist who gained fame in the late 19th and early 20th centuries. He was known for his accurate predictions and was consulted by various prominent figures of his time, including Mark Twain, Oscar Wilde, and Thomas Edison. Cheiro also made some predictions related to India. Parada Kahanee One of his notable predictions about India was made in his book "Cheiro's World Predictions," published in 1926. In this book, he wrote about the possibility of India gaining independence from British...
Post a Comment
Read more

Biography of Abbie Hoffman | Early Life and Political Activism - Later Years and Personal Life - Legacy of Abbie Hoffman

By
Biography of Abbie Hoffman: Abbie Hoffman (November 30, 1936 – April 12, 1989) was an American political and social activist known for his involvement in the counterculture and anti-war movements of the 1960s and 1970s. He was a key figure in the Youth International Party (Yippies) and was known for his theatrical and often humorous protests.  Here is a brief biography of Abbie Hoffman: Early Life of Abbie Hoffman: 1. Birth: Abbie Hoffman was born on November 30, 1936, in Worcester, Massachusetts, USA. 2. Education: He attended Brandeis University, where he earned a degree in psychology in 1959. Parada Kahanee Political Activism: 1. Civil Rights Movement: Hoffman began his activism by participating in the civil rights movement during the early 1960s. 2. Youth International Party (Yippies): In 1967, Hoffman, along with Jerry Rubin and others, co-founded the Yippies, a countercultural and anti-authoritarian political party known for its unconventional and theatrical protes...
Post a Comment
Read more