Compare the characteristics of an operational database and a Essay

Compare the characteristics of an operational database and a dimensional database - Essay Example The data normalization for the operational database is required at a very high level to avoid the data redundancy. This type of databases is also referred to the â€Å"On-Line Transaction Processing† OLPT. This type of database is updated after every transaction and also represents the snapshot of a very current business situation. In an operation database, records are changed, updated, added and replaced. Relational model is used to compose operational systems with update and insert operations. Current databases are multidimensional, and technology is applied to distributed data. Large, complex, and high performance data is only facilitated by the dimensional database. For example, a sale manager wants to view the sale of a product for the particular region over a period. This is the dimensional view of data as higher dimensionality requires the high volume of data. The â€Å"On-Line analytical processing† known as OLAP enables the managers, analysts and professional to gain insight in view of information. An OLAP server supports the structures of the dimensional database. For dimensional databases, the multidimensional model is used to model the system. A company has multidimensional database of products, sales, finance, and employees. (IBM

Management Information System Research Paper Example | Topics and Well Written Essays - 750 words - 2

Management Information System - Research Paper Example Internet is the interconnection of networks across the world which connects computers to servers hence linking the billions of people around the world. The internet which begun in the 1970s has continued to experience tremendous growth in technology and clientele base. Internet is provided by the internet service providers which offer connection to designated internet domains. Sending of information though the internet is a complex process that most people who are not computer technocrats cannot understand. However, the simple explanation is that each computer has an Internet Protocol Address which is unique to that computer. Once information is sent through the internet, it has to be decomposed sending information to the designated address and then reassembled when it reaches the designation and the process is repeated over again with information sought. This process happens so fast that people do not even notice (Laudon & Laudon, 2014). Internet users connect to the internet through the three different domain name system: top-level, second-level and third-level domains. With each domain level, the information is narrowed down to the specifics of the information searched. The top-level domain includes government level, organizational level, and education among other which are abbreviated with .com or .org among others. It is at the third level that information is refined to the main search words. Some of the common internet services include emails, transferring files, having news groups and using the World Wide Web to send or retrieve information such as graphics and texts. The most common internet usage is the chatting and sending of instant messages commonly the social media (Abbate, 2000). The internet with all its glory and numerous advantages also has its own disadvantages. People have the freedom to load in any information on the internet which can then be accessed by others