Concurrency in a Database is a procedure of managing simultaneous operations without conflicting with each other. A database transaction symbolizes a unit of work performed within a database management system against a database. Hashing in a Database Management System is a procedural approach applied to rationally find the position of the required data. Indexing is a way of optimizing the performance of a database by minimizing the number of disk accesses required when a query is processed. Indexing, Hashing, Transaction & Concurrency.A NoSQL database provides a mechanism for storage and retrieval of data that is modeled in means other than the tabular relations used in relational databases. SQL is a domain-specific language that lets you access and manipulate databases. Joins combine data from multiple tables in relational databases. Normalization is the process of organizing data in a database to reduce data redundancy and eliminate undesirable characteristics like Insertion, Update, and Deletion Anomalies. The Relational Model represents how data is stored in Relational Databases and the Entity-Relationship Model defines the conceptual view of a database. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |