Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Database Articles
Page 18 of 546
Difference Between Dataset.from_tensors and Dataset.from_tensor_slices
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 MoreDifference between Structured, Semi-structured and Unstructured data
Data plays a crucial role in understanding the business trends. Many organizations generate and process huge volumes of data. This huge and complex data is referred to as "Big Data". Big data is of three types: structured data, semi structured data, and unstructured data. What is Structured Data? Structured data is generally stored in tables in the form of rows and columns. Structured data in these tables can form relations with another tables. Humans and machines can easily retrieve information from structured data. This data is meaningful and is used to develop data models. Structured data is used by ...
Read MoreMultimedia Database Concepts
In this article, we will discuss multimedia databases, its data representation, data storage, data retrieval, data management and applications of multimedia databases. Introduction To store pictures, videos, and sounds that people use for learning, fun, health, and advertising. We need a multimedia database. A multimedia database has all kinds of information, like words, pictures, sounds, and videos. It keeps track of all this information and finds data easily. These databases enable the storage and retrieval of multimedia data components. All media files in these databases are stored as binary strings and encoded according to their file types. Let's explore the ...
Read MoreNoSQL Data Architecture Patterns
An architecture pattern is a way of organizing data in a logical and structured manner. So, it can be stored and accessed efficiently. NoSQL databases are different from traditional relational databases. Because Tables are not used to store data in it. It uses document-oriented, key-value or graph formats. It makes them more flexible. NoSQL databases can handle a wide variety of data types and sizes. It is suitable for big data applications. It can also provide faster performance than traditional relational databases. It is therefore ideal for applications that require real-time data processing. Architecture Patterns of NoSQL There are given ...
Read MoreObject Database Conceptual Design
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 MoreObject Identity, and Objects versus Literals
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 MoreOffset-Fetch in MS SQL Server
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 MoreOperations on Files
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 MoreOracle Label-Based Security
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 MoreOverview of Dynamic Partition in Hive
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