Databases Benefits And Limitations Of Term Paper

PAGES
1
WORDS
355
Cite
Related Topics:

Databases

Benefits and Limitations of Database Capabilities of Desktop vs. Enterprise DBMS Systems

The use of databases has become pervasive in personal productivity applications including Microsoft Excel and Access, in addition to being supported in open source applications including StarOffice. There are also enterprise-class database management systems (DBMS) that are used for synchronizing the many functions within a company, from coordinating supply chain partners through running factories with ERP systems to supporting customers (O'Leary, 2008). The intent of this paper is to discuss the relative benefits and limitations of each of these types of databases.

Personal productivity databases including Microsoft Access and Excel rely on the standardized graphical interface conventions of Microsoft Office applications and as a result are often easier to use and learn. These applications are often bundled into application suites, making them the least expensive to use. Another benefit is the ability to quickly share databases across users who also have the Microsoft Office suite of applications as well. The limitations of these applications are that they do not integrate easily into real-time process workflows and enterprise systems essential for keeping an enterprise operating (O'Leary, 2008). These personal productivity systems also tend to be islands of customer data that need to be integrated into larger customer information systems to be effective (Zahay, 2008). Enterprise-class DBMS are capable of integrating to broader process workflows due to their underlying technical design. In addition, these DBMS are often used for more advanced customer strategies including data mining, business analytics of customer bases, and the development of long-term loyalty campaigns. All of these types of analysis are not possible on the personal productivity class of databases. The limitations of enterprise DBMS however are the their cost for implementing in larger companies, and the need for training users how to use the many functions in these databases.

References

Daniel E. O'Leary (2008). Supporting decisions in real-time enterprises: autonomic supply chain systems. Information Systems and eBusiness Management, 6(3), 239-255. Retrieved May 8, 2008, from ABI/INFORM Global database. (Document ID: 1475085461).

Debra Zahay (2008). Successful B2B customer database management. The Journal of Business & Industrial Marketing, 23(4), 264-272. Retrieved May 8, 2008, from ABI/INFORM Global database. (Document ID: 1464150941).

Cite this Document:

"Databases Benefits And Limitations Of" (2008, May 09) Retrieved April 25, 2024, from
https://www.paperdue.com/essay/databases-benefits-and-limitations-of-29972

"Databases Benefits And Limitations Of" 09 May 2008. Web.25 April. 2024. <
https://www.paperdue.com/essay/databases-benefits-and-limitations-of-29972>

"Databases Benefits And Limitations Of", 09 May 2008, Accessed.25 April. 2024,
https://www.paperdue.com/essay/databases-benefits-and-limitations-of-29972

Related Documents

Databases and Regulatory Compliance Challenges The advent of technology has increased the popularity of database usage in firms, yet the legislation regulating the field has yet to be finalized. The changing nature of the IT sector, coupled with the legislative traits, creates several situations in which the companies find it difficult to comply with the regulations. This paper recognizes some of those difficulties, and also proposes some solutions. Databases Regulatory challenges for databases No

Database marketing, sales force automation and virtual reality are three of the newest trends in technology to impact the way company's market to their customers. All three technologies offer specific advantages and disadvantages for their use. The appropriate use of the technology must be based solidly on the type of product, costs incurred, and the nature of relationship with clients. When used in a judicious way, all three technologies can

This would also mean that the shadowing process goes on behind the scenes, and one need not even be aware that the process is in fact going on at any point of time; it can go on without creating any sort of disturbance to the user of the application, at any point of time. (Shadow Files) Another important advantage of using the shadowing of a database is that data would

Oracle supports stored programs such as stored procedures and packages. This enables the developers to centralize application logic in the database. Oracle provides powerful functions and sub-queries in its SQL statements. Developers can distribute systems by database links, materialized views and distributed queries. This feature saves much cost for developing distributed systems and applications. And there's a lot of features integrated with Oracle, compare to other database it is

These laws also emphasize that obtaining such personal information and how it will be used should be made with the individual's knowledge and consent. Moreover, individuals also have the additional rights of viewing, correcting, and deleting the information pertaining to them. But do we really have access to all information that is being taken from us? We can never tell and we might end waking up one day being

Integration in the CI/HUMINT Community An Analysis of the Benefits of Integration in the CI/HUMINT Community and Strategies for Effective Implementation Shea Larson The success of any counterinsurgency operation depends largely on the effectiveness and appropriateness of intelligence gathered. Human subjects are a crucial source of intelligence for counterinsurgency operations. Several years back, the U.S. Armed Forces opened up opportunities for women to occupy specific positions in counterintelligence/human intelligence (CI/HUMINT) discipline. However,