Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

WK6 Discussion

Please see attachment instructions to complete the assignment.

 

 

WK6 Discussion Instructions: Cost Functions and Record Lengths 

 

250 words total, answer the questions below with 4 evidence base scholarly articles. APA format, due 15 Nov 24. 

1. Discuss the different types of parameters that are used in cost functions. Where is this information kept?

2. What are the reasons for having variable-length records? What type of separator characters are needed for each? Illustrate with examples.

 

400 words total, replying to the two posts below. Each reply must be 200 words for post 1 and post 2. 

 

 


Damien Post #1

Our text describes different types of parameters used in cost functions which include the size of each file, the number of tuples or records and their record size, the estimated number of file blocks, and potentially the blocking factor of the files. Additionally, the primary file organization should be considered either “unordered, ordered by an attribute with or without a primary or clustering index, or hashed (static hashing or one of the dynamic hashing methods) on a key attribute” (Elmasri, 2016). Per the referenced text, this information is stored in the Database Management System (DBMS) catalog for use by the query optimizer.

Elmasri describes four different reasons a file may have variable-length records. The first are if the file records are of the same type of record but with variable length fields such as the “Name” field of “Employee”. The file records may be the same record type but there may be multiple values for these records in a repeating field which can create a repeating group. One of the fields may be optional with values for only some of the fields, and lastly the file may contain records that are different record types which may create a mixed file. We’ve also learned that separator characters are required to terminate variable-length fields but are not meant to be included in the actual field value itself. These characters separate the data fields and may include symbols such as “?”, “%”, “$”, or “,” dependent on the type of file being utilized.

Elmasri, R., & Navathe, S. (2016). Fundamentals of Database Systems. Pearson.

 

 


Jennifer Post #2:

 

Hello Classmates, 

· Discuss the different types of parameters that are used in cost functions. Where is this information kept?

According to text, a query optimizer estimates and compares the costs of executing a query using different execution strategies and algorithms to choose the strategy with the lowest cost estimate.  The cost-based query optimization uses traditional optimization techniques that search the solution space to a problem for a solution that minimizes an object (cost) function.  Cost functions are not exact cost functions providing estimates, which may lead to a query execution strategy that is not the best.  Cost components for query execution include: access cost to secondary storage, disk storage cost, computation cost, memory usage cost, and communication cost.  To keep track of the various execution strategies this information may be stored in the DBMS catalog, so it can be access by the query optimizer.

· What are the reasons for having variable-length records? What type of separator characters are needed for each? Illustrate with examples.

Reasons for having variable-length records include having different records with files of different sizes.  Files have variable-length records for many reasons for example: containing more fields that vary in size, multiple values in a field, repeating fields, optional fields, and mixed file. They are useful in fields containing names, addresses, or descriptions, where the length of the data can differ.   A separator character used such as ; , % or $ to separate one field from the next. For example separate customers information with semicolon (;) Lisa smith;123 Jason Ave;238-1234 or separation by commas(,) Victor Lee,1980 Bong Ave,648-1298.

Reference:

Elmasri, R., & Navathe, S. B. (2016). Fundamentals of database systems, 7th ed. New York, NY: Pearson Addison-Wesley.

 

 

 

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

D 8 of 485

Follow the attached instructions to complete this work.   Strategies for Addressing Global Threats You will start by writing a short paper as described in the discussion question. You will be using information from this week’s readings and from your own research to address the information needs expressed in the

D 7 of 485

Follow the attached instructions to complete this work. Leadership Update: Cyber Crime   You will start by writing a short paper as described in the discussion question. You will be using information from this week’s readings and from your own research to address the information needs expressed in the question.

D 8 of 413

 Follow the attach instructions to complete this work. Budgeting for Cybersecurity   You will start by writing a short paper as described in the discussion question. You will be using information from this week’s readings and from your own research to address the information needs expressed in the question. Create an

Computer Science written assignment 3

Written Essay Assignment 3-1: · Identify common risks, threats, and vulnerabilities found in the LAN-to-WAN Domain that require proper security controls for mitigation · Identify network and security policies needed to properly secure the LAN-to-WAN portion of the network infrastructure · Write a 2-3 page APA-formatted essay that identifies network

project 3 of 485

Follow the attach instructions to complete the work. Make sure it aligns with the Rubric Project #3: Presentation for Board of Directors Your Task: Padgett-Beale’s Chief Information Security Officer (CISO) has tasked you to continue supporting the Merger & Acquisition team’s efforts to bring Island Banking Services’ security program into

project 2 of 485

Fellow the attach instructions to complete this work. Make sure it aligns with the Rubric Project #2: Cybersecurity Implementation Plan Your Task: The Acquisition of Island Banking Services has moved from the strategy development phase to the integration phase. In this phase, the M&A team will develop transition and implementation

PROJECT 1 of 485

Fellow the attach instructions to complete this work. Make sure it aligns with the rubric Project #1: Cybersecurity Strategy & Plan of Action Your Task: You have been assigned to support the Padgett-Beale Merger & Acquisition (M&A) team working under the direct supervision of Padgett-Beale’s Chief Information Security Officer (CISO).

proj3-Final

Project 3: Cloud Portfolio Report  Step 1: Review BallotOnline’s Cloud Services Offerings  You’ve now had a lot of experience working on many aspects of the cloud at BallotOnline, and you will take a look at what you’ve done in the past. In this step, you will write up how you

AWS Simple Monthly Calculator

Discussion: AWS Simple Monthly Calculator Contains unread posts Now that you have discussed BallotOnline’s cloud services offerings, you will discuss the AWS Simple Monthly Calculator. You should cover the following areas: · What are some of the general use cases that are covered? · What are the requirements to use

D 5 0F 485

Follow the attach instructions to complete this work. Assessing Maturity for Cybersecurity Program Before you begin read:  Our class focuses on integrating many different aspects of cybersecurity, information security, and information assurance.  Recent developments in the field of cybersecurity have resulted in a number of “maturity models” which can be

Discussion 4 of 413

Follow the attach instructions to complete the work Data Breach Reporting Policy Review the Red Clay Renovations company profile and the weekly readings. Provide specific information about “the company” in your response. Due to changes in state and federal laws, Red Clay leadership decided the CISO will be the sole

discussion 4 of 485

Follow the attach instructions to complete this work. Cultural Differences as Barriers to Success The Merger & Acquisition team hired a team of external consultants to assist with identification of cultural issues which could result in barriers to the successful acquisition of Island Banking Services by Padgett-Beale. The consultants conducted

project 3 of 413

Follow the attached instructions to complete this work Download the attached detailed assignment description for this project. You should also review the rubric shown below for additional information about the requirements for the project and how your work will be graded. Please make sure that you use both the assignment description file

Project 2 of 413

Follow the attach instructions to complete this work. Make sure it aligns with the rubric Project #2: Manager’s Deskbook Company Background & Operating Environment Red Clay Renovations is an internationally recognized, awarding winning firm that specializes in the renovation and rehabilitation of residential buildings and dwellings. The company specializes in

Project 1 of 413

Follow the attach instructions to complete this work. Make sure it aligns with rubric Project #1: Employee Handbook Company Background & Operating Environment Red Clay Renovations is an internationally recognized, awarding winning firm that specializes in the renovation and rehabilitation of residential buildings and dwellings. The company specializes in updating

Discussion and Replies

Please see attachment for instructions     Discussion   In 250 words total, answer the questions below with 4 evidence base scholarly articles. APA format. 1. Discuss some of the common issues with implementation of security policy. 2. What are some possible mitigations to ensure policy can be enforced. Replies

revision x 10

I need someone to follow all of the instructions that is provided for revision that can be done no later than tomorrow, do not request bid if this price is not enough or if you cannot fulfill the requirements this is a time sensitive manner I cannot wait 3-4 days