Explain the process of creating flat (text) files and how to store/retrieve data.

Solutions

Expert Solution

Flat (text) files

A flat file, also known as text database, is a type of database that stores data in plain text format. Flat file databases were developed and implemented in early 1970s by IBM.

Flat files typically text files that have all word processing and structure markup removed. A flat file features a table with a single record per line. The different columns in record use a tab or comma to delimit the fields. The flat file database does not have multiple tables, unlike in relational database. The information contained in flat files does not have associated paths or folders.

Store/retrieve data

Each column in flat file database is restricted to a specific data type. The delimiters are used to keep the data formatting at fixed width, and to make it easier to find different fields within a record.

The first row in flat file refers to the field name – which makes it easier to determine what data is dealt with in each field. All rows in the flat file database follow tuple concept in relational algebra, where tuples are an ordered list of elements.

Data in flat files remains in its original form until it is transferred into a staging area in a warehouse or a database management system. After transmission is complete, the data is altered and saved in different forms.

venereology answered 10 months ago

Next > < Previous

Related Solutions

Explain the similarity and difference between the data update and information currency problems associated with flat files.

coding the following project: Setting up structures to store and retrieve data. A major requirement of...

coding the following project: Setting up structures to store and retrieve data. A major requirement of virtually all projects in the financial world involves the storage and retrieval of data. project must be properly modularized and allow for more than one way to store the data to satisfy the various needs of clients.The first manner is by storing data using hashtables (or hash maps) as the basis of storing and retrieving data.

can someone explain the difference between how Oracle and SQLServer store files.? with steps and examples

need it as copy text Explain the digital integrated-circuit design process and how it is applied...

need it as copy text Explain the digital integrated-circuit design process and how it is applied to micro architectures, available design methods and tools?

1. Explain the process of creating a significance test. 2. How do confidence intervals and significance...

1. Explain the process of creating a significance test. 2. How do confidence intervals and significance tests relate? 3. When do you use a matched-pairs t-test?

Discuss the issues involved in sorting large data files. Explain how indexing is used to overcome...

Discuss the issues involved in sorting large data files. Explain how indexing is used to overcome this issue. Explain the difference between physical order and logical order

How to read a text file and store the elements into a linked list in java?...

How to read a text file and store the elements into a linked list in java? Example of a text file: CS100, Intro to CS, John Smith, 37, 100.00 CS200, Java Programming, Susan Smith, 35, 200.00 CS300, Data Structures, Ahmed Suad, 41, 150.50 CS400, Analysis of Algorithms, Yapsiong Chen, 70, 220.50 and print them out in this format: Course: CS100 Title: Intro to CS Author: Name = John Smith, Age = 37 Price: 100.0. And also to print out the...

Data Engineers regularly collect, process and store data. In this task you will develop a deeper...

Data Engineers regularly collect, process and store data. In this task you will develop a deeper understanding of how C programming language can be used for collecting, processing and storing data. In this assignment you get the opportunity to build an interactive program that can manage the list of flights departing Sydney Airport. The list is stored as an array of flight_t type structures flight_t flights [MAX_NUM_FLIGHTS]; The flight_t is a structure typedef for struct flight. The struct flight contains...

QUESTION 17 The process of creating a linear model of bivariate data. a. Least Squares Regression...

QUESTION 17 The process of creating a linear model of bivariate data. a. Least Squares Regression b. Variability c. Extrapolation d. Residual analysis QUESTION 18 The "Portion of Variability" is also known as the a. Correlation coefficient b. Regression line c. Fitted Value d. Coefficient of determination QUESTION 19 Linear regression models may not always acccurately reflect the pattern of data from which they are made a. TRUE b. FALSE QUESTION 20 The following data relates the time a student...

1. Explain the process of creating a significance test. 2. What is the difference between a...

1. Explain the process of creating a significance test. 2. What is the difference between a z-distribution and a t-distribution? When would you use each of them. 3. How do confidence intervals and significance tests relate? 4. What does having the value of zero contained in a confidence interval for a difference tell you? 5. When do you use a matched-pairs t-test?

Subjects