tailieunhanh - UNIT 5. DATABASE MANAGEMENT SYSTEMS LESSON 4. TEXTUAL, RELATIONAL AND XML DATABASESNOTE

Textual or relational database: which choice will better meet our needs? Once you have defined your requirements for document management and delivery, you have to choose the type of database that can meet your needs. To make the right choice, it is useful to understand the basic principles and benefits provided by the two main types of databases: textual and relational. | Information Management Resource Kit Module on Management of Electronic Documents UNIT 5. DATABASE MANAGEMENT SYSTEMS LESSON 4. TEXTUAL RELATIONAL AND XML DATABASES NOTE Please note that this PDF version does not have the interactive features offered through the IMARK courseware such as exercises with feedback pop-ups animations etc. We recommend that you take the lesson using the interactive courseware environment and use the PDF version for printing the lesson and to use as a reference after you have completed the course. FAO 2003 5. Database management systems - 4. Textual relational and xml databases - page 1 Objectives At the end of this lesson you will able to understand the differences between relational and textual databases and understand how XML can be used in a database system. Introduction Textual or relational database which choice will better meet our needs Once you have defined your requirements for document management and delivery you have to choose the type of database that can meet your needs. To make the right choice it is useful to understand the basic principles and benefits provided by the two main types of databases textual and relational. 5. Database management systems - 4. Textual relational and xml databases - page 2 Flat file databases The flat file database can be considered the first basic type of database. A flat file database is a textual file that can be created using a simple text editor. Each information field . title author publisher etc. is separated from others using a delimiter character usually a comma and each record is separated from others using another character or by pressing the ENTER key. XML in Practice Chuck Law 30 01 99 Panda Press 345 Relational Databases Ed Trout 14 03 85 Bross and Smart 267 Object Oriented Technology Eva Good 27 02 95 Panda Press 456 If you use a comma as the separator this is called a CSV file Comma Separated Values . Flat file databases You can also easily create a CSV file using a .