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

Languages in DBMS

Languages in DBMS Structured Query Language(SQL) as we all know is the database language by the use of which we can perform certain operations on the existing database and also we can use this language to create a database. SQL uses certain commands like Create, Drop, Insert, etc. to carry out the required tasks. These SQL commands are mainly categorized into five categories as: DDL – Data Definition Language DQL – Data Query Language DML – Data Manipulation Language DCL – Data Control Language TCL – Transaction Control Language Now, we will see all of these in detail. DDL (Data Definition Language): DDL or Data Definition Language actually consists of the SQL commands that can be used to define the database schema. It simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in the database. DDL is a set of SQL commands used to create, modify, and delete database structures but not data. These commands are normally ...
Post a Comment
Read more

Indexing in DBMS

Indexing in DBMS Indexing is used to optimize the performance of a database by minimizing the number of disk accesses required when a query is processed.  The index is a type of data structure. It is used to locate and access the data in a database table quickly. Index structure: Indexes can be created using some database columns. The first column of the database is the search key that contains a copy of the primary key or candidate key of the table. The values of the primary key are stored in sorted order so that the corresponding data can be accessed easily.  The second column of the database is the data reference. It contains a set of pointers holding the address of the disk block where the value of the particular key can be found. Indexing Methods Ordered indices The indices are usually sorted to make searching faster. The indices which are sorted are known as ordered indices. Example: Suppose we have an employee table with thousands of record and each of which is 10 byte...
Post a Comment
Read more

SQL Injection

SQL Injection The SQL Injection is a code penetration technique that might cause loss to our database. It is one of the most practiced web hacking techniques to place malicious code in SQL statements, via webpage input. SQL injection can be used to manipulate the application's web server by malicious users. SQL injection generally occurs when we ask a user to input their username/userID. Instead of a name or ID, the user gives us an SQL statement that we will unknowingly run on our database. For Example - we create a SELECT statement by adding a variable "demoUserID" to select a string. The variable will be fetched from user input (getRequestString). demoUserI = getrequestString("UserId"); demoSQL = "SELECT * FROM users WHERE UserId =" +demoUserId; Types of SQL injection attacks SQL injections can do more harm other than passing the login algorithms. Some of the SQL injection attacks include: Updating, deleting, and inserting the data: An attack can mo...
Post a Comment
Read more