Skip to main content

Logical Database

Logical Database

A Logical Database is a special type of ABAP (Advance Business Application and Programming) that is used to retrieve data from various tables and the data is interrelated to each other. Also, a logical database provides a read-only view of Data.

Structure Of Logical Database:
A Logical database uses only a hierarchical structure of tables i.e. Data is organized in a Tree-like Structure and the data is stored as records that are connected to each other through edges (Links). Logical Database contains Open SQL statements which are used to read data from the database. The logical database reads the program, stores them in the program if required, and passes them line by line to the application program.

Structure of Logical database

Structure of Logical database

Features of Logical Database:
In this section, let us look at some features of a logical database:

  • We can select only that type of Data that we need.
  • Data Authentication is done in order to maintain security.
  • Logical Database uses hierarchical Structure due to this data integrity is maintained.

Goal Of Logical Database:
The goal of Logical Database is to create well-structured tables that reflect the need of the user. The tables of the Logical database store data in a non-redundant manner and foreign keys will be used in tables so that relationships among tables and entities will be supported.

Tasks of Logical Database:
Below is some important task of Logical Database:
  • With the help of the Logical database, we will read the same data from multiple programs.
  • A logical database defines the same user interface for multiple programs.
  • Logical Database ensures the Authorization checks for the centralized sensitive database.
  • With the help of a Logical Database, Performance is improved. Like in Logical Database we will use joins instead of multiple SELECT statements, which will improve response time and this will increase the Performance of Logical Database.

Data View Of Logical Database:
Logical Database provides a particular view of Logical Database tables. A logical database is appropriately used when the structure of the Database is Large. It is convenient to use flow i.e
  • SELECT
  • READ
  • PROCESS
  • DISPLAY

In order to work with databases efficiently. The data of the Logical Database is hierarchical in nature. The tables are linked to each other in a Foreign Key relationship.

Diagrammatically, the Data View of Logical Database is shown as:

Database Retreving Data


Points To Remember:
Tables must have Foreign Key Relationship.
  • A logical Database consists of logically related tables that are arranged in a hierarchical manner used for reading or retrieving Data.
  • Logical Database consist of three main elements:
    • Logical Database
    • Selections of Data from Database
    • Database Program
  • If we want to improve the access time on data, then we use VIEWS in Logical Database.

Example:
Suppose in a University or College, a HOD wants to get information about a specific student. So for that, he firstly retrieves the data about its batch and Branch from a large amount of Data, and he will easily get information about the required Student but didn’t alter the information about it.

UNIVERSITY DATABASE


Advantages Of Logical Database:
Let us look at some advantages of the logical database:

  • In a Logical database, we can select meaningful data from a large amount of data.
  • Logical Database consists of Central Authorization which checks for Database Accesses is Authenticated or not.
  • In this Coding, the part is less required to retrieve data from the database as compared to Other Databases.
  • Access performance of reading data from the hierarchical structure of the Database is good.
  • Easy to understand user interfaces.
  • Logical Database firstly check functions which further check that user input is complete, correct, and plausible.

Disadvantages Of Logical Database:
This section shows the disadvantages of the logical database:
  • Logical Database takes more time when the required data is at the last because if that table which is required at the lowest level then firstly all upper-level tables should be read which takes more time and this slows down the performance.
  • In Logical Database ENDGET command doesn’t exist due to this the code block associated with an event ends with the next event statement.
Labels:

Comments

Post a Comment

Please do not enter any spam link in the comment box.

Popular posts from this blog

DBMS Keys

DBMS Keys KEYS in DBMS is an attribute or set of attributes which helps you to identify a row (tuple) uniquely in a relation(table). They allow you to find the relation between two tables. Keys help you uniquely identify a row in a table by a combination of one or more columns in that table. Key is also helpful for finding unique record or row from the table. Database key is also helpful for finding unique record or row from the table. Example: Employee ID FirstName LastName 11 Andrew Johnson 22 Tom Wood 33 Alex Hale In the above-given example, employee ID is a primary key because it uniquely identifies an employee record. In this table, no other employee can have the same employee ID. Here are some reasons for using sql key in the DBMS system. Keys help you to identify any row of data in a table. In a real-world application, a table could contain thousands of records. Moreover, the records could be duplicated. Keys in RDBMS ensure that you can uniquely identify a table record despite ...
Post a Comment
Read more

Colors in CSS

Ways to declare Colors in CSS (Image by - Sharma Guides | Subham232330) 1. Color Name 2. Hex Value 3. RGB() and RGBA() 4. HSL() and HSLA() 5. HWB() * Color Name:- background-color:red; * HEX Value:- background-color:#001122; * RGB():- background-color:rgb(25,31,52); * RGBA():- background-color:rgba(0,0,0,1.5);          |           Transparency The hexadecimal system uses values from 0 to 255 but in RGB we can use 0% to 100% as well.
Post a Comment
Read more

Computer Short Questions

Computer Short Questions & Answers: 1. What is any part of the computer that you can physically touch? – Hardware 2. Which generation of computers is still under development? – Fifth 3. What is the most common storage device for the personal computer? – Hard Disk Drive 4. Which key is used in combination with another key to perform a specific task? – Control 5. What is the pattern of printed lines on most products? – Barcodes 6. To make the number pad act as a directional arrow, we press which key? – Shift 7. Which devices let the computer communicate with you? – Input 8. What is the most frequently used piece of hardware for inputting data? – Hardware 9. What is the place where the computer stores programs and data? – Storage unit 10. What is the process of dividing the disk into tracks and sectors? – Formatting 11. What is the space in your computer that loads’ and works with data? – RAM memory 12. What is the storage which stores or retains data after power off? – Non-volatile s...
Post a Comment
Read more