Database
Overview SQLite is a small, compact, a self-contained, embedded and high reliable database. SQLite is not client-server database. Unlike other SQL databases, SQLite does not have a separate server process. SQLite is cross platform and supports various platforms like Windows, Linux, Android etc. Getting started You can download it for the popular OS platforms at: […]
Overview Let’s learn about different types of NoSQL databases in this tutorial. NoSQL databases are designed to handle unstructured or semi-structured data and provide high scalability and availability. Types of NoSQL databases Some of the main types of NoSQL databases: Document Databases Key-Value Databases Column Databases Graph Databases Object-Oriented Databases Document/Data Stores Document Databases store data […]
Overview In this tutorial, we will learn about popular NoSQL databases. NoSQL, also known as “Not Only SQL”, is a well-known approach to database design. NoSQL databases are not mainly built on relational database tables and do not use SQL to manipulate data. This is where the name NoSQL comes from. However, note that NoSQL […]
Overview In this tutorial, we will learn about database characteristics. DBMS characteristics are as follows: Real-world Entity Relations Isolation Consistency ACID Less Redundancy Query Language Concurrent Access Data Security Real-world Entity The database uses real-world entities to design its architecture. It uses behavior and attributes to model the entities. For example, a university database may […]
Overview A 3-tier architecture is a widely used architecture to design a relational database. It separates its tiers from each other based on the complexity of the users and how they use the data present in the database. 3-Tier Architecture The three tiers are as follows: Presentation Tier Application Tier Database Tier Presentation Tier […]
Overview Let’s learn about different MS Access data types in this tutorial. A database table contains fields or columns that hold the table data. The data type defines the characteristics of the data that the field or column can hold. MS Access Data Types Different types of Access data types are as follows: Text Memo […]