0
What are the advantages and disadvantages of views in a database?
Wiki User
∙ 15y ago
Advantages:
•Data isn't dependent on structure of the database.
•Restrict access to a database.
•Subset of data contained in a table.
•Join and simplify multiple tables into a single virtual table.
•Acts as aggregated tables, where aggregated data (sum, average etc.) are calculated and presented as part of the data.
•Gives real time data.
Disadvantages:
•Rows available through a view are not sorted and are not ordered either.
•Cannot use DML operations on a View.
•When table is dropped view becomes inactive, it depends on the table objects.
•It affects performance, querying from view takes more time than directly querying from the table
Pratyush7
Wiki User
∙ 15y ago
Add your answer:
Earn +20 pts
Advantages and disadvantages Flat file database?
No one knows
Advantages and disadvantages of foxpro?
discuss database and field functions
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
Advantages and disadvantages of relational data model?
Relational database is the database that stores data in the database in the form of table that are related to other tables. RDBMS is one of the most widely used Database.
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).
Explain three disadvantages of centralized database and distributed database?
what are the disadvantages of centralized database system
What are the Advantages and disadvantages of Entity Relationship Model?
Entity-relationship model advantages and disadvantages AdvantagesDisadvantagesConceptual simplicityVisual representationEffective communicationIntegration with the relational database modelLimited constraint representationLimited relationship representationNo representation of data manipulationLoss of information
What are the advantages of centralized database?
advantages of centralize and decentralized database
