Databazën

Databazën is the Albanian term for a database, a structured collection of data stored electronically to support information retrieval, management, and analysis.

A database is organized to enable efficient storage and updates. It typically includes a database schema that defines tables, fields, constraints, and relationships. Data are managed by a database management system (DBMS), which provides an interface for creating, querying, updating, and administering the data. Databases come in various models, with relational databases using tables and SQL as a primary query language, while NoSQL databases use document stores, key-value stores, column-family stores, or graphs.

Key properties include ACID (atomicity, consistency, isolation, durability) in traditional relational systems, ensuring reliable transactions, and BASE in some NoSQL systems that trade strict consistency for scalability. They support indexing for fast lookup, transactions, backups, replication, and security controls. Data integrity is maintained through constraints, normalization (to reduce redundancy) and, in some cases, denormalization for performance.

Applications span business analytics, content management, finance, science, and government. Developers interact with databases via query languages, APIs, or object-relational mappings. Design considerations include choice of model, capacity planning, performance tuning, data governance, privacy, and compliance with regulations.

Historically, relational databases emerged in the 1970s and were popularized by SQL; modern systems also include distributed and open-source platforms. The term databazën thus encompasses both traditional relational databases and newer data stores used in software systems today.