Random Insights Flashcards
What does BLOB stand for?
Binary Large OBject
What is BLOB?
A collection of binary data stored as a single entity in a database management system. Blobs are typically images, audio or other multimedia objects, though sometimes binary executable code is stored as a blob.
What is a relational database?
A database based upon a relational model.
What is a relational model?
The relational model (RM) for database management is an approach to managing data using a structure and language consistent with first-order predicate logic, first described in 1969 by Edgar F. Codd. Where all data is represented in terms of tuples, grouped into relations. Supported and retrieved using SQL statements.
What is a tuple?
A tuple is a finite ordered list of elements. (a row in a database or excel sheet of elements)
What is a relation?
A group of tuples (or an entire excel sheet of data = a table)
What is an attribute?
In a relational model, it is a column.
What is a database index?
A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure.
An index is a copy of selected columns of data from a table that can be searched very efficiently
What is PAAS?
Platform as a service (PaaS) or application platform as a service (aPaaS) is a category of cloud computing services that provides a platform allowing customers to develop, run, and manage applications without the complexity of building and maintaining the infrastructure typically associated with developing and launching an app.
(Provider controls: networks, servers, storage, OS, ‘middleware’ (e.g. Java runtime, .NET runtime, integration, etc.), database and other services to host the consumer’s application
What is OT/IT?
IT/OT convergence is the integration of information technology (IT) systems used for data-centric computing with operational technology (OT) systems used to monitor events, processes and devices and make adjustments in enterprise and industrial operations.
IT/OT convergence enables more direct control and more complete monitoring, with easier analysis of data from these complex systems from anywhere in the world.
http://searchitoperations.techtarget.com/definition/IT-OT-convergence
What is SCADA? (OT)
- A control system architecture used for high-level process supervisory management
Acronym for supervisory control and data acquisition, a computer system for gathering and analyzing real time data.
SCADA systems are used to monitor and control a plant or equipment in industries such as telecommunications, water and waste control, energy, oil and gas refining and transportation.
What is a gateway? (OT)
A gateway is a network node that connects two networks using different protocols together.
A gateway is a node (router) in a computer network, a key stopping point for data on its way to or from other networks. Thanks to gateways, we are able to communicate and send data back and forth.
What is a PLC? (OT)
A programmable logic controller, PLC, or programmable controller is a digital computer used for automation of typically industrial electromechanical processes, such as control of machinery on factory assembly lines, amusement rides, or light fixtures. PLCs are used in many machines, in many industries.
A programmable logic controller (PLC), or programmable controller is an industrial digital computer which has been ruggedised and adapted for the control of manufacturing processes, such as assembly lines, or robotic devices, or any activity that requires high reliability control and ease of programming and process fault diagnosis.
What are enterprise systems?
Are large-scale application software packages that support business processes, information flows, reporting, and data analytics in complex organizations. (i.e. ERPs, CRMs, etc)
What are CSPs?
Communications Service Providers
CSPs include the following categories: Telecommunications carrier, content and applications service provider (CASP), cable service provider, satellite broadcasting operator, and cloud communications service provider.
