Posts

2- Concepts of DBMS,RDBMS ,SQL and DBMS vs RDBMS

Image
  What is DBMS? Database Management Systems (DBMS) refer to the technology solution used to optimize and manage the storage and retrieval of data from databases. DBMS was designed to solve the fundamental problems associated with storing, managing, accessing, securing, and auditing data in traditional file systems. DBMS offers a systematic approach to manage databases via an interface for users as well as workloads accessing the databases via apps. The management responsibilities for DBMS encompass: --> Information within the databases --> The processes applied to databases, such as access and modification --> The database’s logic structure Benefits of DBMS Introducing DBMS software to manage databases results in the following benefits: Data security - DBMS allows organizations to enforce policies that enable compliance and security. Data sharing -   Fast and efficient collaboration between users. Data integration -   Instead of operating island of database ...

1- Data, DataBase, DataModel Types & Infrastructure

Image
  What is data? Data is a collection of a distinct small unit of information. It can be used in a variety of forms like text, numbers, media, bytes, etc. it can be stored in pieces of paper or electronic memory, etc. In computing, Data is information that can be translated into a form for efficient movement and processing. Data is interchangeable What is Database? A database is an organized collection of data,  So that it can be easily accessed,managed and maintained. For example, a company database may include tables for products, employees, and financial records. Types Of Data Models The three primary types of data models are conceptual, logical, and physical . Think of them as a progression from an abstract layout to a detailed mapping of the database setup and final form: Types of Data Models -->  Conceptual Data Model Conceptual data models are the most simple and abstract .  Little annotation or data use occurs in this model, but the overall layout an...