DBMS
Database Applications and the Database System Environment
Where databases are actually used, and what sits inside a running database system: the DBMS software, the stored database, the catalog, the applicatio...
#Beginner
Suitable for beginners.
104 notes tagged
DBMS
Schema, Instance and Metadata
A schema is the design of a database and rarely changes. An instance is the data in it at one moment and changes constantly. Metadata is the stored de...
DBMS
Three Level Architecture and Data Abstraction
The ANSI-SPARC architecture separates a database into external, conceptual and internal levels. That separation is what makes data abstraction and dat...
DBMS
Database Users and the Role of the DBA
A database system serves naive users, application programmers, sophisticated users and specialised users, and is run by a database administrator whose...
DBMS
Advantages and Limitations of a DBMS
A DBMS buys controlled redundancy, enforced integrity, sharing, security, recovery and independence. It charges for them in cost, complexity, hardware...
DBMS
File System versus DBMS
The file based approach fails on redundancy, inconsistency, isolation, atomicity, concurrency, security and integrity. Each failure maps to one specif...
DBMS
What a DBMS Is and Why It Exists
A DBMS is the software layer between users and stored data. It exists to give many users controlled, concurrent, recoverable and consistent access to...
DBMS
Data, Information and Databases
Data is raw recorded fact, information is data placed in context, and a database is an organised, shared, self describing collection of related data...
Java
Map in Java: HashMap, LinkedHashMap and TreeMap
A Map stores key to value pairs with unique keys, and it is the collection you will reach for most often.
Java
Set in Java: HashSet, LinkedHashSet and TreeSet
A Set stores unique elements. The three implementations differ in ordering and in what uniqueness is based on.
Java
List in Java: ArrayList, LinkedList, Vector and Stack
A List keeps insertion order and allows duplicates. ArrayList is the default; LinkedList wins only at the ends.
Java
The Java Collections Framework
A small set of interfaces describes how groups of objects behave, and many implementations trade memory, ordering and speed differently.