0
What else can I help you with?
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.
How do databases management system overcome the problem associated with data redundancy?
Database Management Systems (DBMS) overcome data redundancy by implementing normalization, which organizes data into tables to minimize duplication. Additionally, they use relationships between tables, allowing data to be stored in one location and referenced as needed, rather than being repeated. This centralized approach not only reduces redundancy but also enhances data integrity and consistency across the database. Furthermore, DBMS often incorporate constraints and rules to enforce data uniqueness and prevent duplicate entries.
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.
What are the advantages of centralized database?
Centralized databases offer simplified data management, easier maintenance, and increased data consistency due to a single point of control. They also provide better security measures by having a centralized system for monitoring and implementing security protocols. Additionally, centralized databases promote better scalability and efficiency in handling large volumes of data.
Advantages and disadvantages of centralized data processing?
With centralized data processing, one advantage is that you can control all the processing for your business from one location. If you're working on a terminal and it goes down, you can log into another one and keep working. On the other hand, if the central computer goes down, no work can be done on any of the terminals. This is the biggest disadvantage.
What are the advantage of distributed database over centralized database?
The database can be of two types either distributed or centralized . In distributed database the data is in different systems. In centralized database the data is in a single central system.We can categorize database as either distributed or centralized . In centralized database the data is in a single centralized system. While In distributed database the data is in different systems .
How is having a median in math a advantage?
helps show you the skew of data.
Is data centralized in organizations?
Often. Centralized data today is usually considered centralized electronic databases instead of filing cabinets with records. The opposite to centralized data, is compartmentalized. Business organization take advantage of centralized data bases to perform statistical analysis accross divisions. I will give you an example. One division of a computer company might sell printers, and another hard drives. By having a central database, all purchases by the same customers can be compared. Compartmentalized data storage is done usually for security reasons. Two examples are patient records in hospitals and military security. Separate computer installations and established protocols for what information can be accessed by whom are necessary. In the media it has been reported that credit card databases have been entered and many records copied. It is one area where there are pros and cons of centralized data bases, which serves both marketing needs and verifies transactions. There are also pros and cons of centralized police records, which may contain incorrect information, and are easily accessible.
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?
A centralized database is one in which all the data of an organization is stored in a single mainframe computer. One disadvantage of this database is that if the centralized database is corrupted, all the data will be lost.
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.
