A database is an organized collection of data. We use specialized software called database-management system (DBMS) to define, create, edit, query, update and share data.
Different DBMSs use standards such as SQL and ODBC or JDBC to communicate. Popular database systems support the relational model, associated with the SQL language.
A relational database is a collection of schemas, tables, queries, reports, views, and other elements.
Some common types of databases include: Hierarchical databases: These databases look like a family tree and were developed in the 1960s. Relational databases: These databases organize data in predefined relationships, with data stored in tables of columns and rows. This makes it easy to see how different data structures relate to each other. Non-relational databases: Also known as NoSQL, these databases can accommodate a wide variety of data models. NoSQL databases are useful for large sets of distributed data. They are optimized for applications that require flexible data models, large data volume, and low latency. Object-oriented databases: These databases can work with complex data objects, which are objects that mirror those used in object-oriented programming languages. Object-oriented databases add the database functionality to object programming languages, creating more manageable code bases.
Related Topics:
SQL Server
Oracle
Join 4M+ learners. Unlock unlimited quizzes, wrong-answer tracking, flashcards + reminders, study guides, and 1-on-1 challenges.