Information Systems in Business free essay sample

List of the databases in which data about you exists †¢Flat- file data bases. The flat file databases are used to store small amounts of data that is required to be edited by the hand. They are made up of files strings that combine one or more files and they are effective in storing simple data lists but they become complex if the data structures are replicated. Flat file databases require a simple approach to the methods of storing data, therefore if complex data types are stored, the file become unreadable for the individual using the data bases. Many companies use the flat file data bases in storing their data since they are easily assessed and edited (Matthias, 2003). †¢Server databases The server databases uses the Internet and it is easily accessed by the clients at any time, for instance, 24 hours, one week. The clients are able to access the websites in order to retrieve the data. Server databases are applicable to many companies that require to make applications and communications on data issues anywhere in the world. Server databases have a special feature that allows the clients to provide specific data requests from the database and then it is the responsibility of the database to perform the function (Matthias, 2003). †¢Relational databases An example of a rational database includes the SQL server databases. These types of databases uses a logical formulation in the processes that they store data. For instance presentation of tables in data storing where by each field is described by a certain character. The realtions in the databases are described when the characters are linked with one another. many companies uses the relational data,bases since they are effective when they are designed propely and therfre resulting to clear data analysis without any duplication (Bing, 2011). ii): Make a list of the databases in which data about you exists. How is the data in each database captured, updated and how often? What data privacy concerns do you have? Explain briefly. Data sources are defined by their portability mechanisms and the independent approaches that enhances the connection of the databases. There are different types of data sources and they are introduced to define a certain database. An application can be used to define different types of database by changing the components of the data source. There are three different types of data sources, managed data sources,native data source and operational data sources (Pang,2001). †¢Managed data sources Managed data sources define the approaches used in error handling mechanisms, connections pooling as well as global transaction management. Since they are applicable on global transactions they are usually updated on daily basis. A managed data source in a data warehouse provides all the implementation mechanisms and interfaces that are issued in the data source. The warehouse can be able to use the managed data source in the participation of global transactions (Pang,2001). †¢Native data sources Native data sources are significant in the warehouse interface and are provided by the vendor’s sich as oracle. The native data source are different from the managed data source since the connections cannot be retrieved in global transaction. They are updated with several approaches depending on the information to be retrieved. Operational data sources All operational data sources applicable in a warehouse are used in the management of data in different sectors. The data sources are retrieved through the application of connections that enhance the operational process of data retrieving and enhancement effective. In a datawarehouse basis, information of data is retrieved from more than one ideal source therefore the application of the operational data source defines different strategies of connection to effectively define a certain data. ii): Using your company of choice example from above, explain the type of decision support that thecompany can benefit from implementation of a data warehouse. Within this context, what would bethe role of data mining? Decision support systems are important computerized information that enhances the strategies that are used in decision making (Power, 2002). The decision makers are able to use the networking communication technology, data information and other models to enhance the approach of decision making. Decision support systems are significant in the company since they provide information on graphical approaches and include expertise application on artificial intelligence (Power, 2002). BLM Company is entitled to use the communication driven decision support system that has a responsibility in targeting internal patterns. The importance of the communication driven decision support system is to enhance individual collaboration. The technology that is applied in this type of decision support system includes the client services for instance, instant messaging. Role of data mining †¢analyzing Data mining softwares are important in analyzing data from different perspectives (Bing, 2011). It analyses, categories,summaries and indicates the relationship that occurs in a given data. Data mining procedures are effective since they analyses the total components that the user wants prefers effectively. †¢Determination of valuable information Data mining is defined as the processes that are used by data software to analyses, summaries useful content. Data mining provides all the knowledge that is required to uncover certain figures related with information retrieval for several applications. In such cases, cross tabulation information, decision trees applications can assist in the retrieving of certain valuable information. QUESTION 2: Enterprise Content Management (ECM) helps companies to capture, organize and analyze particularly unstructured content to deliver better business. ECM technologies cover a broad set of capabilities. With the help of examples name and briefly explain three of such capabilities. †¢Document management capability Every department in an organization is conversant with document management capabilities. The role of ECM In most of the organization is to assist the organization on the approaches associated with document management through the introduction of policies that requires documentation cycle. ECM applies centralized methods repositories that enhance the mechanisms of discovering the information effectively and therefore the set policies enable tracking of information in the organization through the application of bar codes and labels(Handy, 2009). The centralized mechanisms have ensured that storage and protection of informations against any unauthorized use, hence they offer security on information. Record management capabilities Record management capabilities has been known as a secondary task, strategies that are associated with this capability include, the requirements on clear records assignments within the departments. Record management capabilities ensure that records are well updated in the organization to ensure that the organization maximizes transparency. The record management capabilities provides the managers with an opportunity to set up the records according to the organizations filing plans. †¢Web content management capabilities The development of web content management capabilities ensures that the organization is able to communicate effectively with employees and customers. Web content management capabilities ensures that the organizations is in a position to manage different sectors for instance multilingual Internet sites and mobile services while it ensures that these sectors are effectively updated. Summary of the findings IBM is a worldwide known company that applies the enterprise content management with software application. They provide semantic data management software within the organization. Question 3 Write the lecture summary relating to Week 9 – Topic: Data Warehouse and Data Mining data warehouse Companies are entitled with different sorts of information. The traditional methods of data storage include, invoices, sales and distribution were developed by many companies and it was a hard task that required a lot of computing producing biased and inaccurate information. With the recent innovations of technology and information systems data management and warehousing has become an easy process (Michael, 2009). The effective use of Data warehousing provides an approach of combining all the information that is required by the company. Data warehousing includes the application of all the companies data storage and the retrieving of any information is made easy. Data warehousing is made effectively through the strategies that are associated with the retrieving of information for instance, the selection process of a certain area to retrieve the data, keying of individual as the subject matter and any data information is retrieved and the group team of the organization develops extraction programs. Data warehousing is applicable in coordination of information and copying of data within the organization and outside the organization(Michael, 2009). Trusting data sources. Data warehouse is subjected with different departments with a large number of data sources from the external departments. An organization can lack the control on the quality retrieval of data into the data warehouse, and sometimes it can be a difficult process to access how the data is refreshed. The data sources used by the organization are diverse; therefore there is the need to determine strategies that can be applied in trusting data sources. Tools The tools include the simple reporting query tools which are used to tell us what has happened. On-line analytical processing gives a reason of the happenings †¢executive information system extracts information on the users who want to mess with the data warehouse †¢ data mining processes includes the all the statistical techniques that are advanced with intellectual research properties. Data mining components include, cross z softwares and the IBM . The architecture- centralised or distributed. If the data is termed as centralized then it means that only one database is applicable to a specific hardware for the access of all users. QUESTION 4 Features and tools in face book The features and tools in facebook have different importances on the representation of the companies, public figures, bands. They are the key tools of the entities and they include pages and the profile subscribers. †¢The pages Pages are used to represent company’s public figures, bands. The pages can be applicable to †¢Profiles with subscribe Profiles with subscribe consists of the strategies that an individual uses to subscribe to another person. In this case the profile with subscribes are used by multiple individuals and they include, news feed, find friends Entity attribute value model(EAV) Entity attribute value model is a data model that is used to define entity where by the parameters and properties are used to explain them. The number that is used to describe each entity is relatively modest. This model is also known as the space matrix model. Structure of an EAV table The data that is represented is defined in a spacious approach that is capable of storing the entire space matrix that is composed of occupied values. In the EAV model each parameter and property describes the entire entity and each row that is represented. In EAV model, it stores a single component. The EAV tables are also described as long and skinny in which the long strategies describe a specific number of rows while the skinny description defines the number of the columns (Michael, 2009). Data in EAV table is recorded and retrieved in three columns, entity, the parameters and the values. The entity colum defines the item description and the parameter column defines the attribute characters for instance, name, and ID and the value define the attributes.