Discussion 1 :
The incorrect implementation of databases ought to purpose demanding situations for the entire device. An instance of a database that has been carried out poorly is one which has redundancy. Depending on the number of statistics that the agency is anticipated to have or hold, the corporation wishes to have the surroundings setup enjoyable the needs of the requirement. In these days’ global, there are many alternatives to store our statistics. As an instance, the cloud database, which runs on the cloud computing platform and is provided as-a-service. Relational databases are designed in this kind of way that each object represents one and simplest element, so there have to keep away from duplication
I would really like to explain a scenario wherein the role of the database performs a key role. Wrong designing and implementation of databases machine can reason many challenges and provide now not so properly paintings experience. For instance, a database designed poorly is one that has redundancy. As an instance, in some instances in which statistics fields are identical for diverse factors within the identical desk and all through updating of this fields can create manual mistakes or device error, that allows you to end up presenting a non-preferred end result. Extra error prevalence can result by way of guide mistakes and in this situation data admin who controls a database and does now not have centralized facts manipulate, and which results in pointless duplication. Therefore, redundancy can be prevented or reduced by way of having centralized information manage, wherein insertions and statistics up to date may be monitored to avoid duplicates. The other technique that removes redundancy is normalization because it gets rid of data duplicates from the tables. Alongside those, repetition may be stayed away from or reduced by using having brought together database manipulate, wherein inclusions and information refreshed can be checked to keep away from duplication. We have been getting mismatched information referring to the credit score report of the patron coming from the 0. 33-birthday party source. Consequently, I would really like to conclude that databases have to implement in each group, be it electronic or guide facts, make certain facts integrity and security of records.
Refs:
Andelman, S. J., & Fagan, W. F. (2000). Umbrellas and flagships: efficient conservation surrogates or expensive mistakes?. Proceedings of the National Academy of Sciences, 97(11), 5954-5959.
Bernheim, R. G. (2016). Public Engagement in Emergency Preparedness and Response. Emergency Ethics, 155-185. doi:10.1093/med/9780190270742.003.0005
Discussion 2 :
Designing and architecting a database in a proper way could reduce the problems that come during the development and deployment process. Any small type of mistake in database design would give a lot of pain to the DBA’s, developers and managers alike. In the following discussion, I will be discussing the common mistakes that we went through in my experience at the workplace. Following is the sample list of some problems that we usually encounter with database in any work environment and some of them personally experienced at my work such as poor design or planning, ignoring normalization, improper documentation, lack of naming standards, holding all domain values in one tables, using identity columns as the only key, not using SQL utilities to protect data integration, not using stored procedures to access data, lack of testing etc. Few of the problems from the above list are elaborately presented down and solutions towards them.
Poor Naming Standards:
The names we choose now is not just to identify the purpose of an object but to allow the future programmers to understand the intention of what data it stores. By naming the tables, columns with good naming standards will allow future users to understand its significance easily by avoiding them to go through the large documentation.
Didn’t used stored procedures to access the information(Data):
Stored procedures are very friendly and should be used whenever possible as a flow to insulate the database layer from the users of the data. Initially, it would take more time to set up. Stored procedures make database development much cleaner and allow the ease between the database and functional programmers to perform collaboratively. Some of the other significant reasons for using the stored procedures are maintainability, encapsulation, security, and performance.
Holding all domain Values in one table:
Relational databases are based on a basic idea that every object represents one and only thing, so there should never be any confusion what data it refers to. From column name to table name and to table name to primary key, all the relationships should be traced and should know exactly what the piece of data means.
Above are some of the problems I dealt in my experience, We rectified them accordingly at the end of the day but we lost a large amount of time in correcting them that also includes modification of database design and updating the inconsistent data in the tables to stabilize the web application from the errors and exceptions.
References:
Kam, Davida, “Structured Design of Substitution-Permutation Encryption Networks”, Computers IEEE Transactions on, vol. C-28, no. 10, pp. 747-753, 1979.
David B.Stewart. (September 2001). Twenty-Five most common mistakes with real-time software development presented at Embedded Systems Conference, Boston.
Louis Davidon. (26 Feb 2007). Ten common database design mistakes retrieved from https://www.red-gate.com/simple-talk/sql/database-administration/ten-common-database-design-mistakes/
Discussion 3 :
Since the database is the foundation of basically every business adventure, if you don’t set aside the opportunity to plot the prerequisites of the assignment and how the database will meet them, by then the chances are that the whole undertaking will veer topsy turvy and lose heading. Moreover, if you don’t take the time toward the start to get the database setup ideal, by then you’ll see that any critical changes in the database structures that you need to make. Names, while an individual choice, are the first and most basic line of documentation for your application, which is the prerequisite for consistency. The names you pick are not just to engage you to perceive the purpose behind an inquiry, anyway to allow each future programming engineer, customers, and whatnot to quickly and successfully perceive how a section some bit of your database was relied upon to be used, and what information it stores.(Card,1998) I indicate here some relevant examinations where wrong database usage results in huge messes up for some real media substances.
Pinterest coincidentally informed a couple of customers applauding them on their best in class weddings and offered an uncommon on wedding solicitations. Be that as it may, countless women weren’t getting hitched, and some of them were truly single. A substantial number of the discouraged recipients took to Twitter to share the wrong email. An association agent issued an outflow of regret refering to horrible information and that they were tragic they tumbled off amazingly pretentious on each and every social medium stages. Information gathering is a two-way road, helping an association better adjust and serving altered encounters to customers. We should not let poor information, tricky amassing or nonattendance of due consistency make an information memory the web will never delete.(Davidson, 2007)
For another situation contemplate, Many of CNN’s PC delivered interactives and designs for their live event incorporation are energized by information examination and for this circumstance no doubt the information was too much cheerful. In the midst of a give insights about the decision, CNN demonstrated an information that showed that 110% of Scotland’s populace had been reviewed. As demonstrated by the database, 58% of Scots had said Yes and 52% casted a ballot No. The information was plainly off on the total voter rate, yet it was in like manner off course about the manner in which that the bigger piece of Scots truly casted a ballot No. CNN revived their database later to a progressively exact one exhibiting 52% casting a ballot No and 48% casting a ballot Yes, yet the damage was by then done. Consistently check and twofold check your database plan and don’t just anticipate it’s exact.(Davidson, 2007) Playing out some basic information quality checks already demonstrating data may infer that you don’t hit the remote transmissions first, anyway in any occasion you’ll get the job done perfectly.
Davidson, L. (2007). Ten normal database configuration botches. Straightforward Talk.
Card, D. N. (1998). Gaining from our oversights with deformity causal examination. IEEE programming, 15(1), 56-63.
Andelman, S. J., and Fagan, W. F. (2000). Umbrellas and leads: productive preservation surrogates or costly missteps?. Procedures of the National Academy of Sciences, 97(11), 5954-5959.
Guz, S. (2011). Fundamental oversights in database testing.
Discussion 4 :
According to Charette (2015), individuals and business organizations use computers for various purposes. Some of the uses that organizations computers for is storage for personal and business files, entertainments and executing business functions using specific applications and software that are meant for particular purposes. Sometimes, however, they get frustrations from this computer due to unexpected processes like a computer crash, data loss or any other technical problem that effect the function of the network. It means therefore that the user of the computer might vital documents and file that are most sensitive to him or her or the organization. One of the causes for the abnormalities with the machines is a database that is improperly implemented (Ives & Schneider, 2014). A poorly implemented database usually leads to loss of data /information stored on the computer hence frustration to the user.
An example of a poorly implemented database is SOX. The entire approach of SOX is flawed, and it is technically challenging to understand the history of the SOX. Looking SOX from the perspective of information security, SOX is vague (Charette, 2015). An audit of this process concentrates on ensuring that all the regulations are enforced appropriately such that it cannot access the fraudulent MO. There is no single victim found trying to commit fraud by hacking passwords on a production database can testify to have broken the rules after a review of the logins are revisited (Ives & Schneider, 2014). This database can easily be compromised since hackers/intruders can easily bypass all the tedious processes and controls in trying to access a computer system. They do so by obtaining a valid password through an exploit or static files in the backup orany other means that can permit them legitimately log in to the system. To harness the challenge posed by SOX, it is essential to install a proper 24/7 hours surveillance cameras in your facility, and security software for your computer systems (Ives & Schneider, 2014).
References
Charette, R. N. (2015). Why software fails [software failure]. Ieee Spectrum, 42(9), 42-49.
Ives, B., Walsh, K. R., & Schneider, H. (2014). The domino effect of password reuse. Communications of the ACM, 47(4), 75-78.
Discussion 5 :
Planning and controlling a database has more work involved than just installing the database, where various moving pieces and parts are involved as well as all these pieces are not controlled in a dedicated way, one may notice the system, which is very less efficient that it was designed to be. A proper naming standard should be followed in naming the databases in order to avoid confusion as well as the duplicates. Reference information should not be placed in multiple locations and also the application code. All the databases should have clean and clear documentation, which explains all of its multiple parts, including the variations, which were made at the later time. SOX can be considered as one of the examples of the imperfectly executed database. Poor execution of the database with various mistakes due to which misinterpretations may happen, due to which the complete approach of SOX is defective (Laudon & Laudon, 2016). Many have found this to be indistinct. SOX are generally associated with privacy policy when compared to the illegal activity. During the hiring period, one should be extremely careful so that the illegal activity can be avoided in the software databases.
The feasible choices to avoid the poorly executed database troubles would be using the meaningful and correct database and column and table names and also one should make sure that the width of the column should be increased to fit the complete information (Levene, 1992). Referential uprightness should be implemented in the execution of the important foreign key relationships, which should be strong as needed.
Reference:
Laudon, K. C., & Laudon, J. P. (2016). Management information system. Pearson Education India.
Levene, M. (1992). The nested universal relation database model. Berlin: Springer-Verlag.
Discussion 6:
As industry needs change the focus on safety progress furthermore, the view of data storage including analytics alternatives is developing more complicated. A Knowledge centric methodology in the IT setting would be depicted by a conscious exertion to dole out data ideally than giving information (Harris, 1996). Most of the general issues faced by the user of the SQL Server database are degradation of production, which has an adverse influence on the operation of the SQL database. It is essential to control both the tools and software parameters to limit any SQL Database execution issues. The principal thing that user wants to do after encountering any performance problems is to find a reasonable cause to know the problem ultimately. Some of the issues can easily be fixed while other issues may need time to adjust. Before fixing the issues, the user needs to understand the signs first. Some of the basic problems linked with CPU, memory, system and I/O bottlenecks and slow SQL queries.
Problem Related to CPU
The inadequate device resources can guide to problem in CPU. The user need to recognize the SQL Server Instance who is spending most of the CPU. Occasional high usage of the processor cannot be handled as a serious problem and can overlook. However, if the question seems very often, research over the issue is required. In this position, adding extra processors may not be effective. Therefore, the solution is installed proper Question Assignment tuning, fix the performance plan also reconfigure the individual system to fix the problem. It is prudent to keep a dedicated server to control the SQL Server only, and no additional applications should be present.
Furthermore, Speed is an essential part of the usability of a website. To engage its users, any application or website need to run fast. The overall execution of any app is mainly dependent on database execution. Database optimization includes maximizing the speed also ability with which data is recovered. Indexing is an efficient approach to tune your SQL database that is usually neglected throughout development. In basic terms, an index is a data structure that increases the speed of data retrieval works on a database table by implementing rapid random lookups also effective access of ordered records. Setting up indexes usually doesn’t need much coding, but it does take a moment of thought (Elmasri, 2011).
References:
Harris, D. B. (1996). Creating a knowledge centric information technology environment
Elmasri, R., & Navathe, S. B. (2011). Database systems (Vol. 9). Boston, MA: Pearson Education.
