0
What are the similarities between database and file based system?
Yuganthi
These maybe appear to be similar but they have very important differences.
Data Base: It contains a collection of current status of the stored data. The structure is achieved by organising the data according to a data base model. Today, the most common model is the rational model. The most important task of on-line operational database system is to perform on-line transaction and query processing. So, these systems are named Online Transactional Processing (OLTP) systems. Moreover, database system support ad-hoc query and online transaction processing, can be used for other purposes such as data warehousing.
Data Warehouse: Data warehouse is a repository of information collected from multiple sources, such as different databases of a company in different places, which stored under a unified schema, over a history of time. Moreover, it is used for decision support and data analysis. It consists of a process of data cleaning, data integration, data transform, data loading, and data refreshing. Data warehouse is used for Online Analytical Processing (OLAP).
The major difference between OLTP and OLAP are summarised as follows:
OLTP is customer-oriented and it's used by clients, and clerks. But, OLAP is market-oriented and is used for data analysis by managers and analysts.
These have different content too, the first one has current data with detail. Furthermore, is easily used for getting decision; however, another one has large amount of historical data, which provides facilities for summarisation, and store information in different levels of granularity. Because of their huge volume, OLAP data are stored on multiple storage media.
The main similarity is that both of them are repositories of information, storage large amounts of data.
Wiki User
∙ 11y ago
Wiki User
∙ 10y agoThe similarities are:
Database schema may be similar (Primary keys, foreign keys and indexes etc)
SQL (Structures query language is also similar in a way)
Referential integrity is also similar to a great extend)
Add your answer:
Earn +20 pts
A phylum is based on what similarities between animals?
Internal Similarities.
What are the similarities between alphabetical and numeric filing?
Both are systems of filing based on a progressive order from lowest to highest.
Who are the differences and similarities between zero-based budgeting and activity-based budgeting?
Suggest you look at the CIMA website for excellent resource material on budgeting www.cimaglobal.com go to resources and search from there
What are the similarities between the 10 commandments and five pillars of Islam?
Both of them are based on the same principles of praying to one god and not committing sins.
What are the similarities between India and china?
Japan has a very densely populated economy. But China has a higher population. Their population is 1.3 billion I think.
What is database and database system?
A database is essentially an organized collection of data, typically stored electronically on a computer system. Imagine a giant filing cabinet with information neatly sorted and filed away. That's kind of what a database is like, but way more efficient and powerful. Here's a breakdown of the key aspects: Organized Collection: Data isn't just dumped in a pile. It's structured in a specific way, often using tables with rows and columns, to make it easy to find and use the information you need. Electronic Storage: Most databases are digital these days, allowing for much faster access and manipulation of data compared to physical filing systems. Now, to manage this data effectively, you need a database management system (DBMS). Think of it as the filing cabinet manager. A DBMS is a software application that lets you: Interact with the Database: You can create databases, add, update, and delete data, and most importantly, retrieve information you need. Manage Data Structure: The DBMS defines how data is organized and ensures it stays consistent and usable. Control Access: The DBMS controls who can access the data and what they can do with it, keeping things secure. Some common examples of DBMS software include MySQL, Microsoft SQL Server, and Oracle Database. So, the database and DBMS work together to form a database system. The database stores the information, and the DBMS provides the tools to manage and access it effectively. This allows businesses and organizations to keep track of large amounts of data efficiently, from customer information to product inventory.
What is a system based system?
A database system is a term that is typically used to encapsulate the constructs of a data model, database Management system (DBMS) and database .. (natsume)
A phylum is based on what similarities between animals?
Internal Similarities.
What is a data based system?
A database system is a term that is typically used to encapsulate the constructs of a data model, database Management system (DBMS) and database .. (natsume)
What kind of a database management system is Oracle Database?
Oracle database is the first database management system based on the System-R model of IBM and the first relational database that uses SQL. Though it supports various operating systems.
What model was the Relational Database Management System based on?
The Relational Database Management System was based on a good model. It is based on first-order predicate logic which was discovered in 1969 by a man named Codd.
The modern classification system is based on structural similarities and?
Evolutionary Relationship
Is MySQL DBMS or RDBMS?
AnswerMySQL, like most modern Database Management Systems is based on the relational model. So it is a RDBMS (Relational Database Management System).
5 Designed a system of classifying organisms based on their physical and structural similarities?
Linnaeus
What are domains based on?
This system is based on biochemical analysis and comparison of the RNA of organisms and attempts to group them according to those similarities.
What is a paper based database?
One paper-based database I can readily think of is a phone book. Paper based database is database that consists of many papers, not a e-database! Paper-based communicaton is anything written, drawn or printed.
What is the difference between a computerised database and a paper-based database?
Computerised data is on a computer (well yah) and a paper database is on a peice of paper ( XD ). It is also easier with a Computerised database as it is easier!!!!! :D:D:D:D:D
