This repository was archived by the owner on Apr 17, 2026. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathpublication_project_db.sql
More file actions
618 lines (538 loc) · 29.1 KB
/
publication_project_db.sql
File metadata and controls
618 lines (538 loc) · 29.1 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
-- version 4.5.4.1deb2ubuntu1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 15, 2019 at 05:26 PM
-- Server version: 5.7.11-0ubuntu6
-- PHP Version: 7.0.4-7ubuntu2
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `publication_project_db`
--
-- --------------------------------------------------------
--
-- Table structure for table `conferences`
--
CREATE TABLE `conferences` (
`cid` varchar(5) NOT NULL,
`name` varchar(200) NOT NULL,
`location` varchar(30) NOT NULL,
`date` date NOT NULL,
`other_details` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `conferences`
--
INSERT INTO `conferences` (`cid`, `name`, `location`, `date`, `other_details`) VALUES
('0704', 'IEEE TENSYMP', 'Kochi, Kerala', '2017-07-01', ''),
('0717', 'IEEE International Conference on Communications, Network and Satellite', 'Bali, Indonesia', '2012-07-01', ''),
('1457', 'IEEE TENCON', 'Kochi, Kerala', '2019-10-01', ''),
('1668', 'International Conference on Advances in Computing, Communications and Informatics', 'Bangalore, India', '2018-09-01', ''),
('2024', '2016 IEEE Trustcom/BigDataSE/ISPA', 'Tianjin, China', '2016-08-01', ''),
('2114', '6th International Conference on Advances in Computing and Communications', 'Kochi, India', '2016-09-01', ''),
('2592', '8th International Conference on Security of Information and Networks', 'Sochi, Russian Federation', '2015-09-01', ''),
('2803', '8th International Conference on Human Computer Interaction', 'BITS-Pilani, India', '2016-12-27', ''),
('3199', '12th International Conference on Information and Systems Security', 'MNIT-Jaipur, India', '2016-12-01', ''),
('3210', 'VLSI Design Conference', '', '2016-01-01', ''),
('3481', 'VLSI Design Conference', '', '2010-01-01', ''),
('3645', 'IEEE TrustCom 2018', 'New York, USA', '2018-07-01', ''),
('3947', 'IEEE 16th International Conference on BioInformatics and BioEngineering', 'Taichung, Taiwan', '2016-10-01', ''),
('4217', '4th International Conference on Information Assurance and Security', 'Naples, Italy', '2008-07-01', ''),
('4315', '21st IEEE International Conference on Microelectronic Test Structures', 'Edinburgh, Scotland', '2008-03-01', ''),
('4354', '10th International Conference on Information and Systems Security', 'IDRBT, Hyderabad, India', '2014-12-01', ''),
('4369', 'IEEE TechSym', 'Kharagpur, India', '2014-02-01', ''),
('4458', 'International Conference on Embedded Software (EMSOFT)', 'Torino, Italy', '2018-09-01', ''),
('5176', 'Design Automation and Test in Europe', '', '2004-01-01', ''),
('5222', 'IEEE Indicon', 'Kochi, India', '2012-12-01', ''),
('5497', '9th ACM International Conference on Future Energy Systems', 'Karlsruhe, Germany', '2018-06-01', ''),
('5731', '2nd International Conference on Security in Computer Networks and Distributed Systems', 'Thiruvanthapuram, India', '2014-03-01', ''),
('5734', '2nd International Conference on Security of Information and Networks', 'Gazimagusa, North Cyprus', '2009-10-01', ''),
('5883', '24th International Conference on Database and Expert Systems Applications', 'Prague, Czech Republic', '2013-08-01', ''),
('6062', 'IEEE World Congress on Computational Intelligence', 'Rio de Janeiro, Brazil', '2018-07-01', ''),
('6602', 'International Conference on Communication Systems & NetworkS', 'Bengaluru, India', '2018-01-01', ''),
('7193', '17th ACM Conference on Embedded Networked Sensor Systems', 'New York, USA', '2019-11-01', ''),
('7376', '1st International Workshop on Network and Communications Security', 'Chennai, India', '2009-12-01', ''),
('7531', 'Integrated Circuit and System Design. Power and Timing Modeling, Optimization and Simulation', '', '2006-01-01', ''),
('7799', '14th International Conference on Information Systems Security', 'Bengaluru, India', '2018-12-01', ''),
('8556', '14th ACM Symposium on Access Control Models and Technologies', 'Gazimagusa, Stresa, Italy', '2009-07-01', ''),
('8867', '22nd International Conference on Pattern Recognition', 'Stockholm, Sweden', '2014-08-01', ''),
('8932', 'The 32nd International Conference on VLSI Design', 'Delhi, India', '2019-01-01', ''),
('8940', 'VLSI Design and Test Symposium', '', '2015-01-01', ''),
('9172', 'International Conference on Computing: Theory and Applications', '', '2007-01-01', ''),
('9575', '2nd International Symposium on Security in Computing and Communications', 'Greater Noida, India', '2014-09-01', ''),
('9663', '4th International Conference on Information Systems Security', 'Hyderabad, India', '2008-12-01', '');
-- --------------------------------------------------------
--
-- Table structure for table `conf_authors`
--
CREATE TABLE `conf_authors` (
`centryid` varchar(5) NOT NULL,
`fid` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `conf_authors`
--
INSERT INTO `conf_authors` (`centryid`, `fid`) VALUES
('3584', '0323'),
('0153', '1294'),
('0493', '1294'),
('1414', '1294'),
('2088', '1294'),
('2149', '1294'),
('2156', '1294'),
('2239', '1294'),
('2824', '1294'),
('4668', '1294'),
('8451', '1294'),
('9002', '1294'),
('0282', '1658'),
('2257', '1658'),
('3217', '1658'),
('5105', '1658'),
('5151', '1658'),
('5157', '1658'),
('5987', '1658'),
('7221', '1658'),
('7841', '1658'),
('7851', '1658'),
('8356', '1658'),
('9626', '3272'),
('0153', '3511'),
('0282', '3511'),
('0493', '3511'),
('0844', '3511'),
('1414', '3511'),
('1467', '3511'),
('1853', '3511'),
('2088', '3511'),
('2149', '3511'),
('2156', '3511'),
('2239', '3511'),
('2257', '3511'),
('2346', '3511'),
('2824', '3511'),
('3582', '3511'),
('3584', '3511'),
('3855', '3511'),
('3887', '3511'),
('3918', '3511'),
('4027', '3511'),
('4118', '3511'),
('4375', '3511'),
('4668', '3511'),
('5029', '3511'),
('5587', '3511'),
('5987', '3511'),
('6044', '3511'),
('6051', '3511'),
('6176', '3511'),
('6623', '3511'),
('7221', '3511'),
('7657', '3511'),
('7774', '3511'),
('7828', '3511'),
('8356', '3511'),
('8451', '3511'),
('8796', '3511'),
('8955', '3511'),
('9002', '3511'),
('9626', '3511');
-- --------------------------------------------------------
--
-- Table structure for table `conf_pubs`
--
CREATE TABLE `conf_pubs` (
`centryid` varchar(5) NOT NULL,
`title` varchar(500) NOT NULL,
`cid` varchar(5) NOT NULL,
`authors` varchar(500) NOT NULL,
`volpp` varchar(50) NOT NULL,
`accepted` tinyint(1) NOT NULL DEFAULT '0',
`other_details` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `conf_pubs`
--
INSERT INTO `conf_pubs` (`centryid`, `title`, `cid`, `authors`, `volpp`, `accepted`, `other_details`) VALUES
('0153', 'Fast Implementation of Steady State NSGA-II', '6062', 'Sumit Mishra, Samrat Mondal and Sriparna Saha', 'pp. 3777-3784', 0, ''),
('0282', 'Intelligent Scheduling of Smart Appliances in Energy Efficient Buildings: A Practical Approach', '8932', 'Nilotpal Chakraborty, Arijit Mondal and Samrat Mondal', '', 1, ''),
('0493', 'An Automatic Framework for Entity Matching in Bibliographic Databases', '6062', 'Sumit Mishra, Sriparna Saha and Samrat Mondal', 'pp. 271-278', 0, ''),
('0844', 'Towards Formal Security Analysis of GTRBAC using Timed Automata', '8556', 'Samrat Mondal, Shamik Sural and Vijayalakshmi Atluri', 'pp. 33-42', 0, ''),
('1414', 'MBOS: Modified Best Order Sort Algorithm for Performing Non-dominated Sorting', '6062', 'Sumit Mishra, Sriparna Saha and Samrat Mondal', '', 1, ''),
('1467', 'Few notes towards making honeyword system more secure and usable', '2592', 'Nilesh Chakraborty and Samrat Mondal', 'pp.237-245', 0, ''),
('1853', 'Security Analysis of Temporal-RBAC using Timed Automata', '4217', 'Samrat Mondal and Shamik Sural', 'pp. 37-40', 0, ''),
('2088', 'Entity Matching Technique for Bibliographic Database', '5883', 'Sumit Mishra, Samrat Mondal and Sriparna Saha', 'pp. 34-41', 0, ''),
('2149', 'Unsupervised Method to Ensemble Results of Multiple Clustering Solutions for Bibliographic Data', '6062', 'Sumit Mishra, Sriparna Saha and Samrat Mondal', 'pp. 1459-1466', 0, ''),
('2156', 'Cluster Validation Techniques for Bibliographic Databases', '4369', 'Sumit Mishra, Sriparna Saha and Samrat Mondal', 'pp. 93-98', 0, ''),
('2239', 'Obtaining the upper bound on the number of non-dominated fronts in a Population', '1668', 'Sumit Mishra, Sriparna Saha and Samrat Mondal', '', 1, ''),
('2257', 'Multi-Objective Heuristic Charge Scheduling and Eco-Routing Mechanism for Electric Vehicles', '5497', 'Nilotpal Chakraborty, Arijit Mondal and Samrat Mondal', 'pp. 468-470', 0, ''),
('2346', 'SG-PASS: A Safe Graphical Password Scheme to Resist Shoulder Surfing and Spyware Attack', '2803', 'Suryakanta Panda and Samrat Mondal', 'pp. 27-38', 0, ''),
('2824', 'On Evaluation of Entity Matching Techniques for Bibliographic Database', '1668', 'Sumit Mishra, Sriparna Saha and Samrat Mondal', '', 1, ''),
('3217', 'A framework for estimating peak power in gate level circuits', '7531', 'Diganchal Chakraborty, P. P. Chakrabarti, Arijit Mondal, Pallab Dasgupta', '', 0, ''),
('3582', 'Supporting Negative Authorization in Spatiotemporal Role Based Access Control', '7376', 'Samrat Mondal and Shamik Sural', 'pp. 422-427', 0, ''),
('3584', 'An Unsupervised Heuristic Based Approach for Author Name Disambiguation', '6602', 'KM Pooja, Samrat Mondal and Joydeep Chandra', '', 0, ''),
('3855', 'SGP: A Safe Graphical Password System Resisting Shoulder-Surfing Attack on Smartphones', '7799', 'Suryakanta Panda and Samrat Mondal', '', 1, ''),
('3887', 'On Designing a Questionnaire Based Honeyword Generation Approach for Achieving Flatness', '3645', 'Nilesh Chakraborty, Shreya Singh and Samrat Mondal', 'pp. 444-455', 0, ''),
('3918', 'A Location Sensitive Access Control System', '5222', 'Vasu Devulapalli and Samrat Mondal', 'pp. 379-384', 0, ''),
('4027', 'Tag Digit Based Honeypot to Detect Shoulder Surfing Attack', '9575', 'Nilesh Chakrabory and Samrat Mondal', 'pp.101-110', 0, ''),
('4118', 'CETD: An Efficient Clustering Based Energy Theft Detection Technique in Smart Grid', '0704', 'Aditya Gupta, Nilotpal Chakraborty and Samrat Mondal', '', 0, ''),
('4375', 'On Designing Leakage-Resilient Vibration Based Authentication Techniques', '2024', 'Nilesh Chakraborty, S.Vijay Anand, Gurpinder Randhawa and Samrat Mondal', 'pp. 1875 - 1881', 0, ''),
('4668', 'A Many Objective Optimization Based Entity Matching Framework for Bibliographic Database', '1457', 'Sumit Mishra, Sriparna Saha, and Samrat Mondal', '', 1, ''),
('5029', 'XML -Based Policy Specification Framework for Spatiotemporal Access Control', '5734', 'Samrat Mondal and Shamik Sural', 'pp. 98-103', 0, ''),
('5105', 'A New Approach to Timing Analysis using Event Propagation and Temporal Logic', '5176', 'Arijit Mondal, P. P. Chakrabarti and C. R. Mandal', '', 0, ''),
('5151', 'Performance optimization of real timecontrol systems using variable time period', '8940', 'Jaishree Mayank, Arijit Mondal', '', 0, ''),
('5157', 'Partitioned Fair Round Robin: A Fast andAccurate QoS Aware Scheduler for Embedded Systems', '3210', 'Arnab Sarkar, Arijit Mondal', '', 0, ''),
('5587', 'A Verification Framework for Temporal RBAC with Role Hierarchy', '9663', 'Samrat Mondal and Shamik Sural', 'pp. 140-147', 0, ''),
('5987', 'MinPeak: An Intelligent Scheduler for Non-Preemptive Appliances in Smart Grid', '0704', 'Nilotpal Chakraborty, Arijit Mondal and Samrat Mondal', '', 0, ''),
('6044', 'An Improved Methodology Towards Providing Immunity Against Weak Shoulder Surfing Attack', '4354', 'Nilesh Chakrabory and Samrat Mondal', 'pp. 298-317', 0, ''),
('6051', 'Towards Improving Storage Cost and Security Features of Honeyword Based Approaches', '2114', 'Nilesh Chakraborty and Samrat Mondal', 'Vol: 93, pp. 799-807', 0, ''),
('6176', 'SPOSS: Secure Pin-based-authentication Obviating Shoulder Surng', '3199', 'Ankit Maheshwari and Samrat Mondal', 'pp. 66-86', 0, ''),
('6623', 'SLASS: Secure Login Against Shoulder Surfing', '5731', 'Nilesh Chakraborty and Samrat Mondal', 'pp. 346-357', 0, ''),
('7221', 'Towards Optimal Scheduling of Thermal Comfortability and Smoothening of Load Profile in Energy Efficient Buildings', '4458', 'Nilotpal Chakraborty, Arijit Mondal and Samrat Mondal', '', 1, ''),
('7657', 'Color Pass: An Intelligent User Interface to Resist Shoulder Surfing Attack', '4369', 'Nilesh Chakraborty and Samrat Mondal', 'pp. 13-18', 0, ''),
('7774', 'Detecting Policy Misconfigurations in Temporal Domain Using Object Priority', '0717', 'Madhu Sankeerth Dammati and Samrat Mondal', 'pp. 147-151', 0, ''),
('7828', 'MobSecure: A Shoulder Surng Safe Login Approach Implemented On Mobile Device', '2114', 'Nilesh Chakraborty, Gurpinder Singh Randhawa, Kuntal Das and Samrat Mondal', 'Vol: 93, pp. 854-861', 0, ''),
('7841', 'Accelerating Synchronous Sequential Circuits using an Adaptive Clock', '3481', 'Arijit Mondal, P. P. Chakrabarti and Pallab Dasgupta', '', 0, ''),
('7851', 'Timing analysis of sequential circuits using symbolic event propagation', '9172', 'Arijit Mondal, P. P. Chakrabarti and Pallab Dasgupta', '', 0, ''),
('8356', 'Coordinated Scheduling of Residential Appliances and Heterogeneous Energy Sources in a Smart Microgrid', '7193', 'Pranay Kumar Saha, Nilotpal Chakraborty, Arijit Mondal and Samrat Mondal', '', 1, ''),
('8451', 'On Validation of Clustering Techniques for Bibliographic Databases', '8867', 'Sumit Mishra, Sriparna Saha and Samrat Mondal', 'pp. 3150-3155', 0, ''),
('8796', 'drPass: A Dynamic and Reusable Password Generator Protocol', '7799', 'Suryakanta Panda and Samrat Mondal', '', 1, ''),
('8955', 'A Novel High Speed Automatic Layout System to Place and Route Test Structures for Parametric Test Capability', '4315', 'Andrew J. West, Samrat Mondal, Devjyoti Patra, Kalyan Goswami and Shamik Sural', 'pp. 71-75', 0, ''),
('9002', 'Divide and Conquer Based Non-dominated Sorting for Parallel Environment', '6062', 'Sumit Mishra, Sriparna Saha and Samrat Mondal', 'pp. 4297-4304', 0, ''),
('9626', 'CRDT: Correlation Ratio Based Decision Tree Model for Healthcare Data Mining', '3947', 'Smita Roy, Samrat Mondal, Asif Ekbal and Maunendra Sankar Desarkar', 'pp. 36-43', 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `faculty`
--
CREATE TABLE `faculty` (
`fid` varchar(5) NOT NULL,
`name` varchar(30) NOT NULL,
`email` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `faculty`
--
INSERT INTO `faculty` (`fid`, `name`, `email`) VALUES
('0323', 'Joydeep Chandra', 'joydeep@iitp.ac.in'),
('1271', 'Pushpak Bhattacharyya', 'pb@iitp.ac.in'),
('1294', 'Sriparna Saha', 'sriparna@iitp.ac.in'),
('1658', 'Arijit Mondal', 'arijit@iitp.ac.in'),
('2094', 'Raju Halder', 'halder@iitp.ac.in'),
('2724', 'Mayank Agarwal', 'mayank265@iitp.ac.in'),
('3272', 'Asif Ekbal', 'asif@iitp.ac.in'),
('3511', 'Samrat Mondal', 'samrat@iitp.ac.in'),
('3577', 'Somanath Tripathy', 'som@iitp.ac.in'),
('5325', 'Suman Kumar Maji', 'smaji@iitp.ac.in'),
('6282', 'Sourav Kumar Dandapat', 'sourav@iitp.ac.in'),
('7715', 'Rajiv Misra', 'rajivm@iitp.ac.in'),
('8037', 'Abyayananda Maiti', 'abyaym@iitp.ac.in'),
('8113', 'Jimson Mathew', 'jimson@iitp.ac.in');
-- --------------------------------------------------------
--
-- Table structure for table `journals`
--
CREATE TABLE `journals` (
`jid` varchar(5) NOT NULL,
`name` varchar(500) NOT NULL,
`other_details` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `journals`
--
INSERT INTO `journals` (`jid`, `name`, `other_details`) VALUES
('0426', 'Elsevier Applied Soft Computing', ''),
('1654', 'IET Information Security', ''),
('1809', 'IEEE Transactions on Industrial Informatics', ''),
('2353', 'Computers and Security', ''),
('2445', 'IEEE Access Journal', ''),
('3204', 'Journal of Information Assurance and Security (Special issue on Access Control and Protocols)', ''),
('3343', 'Elsevier Computers & Security', ''),
('3478', 'Elsevier Expert Systems with Applications', ''),
('3687', 'IEEE\r\nTransaction on Computer Aided Design of Integrated Circuits and Systems', ''),
('3892', 'IEEE Transactions on Semiconductor Manufacturing', ''),
('4406', 'Wiley Journal of the Association for Information Science and Technology', ''),
('5411', 'Transactions on Computational Science (Special Issue in Security in Computing)', ''),
('5716', 'IEEE Systems Journal', ''),
('6167', 'International Journal of Trust Management in Computing and Communications', ''),
('6286', 'Transactions on Large-Scale Data and Knowledge-Centered Systems', ''),
('6361', 'IET Circuit, Device and Systems', ''),
('6536', 'ACM Transactions on Design Automation of Electronic Systems', ''),
('7833', 'Elsevier Swarm and Evolutionary Computation', ''),
('8694', 'Springer Applied Intelligence', ''),
('9127', 'Fundamenta Informaticae', '');
-- --------------------------------------------------------
--
-- Table structure for table `journal_authors`
--
CREATE TABLE `journal_authors` (
`jentryid` varchar(5) NOT NULL,
`fid` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `journal_authors`
--
INSERT INTO `journal_authors` (`jentryid`, `fid`) VALUES
('2534', '0323'),
('0796', '1294'),
('1086', '1294'),
('2025', '1294'),
('2121', '1294'),
('3114', '1294'),
('3228', '1294'),
('6613', '1294'),
('7816', '1294'),
('0528', '1658'),
('0645', '1658'),
('3554', '1658'),
('5354', '1658'),
('7148', '1658'),
('7821', '1658'),
('8187', '3272'),
('0528', '3511'),
('0645', '3511'),
('0796', '3511'),
('1086', '3511'),
('1555', '3511'),
('1746', '3511'),
('2025', '3511'),
('2121', '3511'),
('2126', '3511'),
('2534', '3511'),
('3114', '3511'),
('3228', '3511'),
('4905', '3511'),
('5313', '3511'),
('5482', '3511'),
('6385', '3511'),
('6458', '3511'),
('6613', '3511'),
('7148', '3511'),
('7671', '3511'),
('7816', '3511'),
('8187', '3511'),
('8852', '3511');
-- --------------------------------------------------------
--
-- Table structure for table `journal_pubs`
--
CREATE TABLE `journal_pubs` (
`jentryid` varchar(5) NOT NULL,
`title` varchar(500) NOT NULL,
`jid` varchar(5) NOT NULL,
`authors` varchar(500) NOT NULL,
`volpp` varchar(50) NOT NULL,
`date` date NOT NULL,
`accepted` tinyint(1) NOT NULL DEFAULT '0',
`other_details` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `journal_pubs`
--
INSERT INTO `journal_pubs` (`jentryid`, `title`, `jid`, `authors`, `volpp`, `date`, `accepted`, `other_details`) VALUES
('0528', 'Intelligent Scheduling of Thermostatic Devices for Efficient Energy Management in Smart Grid', '1809', 'Nilotpal Chakraborty, Arijit Mondal and Samrat Mondal', 'Vol: 13, Issue: 6, pp. 2899-2910', '2017-12-01', 0, ''),
('0645', 'Efficient Scheduling of Non-Preemptive Appliances for Peak Load Optimization in Smart Grid', '1809', 'Nilotpal Chakraborty, Arijit Mondal and Samrat Mondal', 'vol. PP, no. 99, pp. 1-1', '2017-01-01', 0, ''),
('0796', 'Towards Obtaining Upper Bound on Sensitivity Computation Process for Cluster Validity Measures', '9127', 'Sumit Mishra, Samrat Mondal and Sriparna Saha', 'Vol: 163, No: 4, pp:351-374', '2018-08-01', 0, ''),
('1086', 'GBOS: Generalized Best Order Sort Algorithm for Non-dominated Sorting', '7833', 'Sumit Mishra, Samrat Mondal, Sriparna Saha, and Carlos A. Coello Coello', 'Vol: 43,pp: 244-264', '2018-06-01', 0, ''),
('1555', 'Role Based Access Control with Spatiotemporal Context for Mobile Applications', '5411', 'Subhendu Aich, Samrat Mondal, Shamik Sural and Arun Kumar Majumdar', 'Volume: 4, pp. 177-199', '2009-04-01', 0, ''),
('1746', 'I-SLASS : An Improved Login Approach Over SLASS', '6167', 'Nilesh Chakraborty and Samrat Mondal', 'Volume: 2, No. 4, pp. 309-329', '2014-01-01', 0, ''),
('2025', 'Improved Solution to the Non-Domination Level Update Problem', '0426', 'Sumit Mishra, Samrat Mondal and Sriparna Saha', 'Vol: 60, pp: 336-362', '2017-01-01', 0, ''),
('2121', 'Divide-and-Conquer Based Non-dominated Sorting with Reduced Comparisons', '7833', 'Sumit Mishra, Sriparna Saha, Samrat Mondal and Carlos A. Coello Coello', '', '2019-09-01', 1, ''),
('2126', 'On overcoming the identified limitations of a usable PIN entry method', '2445', 'Nilesh Chakraborty, Jianqiang Li, Samrat Mondal and Fei Chen, Yi Pan', '', '2019-08-01', 1, ''),
('2534', 'A Graph Combination with Edge Pruning based Approach for Author Name Disambiguation', '4406', 'KM Pooja, Samrat Mondal, and Joydeep Chandra', '', '2019-01-01', 1, ''),
('3114', 'A Multiobjective Optimization based Entity Matching Technique for Bibliographic Databases', '3478', 'Sumit Mishra, Sriparna Saha and Samrat Mondal', 'Vol: 65, pp. 100-115', '2016-01-01', 0, ''),
('3228', 'GAEMTBD: Genetic Algorithm based Entity Matching Techniques for Bibliographic Databases', '8694', 'Sumit Mishra, Sriparna Saha and Samrat Mondal', 'Vol: 47, No. 1, pp. 197-230', '2017-01-01', 0, ''),
('3554', 'Symbolic Event Propagation Based Minimal Test Set Generation for Robust Path Delay Faults', '6536', 'Arijit Mondal, P. P. Chakrabarti, Pallab Dasgupta', 'Volume 17 Issue 4', '2012-10-04', 0, ''),
('4905', 'Towards Incorporating Honeywords In n-Session Recording Attack Resilient Unaided Authentication Services', '1654', 'Nilesh Chakraborty and Samrat Mondal', 'Vol: 13, Issue 1, pp: 7-18', '2019-01-01', 0, ''),
('5313', 'HoneyString : An Improved Methodology Over Tag Digit Based Honeypot To Detect Shoulder Surng Attack', '6167', 'Nilesh Chakraborty and Samrat Mondal', 'Volume 3, No.2, pp.93 - 114', '2015-01-01', 0, ''),
('5354', 'Statistical static timing analysis using symbolic event propagation', '6361', 'Arijit Mondal, P. P. Chakrabarti, Pallab Dasgupta', 'Vol 1, No 4, pages 283-291', '2007-01-01', 0, ''),
('5482', 'On Designing A Modied-UI Based Honeyword Generation Approach For Overcoming The Existing Limitations', '2353', 'Nilesh Chakraborty and Samrat Mondal', 'Vol: 66, pp. 155-168', '2017-01-01', 0, ''),
('6385', 'Security Analysis of GTRBAC and its Variants using Model Checking', '2353', 'Samrat Mondal, Shamik Sural and Vijayalakshmi Atluri', 'Volume: 30, Issues: 2-3, pp. 128-147', '2011-01-01', 0, ''),
('6458', 'Towards Identifying and Preventing Behavioral Side Channel Attack On Recording Attack Resilient Unaided Authentication Services', '3343', 'Nilesh Chakraborty, Vijay S. Anand and Samrat Mondal', '', '2019-03-01', 1, ''),
('6613', 'Sensitivity- An Important Facet of Cluster Validation Process for Entity Matching Technique', '6286', 'Sumit Mishra, Samrat Mondal and Sriparna Saha', 'Vol: 29, pp. 1-39, 2016', '2016-01-01', 0, ''),
('7148', 'Multi-Objective Optimal Scheduling Framework for HVAC Devices in Energy Efficient Buildings', '5716', 'Nilotpal Chakraborty, Arijit Mondal and Samrat Mondal', '', '2019-08-07', 1, ''),
('7671', 'Integrated Procedure Automating Test Chip Layout, Place and Route, and Test Plan Development for Efficient Parametric Device and Process Designs', '3892', 'Ann Gabrys, Wendy Greig, Andrew J. West, Philipp lindorfer, William French, Samrat Mondal, Devjyoti Patra, Kalyan Goswami, Shamik Sural and Timothy Crandle', 'Volume: 22, Issue: 1, pp. 110-118', '2009-02-01', 0, ''),
('7816', 'A Divide-and-Conquer based Efficient Non-dominated Sorting Approach', '7833', 'Sumit Mishra, Sriparna Saha, Samrat Mondal and Carlos A. Coello Coello', 'Vol: 44,pp: 748-773', '2019-02-01', 0, ''),
('7821', 'Reasoning about timing behavior of digital using symbolic event propagation and temporal logic', '3687', 'Arijit Mondal, P. P. Chakrabarti', 'Vol 25, No. 9, pages 1973-1814', '2006-01-01', 0, ''),
('8187', 'Dispersion Ratio Based Decision Tree Model for Classification', '3478', 'Smita Roy, Samrat Mondal, Asif Ekbal and Maunendra Sankar Desarkar', 'Vol: 116, pp.1-9', '2019-02-01', 0, ''),
('8852', 'Security Analysis of RBAC with Temporal Constraints - A Model Checking Approach', '3204', 'Samrat Mondal and Shamik Sural', 'Volume: 4, Issue: 4, pp. 319-328', '2009-01-01', 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `projects`
--
CREATE TABLE `projects` (
`pid` varchar(5) NOT NULL,
`title` varchar(200) NOT NULL,
`pi` varchar(5) DEFAULT NULL,
`cost` int(11) DEFAULT NULL COMMENT 'in rupees',
`duration` int(11) DEFAULT NULL COMMENT 'in months',
`other_details` varchar(200) NOT NULL,
`completed` tinyint(1) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `projects`
--
INSERT INTO `projects` (`pid`, `title`, `pi`, `cost`, `duration`, `other_details`, `completed`) VALUES
('3277', 'Design and FPGA prototyping of multicarrier multiple access schemes for variable rate multimedia satellite communication', NULL, NULL, NULL, 'Principal Investigator - Dr. Preetam Kumar and Dr. Kailash Chandra Ray', 0),
('5341', 'Development of an efficient authentication scheme to be used in public domain.', '3511', 1604000, 36, '', 1),
('9376', 'Development of Planning and Designing Tool for Smartly Adopting Electric Vehicles in Indian Cities.', '3511', 5742000, 36, '', 0);
-- --------------------------------------------------------
--
-- Table structure for table `project_co_pi`
--
CREATE TABLE `project_co_pi` (
`pid` varchar(5) NOT NULL,
`fid` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `project_co_pi`
--
INSERT INTO `project_co_pi` (`pid`, `fid`) VALUES
('3277', '1658'),
('9376', '1658'),
('9376', '8113');
-- --------------------------------------------------------
--
-- Table structure for table `sponsored_by`
--
CREATE TABLE `sponsored_by` (
`pid` varchar(5) NOT NULL,
`sid` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sponsored_by`
--
INSERT INTO `sponsored_by` (`pid`, `sid`) VALUES
('9376', '0824'),
('5341', '3801'),
('3277', '5168');
-- --------------------------------------------------------
--
-- Table structure for table `sponsors`
--
CREATE TABLE `sponsors` (
`sid` varchar(5) NOT NULL,
`name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sponsors`
--
INSERT INTO `sponsors` (`sid`, `name`) VALUES
('0824', 'IMPRINT-2 DST/SERB'),
('3801', 'Science & Engineering Research Board (SERB)'),
('5168', 'DEIT, Delhi');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `conferences`
--
ALTER TABLE `conferences`
ADD PRIMARY KEY (`cid`);
--
-- Indexes for table `conf_authors`
--
ALTER TABLE `conf_authors`
ADD PRIMARY KEY (`centryid`,`fid`),
ADD KEY `conf_authors_ibfk_2` (`fid`);
--
-- Indexes for table `conf_pubs`
--
ALTER TABLE `conf_pubs`
ADD PRIMARY KEY (`centryid`),
ADD KEY `cid_index` (`cid`) USING BTREE;
--
-- Indexes for table `faculty`
--
ALTER TABLE `faculty`
ADD PRIMARY KEY (`fid`);
--
-- Indexes for table `journals`
--
ALTER TABLE `journals`
ADD PRIMARY KEY (`jid`) USING BTREE,
ADD UNIQUE KEY `name` (`name`);
--
-- Indexes for table `journal_authors`
--
ALTER TABLE `journal_authors`
ADD PRIMARY KEY (`jentryid`,`fid`),
ADD KEY `journal_authors_ibfk_2` (`fid`);
--
-- Indexes for table `journal_pubs`
--
ALTER TABLE `journal_pubs`
ADD PRIMARY KEY (`jentryid`),
ADD KEY `jid_index` (`jid`);
--
-- Indexes for table `projects`
--
ALTER TABLE `projects`
ADD PRIMARY KEY (`pid`),
ADD KEY `pi_index` (`pi`);
--
-- Indexes for table `project_co_pi`
--
ALTER TABLE `project_co_pi`
ADD PRIMARY KEY (`pid`,`fid`),
ADD KEY `fid` (`fid`);
--
-- Indexes for table `sponsored_by`
--
ALTER TABLE `sponsored_by`
ADD PRIMARY KEY (`pid`,`sid`),
ADD KEY `sid` (`sid`);
--
-- Indexes for table `sponsors`
--
ALTER TABLE `sponsors`
ADD PRIMARY KEY (`sid`);
--
-- Constraints for dumped tables
--
--
-- Constraints for table `conf_authors`
--
ALTER TABLE `conf_authors`
ADD CONSTRAINT `conf_authors_ibfk_1` FOREIGN KEY (`centryid`) REFERENCES `conf_pubs` (`centryid`),
ADD CONSTRAINT `conf_authors_ibfk_2` FOREIGN KEY (`fid`) REFERENCES `faculty` (`fid`);
--
-- Constraints for table `conf_pubs`
--
ALTER TABLE `conf_pubs`
ADD CONSTRAINT `conf_pubs_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `conferences` (`cid`);
--
-- Constraints for table `journal_authors`
--
ALTER TABLE `journal_authors`
ADD CONSTRAINT `journal_authors_ibfk_1` FOREIGN KEY (`jentryid`) REFERENCES `journal_pubs` (`jentryid`),
ADD CONSTRAINT `journal_authors_ibfk_2` FOREIGN KEY (`fid`) REFERENCES `faculty` (`fid`);
--
-- Constraints for table `journal_pubs`
--
ALTER TABLE `journal_pubs`
ADD CONSTRAINT `journal_pubs_ibfk_1` FOREIGN KEY (`jid`) REFERENCES `journals` (`jid`);
--
-- Constraints for table `projects`
--
ALTER TABLE `projects`
ADD CONSTRAINT `projects_ibfk_1` FOREIGN KEY (`pi`) REFERENCES `faculty` (`fid`);
--
-- Constraints for table `project_co_pi`
--
ALTER TABLE `project_co_pi`
ADD CONSTRAINT `project_co_pi_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `projects` (`pid`),
ADD CONSTRAINT `project_co_pi_ibfk_2` FOREIGN KEY (`fid`) REFERENCES `faculty` (`fid`);
--
-- Constraints for table `sponsored_by`
--
ALTER TABLE `sponsored_by`
ADD CONSTRAINT `sponsored_by_ibfk_1` FOREIGN KEY (`pid`) REFERENCES `projects` (`pid`),
ADD CONSTRAINT `sponsored_by_ibfk_2` FOREIGN KEY (`sid`) REFERENCES `sponsors` (`sid`);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;