SYM-408 WK3 DQ2. 150 WORDS OR MORE
Discuss techniques for storing JavaScript Object Notation (JSON) documents in the database engine in relation to the corresponding techniques for XML.
REPLIES. 75 WORDS OR MORE
A Trevor Stoutt
A technique for storing JSON in the database engine is to use a NoSQL database, such as MongoDB, that is specifically designed to store JSON data. NoSQL databases allow for flexible and scalable storage of JSON documents and provide fast query performance for JSON data.
Another method for storing JSON in the database engine is to use a relational database, such as MySQL, and store the JSON data as text or binary data. This method is useful for applications that need to integrate with existing relational databases. However, it can be more difficult to query JSON data stored in a relational database, as it requires parsing the JSON data (n.d.).
JSON and XML have some similarities being that both languages can be parsed, self-describing, and are hierarchical when it comes to the data values. JSON is unlike XML because it is shorter, easier to write, and is not as difficult to parse. Parsing is the biggest advantage that JSON has over XML since XML has to be parsed with the XML parser while JSON can be parsed with standard JavaScript functions (n.d.).
B Nicole Snipes
When it comes to the techniques of storing between (JSON) which is JavaScript Object Notation and XML for a database there are a lot of differences concerning corresponding techniques between the two database engines. JSON or JavaScript Object Notation is a lightweight data-interchange format with independent language, which is based on JavaScript programming language and is amazingly easy to understand and generate. While XML or Extensible Markup Language is designed to carry data and not display data, it is a markup language that defines a certain set of rules for encoding documents. The very vast difference between the two databases is that one is JavaScript Object Notation, and the other is Extensible markup language. Also, one derives from JavaScript while the other is from SGML, representing objects while the other uses tag’s structure to represent data items. Another significant difference is that JSON is less secure while XML is more secure than JSON which can also support comments while JSON can’t (GeeksforGeeks, 2019).
C Joshua Victor
Some of the techniques for storing JavaScript Object Notation (JSON) documents in the database engine in relation to the corresponding techniques for XML include:
· JSON documents can be stored in a database as a text or varchar data type. This is similar to how XML documents can be stored as a text or CLOB data type. However, storing JSON as a text or varchar data type may limit the ability to search or query the data effectively, as the database engine cannot directly process the JSON document’s structure.
· Some database engines support JSON-specific data types, such as JSON or JSONB in PostgreSQL, which allow the database engine to parse the JSON document’s structure and store it more efficiently. This is similar to using XML-specific data types, such as XMLType in Oracle, which allows for more efficient storage and processing of XML documents.
· Some database engines allow JSON documents to be stored as a binary format. This approach enables faster querying and indexing of the JSON documents, and it is similar to the binary storage approach used for XML documents in some databases, such as the XML datatype in Microsoft SQL Server.
· Some database engines, such as PostgreSQL, allow for the creation of hybrid data models that combine relational data with JSON documents. This approach is useful when you need to store structured data that has some variability or when you want to take advantage of the JSON document’s flexible structure.
STG-390 WK2 DQ2. 150 WORDS OR MORE
Find a job description, not just a 20-word help-wanted ad, for a position in your field that you would like to obtain. Describe the required body of knowledge, educational requirements, and expectations of that position.
REPLIES
A Ariel Fuller
In the field of information technology I would like to obtain my degree in information technology support specialist it helps the customers to resolve the problems that they are having. Our role is to find the problem, troubleshoot it, and to fix the issues (Subedi, 2022). The main goal is to solve the customers issues that is related to the devices software, and the application that are toward by the end users( Subedi, 2022). They teach others on how to properly use the business- specific applications and they provide the correct cybersecurity awareness training (subedi, 2022). Some of the tasks for this field is to investigate, troubleshoot, and to resolve the common computer issues, handle device service, repairs, and maintenance, recommend improvements in systems, processes, and devices, and they train the other staff on the new software, policies, and cybersecurity best practices. The qualifications for this field is to have a college degree in computer science or information technology apprenticeship, self-learning using online resources, and to short- term online or in-person certification courses ( Subedi, 2022). The certifications are CompTIAA+(plus) certification and the Google IT support professional certificate. The main skills and qualifications is teamwork, patience, communication, problem solving skills, and organization. The total pay for an information technology support specialist is about $50,013 a year, plus bonuses.
B Justin Quick
I know I will have to go for entry-level positions in the IT field, but my end goal is to work with Homeland Security, they offer a lot of student/recent graduates’ programs as well as job opportunities to start off with. One of the positions I have looked at before for cybersecurity is an IT Specialist for the Department of Veterans Affairs, Deputy Assistant Secretary for Information and Technology, Compliance Risk and Remediation (CRR). Education required a degree in computer science, GS-11 specialized experience, or GS-11 grade, GS-12 specialized experience, and GS-13 specialized experience. Besides some experience in IT-related, attention to detail, customer service, oral communication, problem-solving, and a year of specialized experience. Major duties include analyzing/evaluating mobile platforms and other technologies, managing schedules, conducting system auditing, advising on procedures/systems, and project management principles (It specialist. USAJOBS, n.d.). I even found another job listing for an IT Specialist for data management that is remote (perfect since I live in Nevada and the majority of listings are East coast) and this particular one falls under their assistant program to get started with about the same job duties but more with data management (It specialist (data management). USAJOBS, n.d.).
C Christian Phillips
A job that I found for a career in Information Technology is a System Administrator for Biogensys here in Phoenix, Arizona. The job requires a Bachelor’s degree from an accredited university along with three years of system administration experience, a minimum of three years. It also requires experience with Laserfiche for two years and a confidential security clearance at a minimum. The posting also suggests that an applicant has strong knowledge of Windows operating systems and server administration, both physical and cloud-based along with knowledge of Microsoft 365.
A System Administrator is responsible for managing the company’s SQL server, databases, and applications. The Systems Administrator must be able to work independently and as a team member with the ability to make technical decisions to keep the business and all technology running effectively. Systems administrators are often tasked with day-to-day operations in regard to hardware and software, ensuring the day-to-day needs are met. They can also be called upon to plan and execute large-scale projects such as upgrades, patch rollouts, and conversions. Additionally, personnel must be able to critically think, problem solves, and make analytical decisions with prioritization of tasks at the forefront of all activities ((Just a Moment. . ., n.d.).
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
