Bridging the Knowledge Gap between Transactional Databases and Data Warehouses

Normal 0 false false false EN-US X-NONE X-NONE Data warehouse is widely recognized in the industry as the principal decision support system architecture and an integral part of the corporate information system.  However, the majority of academic institutions in the US and world-wide have been slow in developing curriculums that reflect this reality.  This paper examines the issues that have contributed to the lag in the coverage of data warehousing topics at universities.</p

A Framework for Collecting and Defining Requirements for Data Warehousing Projects

In this paper we address the issue of failure of data warehousing projects due to inadequate requirements collection and definition process. We describe a framework that can help accomplish the objective of developing a business-driven, actionable set of requirements. The framework consists of a series of steps to facilitate collection and definition of requirements in data warehousing projects. The paper also addresses the difficult yet common issue of end-users’ limited availability during the requirements collection process and proposes an approach that can serve to alleviate this problem

Teradata University Network: A No Cost Web-Portal for Teaching Database, Data Warehousing, and Data-Related Subjects

This paper describes the value that information systems faculty and students in classes dealing with database management, data warehousing, decision support systems, and related topics, could derive from the use of the Teradata University Network (TUN), a free comprehensive web-portal. A detailed overview of TUN functionalities and content is given. Freely available resources, such as software tools, large corporate data sets, case studies, and exercises are detailed. Various ways in which the TUN resources can facilitate teaching and learning processes are discussed. The zero-installation, zero-maintenance, zero-cost TUN paradigm is explained

Employing a Multilevel Secure Approach in CRM Systems

This research shows how Multilevel Secure (MLS) data models can be used in a Customer Relationship Management (CRM) context. MLS models were originally developed as database models for the management of information in environments characterized by a strict hierarchy of security levels, such as military institutions and government security agencies. Improvements in evolving database technologies have made MLS data modeling practical as well as theoretically appealing. This paper illustrates how an MLS model can be used as a part of the technology for coordinating business-customer interactions with the objective of building long-term customer loyalty. Several examples are used to show how organizing a database management system based on MLS principles can be used to help businesses provide consistent and appropriate content to various customers and partners. Improvements in flexibility and cost of applications, as well as opportunities for new CRM strategies, are discussed as potential benefits of integrating MLS and CRM technology

Process and Data Logic Integration: Logical Links between UML Use Case Narratives and ER Diagrams

We propose a methodology for providing clear and consistent integration of the process and data logic in the analysis stage of information systems’ development lifecycle. While our proposed approach is applicable across a variety of data and process modeling schemas, in this paper we discuss it in the context of UML use cases for process modeling and ER diagrams for data modeling. We illustrate our approach through an example of modeling an execution of a retail transaction. In our example we integrate a step-by-step processmodel and the corresponding data model at the attribute level detail. We discuss the potential benefits of this approach by illustrating how this methodology, by providing a critical link between process and data models, can result in better conceptual testing early in the analysis process, ensuring better semantic quality of both process and data models

The 360° Performance System in Team Sports: Is It Time to Design a “Personalized Jacket” for Team Sports Players?

Elite performance in team sports attracts the attention of the general public. In particular, the best players became incredibly skilled and physically powerful, which is a fact that potentiates the delivery of a product that is considered attractive, exciting, and competitive. Not surprisingly, this is a very valuable product from an economic and social standpoint; thus, all sports professionals are extremely interested in developing new procedures to improve their sports performance. Furthermore, the great interests of the various stakeholders (owners, chief executive officers (CEOs), agents, fans, media, coaches, players, families, and friends) are one of the main reasons for this development under the sports science umbrella and the accompanying sports industry. All their personal performances should be coordinated and put into practice by the sports team. In this scientific and applied study, we primarily dealt with the individual treatment of players in order to improve their personal performance and, consequently, the team’s sporting performance

M-Commerce: Analysis of Impact on Marketing Orientation

This paper analyzes the potential ramifications to the field of marketing and changes in the market due to the advent of Mobile Commerce (M-Commerce). M-Commerce has been defined as a process of conducting commercial transactions via a “mobile” telecommunications networks using a communication, information, and payment devices such as a mobile phone or a palmtop unit. This paper analyzes the opportunities that various characteristics of the M-Commerce model bring to the field of marketing. In particular, the paper investigates the likelihood of emergence of mall-like zones that are based both on the geographical proximity of services and goods providers and the use of mobile communication devices. Such zones have a potential of becoming the basic units for any marketing analysis of M-Commerce scenarios. As M-Commerce attains maturity, the zones could become the fundamental parameter in marketing evaluation. 1