Use our essay title generator to get ideas and recommendations instantly
Data Warehouse technology has changed the way that global organizations conduct business. Many have found it impossible to create a business strategy without a data warehouse. The purpose of this discussion is to research and explain the importance of data warehouse management.
We will begin by defining data warehouse and describing the business uses for the technology. Our discussion will then focus of data warehouse management. We will examine the three components of data warehouse management. In addition, we will discuss the assurance of safety and privacy which are needed to maintain the integrity of the data warehouse. Our discussion will also focus on the availability and reliability of the data warehouse. We will also investigate different management tools that are used to maintain the data warehouse.
Definition of Data Warehouse is defined as "A Database system containing large amounts of data that uses sophisticated software optimized for…
Barker, Richard. (1998). "Managing and Data Warehouse." Veritas Software Corporation. http://www.keltec.co.uk/whitepaper/manage_datawarehouse.pdf
Compact American Dictionary of Computer Words. (1998) Houghton Mifflin Company
Data Warehousing." (2003). Information Builders. http://www.informationbuilders.com/definition/data-warehousing.html
The Quality Data Warehouse. (1999). SAS Institute. White Papers.
because the system is designed to be able to handle complex queries for information much faster than are traditional databases, designing and implementing such an attack becomes more difficult and complex (Warigon, 1997). At the same time, the ease with which information in a data warehouse can be manipulated creates more significant problems than a traditional database should unauthorized access be obtained (TechFaq, 2010). While no database or information system could possibly have all necessary security precautions embedded within the structure of its basic operations -- i.e. storing, classifying/analyzing, and retrieving data -- as it is simply not in the nature of an information system to provide such security, data warehouses are at a special level of risk due to the organization of data and the speed at which it is processed (TechFaq, 2010; Warigon, 1997).
Building effective security for a data warehouse can occur in a multitude of ways…
Nishith. (2005). Database vs. data warehouse. Accessed 19 December 2011. http://opensourceanalytics.com/2005/11/02/database-vs.-data-warehouse/
TechFaq. (2010). Data warehouse. Accessed 19 December 2011. http://www.tech-faq.com/data-warehouse.html
Warigon, S. (1997). Data warehouse control and security. Accessed 19 December 2011. http://all.net/books/audit/kits/dw.html
In addition, the support of multiple taxonomies is also critical for a data warehouse, and to the extent the architects have created a database architecture that will provide for metadata definition and re-defining of taxonomies is the extent to which the data warehouse will have greater use in the organization. Without a strong focus on these aspects of data agility, a data warehouse can quickly become outmoded and only marginally successful.
Assume that you are the data quality expert on the data warehouse project team for a large financial institution with many legacy systems dating back to the 1970s. Review the types of data quality problems you are likely to have and make suggestions on how to deal with those.
There are going to be a myriad of data quality problems inherent in managing the data quality inconsistencies with legacy systems dating back from the 1970s. Most significant and potentially…
Since poor data quality within a system often results in poor business decisions being made from this data, it is very important that each administrator or system architect look at each customer or end-user differently, in their own unique light. Since each end-user is different, and the needs of the customer often stem from the warehouse's ability to accurately store quality information, a system that dates back to the 1970's will likely have quite a few issues relative to functionality and compatibility with modern data warehousing and information delivery systems. A data warehouse will become obsolete if customers and end-users cannot trust that the data being stored is not "dirty." It is therefore important to start with the assumption that the data stored within a warehouse that leads back to legacy systems from the 1970's is corrupt.
It is also necessary, in these early stages, to ascertain the level of…
Data Warehousing and Mobile Computing
In the contemporary competitive environment, organizations are being forced to collect, store and analyze a large volume of data to make an analytical decision. However, business executives are faced with the time constraints when analyzing data, thus, data warehousing over the mobile computing have come into existing to assist in analyzing data quickly anywhere to assist in enhancing an effective timely decision. The study presents the literature reviews on the application of the data warehousing over the mobile computing. The study reveals that as firms are increasingly doing their businesses online, thus, storing and accessing data over the mobile devices are becoming a necessity. With the growth of the powerful laptop and internet, it is now possible to store a large volume of data in the mobile devices and cloud computing.
Data warehousing is defined as the database system that organizations use for reporting…
Bakar, M.S.A., & Ta's, A. (2012). Data Warehouse Design for Mobile Environment. Knowledge Management International Conference (KMICe), 4(6): 208-212.
Gaspar, V., Madarasz, L., Paralic, J., & Tenaiova, K. (2011). Design and implementation of a client warehouse application over an enterprise resource planning system for mobile devices. Paper presented at the Logistics and Industrial Informatics (LINDI), 2011 3rd IEEE International Symposium.
Golfarelli, M., & Rizzi, S. (2009). Survey Article A Survey on Temporal Data Warehousing. International Journal of Data Warehousing and Mining, 5 (1): 1-17.
Stanoi, I., Agrawal, D., Abbadi, A.E., et al. (1999). Data warehousing alternatives for mobile environments. Mobide '99 Proceedings of the 1st ACM international workshop on Data engineering for wireless and mobile access: 110-115.
All of these factors combined to form the catalyst of the data warehouse project being made a higher priority than the many other competing projects within Wal-mart at the time.
At a cost of approximately $3M in software and $9M in services and training, Wal-Mart partnered with Hewlett-Packard and became one of the first companies to adopt the HP Neoview data warehousing system. One of the key reasons for Wal-Mart choosing the HP Neoview data warehousing system was its high level of compatibility with their existing investments in the Teradata databases, which were used as the foundation of their Business Intelligence applications. Wal-Mart also wanted to create a more consistent integration platform to support their etail Link system so that the FID data could be used for calculating the OI of partner investments in the technology.
Lastly, HP Neoview runs on the existing Tandem NonStop operating system and kernel platform…
Mike Duff. "SUPERMARKETS & SUPERCENTERS: CAN THEY REALLY COEXIST? " Retailing Today 26 May 2008: 14. ABI/INFORM Global. ProQuest. 3 Jul. 2008
Paul Sheldon Foote, Malini Krishnamurthi. "Forecasting using data warehousing model: Wal-Mart's experience. " the Journal of Business Forecasting Methods & Systems 20.3 (2001): 13-17. ABI/INFORM Global. ProQuest.. 1 Jul. 2008
Heather Havenstein. "Wal-Mart Turns to HP for Data Warehouse Update. " Computerworld 6 Aug. 2007: 14. ABI/INFORM Global. ProQuest. 3 Jul. 2008
Jianfeng Wang. "ECONOMIES of it SYSTEMS at WAL-MART - an HISTORICAL PERSPECTIVE. " Academy of Information and Management Sciences Journal 9.1 (2006): 45-66. ABI/INFORM Global. ProQuest. 5 Jul. 2008
The data load for CRM systems is less significant than those of Accounting and Financial systems and applications. Those specific fields captured by customers are often compressed into measures of activity as well, and as a result the data load is less significant than in the areas of Accounting and Financial Systems and Reservation and Booking Systems. Even when customized reports are created based on CRM data; the data load is not nearly as significant in Accounting and Financial Systems. The refresh cycles of data in CRM applications however can be quite significant as customer records need to be continually accessed and used for serving customers flying each day and those planning to take flights in the future. As a result, the refresh cycles of customer records, depending on the specific process, are often required to be in real-time. These specific processes include award travel, free upgrades during check-in, seating…
How Businesses use Data Warehousing
Data warehousing is a technological way for businesses to align data with performance benchmarks so that organizations can obtain a long-range view of aggregated data and engage in complex analytics. These analytics typically give the organization a better understanding of what its stockpile of information means, what data trends over time reveal, and what the data indicates is in store for the business in the future. This paper will provide a description of data warehousing, examples of how it is used in a business, challenges that an organization might face when utilizing a data warehouse (i.e., how it can be implemented and what type of training is required to run it), how data warehousing may change in the next five years, and what organizational leaders can do to be prepared.
What is a Data Warehouse?
A data warehouse is a digital storage…
Bhat, P., & Bose, A. (2018). Application of Information System in Amazon: Issue and Prespectives. International Journal, 6(1), 23-29.
Chen, H. M., Schütz, R., Kazman, R., & Matthes, F. (2016). Amazon in the air: Innovating with big data at Lufthansa. In System Sciences (HICSS), 2016 49th Hawaii International Conference on (pp. 5096-5105). IEEE.
Debortoli, S., Müller, O., & vom Brocke, J. (2014). Comparing business intelligence and big data skills. Business & Information Systems Engineering, 6(5), 289-300.
Gupta, A., Yang, F., Govig, J., Kirsch, A., Chan, K., Lai, K., ... & Bhansali, S. (2016). Mesa: a geo-replicated online data warehouse for Google\\\\'s advertising system. Communications of the ACM, 59(7), 117-125.
Rainer, R. & Cegielski, C. (2012). Introduction to Information Systems: Enabling and Transforming Business, 4th Edition. NY: Wiley.
Information management is essential for FedEx. The company uses information in a number of ways. On the operations side, data drives decisions regarding the scheduling of assets. Every piece has its own delivery time guarantee, for example, and it is necessary to use information to ensure that the right piece gets on the right plane and right truck to reach its destination. How this works is as follows.
The customer goes online and schedules a pickup, and the automated system plugs that information directly to the courier who works that route. The package is scanned at pickup. The tracking number of the basis for information on that package -- the person at the destination can see within minutes that the package has been picked up. From there, the package is scanned at the local depot, when it goes on the plane, when it lands at the hub, when it…
Cardon, D. (2016). Database vs. data warehouse. Health Catalyst. Retrieved April 30, 2016 from https://www.healthcatalyst.com/database-vs.-data-warehouse-a-comparative-review
Standen, J. (2012). Data warehouse vs. data mart. Datamartist. Retrieved April 30, 2016 from http://www.datamartist.com/data-warehouse-vs.-data-mart
Data Warehousing and Mobile Computing
Walmart is the largest company in the world with the estimated one million customers every hour and more than 100 million customers every week. A large number of customer and gigantic supply chain make the company start using the FID system to track moving items and manage the supply chains. However, the FID produces gigantic datasets, which may be challenging to store in the relational database. To address this problem, Walmart develops the data warehousing to store the data, and the company derives cost benefits and data security benefits by transferring the data into the data warehousing. However, Walmart datasets continue to grow, and at present the data has reached 101 terabytes. A change in the business environment makes Walmart make a decision to transfer their data into the cloud. In the present competitive business environment, retail companies are looking for the strategies to cut…
Dabas, C. (2010). A Cloud Computing Architecture Framework for Scalable RFID. Proceeding of the International Multi-Conference of Engineers and Computer Scientists. 1. IMECS.
Foote, P.S. & Malini, K. (2001). Forecasting using data warehousing model: Walmart's experience. The Journal of Business Forecasting Methods & Systems.20(3): 13-17.
Jamal, S.M.K. Omer, A. & Qureshi, A.B.S. (2013). Cloud Computing Solution and Services for RFID-Based Supply Chain Management. Advances in Internet of Things, 3:79-85.
Napper, J. & Bientinesi, P. (2009). Can Cloud Computing reach the top 500? UCHPC -- MAN '09. Proceedings of the Combined Workshops on Unconventional High-Performance Computing Workshops Plus Memory Access Workshop: 17-20.
Database Data Warehousing Design
Data warehousing is a powerful tool that business organizations use to enhance competitive advantages. Data warehousing supports business decision by collecting, organizing and consolidating data for analysis and reporting using tools such as OLAP (online analytical processing ) and data mining. Typically, the relational database technology is generally being used to design a data warehousing and a relational database is a database having collection of tables, and organized based on the relational model. One of the main goals of business organizations is to use data to leverage their strategic competitive advantages. Typically, the data warehousing has become a strategic priority because of the enormous amount of data that organizations need to analyze. Using a relational database, organizations have been able to develop a data warehousing that could assist management to make effective decision. (Microsoft, 2012).
Fundamental objective of this paper is to design the data warehousing…
Microsoft (2012).Data Warehousing | Microsoft SQL Server 2012. Microsoft Corp.
Tera Data (2012).Enterprise Data Warehouse - Global Leader in Data Warehousing . Tera Data Inc.
Appendix 1: ERD for Database Data Warehousing
At times, though, data mining and data warehousing can become more trouble than they are actually worth, and that can lead to all types of problems for a company (Thearling, 2009).
In order to make sure that data mining and warehousing do not become too much trouble for a company to handle, it is vital that the company is clear on the data it wishes to collect. There is no reason to collect every single scrap of data from every person who uses the company's website or searches the internet for the product or service that the company offers. Basic demographic information that relates to the company's product or service, or that relates to the creation of a target market segment, is all very important (Greenfield, 2005a. There are many other data markers that are outliers, however, and that will not have any effect on whether a person would use…
Betancourt, L. (2010). How Companies are using your Social Media Data, Retrieved on July 26, 2010 from http://www.enterpriseirregulars.com/5706/the-top-10-trends-for-2010-in-analytics-business-intelligence-and-performance-management /
Greenfield, L. (2005a) The Case for Data Warehousing Retrieved on July 26, 2010 from http://www.dwinfocenter.org/casefor.html
Greenfield, L. (2005b) The Case Against Data Warehousing Retrieved on July 26, 2010 from http://www.dwinfocenter.org/against.html
Hadfield, M. (2009) Case Study: Jaeger uses data mining to reduce losses from crime and waste Retrieved on July 26, 2010 from http://www.computerweekly.com/Articles/2009/02/23/234953/case-study-jaeger-uses-data-mining-to-reduce-losses-from-crime-and.htm
It is important to realize that the level of technology investment at present is sufficient for the current project; this proposal does not necessarily advocate any additional spending on pure technology.
What this analysis pinpoints as a major area of concern is the slow and very gradual transformation of FAC when it needs to move much faster towards its customer goals. The lack of speed and urgency in the shift can be partially attributed to the lack of cohesion and consistency of overall IT strategies to support the next generation of CM business strategies. At present the IT systems and platforms are sufficient yet they will need to change over time to stay current. Figure 1 illustrates how the ETL structure exists today at FAC, highlighting the role of the data warehouse. FAC will need to streamline this architecture if they are going to continually improve.
Figure 1: Topology of…
Bernoff, J., & Li, C. (2008). Harnessing the power of the oh-so-social web. MIT Sloan Management Review, 49(3), 36-42.
Chan, J.O. (2005). Toward a unified view of customer relationship management. Journal of American Academy of Business, Cambridge, 6(1), 32-38.
Cunningham, C., Il-Yeol Song, & Chen, P.P. (2006). Data warehouse design to support customer relationship management analyses. Journal of Database Management, 17(2), 62-84.
Dver, A. (2003). The future of CRM technology. Information Management, 13(7), 22-22.
Sports Line.com, founded in 1994, is the Internet's leading website in Sports media and e-commerce related to sporting goods products. The content of the website includes one million pages of sports related news, information, merchandise, magazine subscriptions and other services. The site also produces the content for major league baseball, the European NFL league and the PGA tour. In addition it provides sports news for many of the major Internet Service Providers including Netzero, America Online, Excite and Netscape. (About Sportsline.com)
Much of the company's success is due to the integration of data warehousing and database marketing into its' e-business solution. The company uses this technology to achieve the following; manage enormous amounts of data, refine their systems to keep up with the rapidly emerging Internet, incorporate data from various sources and analyze incoming data in real time. (Matrix) This allows Sportsline.com to store important data such as customer names,…
About Sportsline.com. http://about.sportsline.com/releases/freefant.htm
Mollison, Caitlin. "A WebSideStory-CBS SportsLine.com." Business Intelligence News. February 19, 2002.
Sportsline.com Has Record Quarter For Page Views." PR News. January 8, 2001. http://www.findarticles.com/cf_0/m4PRN/2001_Jan_8/68856523/p1/article.jhtml?term=sportsline+database+warehousing
Data Warehousing: A Strategic Weapon of an Organization.
Within Chapter One, an introduction to the study will be provided. Initially, the overall aims of the research proposal will be discussed. This will be followed by a presentation of the overall objectives of the study will be delineated. After this, the significance of the research will be discussed, including a justification and rationale for the investigation.
The aims of the study are to further establish the degree to which data warehousing has been used by organizations in achieving greater competitive advantage within the industries and markets in which they operate. In a recent report in the Harvard Business eview (2003), it was suggested that companies faced with the harsh realities of the current economy want to have a better sense of how they are performing. With growing volumes of data available and increased efforts to transform that data into meaningful knowledge…
Agosta, L. (2003). Ask the Expert. Harvard Business Review, 81(6), 1.
Database: Business Source Premier.
Babcock, Charles (1995). Slice, dice & deliver. Computerworld, 29, 46, 129 -132.
Beitler, S.S., & Lean, R. (1997). Sears' EPIC Transformation: Converting from Mainframe Legacy Systems to Online Analytical Processing (OLAP). Journal of Data Warehousing (2:2), 5-16.
From Supply Chain Efficiency to Customer Segmentation Focus
Because of this focus on supply chain forecasting accuracy and efficiency, the need for capturing very specific customer data becomes critical. The case study portrays the capturing of segmentation data as focused on growing each of the brands mentioned that VF relies on this data to base marketing, location development and store introductions, and pricing strategies on. In reality, the data delivered for these marketing programs and location-based analyses is also providing an agile and scalable platform for VF to more effectively manage and mitigate its supply chain risk as well.
elying on Alteryx for data analysis as it has superior capability to Microsoft Access and Excel in conjunction with the use of SC Software for geo-demographic analysis, VF has created a workflow for translating data warehouses into the basis of marketing and supply chain strategies. The strategic goal of getting the…
Adnan, M., Longley, P., Singleton, a., & Brunsdon, C. (2010). Towards Real-Time Geodemographics: Clustering Algorithm Performance for Large Multidimensional Spatial Databases. Transactions in GIS, 14(3), 283-297.
Paul Sheldon Foote, & Malini Krishnamurthi. (2001). Forecasting using data warehousing model: Wal-Mart's experience. The Journal of Business Forecasting Methods & Systems, 20(3), 13-17.
Yang-Im Lee, & Peter R.J. Trim. (2006). Retail marketing strategy: The role of marketing intelligence, relationship marketing and trust. Marketing Intelligence & Planning, 24(7), 730-745.
Lewis, M., Hornyak, R., Patnayakuni, R., & Rai, a.. (2008). Business Network Agility for Global Demand-Supply Synchronization: A Comparative Case Study in the Apparel Industry. Journal of Global Information Technology Management, 11(2), 5-29.
However, many, if not most data warehouses have yet to deal effectively with this very real problem.
Additionally, in the near future new parallel database servers are likely to improve the power of data warehousing exponentially.
Not only will these servers allow the user to access immense pools of data, but they will also allow them to do so in a fraction of the time (ICFAI, 2004).
Finally, it is also very likely that in the near future the very "number driven" data warehouses (numbers being the de facto definition of data), may become capable of "recognizing" text and even multi-media as data (Orr, 2000). Clearly, the implications of this are enormous -- both theoretically, as well as in the practical realm.
Data warehouses are without question one of the most powerful technologies to impact the world of data management. The simple fact is that knowledge is power --…
Adamson, Christopher. (1998). "Data Warehouse Design Solutions." Wiley: New York.
CIOL. Staff. (2001). "Quantifying the Effects of a Data Warehouse." Web site. Retrieved from Web site on March 24, 2005, from, http://www.ciol.com
Dwinforcenter.org. (2005). "Getting Started with Learning About Data Warehousing" Web site. Retrieved from Web site on March 24, 2005, from, http://www.dwinfocenter.org/getstart.html
Greenspun, Phillip. (2004). "Data Warehousing." Web site. Retrieved from Web site on March 24, 2005, from, http://philip.greenspun.com/sql/data-warehousing.html
Indeed, with 5000 customers, the company is now on the cusp of taking on larger market proportions and should seize the opportunity accordingly.
The sensible approach to this would be the adoption of a Universal Data Architecture. By combining the principles of warehousing and data mart presentation, the organization can create a body of information which is continually growing and a forum for quick and useful analytical examination.
here data warehousing is concerned, it important for an organization to be possessed in the knowledge of its core clientele. By maintaining a database, the hardware store can consider such options as a regular mailings to loyal customers, the distribution of coupons and other schemes aimed at targeting those with an already established interest in the retail location. The nature of a date warehousing strategy, which suggests a continually growing body of information which is in its own regard never fully compete,…
Friedman, Tom. (2005). The World is Flat: A Brief History of the 21st Century. Farrar Straus and Giroux.
Ni*****h, P. (2006). Data Mart vs. Data Warehouse: The Great Debate. Open Source Analytics. Online at http://opensourceanalytics.com/2006/03/14/data-mart-vs.-data-warehouse-the-great-debate
The results of this effort needs to be shared electronically online to ensure everyone is kept informed about its progress.
With the data warehouse project entering the requirements definition phase, it's important to start setting the foundation for users across the network of retail stores to begin having ownership of the new system. Getting them interested in the new data warehouse, and to take ownership of it will require getting their inputs early on during the requirements definition phase.
I'd like to suggest the following steps be taken to ensure their needs are captured as part of the requirements definition phase:
1. Create an online, protected portal and have a series of questions and applications on it to give each store user a chance to contribute to not only the content of the new data warehouse, but its usability as well. Use this data as a means to create…
Birkner, C.. (2008, September). Hedges in flight. Futures, 37(10), 68-69.
Colleen Cunningham, Il-Yeol Song, & Peter P. Chen. (2006). Data Warehouse Design to Support Customer Relationship Management Analyses. Journal of Database Management, 17(2), 62-84.
Phillip Britt. (2007, January). Analyzing Business Turnaround. Customer Relationship Management, 11(1), 14.
Dev, C., Buschman, J., & Bowen, J.. (2010). Hospitality Marketing: A Retrospective Analysis (1960-2010) and Predictions (2010-2020). Cornell Hospitality Quarterly, 51(4), 459.
Database Data Warehouse Design
Our company, Data Analytic Limited, specializes in collecting and analyzing data for various organizations. Over the years, we have assisted various companies to turn raw data into valuable information that assists the companies in making effective decision profitable in the short and long run. Our research and data analytics are geared towards giving extra edge to various companies. Our services include processing and analyzing terabytes of data to provide customer meaningful information for business decision and enhance competitive market advantages. ecent growth of our company necessitates the needs to design and develop data warehouse that will accommodate large volume of customer data.
Objective of this project is to design and develop the data warehouse for our company.
Importance of Data Warehousing for our Organization
Comprehensive portfolios of our business include Business, Market, and Financial research, Data processing services and Domain based analytics. While the relational database…
Hillard, R. (2010). Information-Driven Business. UK. Wiley.
Microsoft (2012).Data Warehousing | Microsoft SQL Server 2012. Microsoft Corp.
Patil, P.S., Srikantha, R., Suryakant, B.P. (2011). Simplification in the Reporting and Analysis Optimization of the Data Warehousing System:, Foundation of Computer Science, 9 (6): 33 -- 37.
Rostek, K. (2010). Data Analytic Processing in Data Warehouses. Foundations of Management, 2(1), (2010), 99-116.
Miller Inc. is a company that wishes to develop a new and more efficicent data repository for all data collected, stored, and transferred. Their desire to create a data warehouse that operates quickly with less effort is the purpose of this project. Adaptation of database modeling along with designing their data warehouse will lead to higher consumer and employee satisfaction. The project goal is to create a database schema to work as well be designed alongside other components such as identifying metadata in order to let IT model the data warehouse, implement and test it.
to identify and gather database requirements, design the dimensional model, develop the system architecture, design the relational database and online transactional processing model, develop the data maintenance application, develop analysis applications to test and deploy the system through a series of steps intended to reduce error rate. The types of applications for use will be…
DBMS and Data Warehouses
(1) in this writing assignment, you will create a brochure advertising your services as a data repository.
Powered By Excellence
Data epository Service
Powered By Excellence is the only data repository service with globally-located data centers across each continent, each with specific security, reliability and fault redundancy systems in place.
Our staff includes world-class experts on the following platforms: IBM, Microsoft, Oracle, MySQL, Informix, Sybase, Teradata and SAS expertise in-house as part of our consulting services division.
Analytics Advisory Services
Big Data Consultancy - Map and Hadoop expertise for gaining insights from very large datasets)
Custom Software Development
SaaS Application Support
Scalable File Storage
Private Cloud Hosting (Dedicated storage and unlimited virtual machines)
High performance with a world-class platform
24/7 Administrator Access
Unlimited Virtual Machine Use
Service Level Agreement (SLA) metrics available 24/7
Trusted Provider of Data epository Services:
(Benander, Benander, Fadlalla, Gregory, 2000)
Benander, A., Benander, B., Fadlalla, A., & Gregory, J. (2000). Data warehouse administration and management. Information Systems Management, 17(1), 71-80.
Choudhary, A.K., Harding, J.A., & Tiwari, M.K. (2009). Data mining in manufacturing: A review based on the kind of knowledge. Journal of Intelligent Manufacturing, 20(5), 501-521.
He, Z., Lee, B.S., & Snapp, R. (2005). Self-tuning cost modeling of user-defined functions in an object-relational DBMS. ACM Transactions on Database Systems, 30(3), 812-812.
Primary Data Collection
Secondary Data Collection
Performance evaluation of the optimized supply chains
Carrefour Ooshop e-grocery
Structural decisions items of operations strategy in logistics
Hardware of the firm
Infrastructure decision areas
Software of the organization
Planning and control
Comparison of structural and infrastructural logistical operations management decisions
Globalization and Logistics Optimization
Logistical optimization models
Challenges in e-grocery Logistics
E-grocery logistical solution
Store-based order picking model
Figure: Store-based order picking model
Store-based order picking for attended goods reception
Store-based order picking for unattended goods reception
Dedicated order picking model
Figure: Dedicated order picking model
Delivery from dedicated centers for attended goods reception
Delivery from dedicated centers for unattended goods reception
E-basic needs frameworks so that organizations can get beneficial
Distinctive logistical results
ecognize e-basic framework
Anand, G., Ward, P.T., Tatikonda, M.V., & Schilling, D.A. (2009). Dynamic capabilities through continuous improvement infrastructure. Journal of Operations Management, 27(6), 444-461.
Barnes, D. (2008). Operations management: An international perspective. United Kingdom: Thomson.
Griffin, R.W., & Pustay, M.W. (2009). International Business: A Managerial
Perspective. (6th ed.). New Jersey: Pearson Prentice Hall.
The job opportunity
Data analyst at Ciber, as solicited in the following advertisement from www.jobview.monster.com
"Ciber is looking for a Data Analyst to analyze data from various GFS. This Senior Data Analyst will have experience working in an enterprise environment and crunching numbers that have high levels of visibility.
Strong to expert level skills and experience in MS Excel: if statements, vlookup, hlookup, pivot tables, macros, etc.
A rich history of analytical and problem solving skills and accomplishments.
Analytical and detail oriented individual that enjoys working with data solutions.
Strong to expert skills in data manipulation with tools like MS Excel and Excel reporting.
Ability to quickly comprehend complex spreadsheets/data.
Intermediate SQL query, & SSRS background.
Good communication and presentation skills to executive management audiences.
Skilled at working with large data sets in Excel, quickly resolving data-related issues.
Clean lines of communication to Executive…
relationships and distinctions between the information systems concepts of data warehousing and data mining, which combined with online analytical processing (OLAP) form the backbone of decision support capability in the database industry. Decision support applications impose different demands for OLAP database technology than the online transaction processing (OLTP) model that preceded it. Data mining with OLAP differs from OLTP queries in the use of multidimensional data models, different data query and analysis tools at both the user-facing front end and the database back end, and different mechanisms for data extraction and preparation before loading into a data warehouse can take place. The construction of data warehouses entails the operations of data cleaning and data integration, which are key pre-processing steps for enabling data mining. Furthermore, the concept of metadata (data about data) is essential to the functioning of a data warehouse, and must be managed appropriately for an effective and…
Berson, A., & Smith, S.J. (1997). Data Warehousing, Data Mining, and Olap (1st ed.). McGraw-Hill. Retrieved from http://dl.acm.org/citation.cfm?id=549950
Chaudhuri, S., & Dayal, Umeshwar. (1997). An overview of data warehousing and OLAP technology. ACM Digital Library, 26(1). doi:10.1145/248603.248616
Douq, Q. (2009, November 24). Comparison of Oracle to IBM DB2 UDB and NCR Teradata for Data Warehousing. X-Space. Retrieved November 14, 2011, from http://space.itpub.net/673608/viewspace-620367
Gartner Newsroom. (2008). Gartner Reveals Five Business Intelligence Predictions for 2009 and Beyond. Retrieved November 14, 2011, from http://www.gartner.com/it/page.jsp?id=856714
Business equirements Document
Miller Inc. looks forward to creating a data repository for all data collected that is beyond the current relational database it currently uses. The company has currently outgrown the relational database in Oracle that it currently uses. Though it enables data to be stored in different tables that can be linked together using record keys, the amount of keys and records makes it difficult to operate a standard relational database. The company thus needs to adapt database modeling in designing their data warehouse. This is the project. Data modeling extends the online transaction processing models that are common in relational database into data warehousing. The project goal is to develop an appropriate database schema to be designed alongside other components such as identifying metadata. The IT role is to model the data warehouse, implement and test it.
Scope of the project
The scope of the project…
Hughes, R. (2008). Agile Data Warehousing: Delivering World-Class Business Intelligence Systems Using Scrum and Xp. Chicago: iUniverse.com.
Humphries, M., Hawkins, M.W., & Dy, M.C. (1999). Data warehousing: architecture and implementation. Englewood Cliffs: Prentice Hall.
Analytics, Interfaces, & Cloud Technology
The use of analytics and cloud technology is a new advance in computing which allows data collection and analytics to be done using higher processing speeds. It allows organizations to take full advantage of the huge amount of data that is collected through web analytics services. Miller Inc. collects a huge amount of data which is difficult to process. It also takes a very long time to process the data since the data is dynamic in nature. There is also a challenge in keeping data secure since the company needs to ensure its business and competitive advantage is protected. Through providing analytics services through cloud technology, Miller Inc. will be able to leverage the data driven frontier of cloud analytics. Basically, the company will be able to leverage the use of technological and analytical tools and techniques which it will design for its clients. These…
Antonopoulos, N., & Gillam, L. (2010). Cloud Computing: Principles, Systems and Applications. London: Springer London.
Buyya, R., Broberg, J., & Goscinski, A.M. (2010). Cloud Computing: Principles and Paradigms. New York: Wiley.
Jamsa, K.A. (2011). Cloud Computing. Burlington, Massachusetts: Jones & Bartlett Learning.
Data storage for today's businesses [...] why a business has separate databases and a data warehouse, and why it does not have just one large database for all its data, both current and historical. Data warehouses help staff evaluate specific data more effectively, and bring together large amounts of data that might not be easily accessible in one massive database.
Storage of Data
The storage of data for today's businesses is a complicated issue, compounded by the need to access data quickly, while still ensuring the data is easily accessible to the staff that need it, and can be combined to utilize all the data from several single databases that might not be easily mined and evaluated from database to database. Keeping separate databases along with a data warehouse makes good business sense for a number of reasons.
One of the main reasons many businesses utilize data warehousing is to…
Chopoorian, John A., et al. "Mind Your Business by Mining Your Data." SAM Advanced Management Journal 66.2 (2001): 45.
Higgs, Edward, ed. History and Electronic Artefacts. Oxford, England: Clarendon Press, 1998.
O'Sullivan, Orla. "Data warehousing - without the warehouse." ABA Banking Journal 88.12 (1996): 42+.
Turning data into knowledge." Canadian Business June 1997: 2+.
Each of the databases exports a view of its tables or objects that conforms to the shared data model, so that queries can be expressed using a common set of names for properties and relationships regardless of the database. The queries are then translated so that they are actually run against the local data using local names in the local query language; in the reverse direction results may be scaled, if needed, to take account of a change of measurement units or character codes (Applehans, et al. 2004). The technological test of these systems is to create programs with the intelligence necessary to divide queries into sub-queries to be interpreted and sent to local databases, and after that to merge all the results that come back. Great progress has been made in methods for setting up efficient dispersed query execution and the constituent that does this is frequently called an…
Angoss Software. (2006) KnowledgeSEEKER in Action: Case Studies. Toronto: Angoss Software International Limited.
Applehans, W., a. Globe, and G. Laugero. (2004) Managing Knowledge: A Practical Web-Based Approach. Reading, MA: Addison-Wesley.
Aubrey, a., and P.M. Cohen. (1996) Working Wisdom: Timeless Skills and Vanguard Strategies for Learning Organizations. San Francisco: Jossey-Bass.
Gray, J. Helland, P. O'Neil, P. And D. Shasha, (2005) the dangers of replication and a solution, Proc. ACM SIGMOD Conference, pages 173-182.
They have to be realistically incorporated into any changes that are made where technology and data are concerned. If they are not taken into account, people in various departments can feel as though they are not important in the scheme of the organization because they have been upstaged by technology.
However, technology has to come into play where organizations are concerned because the world is changing and becoming more global. That means that there are a lot more people buying from companies all over the world and that makes a lot more data that has to be warehoused, especially for the largest of companies. These companies know that they have to find a good balance between making their employees feel as though they are valued and making the technological changes that they need to stay ahead of their industry. Sometimes these things can collide, but this can often be diffused…
When it comes to strategic information management, there are many options that a company has. Data mining, data warehousing, and the various OLAP options are only some of the tools that can be used, but they are three of the most important - if they are used correctly. Because there are several options with OLAP it is very versatile and most companies can find a way to make it work for them so that they can quickly get the answers that they are looking for and help to keep their company moving forward. The other two business intelligence tools, data mining and data warehousing, are also very important, but like any of the other tools there are contributions that they offer and drawbacks that they have. The key to using them all effectively is getting a good understanding of what they can bring to an organization and what they…
Business equirements Document
Describe the project
The project is focusing on a data collection and analysis for a storage and networking company. It is two years old and has been working to establish a repository. This is unique platform which allows someone to access a variety of information about the organization or individuals. Currently, the firm is utilizing a total of 10 terabytes to store all data. However, this is expected to rise by 20% annually. This is because the firm will have cliental and other stakeholders who will use their systems to store and retrieve more information. (Schultz, 2011) (Smith, 2011)
Describe and define the scope of the project
The scope of the project is to create a working database which is capable of handling the needs of the firm and their cliental. This will be achieved by creating a platform which can be expanded to meet these different…
Schultz, G. (2011). Cloud and Virtual Data Storage Networking. Boca Raton, FL: Taylor and Francis.
Smith, H. (2011). Data Center Storage. Boca Raton, F: Taylor and Francis.
Knowledge Management Toolkit
A data warehouse encompasses and provides access to all the company's information to whoever needs access to it. A warehouse literally means a storehouse, and the information within an organization may be distributed within one computer or with many computers, form one single warehouse. They may contain several databases and all types of information, and in a large variety of different formats. However, all the above information and knowledge must be accessible through a server, and the user gains a transparent means of access to the data because he can utilize extremely simple commands to retrieve and gain access to the information, and also analyze it, as he wants to. A data warehouse will also generally contain certain details about the warehouse, and where and how the information has been stored within the warehouse. (Definition of Data Warehouse on the web)
A typical data warehouse is usually…
Allen, Christopher. Definitions of Groupware. Alacrity Ventures. Fall 1990. Retrieved From
http://www.alacritymanagement.com/DoG.html Accessed on 28 January, 2005
Challenges on to KM Advancement. Retrieved From
http://www.bulltek.com/English_Site/IKB%20Introduction/Knowledge_Management_English/KM_Challenges/km_challenges.html Accessed on 28 January, 2005
Continental Go Forward Strategy
The overarching objective of the Go Forward Strategy was to continually accelerate the gains made in customer relationship management (CM), customer service, operations and the maintenance, repair and overhaul of their jets. What Continental was after was the ability to unify their entire operation into a highly integrated, coordinated customer-based platform that could be used for streamlining every aspect of their operations to exceed customer expectations and deliver exceptional value (Watson, Wixom, Hoffer, Anderson-Lehman, eynolds, 2006). The Go Forward strategy further galvanized Continental unto a very focused strategy for ensuring their Enterprise Data Warehouse (EDW) turned into a Powerful catalyst for customer-driven change (Watson, Wixom, Hoffer, Anderson-Lehman, eynolds, 2006).
The $30M investment in the Go Forward Strategy was one of the most effective investments in technology any airline has ever made in technology, with Continental netting a gain of $500M in increased revenue and cost savings.…
Cunningham, C., Il-Yeol Song, & Chen, P.P. (2006). Data warehouse design to support customer relationship management analyses. Journal of Database Management, 17(2), 62-84.
Johnson, L.K. (2004). Strategies for data warehousing. MIT Sloan Management Review, 45(3), 9-9.
Subramanian, A., Smith, L.D., Nelson, A.C., Campbell, J.F., & Bird, D.A. (1997). Strategic planning for data warehousing. Information & Management, 33(2), 99-113.
Watson, H.J., Wixom, B.H., Hoffer, J.A., Anderson-Lehman, R., & Reynolds, A.M. (2006). Real-time business intelligence: Best practices at continental airlines. Information Systems Management, 23(1), 7-18.
Wal-Mart uses high technology to effectively plan and schedule workers shifts. Currently, Wal-Mart boasts 1.2 million workers throughout the world and has been in existence for 43 years (Grant, 2005) HR departments at the different stores and the management constantly ensure that every store has the optimized number of employees to handle the transactions and sales in the store. In the past retailers had permanent employees. Now, Wal-Mart is increasingly employing part-time workers. As the number of stores increase, the number of employees required also increases. Tracking and managing payrolls over a centralized computer database system has proved to be very beneficial for the company.
Wal-Mart invests time and resources to identify products that are preferred by the customer and offering them at prices much below departmental and specialty stores. "Consumer information should be collected systematically and on a timely basis the recommended time between tracking is shortening as…
Blanchard, Dave. "Countdown to Rfid-Day." Logistics Today 45.12 (2004): 1.
Grant, L. "Wal-Mart Ceo Vows 'Unfiltered Truth.'" USA Today, Money section p. 01b (2005).
Kardon, Brian E. "Consumer Schizophrenia: Extremism in the Marketplace." Planning Review 20.4 (1992): 18-23.
Simchi-Levi, David, Philip Kaminsky, and Edith Simchi-Levi. Designing and Managing the Supply Chain: Concepts, Strategies, and Case Studies. 2nd ed. Boston: McGraw-Hill/Irwin, 2003.
An analysis of SAP in Australian energy infrastructure
In 2009 the Australian Government allocated $4.5 billion in support of renewable energy technologies with a target of 20% share of the entire energy market by 2020 (i.e. An increase from 20 terawatt hours to 60 terawatt hours). Ten years ago, during the nation's era deregulation, natural gas reserves were more than doubled from 19.4 trillion cubic feet (Tcf) in 1998 to 44.6 (Tcf) in 1999. At present, new liquefied natural gas (LNG) and gas-to-liquids (GTL) facilities, pipelines are core in national energy sales both in Australia and abroad. During the first several years, supplies of natural gas outpaced domestic demand. Much effort was put into enterprise systems (ES) as a strategy of change management, toward better operational control of facility and infrastructure as the industry ramped up to its present position in the energy market. Of particular utility was…
A Guide to the Project Management Body of Knowledge (PMBOK® Guide) (2004).Third Edition, Paperback. Newtown Square, PA: Project Management Institute.
Davis, B.J. (2005). Prepare: seeking systemic solutions for technological crisis management. Knowledge and Process Management, 12(2), 123-131.
Kritsonis, A. (2005). Comparison of Change Theories. International Journal of Scholarly Academic Intellectual Diversity 8 (1).
Origin Energy (2010). Retrieved from: http://www.originenergy.com.au/
Particularly with the relatively recent passage and renewal of the nation's 2002 Homeland Security Act, individual Americans are becoming more and more concerned that their retrieval and use of information is being tracked, not simply through the paper libraries of the nation, but also via the orld ide eb. However, although there is a concern that one can leave one's information imprint and compromise one's privacy when tracking relevant data -- for instance, a student researching hate groups could be unfairly targeted as a potential sympathizer with such organizations, if he or she leaves a 'track' on his or her high school's hard drive -- one cannot ensure that no data fingerprints are left upon personal or public hard drives or search engines themselves when users access data via large-scale data warehouses.
Until the last few years, data warehousing traditionally focused on relational technology, namely the storing large amounts of…
Kaufman, Perlman & Speciner. (2002). Network Security: Private Communication in a Public World, Second edition. Upper Saddle River, NJ: Prentice Hall.
Large-Scale Data Warehousing Using Hyperion Essbase OLAP Technology." January 2000. Hyperion. Retrieved on July 11, 2004 at http://dev.hyperion.com/resource_library/white_papers/data_warehousing_teraplex_ibm_0.cfm
For example, a straightforward database of customer names for a company is searched with relative simplicity. The names may be retrieved according to beginning letters or other important data (such as item purchased). But for a database of full-text magazine articles, the user will need to search according to name, title, publication, and keywords, among other features. The database will not be able to perform adequately without such usability factors. Even if a database is 'fast' in terms of how it returns queries, the queries must be of use to the searcher.
When developing the infrastructure, a data management system is required to operate the databases, store the information, back up the data, and enforce security. If users are entering sensitive information, password protection and encryption is also essential. The hardware and software used must be adequate to support the needs of the system. And the ease of data entry…
Application performance factors. (2010). MSDN. Retrieved October 5, 2010 at http://msdn.microsoft.com/en-us/library/aa266496%28VS.60%29.aspx
Factors affecting performance. (2010). Dev2Dev. Retrieved October 5, 2010 at http://otndnld.oracle.co.jp/document/products/wlp/docs81/perftune/2pfactors.html
Lambert, Diana. (2010, September 23). California's ailing $34 million student database. The San
Francisco Chronicle. Retrieved October 5, 2010 at http://www.sacbee.com/2010/09/23/3050167/californias-ailing-34-million.html#ixzz11Vt57bmq
Once the sampling frame has been defined, the students will be sent a mock-up of a recruitment website and they will be asked to evaluate its navigation, personalization and what factors add to or detract from its trustworthiness online. The mock-up of the online recruitment site will also allow for alerts by specific job category to be defined in addition to personalization of the site as well. Once students have been given the opportunity to review the website, questionnaires will be sent requesting their opinions. To further minimize boas, the students are going to be told this is for a beta test site program for a new job recruitment site specifically developed for graduating seniors.
Data Collection and Analysis Techniques
The data collection and analysis will be initially managed though online survey application Zoomerang, which has preliminary statistical analysis applications included on the site itself. Further analysis of the data…
Bibliography and Reference List
Talya N. Bauer, Donald M. Truxillo, Jennifer S. Tucker, Vaunne Weathers, et al. 2006. Selection in the Information Age: The Impact of Privacy Concerns and Computer Experience on Applicant Reactions. Journal of Management 32, no. 5 (October 1): 601. http://www.proquest.com (Accessed April 20, 2008).
Susanne M. Bruyere, William Erickson, Sara VanLooy. 2006. Information technology (it) accessibility: Implications for employment of people with disabilities. Work 27, no. 4 (January 1): 397-405.
Grimson, Jane, William Grimson & Wilhelm Hasslebring. (2000). he SI challenge in healthcare. Communications of the ACM. 43 (6): 49-55.
According to the article "he SI Challenge in Healthcare," a critical component of business process reengineering in the healthcare system is the implementation of electronic record-keeping. Electronic Health Care Record (EHCR) means that all patient data is stored regardless of is source. While it "presents obvious integration challenges...linking of records to clinical guidelines and protocols is essential if best-practice is to be embedded as an integral part of the health care delivery process and if the problems associated with widespread variations in treatment costs and outcomes are to be addressed" (Grimson, Grimson & Hasslebring 2000: 49). Medical errors can be reduced if patient records are easily shared and are comprehensively recorded on a general database. Also, outcomes can be more easily compared when medical research is conducted by researchers.
Three major approaches to sharing healthcare information electronically exist: message-based sharing, data warehousing, and common architecture. Message-based approaches allow institutions to share information, even if they have different storage systems. Data warehouses, as the name suggests, are repositories information that can be accessed by providers, and common architecture involves an integrated architecture storage system that links providers. A common domain-specific EHCR data model is regarded as ideal as it is commonly accessible and thus least likely to result in medical errors due to incomplete information. However, the implementation of this model has proven difficult in the U.S. (Grimson, Grimson & Hasslebring 2000: 50).
The European Union nations are already embarking upon an even more ambitious initiative in the form of total unity of all nations' databases, although this too has proved elusive, given an inability to agree upon specific models. For example, "the Good European Health Record concentrated on providing a comprehensive model that captures all the rich ethico-legal semantics of the EHCR, while the W3-EMRS placed more emphasis on the ability to share records securely between institutions and agreeing on a common data set for the shared record" (Grimson, Grimson & Hasslebring 2000: 50). Much of the article involves discussing the different applications and advantages of specific approaches and software systems. Ultimately, this is frustrating given that the conclusion of the article is that while the technological implementation will be determined by developments in the non-healthcare markets of business and IT, the methods by which healthcare data will be structured must be determined by pressures and demands of the healthcare community itself in a united fashion. Uncertainty about the value of a truly united system of records and reconciling different security needs for different contexts has made such universal agreement a challenge.
Many of the concerns of the article have grown outdated, such as its tentative discussion of how the World Wide Web can be useful in information-sharing. A more comprehensive discussion of the need for discussion between healthcare entities in the industry and across borders about the most effective way to implement ER and to share data in a secure manner, and the cultural reasons for why such dialogue has not occurred, would have been more useful and ultimately made the article less dated. A specific comparison of how different systems can work in action, rather than just a theoretical discussion of the software architecture would also have made a more persuasive case for the superiority of different systems over others.
Everyone who has been to college knows how difficult shopping can be with roommates. The fact of the matter is that no one agrees on anything. What happens is that often times, college students have to buy sodas in bulk, thinking they will be saving money; but, because only some people in their household actually like certain flavors, there is a lot of waste. The product here is actually a beverage delivery service that provides 12 and 24 packs of beverages or sodas, all with unique flavor combinations upon order request. The customers can go online and order whatever number of particular flavors they want, allowing them to mix and match in order to create a bulk discount that all the members of their household can enjoy.
Price 12 pk
Price 24 pk
Cartlidge, John & Phelps, Steve. (2010). Estimating consumer demand from high-frequency data. Annual International Academic Conference on Business Intelligence and Data Warehousing. Web. http://www.cs.bris.ac.uk/~cszjpc/pubs/10bidw.pdf
Citizens Information. (2011). Display price for goods and services. Pricing. Web. http://www.citizensinformation.ie/en/consumer_affairs/consumer_protection/pricing/price_display_of_goods_and_services.html
Gopinath, Gita & Itskhoki, Oleg. (2009). Frequency of price adjustment and pass-through. Princeton University. Web. http://www.princeton.edu/~itskhoki/papers/FrequencyAndPassThrough.pdf
Lind, D., Marchal, W. And S. Wathen (2004). Statistical Techniques in Business and Economics. The McGraw-Hill Companies.
Some manufacturers have sought to improve their profitability by becoming more horizontally integrated in their supply chain management operations, but it does not appear feasible for the company to acquire the vendors that supply its component parts so viable alternatives must be identified that can facilitate the supply chain management process vertically. As Choy, Lee and Lo (2003) point out, "Very few manufactures now own all the activities along the chain but integrate the supply network from various supplier networks and the ability to make fast and accurate decision often constitute a competitive advantage compared with the competitors or other networks" (87). It is clear that the company could benefit from an information technology solution to its current paper-driven approach to managing its supply chain operations. In this regard, Choy and his associates also note that, "The rapid advance in information technology is now deployed not only to improve existing…
Akram, a., Chohan, D., Wang, X.D., Yang, X. And Allan, R. 2005. "A Service Oriented
Architecture for Portals Using Portlets." Warrington, UK: CCLRC e-Science Centre,
CCLRC Daresbury Laboratory.
Boyson, S., Corsi, T. And Verbraeck, a. 2003. "The e-supply chain portal: a core business model." Transportation Research Part E, 39, 175 -- 192.
Enterprise-Level Business Information Systems
In terms of workplace productivity and efficiency, one key aspect to when developing an effective information system for an enterprise is how to select a system that is simple enough to understand for the vast majority of its users, but technologically forward enough so that it has adequate backup for the data stored within the system's various components. Ideally as well, the system should be able to consolidate all data so that it may be shared at various levels within the business' structure, yet still have adequate passwords and security controls. "Experts say about 65% of all companies have lost control of the management or planning of a computer project at some stage," thus the creation of a system with adequate backup and maximum efficacy cannot be underestimated, not simply from a technical point-of-view, but also the point-of-view of the business as a whole. ("The Computer…
A. Discuss which business process mapping tools you recommend in documenting the design.
Firstly, the business must map out, what sorts of improvements or future successes, it desires to achieve with the new database design. If improvement of information sharing to increase sales is one goal, for instance, it must quantify the percentile increase it hopes to achieve. The overall success of the business in question must be quantified according to certain overall goals, as well as risks taken into consideration of not pursuing the new design. In documenting this design, firstly, the goals should be defined in terms of increased information sharing and data collection, coupled with the implementation of security procedures. After implementation, an audit of time saved by company members, questionnaires posited to company members regarding the system's ease and safety of usage, as well as an overall tabulation of increased productivity and sales must be taken into consideration. (Jacka & Keller, 2001)
In this area, it is important to remember that when new updates and projects go "astray, about 80% of the problem is management-oriented, not technical. You can hire lots of technicians to solve your problems, but most technicians
The term "data mining" refers to the process of taking a large amount of data, sorting through it, and refining appropriate and relevant information. Typically, it is used with ERP systems to help make strategic decisions based on the patterns that come out of the data review. It is also that more formal and statistical analysis of large sets of data within complex ERP Systems. Data warehousing is a term meaning the storage of information for an organization. The data warehouse is the place that the data is stored and organized. Data warehousing, per se, is passive; while data mining is active. One needs to have the data in a depository of some kind before it can be mined for use. Both data mining and data warehousing are essential to the effective management of the strategic planning process. The amount and quality of the data warehoused is directly related to…
Kimball, R. And M. Ross, (2002), the Data Warehouse Toolkit, John Wiley & Sons.
The term "data mining" refers to the process of taking a large amount of data, sorting through it, and refining appropriate and relevant information. Typically, it is used with ERP systems to help make strategic decisions based on the patterns that come out of the data review. It is also that more formal and statistical analysis of large sets of data within complex ERP Systems. Data warehousing is a term meaning the storage of information for an organization. The data warehouse is the place that the data is stored and organized. Data warehousing, per se, is passive; while data mining is active. One needs to have the data in a depository of some kind before it can be mined for use. Both data mining and data warehousing are essential to the effective management of the strategic planning process. The amount and quality of the data warehoused is directly related to the organization's ability to use that data appropriately. Mining data from various sources increases the statistical validity of the data set, and provides more useful information quicker.
Student #2 shows us how data mining is used in a medical model, as well as correlating with course lecture material. It is clear from their analysis that the power of data mining is only as good as the data itself, and that a real key to any program is finding the appropriate way to handle the voluminous amounts of data and make something meaningful out of it -- like patterns, hidden statistical similarities and abnormalities, etc. Another use of data mining in healthcare, though, might be from a human resource standpoint; finding skill levels and appropriate human capital to utilize within a larger organization to improve efficiency. Really, the possibilities are endless; technical, quantitative, qualitative studies, and even patient satisfaction surveys -- usable data for managers who may not have the time or expertise to wade through large amounts of data, but need specific questions answered in a timely manner.
Strategic Information Systems'?
A strategic information system is a system that enables an organisation to alter the structure of its business strategy so that it can achieve a competitive advantage over others. This system also helps organisations in fastening the time it takes to react and adapt to several environmental changes that take place and makes the overall business structure more efficient. Within a strategic information system there exists a decision support system that helps align business goals and strategies with information systems and technologies.
Write down the various business models of internet.
The various business models of the internet include:
Advertising, Blogging, Affiliate, Community, Utility, Subscription, Brokerage, Merchant, Manufacturer.
Question 3: What is 'Network Bandwidth'?
The amount or volume of data which is being transmitted through a particular network at a given point in time is referred to as a network bandwidth. Network bandwidth's can be affected by software…
Elie Tahari Ltd. And Business Intelligence
Elie Tahari Ltd. is a high end women's apparel designer and retailer. Launched in 1974, the company helped to revolutionize the store-within-a-store concept. The privately held retailer merchandizes its collection in dedicated space in retail chains such as Bloomingdale's, Neiman Marcus and Saks Fifth Avenue. The company has just over 800 employees with 22 retail locations, along with is clothing in 600 free-standing boutiques and high-end department stores. The company's merchandise is available in 40 countries around the world (Laskowski, 2011).
The company depended on its information systems to run its operations and to position it to make the most of new opportunities to expand business. Prior to the implementation of their new system, Tahari was limited by the quality of the sales data they received; the data was frequently incomplete, redundant or inconsistent. Tahari needed two employees working full-time for two days each…
Amato-McCoy, D.M. (2004 January). Elie Tahari gains timely access to needed data. National Retail Federation. Retrieved December 26, 2011 from: http://www.informationbuilders.com/applications/pdf/RetailTahari.pdf
Bara, A., Botha, I., Diaconita, V., Lungu, I., Velicanu, A., and Velicanu, M. (2009). A model for business intelligence systems development. Informatica Economica, 13(4) 99-109. Retrieved December 26, 2011 from: http://revistaie.ase.ro/content/52/10%20-%20Bara,%20Botha.pdf
Baum, D. (2003). Elie Tahari Ltd. unveils new end-user reporting framework. Retrieved December 26, 2011 from: http://www.informationbuilders.com/new/magazine/v14-2/pdf/Tahari.f03.pdf
Laskowski, N. (2011, May 20). Elie Tahari uses BI tools to grow without adding overhead. TechTarget. Retrieved December 26, 2011 from: http://searchbusinessanalytics.techtarget.com/news/2240036038/Elie-Tahari-uses-BI-tools-to-grow-without-adding-overhead
Human esources Management - Maintaining a Competitive Edge in the Corporate Marketplace
Change continues to reshape the workplace. Today's H professional is called upon to help the organization retain its competitive edge in the marketplace. Along with representing the best interests of employees, H professionals assume the role of strategic partner, administrative expert, and change agent. H assumes a critical role in promoting the vision and shaping the focus of the company. H professionals must be skilled and knowledgeable business partners, able to wear many hats while demonstrating their own competencies in communication and decision-making skills. (Aghazadeh, 1999)
Today, H departments face many challenges. Some are conventional and continuing concerns.
Attract, retain and motivate employees;
Ensure legal and regulatory compliance;
Manage the human side of technological change.
Perhaps, most critically today however, progressive H departments are charged with adding value to the corporation as they seek to:
Aghazadeh, Seyed-Mahmoud (1999). Human Resource Management: Issues and challenges in the new millennium. Management Research News, 22(12) 19-32.
Ashbaugh, Sam and Rowan Miranda (2002). Technology for Human Resources Management: Seven Questions and Answers. Public Personnel Management, (31) 7.
Ball, Sarah (2002, Sept). How technology can make you look good. Employee Benefits, S9-11.
Barro, Tom. A Tangled Web of Partnerships. Retrieved Feb. 21, 2003 at http://www.astd.org/CMS/templates/index.html?template_id=1&articleid=23780
Barratt, C.C., Acheson, P., & Luken, E. (2010). eference models in the electronic library: The Miller Learning Center at the University of Georgia. eference Services eview 8(1), 44
The authors of this article provide the most effective ways of providing support to the patrons of the large university to ease the undertaking of activities within its electronic library. The authors conducted research to evaluate the effectiveness of different models of providing research services for the students in a large research university, hence, its strength. The study is important for the study as it provides information about the different models that can be used in providing a better architecture for a research library for the universities involved in research.
Author Note: the authors have vast experiences as librarians and researchers in different universities. Barratt works with the Miller Learning Center as an instruction librarian. Acheson works with Public library…
Kasmaee, F.K., Nassiri, R., & Shabgahi, G.L. (2010). Achieving CMMI Maturity Level 3 by Implementing FEAF Reference Models. International Journal of Advancements in Computing Technology, 2(4), 115-122.
A Comparison of the Top Four Enterprise-Architecture Methodologies. (n.d.). A Comparison of the Top Four Enterprise-Architecture Methodologies. Retrieved June 20, 2014, from http://msdn.microsoft.com/en-us/library/bb466232.aspx
Huysman, M. (2000). Rethinking organizational learning: analyzing learning processes of information system designers. Accounting, Management and Information Technologies, 10 (2), 81-99.
Inmon, W.H., Strauss, D., & Neushloss, G. (2008). DW 2.0 the architecture for the next generation of data warehousing. Amsterdam: Morgan Kaufmann/Elsevier.
Database System in a Retail Environment
We are in a world of information boom and efficient management of data holds the key for success in this new business environment. The world of Internet has opened new vitas for corporations to take their business into a global level. Data management is at the center of all business applications and database systems are the very core of this new business perspective. Database systems have helped us take a huge stride in our ability to collect, interpret, and even assist in our decision making process. In short we can say that database management systems have bought a paradigm shift to our mode of business and have evolved from being simple store houses of data to more complex and highly efficient business decision making tools. Let us take Wall-Mart, the giant retailer as our case study and how the company profited from the implementation…
Author not available, "Wal-Mart Deploys Data Mining Software." Accessed on 4th March, 2003
Phillip Greenspun, "Data Warehousing," Accessed on 4th March 2003, http://philip.greenspun.com/sql/data-warehousing.html
Tom Chester, "Database Sizes," Accessed on 4th March 2003. http://sd.znet.com/~schester/facts/database_sizes.html
XML is used not only to represent the data but also as a messaging protocol called SOAP; and (6) Portal Integration is another popular integration methodology in use today. It doesn't involve expensive and time consuming technologies and processes that EAI and data warehousing require. Also, it is the most customer-facing of all the methods described in this section. This means that it can be highly personalized and customized to the customer's requirements. In future, portals will present their functionality as web services so that multiple portals from different vendors can be integrated.
Architecture of Portals
The portal, when speaking technically, is "a framework that enables developers to plug various software components called portlets, and then deliver the aggregated content to multi-devices." (Mohan, 2003) Integration may be accomplished through using HRML, JSP, Java eans, Java servlets, XSL that transforms XML through XSL transformation or even CGI. Sun Microsystems' Java Community…
Mohan, Sajeev (2003) Mechanics of Oracle Portal and Identity Management. Online available at http://download.oracle.com/owsf_2003/36786_Mohan.doc
Reducing the Costs of it Security Management (2006) Sumner Blount eTrust Solutions Online available at http://i.cmpnet.com/ittransformationcenter.techweb.com/pdfs/reducing_costs_security_mgt.pdf
Building a Portal? Vive La Difference (2001) Information Week. 5 November 2001 Online available at http://www.informationweek.com/news/showArticle.jhtml?articleID=6508083
Oracle Solutions for Workforce Excellence - HR Transformation: Transform HR from an Administrative Function to a Strategic Partner. http://www.oracle.com/global/uk/hcm/9575%20Transformation-2-9-4.pdf
Zara Case Analysis
Zara: IT for Fast Fashion is a unique case study in that it powerfully illustrates how a lack of IT integration and process efficiency can over time force an organization into complacency, lowering the standards of performance due to a lack of real-time market and operations data and analytics. The POS terminals that are running on a discontinued version of the Microsoft DOS operating system is a metaphor of the entire company's approach to using IT more effectively. Adopting a more agile IT architecture based on the Software-as-a-Service (SaaS) platform is needed. Integrating ordering fulfillment, distribution and manufacturing is needed.
Zara's management teams are being pulled in spe4rate directions as the company continues to aggressively expand, operating 11,558 stores in 45 countries as part of the Inditex group, 550 of which are branded as Zara stores. Inditex is on pace to open one store a…
Azevedo, S., & Ferreira, J.. (2009). RFID Technology in Retailing: An Exploratory Study on Fashion Apparels. IUP Journal of Managerial Economics, 7(1), 7-22.
Carr, K.. (2010, April). It's about value, not cost. Marketing: Field Marketing Essays,15.
Wujin Chu, & Paul R. Messinger. (1997). Information and channel profits. Journal of Retailing, 73(4), 487-499.
Howard Cox, & Simon Mowatt. (2004). Consumer-driven innovation networks and e-business management systems. Qualitative Market Research, 7(1), 9-19.
Business transactions between independent business entities require the thoughtful integration of it systems, for example, as well as between a company and its customers, suppliers, or other business partners, such as co-producers and banks (Luftman). Consequently, effective system integration is important for both economic and strategic business reasons. In this regard, Luftman reports that, "External systems integration involves many technologies and business arrangements with different pros and cons, but they can be grouped in two broad categories: one-to-one or one-to-many approaches that link an individual company with its business partners and hub-and-spoke approaches that provide the possibility of many-to-many connections" (Luftman, p. 252).
Since the introduction of computers several decades ago, the increasing computerization of business organizations has experienced a sequence of transformations as a result of the rapid development in information technology and increasingly complex business needs (Yang & Lu, 2005). As these authors point out, "The continuous e-revolution…
Abdelraheem, a.Y. (2005). Integrating instructional technology with information technology and its implications for designing electronic learning systems. International Journal of Instructional Media, 32(2), 125.
Earl, M.J. (2003). Integrating business and it strategy: Reframing the applications development portfolio. In Luftman at p. 51.
Luftman, J.N. (2003). Competing in the information age: Align in the sand. New York: Oxford University Press.
Mcginn, D., Kudyba, S. & Diwan, R. (2002). Information technology, corporate productivity and the new economy. Westport, CT: Quorum Books.
. This process is shown to be applicable to the many different areas of
the divisions and the overall areas of change most needed, including
suppliers and customer relationships.
. After finding the five-step process in the previous chapters' lessons
learned the team experiments with the steps and creates a revised set
. Step one - identify the systems constraints including all
bottlenecks and all variables including in the constraint
. Step two - define strategies for how to cope with,
overcome, and capitalize on constraints within the model
. Step three - take all tasks to step two decisions
. Step four - evaluate all systems constraints and look to
. Step five - If in the previous steps a constraint was
encountered, then broken, the process needs to go back to
. The team finds for the first time…
Computers Are Related to My Profession
Computers are a very important part of our world and are vital to the success of any firm. This paper will explore how computers are related to my profession as an Internet merchant. We will discuss the role that the computer plays in allowing me to perform my duties as a merchant. The discussion will also focus on the program languages and devices that are vital to my success. This technology includes Application Service Providers, a Merchant Account and Data Warehousing. I will explain how these technologies are used and why they are vital to the success of my business. First lets discuss the nature of my profession and the duties that I perform.
Nature of my Profession
As an Internet merchant I sell products and services over the World Wide Web. I have a website that allows people to purchase products using credit…
Hayes, Ian S. "Implementing an ASP Solution." Software Magazine. Dec 2000. http://www.findarticles.com/cf_0/m0SMG/6_20/69412619/p2/article.jhtml?term=ASP+programing+laguage
Mccollum, Tim. "Tools For Targeting Customer Service." Nations Business. Nov 1, 1998. http://www.findarticles.com/cf_0/m1154/1998_Nov_1/53111049/p1/article.jhtml?term=database+management
Vignette Merchant Suite Provides Powerful Solution for Direct Sales Online to Businesses and Consumers." Business Wire. June 18, 2001. http://www.findarticles.com/cf_0/m0EIN/2001_June_18/75609966/p1/article.jhtml?term=Online+Merchant+Accounts
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 be immediately available, even when the primary database has failed due to some reason or another. Non-exclusive usage of the primary database is also permitted, and this means that the database will not be locked, and this in turn means that it can be updated and changed during the process of its creation. Computer resource can be conserved, and this is because of the fact that shadowing does not use any separate process; the database process gives the shadow database…
Database Shadowing System with data tags that select an operation of the save command"
Retrieved at http://www.freepatentsonline.com/5230075.html . Accessed 4 October, 2005
Data Recovery without data loss" Retrieved at http://www.enet.com/enet.com.nsf/PAGES_RRDF_Recov.html?OpenPage&charset=iso-8859-1Accessed 4 October, 2005
Eng, Audra. (July, 2004) "Sygate Secure Enterprise, 4.0" Retrieved at http://www.sygate.com/solutions/datasheets/wp/WP-Sygate-Secure-Enterprise.pdf. Accessed 4 October, 2005
Systems Media Table: Comparison
The main purpose of this program is to construct sentences of the perceived information and manipulate paragraphs to form a word document. The program uses a display format 'what-you-see-is-what-you-get' to enhance the quality of the expected hardcopy.
WordPerfect and Microsoft Word are mostly superseded by both organization and personal computers to perform functions such as word formatting, letter processing and some simple designing. Accordingly, it is the most frequently used program in day-to-day operation.
It is used to type the text, save, and format and print the text.
It is used to insert pictures into the text page.
It is used to spell check the text document.
It is used to prepare letters and other word documents.
This kind of database system is to display a structure that would relieve the presentation of information using parent to child relationship. The…
AJ, W., & al, e. (2007). The role of decision aids in promoting evidence-based patient choice in Edwards A and Elwyn E (eds) Evidence-based patient choice:. O'Connor A and Edwards A.
European Commission DG Health and Consumer. (2012). Guidlines on the Qualification and Classification of Stand-alone Software used in Healthcare withing the Regulatory Framework of Medical Devices. Articles of Directive 93/42/EEC .
Eysenbach, G., Powell, J., Gunter, T.D., & Terry, N.P. (2005). The Emergence of National Electronic Health Record Architectures in the United States and Australia: Models, Costs, and Questions. Journal of Medical Internet Research: The Leading Peer-reviewed Internet Journal.
Fesenko, N. (2007). Compression Technologyes of Graphic Information. International Journal "Information Theories & Applications."
Significance of the Study
This study is significant because it sheds light on a very important contributor to local and international trade. Trade fairs have a long history in providing a meeting place for buyers and sellers. They are an important channel of communication for B2B buyers and sellers. This is a significant area for study because there are limited channels of communication between B2B buyers and sellers. The previous sections have diversified the importance of communication to trade. B2B buyers and sellers cannot use mass channels of communication such as television advertising or newspaper advertising. In this market usage of personal visits and demonstrations are the common channels of marketing and communication. The B2B selling and marketing activities are less highlighted in research than B2C activities. Therefore, this study is significant because it explores a very important channel of marketing and communication in the B2B market.
The study is…
UFI.(2009). The Trade Fair Industry in Asia, 5th edition: A UFI report researched and compiled by Business Strategies Group Executive Summary -- for UFI members only." Business Strategies Group Ltd. [online] Available at http://www.ufi.org/media/membersarea/studies_reports/2009_bsg_report_summary_andorder_form.pdf [Accessed 10 May, 2012].
Viardot, E. (2004). Successful Marketing Strategy for High-Tech Firms. Volume 5. NY: Artech House
Yeshin, T. (2006). Sales Promotion. NY:Cengage Learning
Internet has grown exponentially since its first introduction to the public. The precursor to the Internet was the ARPANET. The Advanced Research Projects Agency (ARPA) of the Department of Defense (Carlitz and Zinga, 1997) and the National Science Foundation (NSF) were the primary creators of the ARPANET. Subsequently however, efforts from private entities and universities have helped develop the network infrastructure, as it exists today. "The goals of ARPA's 'Resource Sharing Computer Network' project were to develop the technology for and demonstrate the feasibility of a computer network while improving communication and collaboration between research centers with grants from ARPA's Information Processing Techniques Office (IPTO)." (Press, 1996) J.C.R. Licklider of MIT undertook groundbreaking work in developing computer interactivity. Later, he implemented his vision though time-sharing systems-affordable interactive computing. The effort of the NSF also helped to distribute the features of this new networking capability to all major universities and research…
Ansari, Asim, Skander Essegaier, and Rajeev Kohli. "Internet Recommendation Systems." Journal of Marketing Research 37.3 (2000).
Bannan, Karen J. "Clean It Up." PC Magazine 20.16 (2001).
Beguette, Glenda, et al. Internet Content Filtering and Cipa Legislation. 2002. Available: http://lrs.ed.uiuc.edu/students/tsullivl/469Sp02/filtering.html. June 26, 2005.
Bell, Bernard W. "Filth, Filtering, and the First Amendment: Ruminations on Public Libraries' Use of Internet Filtering Software." Federal Communications Law Journal 53.2 (2001): 191-238.
All in all, Business Intelligence allows the company to better analyze the myriad of forces in the micro and macro environment and to make better informed decisions. It as such supports analytics, which in turn creates competitive advantages for the economic agent (Davenport, 2006), but it also creates internal strength and stability in the face of external pressures; it supports the processes of decision making.
Still, regardless of the benefits of Business Intelligence and Knowledge Management within the organizational setting, fact remains that the two concepts are more difficult to apply in practice than they are to define in theory. Otherwise put, economic agents face a wide array of challenges when actually implementing BI and KM in their institutions. Some of the more notable of these challenges include the following:
apid development of the IT community, which generates the need for continuous updates, maintenance, technology replacements and the adjacent costs…
Bardoliwalla, N.., 2009, The top 10 trends for 2010 in analytics, Business Intelligence and Performance Management, Enterprise Irregulars, http://www.enterpriseirregulars.com/5706/the-top-10-trends-for-2010-in-analytics-business-intelligence-and-performance-management / last accessed on September 22, 2011
Davenport, T.H., 2006, Competing on analytics, Harvard Business School
Loshin, D., 2003, Business intelligence: the savvy manager's guide, getting onboard with emerging IT, Morgan Kaufmann
Staples, S., 2009, Analytics: unblocking value in Business Intelligence (BI) initiatives, CIO, http://www.cio.com/article/489257/Analytics_Unlocking_Value_in_Business_Intelligence_BI_Initiatives last accessed on September 22, 2011
There are as many sentiment analysis techniques as there are reasons for conducting sentiment analysis. Analysis techniques are employed to discern sentence, phrase, word and text meanings, and predictive, machine-related, emotional and psychological aspects are measured by sentiment analysis as well. This literature review will attempt to navigate the various avenues presented by such diverse usage of sentiment analysis and provide information that categorizes and differentiates between the various techniques employed.
The review will focus on a number of different analytical techniques, including sentiment analysis, predictive analysis, text, phrase, sentence and word analytics, and why and how the different arenas approach the use of their specific style of analysis.
Sentiment analysis has been described as using a lexicon "with information about which words and phrases are positive and which are negative" (Wilson, Wiebe, Hoffman, 2009, p. 400) and as an analytical tool that "focuses on identifying positive and negative…
Ahmad, K. & Almas, Y.; (2005) Visualizing sentiments in financial texts? Proceedings of the 9th International Conference on Information, Visualization, Vol. 1, pp. 363 -- 368
Alpern, P. (2010) Forecasting the future with predictive analytics, Industry Week, Vol. 259, Issue 7, pp. 47-48
Chaovalit, P. & Zhou, L.; (2005) Movie review mining: A comparison between supervised and unsupervised classification approaches, Proceedings of the 38th Hawaii International Conference on Systems Sciences, Big Island, HI, USA
Chemla, E.; Mintz, T.H.; Bernal, S.; Christophe, A.; (2009) Categorizing words using frequent frames: What cross-linguistic analysis reveal about distributional acquisition strategies, Developmental Science, Vol. 12, Issue 3, pp. 396-406