Explain how databases help ensure that organizations can maintain data integrity.
Databases are usually managed by a database management system (DBMS). Data and DBMS together with related applications are collectively referred to as database systems, often abbreviated as a single database. When a company or organization develops a database, it is the responsibility of the database to store information. Data integrity is part of information security and is achieved when information in a database is complete, accurate, consistent and reliable throughout the information cycle. Database developers determine the accuracy of the design phase using standard procedures and rules. Data integrity is ensured through error checking procedures and other validation methods.
Compare how the data in transactional databases differs from that in data warehouses?
XXXX Warehouses XXX databases are all XXXXXXXX XXXXXXX systems, but XXX produced for XXXXXXXXX purposes. XXXX XXXXXXXXXX are designed XX XXXXX XX XXXX XXXXXXXX of historical data XXX XX allow fast XXX complex requests on XXX data, usually XXXXX XXXXXX XXXXXXXXX (OLAP). X XXXXXXXX is created that XXXXXX current transactions XXX provides ongoing XXXXXXXX XXXXXXXXX, also XXXXX as XXXXXX transaction XXXXXXXXXX, XX XXXXXXX XXXXXX certain XXXXXXXXXXXX. XX XX XXXXXXXXX that XXX transaction database is XXX suitable XXX XXXXXXXX. XXX XXXXXXXXX analysis, datawarehouse XXX XXXXXX. Data XXXXXXXXXX are XXXXXXXXX XX various types: OLAP (XXXXXX Analytical Processing) databases. The XXXX XXXXXXX exists as one level above XXXXXXX database or database (XXXXXXX an XXXX database). XXXXXXXXXXXXXXXXXX data from XXX these databases and XXXXXXX an XXXXXXXXX level of analysis.
What is the relevance XX XXXX XXXXXX in XXXXXXXXXXXXX?
Data Mining is an important process for gaining insight XXXX XXXXXXXX behavior in relation to XXXXX commercial XXXXXXXXX. XXXX XXXXXXXX anonymous XXXXXX that are XXXXXXXXX XXX XXXXXXX. Data XXXXX is XXXXX misunderstood. XXXXXX think it's XXXX computing, but XXXXXXXX it's XXXX more, with sophisticated tools and XXXXXXXXXX. XXdata mining, business organizations can XXXX business XXXXXXXXX more XXXXXXXXXX and XXXXXXXX XXXX profits. XXXX XXXXXXXXX to advertising marketing and introducing XXX products or services, to others. XXXX XXXXXX has XXXXXX XXXX XXXXXXXXX offer XXXXXXXX that XXXX should or should not sell. Medical XXXXXXXXXXX XXX data XXXXXX for vaccines needed for development XX XXXXXXXXX XXX latest XXXXXXX XXXXXXXX. XXXXXXXXXX XXXXXXXXXXX XXXX to XX built XX the road XXX XXXX (Jun XXX, &XXX; Siau, 2001).
Imagine XXXX you XXX hired XX a XXX of a quickly XXXXXXX XXXXXX chain XXXX an XXXXXX XXXXXXXX. You have XXXXXXX XXXXXXXXXXXXX XXXXXXXXX XXX want to XXXXX a business XXXXXXXXXXXX infrastructure. XXX XXXX have XXXXXXX XXXXXXXXXXX within your XXXXXXX with XXXXXXXXX such XX XXXXXXXXX, XXXXXXXX XXXXXXX, accounts payable, XXXXX, and XXXXXXXX XXXXXXXXXX. What XXXXX XXXX proposed business intelligence infrastructure consist XX? Justify XXXX XXXXXXXXX.
Implementing Business XXXXXXXXXXXX Infrastructure (BI) can XX a XXXXXXXX task. The XX XXXXXXX has XXXXXX requirements, conditions and potential difficulties. Although XXX XXXXXXXXXXXX XXXXX a XXXXXXXXXX to assist you in the XXXXXXX, XXXXX are several aspects of the project XXXX your organization XXXXX to XXXXXXXX, and XXXX initial XXXXXXXXXX XXXX XXXX organization XXXXX XX XXXXXXX XXX XXXXXXX successfully. Simply XXX, it's XXXXXX XXXXXXXXXX XX make your XXXXXXXX XXXX in the XXXXX XXXXXXXXX without XXXXXX XXX XXXXX information XX XXXXX XXX XXXXXXXX XXXXXX process. However, it is no XXXXXX just access XX XXXXXXXXXXX, XXX XXXXXXXXX XXXXXX XX XXXX information in XXX XXXX future, which proves to be a difference, XXXXXXXXXX XX we XXXX to XXXX XX with XXX XXXXXXX exchange rates in the conversation. XXX XXXXXXXXXXXXX, XXXXXXXXXX of XXXX, XXXXXXX XXXX a dedicated XX. The XXXXX XXXXXX of action XXXXXXXXX the XXXXXXXXXX XX XXXX, organization XXX XXXXXXXXXX XX XXXXXXXXX information for all interested XXXXXXX. XXXX means moving XXXXXXXXXXX XXX network XXXXXXX, databases XXX XXXXXXX documents that are XXXXXXXXX available in most organizations XX a scalable XXX XXXXXXXXX XX architecture. XXXX XXXXXXXXXX XXX XXXX of manual XXXX XXXXX: XXXXX XXXXXX, lost data. X recent survey of XXXX XXXX X,000 XXXXXXXX executives has shown XXXX BI's XXXXXXX XXXXXXXXXX XXX ‘XXXX quality and XXXXXX data management.’ XXXX XX XXXXXXX most XXXXXXXXX XXXX stacks of XXXX XXXX many sources: XXX, website XXXXXXXX, social XXXXXXXXX XXXXX XXX XXXX XXXXXXXXXX XXXXXXXXXXXXX with customers. XXX challenge is not XX XXXXXXX data, but XX decide XXXX the data really XXXXX. XXXX, a solid XX XXXXXXXXXXXXXX means that it is tailored XX your XXXXXXXX XXXXX XXX XXXXXXXXXX, the difference between XXXX XXXXXXXXXXXXXX XXXX business and XX XXXXX XXXXXXXXX. For example, if the customer experience XX an important XXXXXXXX, BI can help illustrate XXX XXXXXXXX's XXXXXX history XXX XXXXXXXX important points that you XXX likely to miss and XXX XXX XXXXXXXXX and bad XXXXXX XXXXXXXXXXX XX XXXXXXXXX with XXX brand. It can XXXX reveal inefficiencies XXX XXXX XXX XXXX to areas where XX XX XXX achieve XXX so XX can work XX XXXXXXX it (Watson, &XXX; Wixom, XXXX).
References:
XXXXXX, X., Augusto, M., &XXX; Silva, C. (XXXX). XXXXXXXXXXX advantage in e-commerce: the case XX database XXXXXXXXX. In Business, XXXXXXXXX, XXXXXXXXX Sciences, XXX XXXXXXXXXX(XX. XXX-130). XXXXXXXX, Berlin, Heidelberg.
Jun XXX, S., &XXX; Siau, X. (2001). X review XX XXXX mining techniques. Industrial Management &XXX; Data XXXXXXX, XXX(X), XX-46.
Gray, P., & XXXXXX, X. X. (1998). XXXXXXX and XXXXXX XXXXXXXXXX in XXXX XXXXXXXXXXX. XXX XXXXXX Database: the XXXXXXXX XXX XXXXXXXX in Information Systems, 29(X), XX-90.
XXXXXX, X. M., XXXXXX, E., &XXX; XXXXXXX, A. (2006). Business XXXXXXXXXXXX systems in XXX holistic XXXXXXXXXXXXXX XXXXXXXXXXX supporting XXXXXXXX-making in XXXXXXXXXXXXX. XXXXXXXXXXXXXXXXX XXXXXXX of XXXXXXXXXXX, XXXXXXXXX & Management, X.
Watson, X. X., &XXX; XXXXX, B. H. (XXXX). The current state XX XXXXXXXX intelligence. Computer, 40(9), 96-XX.
">