Online Analytical Processing (OLAP) – Definition, Architecture and Functionality

OLAP Council (1997) define Online Analytical Processing (OLAP) as a group of decision support system that facilitate fast, consistent and interactive access of information that has been reformulate, transformed and summarized from relational dataset mainly from data warehouse into Multi-Dimensional Databases (MDDB) which allow optimal data retrieval and for performing trend analysis. OLAP is an important concept for strategic database analysis. OLAP have the ability to analyze large amount of data for the extraction of valuable information. Analytical development can be of business, education or medical sectors. The technologies of data warehouse, OLAP, and analyzing tools support that ability. Online Analytical Processing (OLAP) enable discovering pattern and relationship contain in business activity by query tons of data from multiple database source systems at one time. Processing database information using OLAP required an OLAP server to organize and transformed and builds MDDB. MDDB are then separated by cubes for client OLAPContinue reading

What is Expert System?

An expert system is an advanced computer application that is implemented for the purpose of providing solutions to complex problems, or to clarify uncertainties through the use of non-algorithmic programs where normally human expertise will be needed. Expert systems are most common in complex problem domain and are considered as widely used alternatives in searching for solutions that requires the existence of specific human expertise. The expert system is also able to justify its provided solutions based on the knowledge and data from past users. Normally expert systems are used in making business marketing strategic decisions, analyzing the performance of real time systems, configuring computers and perform many other functions which normally would require the existence of human expertise. The difference between an expert system with a normal problem-solving system is that the latter is a system where both programs and data structures are encoded, while for expert system onlyContinue reading

Distributed Data Processing (DDP)

Distributed database system technology is the union of what appear to be two diametrically opposed approaches to data processing: database system and computer network technologies. Database system have taken us from a paradigm of data processing in which each application defined and maintained its own data to one in which the data is defined and administered centrally. This new orientation results in data independence , whereby the application programs are immune to changes in the logical or physical organization of the data. One of the major motivations behind the use of database systems is the desire to integration the operation data of an enterprise and to provide centralized, thus controlled access to that data. The technology of computer networks, on the other hand, promotes a mode of that work that goes against all centralization efforts. At first glance it might be difficult to understand how these two contrasting approaches canContinue reading

Case Study: Management Information System at Dell

Management information system involves the information system and the organization. MIS begins where computer science ends. Computer scientists deserve accolades for developing and delivering even more advanced forms of information technology: hardware technology; software technology; and network technology. Yet because no technology implements itself, there is more to MIS than just information technology. MIS has dimensions. The four interrelated dimensions of MIS are as follows: First, MIS involves not just information technology, but also its instantiation; second, MIS involves, as reactive and inextricable elements, both an information system and its organizational context; third, MIS involves information technology as a form of intellectual technology; and fourth, MIS involves the activities of a profession or corporate function which are integral to the essence of what MIS is (Currie & Galliers, 1999). Dell Computer Corporation: Company Background Dell Computer Corporation is a major manufacturer of personal computers, computer peripherals, and software. Among theContinue reading

Case Study on Information Systems: Cisco Systems

Cisco Systems advertises itself as the company on which the Internet runs, and this San Jose, California, company does dominate the sale of network routers and switching equipment used for Internet infrastructure. Under the leadership of CEO John Chambers, it has been so successful that it even briefly became the most valuable company on earth in early 2000, reaching a valuation of $555 billion and a stock price of more than $80 per share. One key to its success is that Cisco uses information systems and the Internet in every way it can. However, by April 2001 the stock closed below $14, a decline of more than 80 percent, while the company value fell to around $100 billion. What was to blame for this precipitous plunge? What role did Cisco’s information systems play? Cisco was founded in 1984 by Stanford University computer scientists looking for an easier and better wayContinue reading

Software Development Processes

Software development processes are the structures or processes imposed on the development of a software product. To produce a successful and qualitative software product certain processes management criteria need to be considered. A process is a particular method of doing something, generally involving a number of steps or operations. A software development project will have at least development activities and project management activities. The development process focuses on the activities directly related to the production of software that is design, coding, and testing. Project management processes focus on planning, estimation, scheduling and taking corrective action when things do not go as per plan. Configuration management processes focus on change and configuration control, so that the correct, tested and approved version of software component are put together for delivery. The process management processes focus on the management and improvement of these processes. The four named processes will be discussed in detail;Continue reading