COMPUTER TERMS

RJ-45 Port

RJ45, which incidentally stands for registered jack 45, is the Ethernet style data port found on switches, routers and network cards. RJ45 actually refers to the port (female) and the connector (male) though it often is used to refer to a cable type, most commonly referred to as the Ethernet Cable.

USB

A USB port is a standard cable connection interface for personal computers and consumer electronics devices. USB ports are used for connecting devices for data transfer and for charging devices as well. Flash drives are biggest examples for these ports, which are connected on these ports only. Types of USB Ports - USB-A, USB-B and USB-C.

DVI

Digital Visual Interface (DVI) is a video display interface developed by the Digital Display Working Group (DDWG). The interface is designed to transmit uncompressed digital video and can be configured to support multiple modes such as DVI-A (analog only), DVI-D (digital only) or DVI-I (digital and analog). DVI can stream up to 1920×1200 HD video, or with dual-link DVI connectors you can support up to 2560×1600 pixels.

Augmented Reality

Augmented reality is using technology to superimpose information on the world we see. This is rather different from virtual reality. Virtual reality means computer-generated environments for you to interact with, and being immersed in. Augmented reality (also known as AR), adds to the reality you would ordinarily see rather than replacing it. 

Pokemon go game is a good example of AR where the gamers used physical world as gaming spaces with superimposed Pokemon ( the character of the game) in the real world.

IEEE 802

IEEE 802 is a family of The Institute of Electrical and Electronics Engineers Standards Association (IEEE-SA) is an organisation within IEEE that develops global standards in a broad range of industries. IEEE 802 are standards dealing with local area networks and metropolitan area networks.

Some important working groups of IEEE802 protocol family are:

IEEE 802.1         Higher Layer LAN Protocols (Bridging)

IEEE 802.3         Ethernet

IEEE 802.11 Wireless LAN (WLAN) & Mesh (Wi-Fi certification)

IEEE 802.14 Cable modems

IEEE 802.15 Wireless PAN

ARPANET

ARPANET was a large wide-area network created by the United States Defense Advanced Research Project Agency (ARPA). ARPANET was to be used for projects at universities and research laboratories in the US. The Internet protocol suite (TCP/IP) was introduced as the standard networking protocol on the ARPANET.

Data warehousing

A data warehouse is a relational database that is designed for query and analysis rather than for transaction processing. Data warehouse is also known as an enterprise data warehouse is a system used for reporting and data analysis, and is the central repository of integrated data from one or more disparate sources.  Data warehousing involves data cleaning, data integration, and data consolidations.

Data Mining

Data Mining (sometimes called data or knowledge discovery) is the process of analysing data from different perspectives and summarising it into useful information. The related terms data dredging, data fishing, and data snooping refer to the use of data mining methods to sample parts of a larger population data set.

Data warehousing is the process of compiling and organising data into one common database, and data mining is the process of extracting meaningful data from that database.

Dataphone Modem

At&T Dataphone was the first commercial modem made for converting digital computer data at analog signals for transmission across long distance networks. A modem (modulator-demodulator) is a network hardware device.

Hybrid Cloud

A hybrid cloud joins together a public and private cloud with an encrypted connection and technology that makes data portable. The key here is that both clouds remain separate, independent entities while also having one or more touch points in common.

A public cloud is one based on the standard cloud computing model, in which a service provider makes resources, such as applications and storage, available to the general public over the Internet. Examples of public clouds include Amazon Elastic Compute Cloud (EC2), IBM's Blue Cloud, Sun Cloud, Google AppEngine and Windows Azure Services Platform. Whereas a private cloud is a particular model of cloud computing that involves a distinct and secure cloud-based environment in which only the specified client can operate.

Foreign Key

In a relational database, a foreign key is a field in one table that uniquely identifies a row of another table or the same table i.e. the foreign key is defined in a second table, but it refers to the primary key in the first table.

POST

POST (Power-On Self-Test) is the diagnostic testing sequence that a computer's basic input/output system (or "starting program") runs to determine if the computer keyboard, random access memory, disk drives, and other hardware are working correctly.If the necessary hardware is detected and found to be operating properly, the computer begins to boot.

BSOD

      Blue screens are generally caused by problems with your computer’s hardware or issues with its hardware driver software. A BSOD is the result of low-level software crashing — or faulty hardware.A blue screen occurs when Windows encounters a STOP Error. This critical failure causes Windows to crash and stop working. The only thing Windows can do is stop the computer and restart it.

Doughnut Chart in Excel

If you have several parts of something one, you can demonstrate each item in one pie chart. But a doughnut chart can help you demonstrate the changes of those parts. A pie chart contains one data series.  A doughnut chart shows the relationship of parts to a whole, but a doughnut chart can contain more than one data series.