Question

In: Computer Science

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

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.


Related Solutions

Explain the similarity and difference between the data update and information currency problems associated with flat files.
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
can someone explain the difference between how Oracle and SQLServer store files.? with steps and examples
2. Combine multiple files Use Python programming to combine two text files: customer-status.txt and sales.txt Data...
2. Combine multiple files Use Python programming to combine two text files: customer-status.txt and sales.txt Data columns in customer-status.txt (separated by comma): Account Number, Name, Status 527099,Sanford and Sons,bronze Data columns in sales.txt (separated by comma): Account Number, Name, SKU, Quantity, Unit Price, Ext Price, Date 163416,Purdy-Kunde,S1-30248,19,65.03,1235.57,2014-03-01 16:07:40 527099,Sanford and Sons,S2-82423,3,76.21,228.63,2014-03-01 17:18:01 After you combine, you will see the following: 527099,Sanford and Sons,S2-82423,3,76.21,228.63,2014-03-01 17:18:01,bronze
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?
Linux Question: you will practice on creating and editing a text file by VI. How to:...
Linux Question: you will practice on creating and editing a text file by VI. How to: Install JDK 1.8 by the following command: $ sudo yum    –y    install    java-1.8.0-openjdk-devel.x86_64 Use VI to create a file “YourFirstNameHomework.java” (e.g., “MollyHomework.java”) and add the following contents into it. (grading details: file name format:10 pts, a screenshot of the file content in the VI environment: 10pts, paragraphs: 10pts, empty lines and indentations: 10, text: 10pts) Here's the code import java.util.Scanner; // Import the Scanner...
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
Code is only reading the last line from the text files. How would I resolve? This...
Code is only reading the last line from the text files. How would I resolve? This is for the Name Search problem in Starting out with Python book. def main(): #open a file for reading infile = open('GirlNames.txt' , 'r') #Read the contents into a list Girls = infile.readlines() #open another file for reading infile = open('BoyNames.txt', 'r') #Read the contents into a lits Boys = infile.readlines() #Get a name to search for Name = input('Enter a name: ') #Determine...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT