Veritabanları ile ilgili gerek Türkçe, gerek İngilizce olan kaynakların çoğunda, sıklıkla karşılaştığımız veritabanı terimlerinin bir kısmını altta paylaşacağım. Database Systems kitabından çalışmaya devam ettikçe, önemli gördüğüm yerleri böyle sık sık paylaşacağım.
File-based system : A collection of application programs that perform services for the end-users such as the production of reports. Each program defines and manages its own data.
Database : A shared collection of logically related data (and a description of this data), designed to meet the information needs of an organization
Entity : A distinct object in the organization that is to be represented in the database.
Attribute : A property that describes some aspect of the object that we wish to record.
Relationship : Association between several entities.
DBMS : A software system that enables users to define, create, and maintain the database and provides controlled access to this database.
DDL(Data Definition Language) : The DDL is allows to users to specify the data types and structures, and the constraints on the data to be stored in the database.
DML(Data Manipulation Language) : Having a central repository for all data and data descriptions allows the DML to provide a general enquiry facility to this data, called a query language.
Two types of DML : Procedural, non-procedural. The main difference between them is that procedural languages typically manipulate the database record by record, while non-procedural languages operate on sets of records.
Procedural DMLs specify HOW to output of a DML statement is to be obtained.
Non-procedural DMLs describe only WHAT data is to be obtained.(SQL is a non-procedural DML)
Kaynak : Database Systems A practical approach to design, implementation and management, 2th edition