1. A database is a collection of information put together and is quickly and easily accessed, updated and managed. When designing a database make sure that it performs all important functions without hitches, quickly and correctly.
First time when Alexandria Training College database was developed, the designer had made mistakes that were not realized when it was online. When students started accessing the database, they had very hard time to get the information they wanted. The data were scattered everywhere and unorganized. Other information was half presented and another missing. The database was much and unnecessary complex and it was exposed to hacking. To make it worst, it displayed user’s private information and it was very tricky and inconsistent (poly interpretable). The information to be accessed was hidden from the rows and columns hence, was not following sequences.
The database was so slow and hard. Furthermore, it was inflexible and the students were totally unable to access other information. Looking at the database, one could tell that the designer had done a lot of unnecessary things instead of a simple and easy task.
Possible cause of poor database implementation.
a. Bad design. Bad designing of database lead to poor and abnormal performance. The table indexes are messed and some cannot be fetched to give information.
b. Professional mishandling. When the designer fails to monitor database, and assume that everything is perfectly working. They failed to check error alert and do common corrections.
Answer:
2. Database is a collection of data which is stored in structural format. It is used to store the data and retrieve the data whenever we want. When a new data comes to the database then it will store or update the information in the relevant table. Databases are present in large mainframe systems as well as small systems. Nowadays every application is depends on the database. Every piece of information was storing in database for future usage. Most of the databases are storing the structural data. Database was started in 1960s. In 1960s there is a hieratical and network database. In 1980s there is an object-oriented databases and nowadays we are utilizing SQL, cloud and NoSQL databases. In this discussion I am discussing about very poorly implemented database, reasons for the problems and solutions to them.
Very Poorly Implemented Database
I faced problem with poorly implemented database in my organization. I worked in testing team. Our company recruited new staff for designing database to this project. They had designed the database for this project and given Project development team developed an application for one of our firm clients related to sales. While we tested the application we observed that data is not properly inserted into the relevant tables. In this application one table is depends on other tables such as order table, sales table, customer details, review rating tables etc. are depends on each other. When a consumer purchased the product the details was not uploaded into the sales details. It is only updated in order details. When we track the sales details in the application it not showed the previous order details. Product count also not decreased. I saw the database, database designers were not followed proper naming conversion in the database design. It leads to complications in the new updates of the application. There is not a foreign key in the tables which are having the relevant data of other table.
Reasons for the problem and solutions to the problem
Reasons for the problem
Database designers not having the knowledge of naming conversions, relation between tables and they does not have the proper idea about the application. The database administrator not trained the database design staff about the rules and regulations in the development of the database such as naming conversions, understanding of the application and data, how to create foreign key to connect the related tables.
Solution for the problem
Database designers or developers should clearly understand the purpose of the application and data flow in the application to develop the perfect database. Bad practice of the database leads to explore the sensitive data of the consumer because every details of the consumer stores in the database. So, in the designing phase database developer or designers should understand the purpose of the data in the application. Naming conversion is very important to database (Louis Davidson. 2017). It can give the clear idea about the database to the new staff when new staff working on new update of the application.
Answer:
3. Most of the cases database design is done right, then there will be a bit trouble in development, deployment, and performance issues in production whereas good database design just works with no issues. If there is a small mistake in design every member in a project will get an issue. Change control isn't only for application advancement. Database patterns require change control as some other segment in your IT association. Database diagrams like tables, segments, data types, functions, etc., aren't static and will normally change the shifting needs of the association. As an organization targets new markets extends its goals or adjusts a line of business, its database must have the capacity to help these undertakings, which here and there implies changes to the database. The main trick is to fix the issue carefully. If we don’t have a chance to fix the issue we have to run database patterns into an unnormalized condition which may result in high usage of disk and cost. We might have a chance to create triggers, but it results in data corruption.
From my experience, I can list out the lagging factors like designing, naming standards, documentation, domain values, identity keys, SQL factors, stored procedures to access data, generic objects, and finally testing. If all the above factors work well then there will be no major issues with the project or a computer. Today generation mostly depend on data producers as virtually any person can generate data through sharing tables, social applications like Facebook, Twitter, Instagram, etc., and a wearable device like Fitbit. The main Challenge for database group is to upgrade algorithms and incentives levels that guide people and share the most useful data and to maintain the data in privacy.
Many people today are data producers, as virtually anyone can generate a torrent of data now through the sharing of tables, the use of mobile phones, social platforms and applications (e.g., Facebook, Twitter), and an increasing collection of wearable devices (e.g., Fitbit). One key challenge for the database community is to develop algorithms and incentives that guide people to produce and share the most useful data while maintaining the desired level of data privacy
Conclusion:
For every few years, a group of database researchers meet and have a meeting regarding research, new versions, directions. This report summarizes that Big Data is competing with the database, so they were in a plan to give multiple opportunities to make a transformative impact. So, the main ideas are on five research areas like fast data infrastructures, data management landscape, end-to-end processing and understanding of data, cloud services, and managing the diverse roles of people in the data cycle.
Answer:
4. What many people don’t know is that Android and Linux are families and they operate under the same kernel. The Linux family started developing OS for laptops and desktop in 1991 and in 2011 part of development was sold to Google who is the developers of mobile OS called Android.
Android is now owned by owned by Google, Inc. and it is an open source operating system likewise, Linux is also an open source operating system developed by Linus Torvalds under the GNU project.
Although Android was created based on Linux 2.6 kernel, it only supports two types of architecture, viz x86 and ARM whereas GNU/Linux OS has gone through a lot of changes and upgrades and support a lot of architecture including both viz x86 and ARM which is commonly used by pc while Android create OS for mobile phones.
Both Android and Linux have been able to release several versions with different flavor and name which include Froyo, Gingerbread, and Honeycomb for Android and Debian, Ubuntu, and Knoppix for Linux. Every version includes an upgrade of features and bug fixing. While Android is able to upgrade via OTA (over the air) Linux is so limited and can only be upgraded manually. Android most deals with touchscreen gadgets while Linux mostly deals with physical keyboard gargets like desktops.
Having been in the market for a long time, Linux has developed OS for televisions and latterly, android seems to be inventing and venturing in this field too when they developed a set-top box that acts like decoders with a digital power to stream tv to a pc
Answer:
5. What many people don’t know is that Android and Linux are families and they operate under the same kernel. The Linux family started developing OS for laptops and desktop in 1991 and in 2011 part of development was sold to Google who is the developers of mobile OS called Android.
Android is now owned by owned by Google, Inc. and it is an open source operating system likewise, Linux is also an open source operating system developed by Linus Torvalds under the GNU project.
Although Android was created based on Linux 2.6 kernel, it only supports two types of architecture, viz x86 and ARM whereas GNU/Linux OS has gone through a lot of changes and upgrades and support a lot of architecture including both viz x86 and ARM which is commonly used by pc while Android create OS for mobile phones.
Both Android and Linux have been able to release several versions with different flavor and name which include Froyo, Gingerbread, and Honeycomb for Android and Debian, Ubuntu, and Knoppix for Linux. Every version includes an upgrade of features and bug fixing. While Android is able to upgrade via OTA (over the air) Linux is so limited and can only be upgraded manually. Android most deals with touchscreen gadgets while Linux mostly deals with physical keyboard gargets like desktops.
Having been in the market for a long time, Linux has developed OS for televisions and latterly, android seems to be inventing and venturing in this field too when they developed a set-top box that acts like decoders with a digital power to stream tv to a pc
Answer:
6. An operating system is the system software that manages computer hardware as well as other software and facilitates providing common services for computer programs. Today there are numerous computerized operating systems loaded on our computer or phone devices, each has their own platforms, services, user interfaces and performance levels. Following is the discussion on two of the operating systems: BeOS Journaling File System and UNIX.
BeOS operating system was developed in the year 1991 by Jean Louis Gasses when he left the Apple computers. The operating system at that time features radical technology, for it was designed as an efficient, lightweight, multithreaded system that facilitated multitasking. It was very fast even on mediocre hardware and was able to be compatible it any processors on the computer. One of the prominent features included in this operating system is the file system. It is known as BFS – BeOS File System, which includes 64-bit journaling file system that uses file metadata. The ability of this system to give query and sorting against the file metadata gave the system database like quality, which is similar to WinFS in Windows 8. Its 64-bit address space provided the system a theoretical ability to facilities huge volume of more than 8 exabytes and files over 30 GB, provided that at the time 30 GB hard drives were not common. The system has the ability to provide high-quality streaming read performance, query and write access as well as storage with quicker recovering ability in case of failure. All this happens because of the BeOS’s focused multithreaded core. It is pertinent to mention here that this operating system did not go well with the markets for commercial use, but there are still a small group of people who are enthusiast about it.
The operating system is that has been in use for more than three decades. The system erupted from the ashes in 1960 in a failed attempt. The developers; however, did not give up and developed a system that provided a work environment described as “of unusual simplicity, power, and elegance.” The system is not flexible as other operating systems in the market, for it requires strict and well-defined hardware machinery that too works only on the specific CPU machines. Unlike another operating system, Unix OS is not a freeware and hence its source code is not freely available, additionally, it is not customizable and no modified versions of the system are available. It is, by and large, is costlier than other operating systems due to this reason is preferred by companies running huge data servers. Some of the advantages of this operating system are as follows:
· It can be installed on many computers, such as mainframe, supercomputers, and micro-computers;
· Unix is stable and does not go down and thus requires less maintenance and administration;
· It has better built-in security and permission features;
· It is a leader in serving the Web, for about 90% of internet relies on Unix system;
Answer:
kkthota87
ReplytoDiscussions1.docx
0
