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

co task 6

Topic-bitcoin Task 6 Objective: To apply systems thinking principles to analyze a blockchain network and understand its key components, interactions, and dynamics. Assignment Tasks: Select a Blockchain Network: Choose a specific blockchain network or cryptocurrency project to analyze. You can select well-known networks like Bitcoin, Ethereum, or any other blockchain

CO Task 5

In this homework, we explore Naïve Bayes, K-Nearest Neighbors, and Support Vector Machine models. 1) (50 points) Use “credit_Dataset.arff” dataset and apply the Naïve Bayes, K-Nearest Neighbors, and Support Vector Machine technique using the WEKA tool in 2 different settings, including: a. 10 fold-cross validation. b. 80% training. Write a

PhD thesis

I need a comprehensive PhD thesis developed on the topic of “Emotion-Aware Artificial Intelligence and Sustainable Consumer Behavior: A Neuro-AI Marketing Framework for Continuous Green Consumption.”

Co project

· Comprehensive Literature Review: Require a more comprehensive survey of existing approaches. · Comparative Study: Expect more detailed benchmarking of at least 8 to 10 machine learning models. · Additional Experiments: · Conduct feature selection or dimensionality reduction as an extra step. · Explore ensemble methods or advanced techniques beyond

AI

Did AI take place the Software Engineers, HR consultants and Data Entry Jobs?

Data visualization 4 part 2

Follow the attached instructions to complete this work. Unit 4 Assignment Directions: Time Series In this assignment, you will perform a time series analysis in Tableau. · Choose a dataset to analyze based on the requirements provided.   · Once you’ve selected your time series, build a forecast to predict future

Computer Science CG Assignment 8 presentation

Follow the attach instruction to complete this work. Note: Make sure it aligns with Rubric Unit 8 Assignment 2 Directions: Final Presentation Purpose With this presentation, you will gain valuable experience demonstrating your expertise in cybersecurity governance by presenting as a CISO to a hypothetical professional audience.  Directions Begin by incorporating

Computer Science CG assignment 8

Follow the attached assignment to complete the work. Note: Follow Rubric Unit 8 Assignment 1 Directions: Presentation Rehearsal Purpose The rehearsal is your first run-through of your talk. Use the opportunity to de-bug any technical issues with lighting, positioning, and recording. You will not be graded on technical or artistic

Computer Science CG assignment 7 Outline

 Follow the attached document to complete this work Unit 7 Assignment 1 Directions: Professional Presentation Outline Purpose This assignment allows you time to review your research from previous units and organize your thoughts in an outline format. Plan on changing your paper and presentation based on feedback on this outline.  Directions

Computer Science CG assignment 6 ,

Follow the attached direction to complete this work. Note: Make sure it Aligns with Rubric Unit 6 Assignment 2 Directions: Timothy Brown vs. the SEC Purpose The Securities and Exchanges Commission (SEC) is a key US federal agency that regulates financial reporting. In this paper, you will explore how the

Microsoft 365Tenant to Tenant Migration Solution

A smooth tenant-to-tenant migration requires more than just moving mailboxes—it demands precision, security, and planning. With the MailsDaddy Cross-Tenant Migration Service, IT teams can execute a flawless cross-tenant mailbox migration that covers emails, attachments, calendars, contacts, and OneDrive data. It’s built for businesses of every size, ensuring the entire Office

CO Data 3

DECISION TREES for Risk Assessment One of the great advantages of decision trees is their  interpretability. The rules learnt for classification are easy for a person to follow, unlike the opaque “black box” of many other methods, such as neural networks. We demonstrate the utility of this using a  German

Computer Science Homework 1

MMIS 671 Homework 1. Constrained Optimization Problems A company produces 3 types of cables: A, B, and C. In-house production costs per foot of cables A, B, and C are $6, $8, and $10, respectively. The production process requires 5 resources: Drawing, Annealing, Stranding, Extrusion, and Assembly. For each resource,

MIMT

  Task 2.4 — Executing the Payload After decrypting and executing the transferred file, it generates a unique hash tied to your GTID. What’s the hash?

data Discussion 3

Follow the attached instructions to complete this. use the   CRM Sale Dashboard. Unit 3 Discussion: Deconstruction of an Advanced Dashboard: Trends and Improvements   Discussion Prompts · Does the dashboard designer use any of the trends that are described in Milligan’s Chapter 9? · If they did use those