1) Difference between database and data warehouse:
• Database is used for on-line transactional processing (OLTP) but may also be used for data warehousing
• Data warehouse is designed for on-line analytical processing (OLAP), it reads historical data for the users for business decisions
• In databases the tables and joins are complex since databases are normalized for RDMS (relational data management system), this facilitates in reducing the redundant data and thereby saving the storage space
• In data warehouse the tables and joins are simple as it is de-normalized, in turn facilitates in reduction of response time for doing analysis
• Databases are optimized for write operations whereas data warehouses are optimized for read operations
• Data warehouse includes database in it’s structure
• Data warehouse is used for reporting and data analysis whereas database is organized collection of data and reduces data redundancy
2) How does a database support business intelligence:
• Databases are usually accessed through what's known as a business intelligence (BI) portal, which is simply a user-friendly interface connected to the database. Through the BI portal and its accompanying software tools, analysts perform queries, create reports, analyze data and create forecasts.
• Previously in 1960s data has to be stored on large volumes of magnetic tape and for developing queries to establish correlations was a tedious task and used to take days.
• Databases are OLTP systems that is they used for transaction process and they can be accomplished by using business intelligence and most important thing is various users ranging from Project Managers, developers, or Business Systems Consultants and most important is DBAs need to generate re...
... middle of paper ...
... and expense management and costs $29
For project management – Mindomo, $8/month without any contract
The best CRM tool now a days is Salesforce.com, $65 per user per month
Quickbase – cloud database and it costs $250, fast, reliable, document storage and automated e-mail notifications
Basing on all the above advantages, I use cloud computing for this company.
References:
Management Information Systems – Managing the digital firm by Kenneth. C. Laudon
http://alloraconsulting.com/it-solutions/83-how-to-set-up-a-network-for-small-business-at-low-cost
http://www.iscnetwork.com/network/networkcosts.shtml
http://www.atlantic.net/blog/2013/10/17/byod-changing-technology-workplace/
http://www.superpccare.com/index.php/understanding-components-computer-network/
http://www.isys.ucl.ac.be/vldb04/eProceedings/contents/pdf/PAN2.PDF
Smith, W., & Jewett, D. (2009). Tableau software and teradata database the visual approach to the active data warehouse. In Retrieved from http://www.tableausoftware.com/learn/whitepapers
Databases always used to fascinate me from my under graduation with great curiosity to know how large data is managed and queried. This led me to do Masters in computer science concentrating in the field of Data Management. In the course of my study, I understood the concepts of DBMS which provides a robust and efficient way of managing and mining data. Through the courses like Database Systems (ITCS 6160), Knowledge Discovery in Databases(ITCS 6162) and Knowledge Based Systems(ITCS 6155) I gained enough theoretical and practical knowledge about the importance of proper organization of data, good techniques to build an efficient database management system and how well the data can be managed.
The data warehouse is part of the data provisioning function. It could be described as a big depository. Data warehouse must provide interfaces that accept transaction data from different types of transaction processing systems and move them into the warehouse environment. During this process that data are tested and validated to assure that only high quality data are accepted.
Ans: Data warehouse can be defined as the repository of data. It is a pool of data which helps in decision making. It contains historical data as well as current data. The data usually first structured in a form that can be easily read by analytical processing activities like OLAP, data mining etc. The benefits of data warehouse are: it helps in decision making; it provides the single version of truth though the data is collected from various sources which in turn will help to determine the current state of business and identify problems, enhanced system performance and accessing of data is very simple. As many applications are web based, even the users access data via web and the data from web can be put into the data warehouse; web accessibility is important with data warehouse.
Businesses have data warehouses in place to attain knowledge about latest fads in organization data that affect the business strategically. This type of analysis and reporting is called OLAP: on line analytical processing. Management uses OLAP tools on data warehouse to run reports and make determinations. This would be impossible to do with an operational data store, since operational data store contains data that is only true at the current time. For exam...
A data warehouse can be defined (Section 5.2) as “a pool of data produced to support decision making.” This focuses on the essentials, leaving out characteristics that may vary from one DW to another but are not essential to the basic concept.
In today's fast paced world, data warehouse plays an important role in all sectors including financial, IT, retail and many more. Over the past decade data warehouse has been used to derive business solutions and increase productivity for potential success. After analysing various success factors to define a good solution the main factors noted and discussed in this review are those involving the system process, information quality and organisational impacts. Success of a warehouse architect depends on many organizational factors which include data warehouse, ETL, data modelling, security and business intelligence. By taking into account all these factors
OLAP is used for mainly for analysis. This means that the system copes with any business logic and statistical analysis that is relevant for the application and the user, and keep it easy enough for the target user. This analysis is done in the application’s own engine or in a linked external product such as a spreadsheet. All the required analysis functionality can be provided in an intuitive manner for the target users. This could include specific features like time series analysis, cost allocations, currency translation, goal seeking, ad hoc multidimensional structural changes, non-procedural modeling, exception alerting, data mining and other application dependent features.
A database is a structured collection of data. Data refers to the characteristics of people, things, and events. Oracle stores each data item in its own field. For example, a person's first name, date of birth, and their postal code are each stored in separate fields. The name of a field usually reflects...
OLAP (On-line Analytical Processing): In the OLAP process there is a high level of data transformation and aggregation. This usually consists of complicated formulas and queries to produce the relevant required data. (Data Warehouse, 2009)
A data warehouse comprised of disparate data sources enables the “single version of truth” through shared data repositories and standards and also provides access to the data that will expand frequency and depth of data analysis. Due to these reasons, data warehouse is the foundation for business intelligence.
Prior to the start of the Information Age in the late 20th century, businesses had to collect data from non-automated sources. Businesses then lacked the computing resources necessary to properly analyze the data, and as a result, companies often made business d...
Businesses are driven to be more competitive in their market place and try and do this through collecting and analysing data. Business intelligence systems process historical as well as real-time data to generate information (Bara et al 2009). This allows them to make better decisions and predict market trends (Simmers 2004). A business intelligence system that has been well designed allows the ability to analyse information for achieving...
As Faubl 2011 asserts, databases are mainly created for three core functions; to organize, store, and retrieve information in a more effective and efficient manner possible. Basically, this forms the foundation for the reason and how to use the database. To use database, first need to determine the purpose of the database you are intending to create, then collect and organize the required information, create the logic and physical data models. However, its areas of application are multidisciplinary and cut across various sectors of economic, social and political arenas upon which the three main functions are exercised. These areas of application may include but not limited to; Government to records information such as statistics, election information and tax records among others; Police for criminal records management; Banks to store, track and analyze all customers and their related transactions; Motor vehicle department to keep driver’s and vehicle’s records and history.
In our world, people rely heavily on the power of technology every day. Kids are learning how to operate an iPad before they can even say their first word. School assignments have become virtual, making it possible to do anywhere in the world. We can receive information from across the world in less than a second with the touch of a button. Technology is a big part of our lives, and without it life just becomes a lot harder. Just like our phones have such an importance to us in our daily lives, database management systems are the same for businesses. Without this important software, it would be almost impossible for companies to complete simple daily tasks with such ease.