What is the advantages and disadvantages of hierarchical database?

Advantages of hierarchical database model?

optical illusion

Disadvantages of Hierarchical database model?

Some disadvantages of the hierarchical database model include complexity in representing certain types of relationships, limited flexibility in querying data due to its rigid structure, and potential data redundancy issues as each child can only have one parent record.

What is central hierarchical database?

Advantages and disadvantages of foxpro?

discuss database and field functions

Advantages and disadvantages Flat file database?

No one knows

Advantages and disadvantages of clustering?

Advantages: • High performance • Large capacity • High availability • Incremental growth Disadvantages: • Complexity • Inability to recover from database corruption

What are the advantages and disadvantages of a computer base database?

if there's a power cut then don't use it

Advantages and disadvantages of lotus notes?

There are many advantages and disadvantages of Lotus Notes. Advantages include the extensive database options that lotus notes has to offer. A disadvantage is it's clunky interface which needs to be modernized.

What are the advantages and disadvantages of using a paper based database?

you could get your head stapled to the paper and will die....

The advantages and disadvantages of using Microsoft Excel Cube Function to extract data from a database?

None

What are the advantages and disadvantages of PHP with mysql?

Ultimately PHP is a programming language and MySQL is a database language. Using PHP with MySQL is a nice combination with built-in support and the simplicity of it all. However, there aren't a lot of disadvantages of using PHP with a database, it just allows for better data organization and whatnot. There are definitely advantages and disadvantages to using a database other than MySQL (such as MongoDB or PostgreSQL).

What are the advantages and disadvantages of hierarchical model databases?

The main advantages of the hierarchical database are:· Performance. Navigating among the records in a hierarchical database is very fast because the parent/child relationships are implemented with pointers from one data record to another. The same is true for the sideways relationships from child to child and parent to parent. Thus, after finding the first record, the program does not have to search an index (or do a table scan) to find the next record. Instead, the application needs only to follow one of the multiple child record pointers, the single sibling record pointer, or the single parent record pointer to get to the "next" record.· Ease of understanding. The organization of the database parallels a corporate organization chart or family tree. As such, it has a familiar "feel" to even nonprogrammers. Moreover, it easily depicts relationships where A is a part of B (as was the case with the order database we discussed, where each item was a part of an order).The main disadvantage of the hierarchical database is its rigid structure. If you want to add a field to a table, the database management system must create a new table for the larger records. Unlike an SQL database, the hierarchical model has no ALTER TABLE command. Moreover, if you want to add a new relationship, you will have to build a new and possibly redundant database structure.