Information Systems in Business
QUESTION 1: 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). •
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). •
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.
iii): Using your company of...
Please join StudyMode to read the full document