by Dinesh Thakur Category: DBMS & RDBMS

The Database Users fall into several categories:


Application Programmers are computer professionals interacting with the system through DML calls embedded in a program written in a host language (e.g. C, PL/1, Pascal): These programs are called Application Programs. The DML Precompiled converts DML calls (prefaced by a special character like $, #, etc.) to normal procedure calls in a host language.



 
by Dinesh Thakur Category: DBMS & RDBMS

Database System Structure are partitioned into modules for different functions. Some functions (e.g. file systems) may be provided by the operating system. Components include:



 
by Dinesh Thakur Category: DBMS & RDBMS

There are four basic components of Database Management System:

(i) Data: Raw facts which we want to feed in the computer.

(ii) Hardware: On which the data to be processed.

(iii) Software: The interface between the hardware and user, by which the data   will change into the information.

(iv) User: There are so many types of users some of them are application programmer, end case users and DBA.



 
by Dinesh Thakur Category: DBMS & RDBMS

A Database Administrator, Database Analyst or Database Developer is the person responsible for managing the information within an organization. As most companies continue to experience inevitable growth of their databases, these positions are probably the most solid within the IT industry.



 
by Dinesh Thakur Category: DBMS & RDBMS

SQL statements are divided into two major categories: data definition language (DDL) and data manipulation language (DML).

Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples:



 
by Dinesh Thakur Category: DBMS & RDBMS

When multiple transactions are trying to access the same sharable resource, there could arise many problems if the access control is not done properly. There are some important mechanisms to which access control can be maintained. Earlier we talked about theoretical concepts like serializability, but the practical concept of this can be implemented by using Locks and Timestamps.

 
by Dinesh Thakur Category: DBMS & RDBMS

What is a database server? It is similar to data warehouse where the website store or maintain their data and information. A Database Server is a computer in a LAN that is dedicated to database storage and retrieval. The database server holds the Database Management System (DBMS) and the databases. Upon requests from the client machines, it searches the database for selected records and passes them back over the network.



 
by Dinesh Thakur Category: DBMS & RDBMS

What is a Database View, A view can join information from several tables together, or we can say that Views are useful for Hiding unwanted information for example adding the ename field to the Order information. Database View is a subset of the database sorted and displayed in a particular way. A database view displays one or more database records on the same page. A view can display some or all of the database fields.



 
by Dinesh Thakur Category: DBMS & RDBMS

The environment of database is said to be instance. A database instance or an ‘instance’ is made up of the background processes needed by the database software. These processes usually include a process monitor, session monitor, lock monitor, etc.  They will vary from database vendor to database vendor.



 
by Dinesh Thakur Category: DBMS & RDBMS

A database object in a relational database is a data structure used to either store or reference data. The most common object that most people interact with is the table. Other objects are indexes, stored procedures, sequences, views and many more.



 
by Dinesh Thakur Category: DBMS & RDBMS

A database instance controls 0 or more databases. A database contains 0 or more database application schemas. A database application schema is the set of database objects that apply to a specific application. These objects are relational in nature, and are related to each other, within a database to serve a specific functionality. 



 
by Dinesh Thakur Category: DBMS & RDBMS

The related information when placed is an organized form makes a database. In simple words, an organized collection of related information is known as database. The organization of data/information is necessary because unorganized information has no meaning. There are so many examples of organized information, more precisely and the most common are, the dictionary, the telephone directory, student record register, your own address book and many more. In each of these the data is stored in some particular order i.e. in an organized form.



 
by Dinesh Thakur Category: DBMS & RDBMS

An early proposal for a standard terminology and general architecture for database systems was produced in 1971 by the DBTG (Data Base Task Group) appointed by the Conference on Data Systems and Languages (CODASYL, 1971). The DBTG recognized the need for a two level approach with a system view called the schema and user views called subschema. The American National Standards Institute (ANSI) Standards Planning and Requirements Committee (SPARC) produced a similar terminology mid architecture in 1975 (ANSI 1975). ANSI-SPARC recognized the need for a three level approach with a system catalog.



 
by Dinesh Thakur Category: DBMS & RDBMS

Normalization is the process of removing redundant data from your tables in order to improve storage efficiency, data integrity and scalability. This improvement is balanced against an increase in complexity and potential performance losses from the joining of the normalized tables at query-time. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored.



 
by Dinesh Thakur Category: DBMS & RDBMS

When a company asks you to make them a working, functional Database Management System (DBMS) which they can work with, there are certain steps to follow. Let us summarize them here:



 
by Dinesh Thakur Category: DBMS & RDBMS

DBMS stand for Database Management System, which consist n number of tables there is no relationship between another table. RDMBS stand for Relational Database Management System, which having the relationship with other tables. The Relationship between tables in DBMS is Physical and the relationship in RDBMS is Logical.



 
by Dinesh Thakur Category: Computer Terms

• Switched-Mode Power Supply (SMPS) is an electronic circuit which converts the power using switching devices that are turned on and off at high frequencies, and storage components such as indicators or capacitors to supply power when the switching device is in its non-conduction state. It can be abbreviated as SMPS.
• The switched-mode power supply is also called switch-mode power supply or switching-mode power supply. Its efficiency is high. That’s why we use it in the variety of electronic types of equipment which require a stable and efficient power supply.

 
by Dinesh Thakur Category: Computer Terms

An embedded system is a complex system also known as an integrated system; It has software embedded into hardware (also known as Firmware) to perform specific tasks or a single task. It typically contains one or more microprocessors for executing a set of programs defined at design time and stored in memory. Which makes a system dedicated to a specific function, within a more extensive system. It is a low-power Microcontroller/Microprocessor based computer system, which dedicated to providing specific functionality.



 
by Dinesh Thakur Category: Computer Terms

Moving from a hard drive to an SSD is a fairly straightforward procedure that you can perform in less than an hour. Here, we’ll cover the steps you’ll need to take in order to install an SSD in a desktop PC.

 
by Dinesh Thakur Category: Computer Terms

eSATA. The external SATA interface has been around longer than most of the ports we just described. Until USB 3.0 came along, this port was the fastest link to consumer storage peripherals such as external hard drives.

 

Page 12 of 17



About Dinesh Thakur

Dinesh ThakurDinesh Thakur holds an B.SC (Computer Science), MCSE, MCDBA, CCNA, CCNP, A+, SCJP certifications. Dinesh authors the hugely popular blog. Where he writes how-to guides around Computer fundamental , computer software, Computer programming, and web apps. For any type of query or something that you think is missing, please feel free to Contact us.