MIS 610

MIS 610 Topic 8 DQ 1 You have employed several commonly used database automation tools in your work throughout the course. Discuss which of these tools has proven to be the most useful overall. Provide your reflective analysis with support from your work, an industry example, or the Topic Materials. The last eight weeks has been a great experience for me, I learned a lot from the discussion questions. However, one important tool that proven to be the most useful for me is the study materia...

MIS 610 Topic 4 DQ2 Determinism of a function is one of several properties of user-defined functions that determine the ability of SQL to index results. When and for what purposes would you choose to use deterministic versus nondeterministic functions to arrive at your desired results? Justify your ideas with support from the Topic Materials or relevant industry examples. A deterministic function is one that will always provide the exact same result to you, whereas a nondeterministic funct...

MIS 610 Topic 6 DQ 2 Some consider SQL to be an ORDBMS due to several recently implemented features it provides, but most consider it an RDBMS. Oracle once touted itself as an ORDBMS in Release 8, but later retracted that statement in Release 8.1 (while retaining key desirable organizational features). What programs are actually considered “object based”? Select a specific program and explain both its functionality and advantages to a business. Justify your ideas with support from the Top...

MIS 610 Topic 5 DQ 2 Describe four key features of an object database management group (ODMG) and what makes this technology so appealing for so many different types of users. From those you previously identified, select the key feature you believe to be the most essential and versatile, and provide your predictions of how this specific feature will be or could be improved to make it even more useful in the future. Justify your ideas with support from the Topic Materials or relevant industry ...

MIS 610 Topic 6 DQ 1 Of the two object-capable data programming methods, what attributes of object relational design make it the more preferred method? Justify your ideas with support from the Topic Materials or relevant industry examples. Object-oriented database management systems (OODBMSs) combine database capabilities with object-oriented programming language capabilities. This allows object-oriented programmers to develop the product, store them as objects, and replicate existing obje...

MIS 610 Topic 7 DQ 1 Referring to the topic reading “Whatever Happened to Object-Oriented Databases?”, do you agree with the position that an object-oriented database is a niche market? Provide your assessment of the author’s stance, supporting your rationale with findings from the literature or relevant examples from the field First and foremost, object-oriented database management system (OODBMS), sometimes shortened to ODBMS for object database management system, is a database m...

MIS 610 Topic 7 DQ 2 Google and Amazon have done some amazing work regarding their database management systems. However, one of the constants is a lack of standardization. How do new DBMS products entering the market, such as graph databases, help or hinder companies trying to modernize? Justify your ideas with support from the literature or relevant industry examples. Data standardization is the critical process of bringing data into a standard format that allows for collaborative researc...

MIS 610 Topic 1 DQ 1 Describe the difference between static and dynamic embedded SQL. Provide two real-world examples of situations are most suitable to each of these procedural events along with a rationale for each. Something that needs to be before discussing static and dynamic embedded SQL is between compile time and run time. The time period to convert the source code to machine code is known as compile time. Tasks such as syntax analysis, semantic analysis, and code generation occu...

MIS 610 Topic 2 DQ 1 Review the Topic Material “Dirty Secrets of the CASE Expression.” Based on this article and the other topic readings, identify one limitation you could encounter in the workplace and describe strategies for circumventing it. Justify your ideas using support from the Topic Materials or relevant industry examples. One of the limitations that consists of Case Logic is that it can only use 10 levels. For instance SELECT CASE Title WHEN '1' THEN 'A' and so...

MIS 610 Topic 3 DQ1 Explain how a UNION function operates and how the resulting data is intended to be used. Discuss the weaknesses that exist, and strategies for making the process stronger to deliver a better end result. Justify your ideas with support from the Topic Materials or relevant industry examples. 4 posts Re: Topic 3 DQ 1 A UNION is a query/function that allows someone work with two SELECT statements and will carry over everything that is written within the query. UNIONS ...