Notes, summaries, assignments, exams, and problems for Technology

Sort by
Subject
Level

Search Engine Mechanics: Crawling, Indexing, and Ranking

Classified in Technology

Written on in English with a size of 3.61 KB

Search Engine Functions: Crawling, Indexing, Publishing

Crawling

The process by which search engine robots (also known as spiders or web crawlers) discover new and updated web pages and add them to the search engine index. They achieve this by performing an algorithmic scan to determine which pages to crawl, then follow links to interconnect content across the web.

Indexing

Once a document or web page is located, it is processed and stored in a vast database, making it available for user retrieval. Search engines maintain large data centers where their robots process all the pages and information gathered during crawling.

Serving Search Results

The primary goal of search engines is to provide an almost immediate and relevant answer to the user's... Continue reading "Search Engine Mechanics: Crawling, Indexing, and Ranking" »

Mechanical Principles and Tool Applications Explained

Classified in Technology

Written on in English with a size of 3.57 KB

Mechanical Tool Usage Facts

A torque wrench is used to tighten a bolt when: The exact amount of force on the bolt has to be measured.

Taps and Dies Function

Taps and dies are tools used to: Cut threads for nuts and bolts.

Metal Pattern Creation

The type of pattern made on metal is created by a process called: Knurling.

Nail Sizing System

Which of the following uses a penny system to specify its size? Finishing nail.

Chimney Leak Prevention

What is placed around a chimney to prevent leaks? Flashing.

Sheet Metal Bending

Which tool is used to bend large sections of sheet metal? Brake.

Fastening to Sheet Metal

Self-tapping screws are primarily used when fastening objects to: Sheet metal.

Concrete Reinforcement

Anchor bolts are used to hold the: Rebar to the concrete.

... Continue reading "Mechanical Principles and Tool Applications Explained" »

Understanding Gears: Types, Mechanisms, and Applications

Classified in Technology

Written on in English with a size of 3.04 KB

What are Gears?

Gears are mechanical elements designed to transmit turning movements.

Characteristics of Gears

Two main characteristics define a gear:

  1. Number of Teeth (Z): This characteristic represents the number of teeth on a gear.
  2. Rotational Speed (N): This characteristic represents how fast a gear rotates.

Gear Ratios and Speed Control

Different Number of Teeth

Using gears with different numbers of teeth allows us to modify a machine's rotational speed. If the output gear is larger than the motor gear, it will rotate slower. Conversely, if the output gear is smaller, it will rotate faster.

Same Number of Teeth

If two gears have the same number of teeth, they will rotate at the same speed.

Motor Gear vs. Output Gear

In a gear pair:

  • The motor gear initiates
... Continue reading "Understanding Gears: Types, Mechanisms, and Applications" »

Essential Hand Tools for Electricians and Their Uses

Classified in Technology

Written on in English with a size of 2.91 KB

Pliars: The plier is a hand tool. It is my favorite tool. It is very useful for many kinds of different jobs; for example, it is useful for electricians. It is made of metal, plastic, steel, and other materials. It has a plastic handle, which is insulating. It is used for picking up objects and cutting wire; also, this tool is used for tightening wires. There are many kinds of pliers, like needle nose pliers, clamping pliers, lineman pliers, and side-cutting pliers.

Cutting Tools: It has a special insulating plastic handle and a steel blade. It is made of a lot of different colors. There are many kinds of cutting tools like cutters, electrician scissors, wire strippers, and hacksaws. These tools are very dangerous because they can cut your hands... Continue reading "Essential Hand Tools for Electricians and Their Uses" »

Java List Implementation with Search, Insert, and Remove

Classified in Technology

Written on in English with a size of 2.3 KB

Java List Implementation

Class Definition

public class Lista { 
    private Object[] item;
    private int primeiro, ultimo, pos;

    public Lista(int maxTam) {
        this.item = new Object[maxTam];
        this.pos = -1;
        this.primeiro = 0;
        this.ultimo = this.primeiro;
    }
}

Search Method

public Object pesquisa(Object chave) {
    if (this.vazia() || chave == null) {
        return null;
    }
    for (int p = 0; p < this.ultimo; p++) {
        if (this.item[p].equals(chave)) {
            return this.item[p];
        }
    }
    return null;
}

Insert Method

public void insere(Object x) {
    if (this.ultimo >= this.item.length) {
        throw new Exception("Error: List is full");
    } else {
        this.item[this.ultimo]
... Continue reading "Java List Implementation with Search, Insert, and Remove" »

MPEG Compression Standards: Video and Audio Formats

Classified in Technology

Written on in English with a size of 2.62 KB

MPEG Compression Standards

MPEG-1

  • Designed for up to 1.5 Mbit/sec.
  • Standard for the compression of moving pictures and audio.

This was based on CD-ROM video applications, and is a popular standard for video on the Internet, transmitted as .mpg files. In addition, level 3 of MPEG-1 is the most popular standard for digital compression of audio—known as MP3.

MPEG-1 is the standard of compression for Video CD, the most popular video distribution format throughout much of Asia.

MPEG-2

  • Designed for between 1.5 and 15 Mbit/sec.
  • Standard on which Digital Television set-top boxes and DVD compression is based. It is based on MPEG-1, but designed for the compression and transmission of digital broadcast television.
  • The most significant enhancement from MPEG-
... Continue reading "MPEG Compression Standards: Video and Audio Formats" »

Zener Diode Voltage Regulator: Principles and Operation

Classified in Technology

Written on in English with a size of 2.89 KB

Zener Diode as a Voltage Regulator

The function of a regulator is to provide a constant output voltage to a load connected in parallel with it, despite ripples in the supply voltage or variations in the load current. The Zener diode continues to regulate the voltage until the diode's current falls below the minimum IZ(min) value in the reverse breakdown region.

It permits current to flow in the forward direction as normal, but also allows it to flow in the reverse direction when the voltage exceeds the breakdown voltage, known as the Zener voltage. The Zener diode is specifically manufactured to have a reverse voltage breakdown at a precise level. In breakdown, the voltage across the Zener diode remains nearly constant over a wide range of currents,... Continue reading "Zener Diode Voltage Regulator: Principles and Operation" »

SQL Queries, Stored Procedures and Triggers for Project Management

Classified in Technology

Written on in English with a size of 3.42 KB

SQL Queries for Project Management

Query 1: Projects Delivered This Year or Without a Delivery Date

SELECT NomeP
FROM Projecto
INNER JOIN trabalha_em ON npr = nproj
WHERE DATEPART(year, Data_entrega) = DATEPART(year, SYSDATE)
OR data_entrega = NULL
ORDER BY total DESC;

Query 2: Employees Working Above Average Hours per Project

SELECT nomeP, nome, total_horas
FROM projecto
INNER JOIN trabalha_em t1 ON npr = nproj
INNER JOIN funcionario ON nemp = nf
WHERE total_horas > (SELECT AVG(total_horas)
FROM trabalha_em WHERE npt = t1.npt);

Query 3: Employees Earning More Than Their Supervisors

SELECT f.nome AS 'nome_funcionario', f.salario AS 'salario_funcionario', s.nome AS 'nome_supervisor', s.salario AS 'salario_supervisor'
FROM funcionario f
INNER JOIN funcionario
... Continue reading "SQL Queries, Stored Procedures and Triggers for Project Management" »

Implementação de Lista Autorreferenciada em C#

Classified in Technology

Written on in English with a size of 2.47 KB

Listas Autorreferenciadas

Exemplo de implementação de uma lista autorreferenciada (lista simplesmente encadeada) em C# utilizando nó sentinela (cabeça):

public class ListaRef {
    private class Celula {
        public Object item;
        public Celula prox;
    }

    private Celula primeiro, ultimo, pos;

    // Operações
    public ListaRef() { // Cria uma Lista vazia
        this.primeiro = new Celula();
        this.pos = this.primeiro;
        this.ultimo = this.primeiro;
        this.primeiro.prox = null;
    }

    public Object pesquisa(Object chave) {
        if (this.vazia() || chave == null)
            return null;

        Celula aux = this.primeiro;
        while (aux.prox != null) {
            if (aux.prox.item.Equals(
... Continue reading "Implementação de Lista Autorreferenciada em C#" »

Primary and Secondary Memory: RAM, ROM, and More

Classified in Technology

Written on in English with a size of 3.12 KB

Primary Memory (Main Memory)

Primary memory holds only the data and instructions on which the computer is currently working. It is generally made up of semiconductor devices. These memories are not as fast as registers. The data and instructions required to be processed reside in the main memory. It is divided into two subcategories: RAM and ROM.

Characteristics of Main Memory:

  • These are semiconductor memories.
  • It is known as the main memory.
  • It is the working memory of the computer.
  • It is faster than secondary memories.
  • A computer cannot run without primary memory.

RAM (Random Access Memory)

RAM (Random Access Memory) is the internal memory of the CPU for storing data, programs, and program results. It is a read/write memory that stores data until... Continue reading "Primary and Secondary Memory: RAM, ROM, and More" »