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
-
Economics & Finance
Big Data Analytics Articles
Page 135 of 135
How to BIND all the packages in a collection COLLA to a plan PLANA?
The package is a database object which contains the SQL statements from DBRM in a DB2-optimized form.The collection is a group of packages using which we can segregate the DB2 packages belonging to the different applications. For example, in a production environment for a Telecom company, we can have different collections for order handling, billing and customer service.The package or group of packages (collections) are binded into a plan. A plan is an executable object which contains the DB2 access paths of all the SQL queries within it. We can bind a package into a plan directly or we can ...
Read MoreHow to execute a COBOL-DB2 program PROGA of plan PLANA?
The COBOL-DB2 program can be executed with the help of IKJEFT01. The IKJEFT01 is an inbuilt mainframe utility that allows us to run z/OS TSO commands via Job control language(JCL). If we want to execute a COBOL-DB2 program PROGA of plan PLANA we must give a JCL step as below.//STEP010 EXEC PGM=IKJEFT01 //STEPLIB DD DSN=DIS.TEST.LOADLIB, DISP=SHR //SYSOUT DD SYSOUT=* //SYSTSIN DD * DSN SYSTEM(TB3) RUN PROGRAM (PROGA) PLAN(PLANA) END /*In the above JCL step, we have first used IKJEFT01 utility to call the COBOL-DB2 program. The loadlib path for the program PROGA is given in STEPLIB i.e. DIS.TEST.LOADLIB and the ...
Read MoreThe magnitude of big data
Large volumes of structured and unstructured data are essentially referred to as ‘Big Data;’ and is produced by almost all sources around us such as social media exchange, digital processes, mobile devices, sensors etc. Big Data provides insights into patterns, trends, and correlations with other entities in the business world. Big Data swamps businesses on a regular daily basis, and due to the speed and accuracy with which it is analyzed, it leads to enhanced and accurate decisions via tactical business steps. As it is variable and complex and comes from various sources, it is imperative to connect it and ...
Read MorePrimary key Vs Unique key
Primary KeyPrimary Key is a column that is used to uniquely identify each tuple of the table.It is used to add integrity constraints to the table. Only one primary key is allowed to be used in a table. Duplicate and NULL (empty) values are not valid in the case of the primary key. Primary keys can be used as foreign keys for other tables too.Let’s take an example, We have a table name employee which stores data of employees of a company. The below table shows the contents of the table.Emp_idNamePh_No.PositionSalaryEmp_id here is primary key of the table. As the ...
Read MoreHow IoT impacts Big Data
When it comes to two of the most talked about technologies in present times, Big Data and Internet of Things (IoT) are perhaps right at the helm. And over the last few years, Big Data has made progress in numerous domains. And although Internet of Things happens to be different, it is massively linked to Big Data.What is Big Data?Big Data is essentially a large amount of data that is in complex form. Specifically, it also refers to the use of predictive analysis and methods that allows extraction of valuable information from such data. This allows better decision making, reduction ...
Read MoreCareers in BigData? – A Big Leap Forward
Big Data is everywhere and there is an urgent need to collect and preserve whatever data has been generated. We also find that there is a greater fear of missing something, which is important. Big Data Analytics has become crucial, it helps improve business, decision making and offers the biggest edge over the competitors.What does the term Big Data mean?The term big data can be described as something large volume of data which is both structured and unstructured, that inundates a business on a day-to-day basis. Data is available everywhere but how can organizations capitalize on that is the big ...
Read MoreReal Estate Technology Trends in 2017
Technology is pervading into all aspects of real estate, making its functioning easier and quicker. And with the rising need to manage client demands, converting leads into sales, along with the requirement for broad property research, it is becoming all the more imperative to make use of multifaceted technologies that aid in causing consequential changes in the real estate business.Over the last few years, along with the emergence of new technologies, the existing ones have also witnessed a turnaround with added features to support the increasing requirements. These include a larger usage of precast construction, building information modeling process offering ...
Read MoreFind document with array that contains a specific value in MongoDB
You can use find() method to find document with array that contains a specific value. The syntax is as follows:db.yourCollectionName.find({"yourArrayFieldName":"yourValue"}, .......N).pretty();To understand the above syntax, let us create a collection with documents. The query to create a collection with documents is as follows:>db.findSpecificValue.insertOne({"StudentId":1, "StudentName":"Larry", "FavouriteSubject":["C", "C++", "Java"]}); { "acknowledged" : true, "insertedId" : ObjectId("5c6e8996140577d89182b8d0") } >db.findSpecificValue.insertOne({"StudentId":2, "StudentName":"Larry", "FavouriteSubject":["MongoDB", "MySQL", "SQL Server"]}); { "acknowledged" : true, "insertedId" : ObjectId("5c6e89b1140577d89182b8d1") }Display all documents from a collection with the help of find() method. The query is as follows:> db.findSpecificValue.find().pretty();The following is the output:{ "_id" : ObjectId("5c6e8996140577d89182b8d0"), "StudentId" ...
Read More