Long Polling and WebSocket are both technologies used for real−time data transfer between a client and a server. They provide a way for the client to receive updates from the server in real−time, allowing for more interactive and responsive web applications. The main difference between them is that long polling sends the request to the client or receiver and waits until a response is received which means one−way communication. On the other hand, WebSockets are used to send the data in both directions simultaneously. What is Long Polling? In long polling, until it has information to send back to the ... Read More

Dataset.from_tensors and Dataset.from_tensor_slices are methods in the TensorFlow library that are used to create datasets. Dataset.from_tensor creates a dataset from a single tensor whereas Dataset.from_tensor_slices creates data set by slicing a tensor along the first dimension. In this article, we will understand the difference between the two methods and how they are used in different use cases. from_tensor from_tensor_slices Creates a dataset from a single tensor Creates a dataset by slicing a tensor along the first dimension Useful for small datasets that can fit in memory Useful for large datasets that ... Read More

Hive was developed by Facebook. It is used for analytics and MapReduce jobs. It can read, write, and manage large datasets. Hive can replace traditional database operations. Hive uses indexing to make queries more efficient, and it can work with compressed data stored in the Hadoop ecosystem. In this article, we will discuss Dynamic Partitioning and operations on Dynamic Partition in Hive. Apache Hive Apache Hive is a warehousing system. It is used to perform operations on structured data. It is widely used for analytics and MapReduce jobs. Apache Hive provides functionality for reading, writing, and managing large datasets. One ... Read More

Oracle Label-Based Security (OLS) is a feature of the Oracle Database that provides fine-grained access control over sensitive data based on security labels. This feature enables organizations to enforce access control policies based on the sensitivity of the data rather than the traditional approach of user roles and privileges. In this article, we will discuss how Oracle Label-Based Security works and its benefits. Oracle Label-Based Security Oracle Label-Based Security works by assigning a security label to each row of data in a table. The label identifies the sensitivity level of the data, such as confidential, secret, or top secret. Each ... Read More

Retrieval and Update Operations When we work with files, we usually do two types of operations: retrieval and update. Retrieval operations help us find specific records in the file and look at their data. Update operations change the file by adding, removing, or modifying records. Selection Conditions To do either operation, we may need to specify a condition that the records must meet. For example, we might want to retrieve all the records where the salary is greater than or equal to $30, 000. This is called a selection condition. Selection conditions can be simple or complex. A simple condition ... Read More

Online Analytical Processing Server (OLAP) is used to enable users to perform analysis on information retrieved from multiple database systems concurrently. It operates on a multidimensional data model. Users can write query data across multiple dimensions, such as location, time, and categories (e.g., Hyderabad-> 2017 -> Sales data). In OLAP, databases are organized into one or more cubes. These cubes are known as Hyper-cubes and represent a multi-dimensional array of data. Each cell within the array corresponds to specific combination of dimension values. The dimensions define the characteristics or attributes. Data can be sliced and diced for analysis by attributes. ... Read More

Offset-Fetch is feature in MS SQL Server. It helps to retrieve subset of rows from result set. It consists of two components: OFFSET and FETCH. The OFFSET clause specifies the number of rows to skip from the beginning of the result set. FETCH clause determines the number of rows to retrieve. Syntax SELECT column1, column2, ... FROM table ORDER BY column OFFSET {integer_value} {ROWS | ROWS ONLY} FETCH {FIRST | NEXT} {integer_value} {ROWS | ROWS ONLY} ONLY; Explanation of Syntax SELECT column1, column2, ...: Specifies the columns to be selected from the table. FROM table Specifies the table from ... Read More

DBMS supports object-oriented data. It ensures direct correspondence between real-world objects and their representations in the database. This correspondence ensures that objects retain their integrity and identity. It enables easy identification and manipulation. Object Data Management System (ODMS) assigns unique identity to each independent object stored in the database. This unique identity is implemented through a system-generated object identifier (OID). This OID serves as distinct value assigned to each object by the system. It is not visible to external users. However it is internally utilized by the system to ensure the unique identification of each object and to establish and ... Read More

You should consider the needs of the applications during designing a database. Object databases offer a unique approach to database design that can be beneficial in certain situations. In this article, we will discuss the conceptual design of object databases. Object database design Object-Oriented Model is process of representing real-world entities as objects in computer programs. It is fundamental aspect of Object Database Conceptual Design. Object-oriented modeling is more flexible and dynamic than traditional relational model. It enables developers to model complex relationships between objects more efficiently. Object-oriented modeling allows for inheritance, encapsulation, and polymorphism. It is easier to maintain ... Read More

In database management systems (DBMS), super keys are an essential concept used to identify unique records in a table. A super key is a set of one or more than one attribute that can uniquely identify a record in a table. In this article, we will explore the number of possible super keys in a database and their significance. What is a Super Key? A super key is a group of attributes in a table that can identify each row in that table uniquely. It's different from primary and candidate keys because only the smallest possible super keys can be ... Read More