Understanding Database Systems and Their Architecture
DATABASE: A database is an interrelated data structure that is determined by criteria that tries to avoid unnecessary redundancy. The information stored can serve one or more applications. The storehouse is independent of the information, allowing the use of programs that permit adding, deleting, and retrieving information while modifying the database.
BENEFITS:
- Reduces redundancy to provide accurate information.
- Centralized control helps prevent inconsistencies.
- Ensures the security of information,
Optimize Windows XP for Enhanced Performance and Speed
Complete Optimization Techniques for Windows XP
1. Disable Unnecessary Services
Windows XP has many services running that can slow down the system, and many of them are not needed. Here is a list of services that can be disabled on virtually all machines:
- Alert Service
- Portfolio
- Computer Browser
- Tracking Client Distributed Link
- Support Fast User Switching
- Help and Support (do not touch if you use Windows regularly)
- Access to Human Interface Device
- Indexing Service
- IPSEC Services
- Messenger
- NetMeeting Remote Desktop
Understanding Parallelism and Memory Management in Computing
BASICS:
PARALLELISM: Coexistence of processes.
ATTENDANCE: Parallels between related processes (which require synchronization).
TIMING: The correspondence of a temporal order between processes arising from the communication between them needed to ensure mutual exclusion.
THREADS: Value of dominance and dependence between the operating system and processes.
Shared Variable: Variable that can be updated by two or more processes.
CRITICAL SECTION: Location of the program where there is a shared variable.
Read MoreUnderstanding Fourth Generation Languages and Their Evolution
4GL Fourth Generation Languages: The fourth-generation languages include a high degree of abstraction that creates a true black box. The programmer does not specify how applications should be performed; instead, they provide a number of parameters. The program created is always far removed from the machine or hardware, which has been the trend with each generation of programming languages. We must remember that the power of 4GL is based on the ability to generate code automatically, although the
Read MoreUnderstanding Entity-Relationship and Database Models
Entity Relationship Model
Features:
The model was proposed by Peter P. Chen and may be used as a basis for a unified view of the data, taking the natural approach in the real world that consists of entities and relationships.
The E/R model, as its name implies, focuses on two fundamental concepts: the entity and the relationship.
In the E/R models, we can distinguish key elements such as entities, attributes, and relationships, plus the set of values, analogous to the concept of dominance.
Advantages:
Read MoreComputer Fundamentals: Data, Processing, and Hardware
A. Introduction
Data
Data: The smallest unit of information, which can be numerical, alphabetical, or alphanumeric.
Data Processing
Data Processing: A set of operations required to transform initial data, information, or results. These operations can include sorting, adding, subtracting, classifying, etc.
Information
Information: The result of data and its processing.
B. Computer and its Elements
Source of Information
Computer Science: The science in charge of research and development of automatic information
Read More