Database Structures Flashcards
What is a flat file?
A flat file is a plain text data file where each line represents a single record, and the fields within the record are typically separated by delimiters like commas or tabs. It lacks structured relationships between records and is commonly used for storing simple data sets.
What are the benefits of using a flat file?
Some benefits of using a flat file include its simplicity in creation, editing, and reading. They are easy to understand by both humans and computer programs. Flat files also serve as a common means of data interchange between different systems or applications, allowing for data import/export and data exchange.
What are the disadvantages of using a flat file?
The disadvantages of using a flat file include the lack of structural organization and relationships found in relational databases. Flat files are not efficient for complex data operations or querying large datasets. They do not offer advanced features like indexing, data integrity constraints, or the ability to perform complex queries using SQL.
What is a relational database?
A relational database is a structured database system based on the relational model. It organizes data into tables consisting of rows and columns, with relationships established through keys. Relational databases use SQL (Structured Query Language) to perform operations, queries, and maintain data integrity.
What are the benefits of using a relational database?
Relational databases offer several benefits, including the ability to establish relationships between tables, ensuring data consistency and integrity. They provide efficient data retrieval and querying capabilities, supporting complex operations and aggregations. Relational databases also offer features like indexing, transaction management, and scalability.
What are the disadvantages of using a relational database?
Some disadvantages of using a relational database include increased complexity compared to flat files, requiring expertise in database design and SQL. Relational databases may have performance issues with extremely large datasets or complex queries. They can also be more resource-intensive and require maintenance and optimization.
What is ANSI/SPARC architecture?
ANSI/SPARC architecture refers to a framework for database systems developed by the American National Standards Institute (ANSI) and the Standards Planning and Requirements Committee (SPARC). It provides guidelines for designing and implementing database management systems, emphasizing the separation of three levels: external, conceptual, and internal.
What is Level 3 ANSI/SPARC?
Level 3 ANSI/SPARC, also known as the physical level, is the lowest level in the ANSI/SPARC architecture. It focuses on the physical storage and access methods of the database, including file organizations, indexes, and data storage structures. This level deals with the physical implementation details of the database system.
