Skip to main content

Newer Post or latest post

Explain some points on database management systems in cloud computing?

Explain some points on database management systems in cloud computing? Cloud computing provides the services of implementing the database management system to process the data to the client user for a specific task to process it. The database management system included the different types of manipulations command that can be performed on the database file into the relational database file and object database file with different types of query language, where the relational database model uses the SQL and Object database model uses OQL on the database files to manipulate the database information. The user can use the processing of the database using the application program interface to apply the database command on the information to manipulate it depending on the user requirements. Database Management Systems (DBMS) in cloud computing offer scalable, flexible, and cost-effective solutions for storing and managing data over the internet. Unlike traditional on-premise databases, cloud-ba...

What do you mean by the "Mapping" of the database structure in DBMS?

What is “Mapping” in the DBMS?

Mapping in DBMS {Database Management System}

The mapping is a link or connect and equality to describe between view level, conceptual level and internal level.

It used to describe how they are connecting to each other in three levels.

It is a process to convert a request of external level which is request both the two level such as logical level and physical level.

Simply it is a map of Database structure which shows the links of the three levels basically.

There are two types of mapping in DBMS.

  • External conceptual mapping
  • Internal conceptual mapping
In the DBMS each users refers only its own external schema. Hence the DBMS must transform a request on a particular or specified external into the request against to the conceptual schema which means logical level of schema in the logical refers where the logical term has perform in the database and then into the request against internal schema which means the internal is schema in the physical level where the physical structure has their connectivity of the database to computer system or any hardware connectivity show in the physical level store and retrieve data to the database and from the database.

Comments

Popular posts from this blog

what are the function of the joystick and light pen?

Q 1. State the functions of a joystick and that of a light pen? Introduction to the joystick device, virtual or soft joystick tool, game controller, virtual or soft game controller and light pen topics are covered below here: Joystick What is the meaning of the joystick in computer? What is the joystick as a peripheral device in the computer system? What is main use of joystick in computer system peripheral devices? What is the purpose of the joystick in computer? What are the types of joysticks in the peripheral system for game purpose? What do you mean by analog joystick in peripheral system? What are the advantages of analog joystick device? What are the disadvantages or drawbacks of analog joystick device? What are the uses of joysticks? What are top 5 uses of joystick device in the computer system peripheral? Where is the use of joystick? How to connect the joystick for game in computer system? Can you connect the joystick to the laptop? Why do n...

About the memory and its Classification of the computer Memory

"Hi everyone, I'm Rudra, a CS engineer and passionate blogger. Welcome to my post on [About the memory and its Classification of the computer Memory. ], where I'll share insights on Information Technology and Computer Science education. My goal is to provide helpful information and answer your questions. Feel free to ask me anything in the comments below. Let's dive into today's topic…🙂” What are the memories in the reference of computer system? What is Computer Memory?:- The memory is the essential for the computer to store the data, instruction and information. Without memory, computers are not be able to store data, instruction etc. The memory is an essential part of a computer system. It is require by the computer system to store information. Memory can be divided into the following two categories types: i) Primary or Main memory ii) Secondary Memory or Permanent memory In this figure I'll show the classification of the memory of computer s...

Describe the different ways of mobile communication systems for users?

Describe the different ways of mobile communication systems for users? Mobile communication makes it easy to connect with many users through the different types of ways to provide the communication system, share the information to each other and make communication between two or more users through the mobile devices. Such as:- an internet service provides many ways to connect the users in the text, audio, image and video file or data connections sharing the information to each other using these data types to communicate to each other. The user needs to communicate with the other user on the data communication system application software provide the process the data to send the file or message to the user who is connected to the communication application software through their user ID name or email to communicate to share the text or audio file or video file or image file also can be shared into the application software to the user such as:- if the application software provide the chatt...