0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
Why ERP is a business enabler?
ERP enables the organization to have a centralized data to which anybody within the organization can have access. Thus a centralized data will help the company to pool out the useful information at any moment of time. Moreover data will be arranged in proper order thus reference becomes easy & fast.
What are the problems of managing data in a traditional file environment?
•Data redundancyDifferent systems/programs have separate copies of the same data •Program-data dependence All programs maintain metadata for each file they use •Lack of flexibility Programmers must design their own file formats •Poor security, lack of data-sharing and availability No centralized control of data •Excessive Program Maintenance 80% of of information systems budget
DBMS facilities required for Recovery and back up?
1.The data definition facility or data definition language (DDL). 2.The data manipulation facility or data manipulation language (DML). 3.The data query facility or data query language [DQL]. 4.The data control facility or data control language [DCL]. 5.The transaction control facility or data control language [TCL].
Importance of a database?
the porpose of database is to sstore consistent,standardise data at a centralized place in a secure manner and to facilitatedata sharing among all the applications requiring it.
Advantage of database management system?
One advantage of having a database management system is the fact that it can store a lot of information about customers. Another advantage is the fact that businesses can easily secure these systems while they secure their other systems.
What are the advantage of distributed database over centralized database?
Distributed databases offer advantages such as improved scalability, increased availability, and better fault tolerance compared to centralized databases. They also provide better performance by reducing network latency and enabling data to be processed closer to where it is needed. Additionally, distributed databases can offer better data security by replicating data across multiple locations.
Advantages and disadvantages of centralized database system?
Centralized databases have the advantage of being fast, and easy to manage while information is easy to manage. However, it has its disadvantages as well. All the information must be stored on a server and if that server happens to fail, no one can access the database. Having outside servers can remove this issue.
Advantages and disadvantages of centralized data processing?
Advantages of centralized data processing include easier data management, real-time updates across the organization, and better security through centralized control. Disadvantages may include potential single points of failure, slower processing times due to network traffic, and higher costs for maintaining and scaling centralized infrastructure.
Is data centralized in organizations?
In traditional models of data management, organizations often centralize their data in a single database or data warehouse. This centralization can make it easier to control access, ensure data quality, and perform analytics. However, there is a trend towards more decentralized approaches that distribute data across different systems or use cloud-based storage for increased flexibility and scalability.
How is having a median in math a advantage?
helps show you the skew of data.
Avoid data redundancy?
Centralized control of data by the DBA avoids unnecessary duplication of data and effectively reduces the total amount of data storage required. It also eliminates the extra processing necessary to trace the required data in a large storage of data. Another advantage of avoiding duplication is the elimination of the inconsistencies that tend to be present in redundant data files. Any redundancies that exist in the DBMS are controlled and the system ensures that these multiple copies are consistent.
What are the disadvantages of centralized data processing?
Some disadvantages of centralized data processing include the risk of a single point of failure, as the entire system can be compromised if the centralized data processing center experiences a technical issue or outage. Additionally, centralized data processing may lead to slower response times, as data has to be transmitted back and forth between the center and the various endpoints. There is also concern about data security and privacy, as centralizing data in one location can increase the risk of unauthorized access and breaches.
What are the advantages of metadata?
Metadata provides valuable information about data, such as its source, format, and quality, making it easier to understand and manage. It improves data organization, searchability, and retrieval, leading to increased efficiency in data processing and analysis. Additionally, metadata helps ensure data integrity, consistency, and compliance with regulations.
What are examples of centralized information architectures?
Examples of centralized information architectures include traditional data warehouses, where all data is stored and managed in a central repository. Another example is a centralized content management system, where all digital content is stored and managed in a central location. Additionally, centralized databases, where all data is stored in a single database server, are also common examples of centralized information architectures.
What are the advantages of de-normalized data?
1. We can retrieve the data from tables using less number of joins. 2. The data is more centralized.
What is the difference between a centralized and a decentralized information system?
Centralized Data Processing (CDP) uses Centralised computers, processing, data, control, support. The advantages are Economy for equipment and personnel, Lack of duplication, Ease in enforcing standards, security. In Distributed Data Processing (DDP)Computers are dispersed throughout organisation. Which allows greater flexibility in structure, More redundancy and More autonomy. Hi, Centralized data processing is a Computer data processing architecture where data processing support is provided by one or a cluster of computers, generally a large. dedicated computers, located in a central data processing facility. In a centralized architecture, each person is provided with a local terminal that is connected by a communications facility to the central data processing facility. A fully centralized data processing has following features: 1. Centralized computers 2. Centralized processing 3. Centralized Data 4. Centralized Control 5. Centralized Staff Support A Distributed data processing facility is one in which computers, usually smaller computers, are dispersed throughout the organization. The objective of such disperse is to process information in a way that is most effective based on operational. Therefore, DDP (Distributed Data Processing) features: 1. A collection of terminals link together by some kind of communication link and has no main central computer or not fully (minimal) depend on central computer. 2. Processing of information is happening on each terminal and send results to a main server for store and retrieval purposes. 3. Data may duplicate as data may store in locally or in remote server. 4. Local computer operator can control the machine in his premises. 5. Separate staff will maintain central computer (if there any) where other terminals may control by one or few other members. Hope this will help you! (H.W Thushara Indika from Bandarawela - Sri Lanka)
What is the advantage of having a memory card slot feature?
Memory cards can be used to transfer data instantly from one device to another.
