-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `chimezie`
--

-- --------------------------------------------------------

--
-- Table structure for table `assignment`
--

CREATE TABLE `assignment` (
  `id` int(11) NOT NULL,
  `teacher_id` varchar(200) NOT NULL,
  `title` varchar(200) NOT NULL,
  `dept` varchar(200) NOT NULL,
  `content` varchar(10000) NOT NULL,
  `student_email` varchar(200) NOT NULL,
  `score` int(100) NOT NULL,
  `status` varchar(200) NOT NULL,
  `content_id` varchar(12) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `assignment`
--

INSERT INTO `assignment` (`id`, `teacher_id`, `title`, `dept`, `content`, `student_email`, `score`, `status`, `content_id`) VALUES
(1, 'ezemakelle@gmail.com', 'image assignment', 'Class_1', 'This should work', 'favouremmanuel@gmail.com', 12, 'Submitted', '5'),
(2, 'favour2020@gmail.com', 'Diamond Assignment', 'Class_1', 'this is a test', 'favouremmanuel@gmail.com', 0, 'Submitted', '10');

-- --------------------------------------------------------

--
-- Table structure for table `comment_tab`
--

CREATE TABLE `comment_tab` (
  `id` int(11) NOT NULL,
  `content_id` varchar(100) NOT NULL,
  `student_name` varchar(100) NOT NULL,
  `student_pic` varchar(150) NOT NULL,
  `comment` varchar(10000) NOT NULL,
  `teacher_id` varchar(100) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `comment_tab`
--

INSERT INTO `comment_tab` (`id`, `content_id`, `student_name`, `student_pic`, `comment`, `teacher_id`, `date`) VALUES
(1, '12', 'Reg Victor', '', 'This is a mess Up', '', '2021-07-12 13:51:21'),
(2, '10', 'Victor Effiong', '', '', '', '2021-07-12 13:52:39'),
(3, '2', 'Jude', '', 'This is a test', '', '2021-07-14 01:53:45'),
(4, '2', 'EXPERT PLAN', '', 'Good', '', '2021-07-14 02:14:16'),
(5, '1', 'Good', '', 'Testing', '', '2021-07-14 02:21:20'),
(6, '1', 'Jude bad ', '', 'Testing also', '', '2021-07-14 09:37:56'),
(7, '1', 'Ezema Kelechi Henry', '', 'This should be better', 'kele@gmail.com', '2021-07-14 11:15:40'),
(8, '6', 'edino amos', '', 'I have read this and i need more clearification on paragraph 2', 'ezemakelle@gmail.com', '2021-07-14 12:32:33'),
(9, '8', 'favour cps', '', 'Testing', '<br />\r\n<b>Notice</b>:  Undefined index: teacher_id in <b>C:\\xampp\\htdocs\\pearl\\details.php</b> on l', '2021-07-16 06:15:21'),
(11, '8', 'favour cps', 'pearl_6cd8eaf7460927f0a9a5d3711077a133.png', 'This Should work', 'food@gmail.com', '2021-07-16 06:29:42'),
(12, '8', 'edino amos', '1626429733012.jpeg', 'Doings get levels', 'food@gmail.com', '2021-07-16 11:43:54'),
(13, '8', 'edino amos', '1626429733012.jpeg', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>This should help you with the proble,s</p>\r\n</body>\r\n</html>\r\n', 'food@gmail.com', '2021-07-16 11:47:08'),
(14, '2', 'Amos Edino', '', 'This should work', 'good@gmail.com', '2021-08-01 14:24:20'),
(15, '2', 'Amos Edino', '', 'Please can u all see what am seeing', 'good@gmail.com', '2021-08-01 14:29:07'),
(16, '17', 'Amos Edino', '', 'What about This nah', 'good@gmail.com', '2021-08-01 14:31:35'),
(17, '17', 'Amos Edino', '', 'This boy is good', 'good@gmail.com', '2021-08-01 14:33:13'),
(18, '18', 'Amos Edino', '', 'Hello all', 'good@gmail.com', '2021-08-01 14:33:38'),
(19, '14', 'Favour Girl', '', 'this is okay', 'good@gmail.com', '2021-08-03 15:01:57');

-- --------------------------------------------------------

--
-- Table structure for table `content`
--

CREATE TABLE `content` (
  `id` int(11) NOT NULL,
  `teacher_id` varchar(100) NOT NULL,
  `title` varchar(150) NOT NULL,
  `module_id` int(100) NOT NULL,
  `dept` varchar(100) NOT NULL,
  `content` mediumtext NOT NULL,
  `content_type` varchar(100) NOT NULL,
  `file1` varchar(100) NOT NULL,
  `file2` varchar(100) NOT NULL,
  `date_posted` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `content`
--

INSERT INTO `content` (`id`, `teacher_id`, `title`, `module_id`, `dept`, `content`, `content_type`, `file1`, `file2`, `date_posted`) VALUES
(1, 'kele@gmail.com', 'Testing', 0, 'Computer', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Automated palliative money disbarment has to do with the application of computer knowledge in the course of allocating and disbusing palliative money to the masses&quot;</p>\r\n\r\n<p>&quot;</p>\r\n</body>\r\n</html>\r\n', 'Lecture_Note', 'blog_afad1c716d0fe3d842bc4c4df80e168e.jpg', 'blog_afad1c716d0fe3d842bc4c4df80e168e.jpg', '2021-07-12 13:33:08'),
(2, 'Reg@gmail.com', 'FootBall Match', 0, 'Biology', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Fine boy no swags</p>\r\n</body>\r\n</html>\r\n', 'Assignment', 'blog_f088bd4131c6a268c64f611ece0cd4da.png', '', '2021-07-13 14:11:44'),
(5, 'ezemakelle@gmail.com', 'image assignment', 0, 'Computer', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>do this to be submitted next week</p>\r\n</body>\r\n</html>\r\n', 'Assignment', 'blog_a45ccde394145439fd4ba514138060ab.jpg', '', '2021-07-14 12:23:02'),
(6, 'ezemakelle@gmail.com', 'notes', 0, 'Computer', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>read this</p>\r\n</body>\r\n</html>\r\n', 'Lecture_Note', 'blog_ea11478fca645fb6e76f6a2357e51c88.png', '', '2021-07-14 12:28:44'),
(7, 'ezemakelle@gmail.com', 'biology course', 0, 'Computer', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>get ur note above</p>\r\n</body>\r\n</html>\r\n', 'Lecture_Note', 'blog_c4b0b7a59dcc6e7c8259f9c37c8e1041.docx', '', '2021-07-15 13:09:39'),
(8, 'food@gmail.com', 'Adding two numbers', 0, 'Class_4', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Labore dolor amet ipsum ea, erat sit ipsum duo eos. Volup amet ea dolor et magna dolor, elitr rebum duo est sed diam elitr. Stet elitr stet diam duo eos rebum ipsum diam ipsum elitr.</p>\r\n\r\n<p>&nbsp;</p>\r\n</body>\r\n</html>\r\n', 'English', 'blog_40d363231fd60bf8ec0832b352411c6f.jpg', '', '2021-07-16 05:05:24'),
(9, 'food@gmail.com', 'Example of Acknowledgement', 0, 'Class_3', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p style=\"margin:0cm 0cm 8pt; text-align:justify\"><span style=\"font-size:11pt\"><span style=\"line-height:107%\"><span style=\"font-family:Calibri,sans-serif\"><span lang=\"EN-US\" style=\"font-size:14.0pt\"><span style=\"line-height:107%\"><span style=\"font-family:&quot;Times New Roman&quot;,serif\">Foremost, I express my sincere gratitude to God Almighty for giving me the grace and knowledge to bring this project to actualization and my department, the department of computer Science for giving me the opportunity to embark on this project and in the process learn a great deal from it.</span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:0cm 0cm 8pt; text-align:justify\"><span style=\"font-size:11pt\"><span style=\"line-height:107%\"><span style=\"font-family:Calibri,sans-serif\"><span lang=\"EN-US\" style=\"font-size:14.0pt\"><span style=\"line-height:107%\"><span style=\"font-family:&quot;Times New Roman&quot;,serif\">My profound appreciation goes to my amiable supervisor, Modesta. E. Ezema (Ph.D) Senior Lecturer, Computer Science Department University of Nigeria Nsukka. Pioneer coordinator Nigeria Women in Information Technology (NIWIIT) Enugu State (2012-2016) Second Vice President Nigeria Women in Information Technology (NIWIIT) National (2016-2018) for her valuable contributions, support and time spent to help me complete this project.</span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:0cm 0cm 8pt; text-align:justify\"><span style=\"font-size:11pt\"><span style=\"line-height:107%\"><span style=\"font-family:Calibri,sans-serif\"><span lang=\"EN-US\" style=\"font-size:14.0pt\"><span style=\"line-height:107%\"><span style=\"font-family:&quot;Times New Roman&quot;,serif\">I won&#39;t forget to appreciate the influence of my friends who constructively criticized my work, encouraged me to do better and helped me in one way or the other.</span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:0cm 0cm 8pt; text-align:justify\"><span style=\"font-size:11pt\"><span style=\"line-height:107%\"><span style=\"font-family:Calibri,sans-serif\"><span lang=\"EN-US\" style=\"font-size:14.0pt\"><span style=\"line-height:107%\"><span style=\"font-family:&quot;Times New Roman&quot;,serif\">I want to specially acknowledge my parents, siblings and family relations for their continual support during the period of the project. They were integral to the success of this project.</span></span></span></span></span></span></p>\r\n</body>\r\n</html>\r\n', 'Science', 'blog_d903292761a398c4dfaee8f0fb4a5553.jpg', '', '2021-07-16 12:00:41'),
(11, 'favour2020@gmail.com', 'FootBall Match', 0, 'Class_2', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Labore sea amet kasd diam justo amet ut vero justo. Ipsum ut et kasd duo sit, ipsum sea et erat est dolore, magna ipsum et magna elitr. Accusam accusam lorem magna, eos et sed eirmod dolor est eirmod eirmod amet.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<form action=\"http://localhost/pearl/save_assignment.php\" method=\"post\">&nbsp;</form>\r\n</body>\r\n</html>\r\n', 'Mathematics', 'blog_d41906e2e6311cda0a4248140c762778.mp4', '', '2021-07-22 08:30:51'),
(12, 'favour2020@gmail.com', 'Introduction To Number Systems', 0, 'Class_2', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Labore sea amet kasd diam justo amet ut vero justo. Ipsum ut et kasd duo sit, ipsum sea et erat est dolore, magna ipsum et magna elitr. Accusam accusam lorem magna, eos et sed eirmod dolor est eirmod eirmod amet.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<form action=\"http://localhost/pearl/save_assignment.php\" method=\"post\">&nbsp;</form>\r\n</body>\r\n</html>\r\n', 'Mathematics', 'blog_de1104df07fc87188c22c506ace06fe2.mp4', '', '2021-07-22 08:56:26'),
(13, 'good@gmail.com', 'Overview of computer Networks', 1, 'Physics', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>&nbsp;</p>\r\n\r\n<p>\r\n<video controls=\"\" height=\"420\" width=\"640\"><source src=\"uploads/Benefit-of-Data-warehouse.mp4\" type=\"video/mp4\" /></video>\r\n</p>\r\n\r\n<p><strong>Scale of Computer Networks</strong></p>\r\n\r\n<p>Conceivably, the most significant change in Computer Engineering and Science over the past twenty years has been the enormous growth of networks and their importance in the daily lives of billions of people. Because of this growth, and the diversity of networks now widespread across the globe. Computers may connect to each other by either wired or wireless media. &nbsp;There is no doubt that computer networks, also known as datacom or data transmission networks, represent a logical result of the evolution of two of the most vital scientific and technical of modern civilization called computer and telecommunication technologies.</p>\r\n\r\n<p>A computer network consists of two or more computing devices that are connected in order to share the components of your network (its resources) and the information. Our working definition of a computer network is &ldquo;any system that allows communication between devices that perform algorithms on data.&rdquo; Although devices that perform data processing are now invariably digital systems, not all of the devices connected to networks are data processing devices. Examples are a microphone, an analog telephone and refrigerator. The history of networks, described below, includes many non-digital devices and, as networks become ever-present, more and more types of devices are connected to networks.</p>\r\n\r\n<p>The historical and anthropological study of social networks, how humans interact and communicate, is not limited to communication by electricity,</p>\r\n\r\n<p>radio, and optical systems. However, for our discussion it is more useful to begin with the electrical telegraph and telephone systems that became the foundation for what would become the first computer networks.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Telegraphy and Broadcasting</strong></p>\r\n\r\n<p>The first telegraph systems had no mechanical repeating .Repeating is crucial because an electrical signal can only travel so long before it is too weak to be useful. Therefore longer distances, a person had to listen to the Morse code or other coded signal and repeat the message by entering it again, physically tapping it on a key. A repeater is solely a device that does the job of repeating a signal cleanly and clearly so that it can travel for longer distances without signal degradation. Telegraph lines with repeaters were really the beginning of networks, in recent time. Many types of repeater are still important to networks. There are similar limitations on wireless signals and signals transmitted through optical fiber so these networks also often use repeaters. After communication, systems became more than just one line with one transmitter and one receiver at a time, the next problem was how to get a message from one end to another on a network that had many possible destinations. One possibility is to have each message broadcast to all destinations at once over the whole network. Many networks still use this principle. Radio and television networks have operated on the same broadcast principles for over half a century, except for various changes in the format of information being sent and received (for example FM vs. AM, analog vs. digital, etc.).</p>\r\n\r\n<p>One problem with broadcasting is that most systems could only take one message at a time per channel or per line .On such systems there must be away to avoid collisions , messages interfering with each other because of more than one sender using a single medium. Avoiding collisions is still an important task in modern communication networks.</p>\r\n\r\n<p>The data transmitted by telegraph was essentially digital and in a binary form. This binary form was usually in a form not based on binary numbers but easy for human operators. Mechanization of the codes meant switching to regular-length codes based on binary numbers, such as the Baudot code. Developed by &Eacute;mile Baudot, this code was a five-bit binary code for sending (upper case) alphabetic characters, other characters, and control sequences. This code was later developed into the ASCII (American Standard Code for Information Interchange) which is used in many programming languages and other computer applications.</p>\r\n\r\n<p><strong>Telephony</strong></p>\r\n\r\n<p>Unlike telegraph, the telephone could transmit analog data. The developers of the telephone (like the developers of many networks) did not foresee its main purpose, for voice transmission .Suddenly special training was no longer necessary and smaller businesses, organizations, and homes could be part of the network. However, the increase in the number of possible receivers and the need to send to just one (or a small number) is a problem on an open network.</p>\r\n\r\n<p>Point-to-point access requires some kind of switching . As with repeating, this job was originally done by human operators who listened for signals (voice or code) and physically connected the lines or turned switches. Automatic electromechanical switches were developed to take the place of human operators and automatic switching became such an essential change that we still call a telephone network a Public Switched Telephone Network or PSTN.</p>\r\n\r\n<p>In many countries, public companies were given a monopoly over providing telephone services, in exchange for providing broad PSTN coverage.</p>\r\n\r\n<p>Telephone monopolies at first resisted connection of unapproved devices, such as a modem (modulator-demodulator). As more computers connected, the global PSTN and its various networks became the foundation for many early computer networks and still has a major role in computer networks, both on a local and a global level.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>The First Computer Networks</strong></p>\r\n\r\n<p>Military research groups began to investigate the large-scale coordination of digital information in the 1950&rsquo;s. The Semi-Automatic Ground Environment</p>\r\n\r\n<p>(SAGE) was a US Air Force project designed to bring together various military data, such as radar data. One developer of SAGE brought the networking ideas to business with the airline reservation system called the&nbsp; Semi-Automated Business Research Environment (SABRE). These and other advances resulted in a variety of different networks developing around the world, networks with completely different protocols .A protocol is a mutually understood method of transaction, without which meaningful communication</p>\r\n\r\n<p>is impossible. The Internet as we know it today requires some way of uniting these various networks under shared protocols.</p>\r\n\r\n<p>In the late 1960&rsquo;s, the Advanced Research Projects Agency Network, known as ARPANET, was formed from smaller networks. ARPANET was a military project but, at a very early stage, it began to connect many non-military organizations, including educational institutions. Under this project, the first large-scale integration of networks was attempted. It was called &ldquo;internetworking&rdquo; but this adjective was shortened to internet . Eventually the word became a proper noun and the National Science Foundation (NSF) took over the growing Internet , as NSFNET. By this time, the expansion of Unix distributions, especially BSD Unix (Berkeley Software Distribution Unix), had allowed many universities to join the new global network.</p>\r\n\r\n<p>Corporations had been involved as research partners but the network was still not open to specifically commercial uses. The NSF opened the Internet for commercial use in 1991. Whether we look at number of devices connected or the amount of traffic, the growth of the Internet has been exponential in this century. However, contribution of some methods to actualize the goal of computer networks cannot be over emphasized such as Batch processing and mulititerminal systems.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Batch processing Systems</strong></p>\r\n\r\n<p>Batch processing played important role because of bulky and high cost of mainframe computers. These computers never handled the users interactively as expected leading to batching of jobs and later delivery of computation. This is called centralized system.</p>\r\n\r\n<p>The need to allow users be in charge of managing data in an interactive mode became paramount, therefore more research on the technology.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>Multi-terminal systems: Prototype of the Computer Network.</strong></p>\r\n\r\n<p>In 1960s, a switch to new methods of organizing computer processing for efficiency evolved, these methods took into accounts the end users expediency thus multiterminal systems. Terminals moved out of computing centers onto desktops over entire organizations as at then. Nevertheless, processing power is solely centralized, some functions as data inputs and outputs became distributed due to high number of users. This highly looked similar to Local Area Networks (LANs) of today. Access to shared files and peripheral devices turned reality and maintained the illusion of using the computers in an exclusive mode by the users.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p><strong>First Wide Area Networks (WANs)</strong></p>\r\n\r\n<p>Wide Area Networks evolved first joining geographical distributed computers in countries.</p>\r\n\r\n<p>The moment distributed systems appeared, not only were there connections between terminals and computers but also connections was implemented between computers. It all started with the solution of a simpler task by providing access to a computer from remote terminals located hundreds and thousands of kilometers apart.</p>\r\n\r\n<p>Computers were able to interact in terms of data exchange on automatic mode, which is the basis for computer networking.</p>\r\n\r\n<p>During process of Developing WANs, modern fundamental computer networking ideas such as th', 'Lecture_Note', '', '', '2021-07-31 20:47:50'),
(14, 'good@gmail.com', 'Benefits of data warehouse', 1, 'Physics', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>&nbsp;</p>\r\n\r\n<p>\r\n<video controls=\"\" height=\"420\" width=\"640\"><source src=\"uploads/Data-Encrption.mp4\" type=\"video/mp4\" /></video>\r\n</p>\r\n\r\n<p><strong>Benefits of data warehouse</strong></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>A data warehouse maintains a copy of information from the source transaction systems. This architectural complexity provides the opportunity to:</p>\r\n\r\n<ul>\r\n	<li>Integrate data from multiple sources into a single database and data model. More congregation of data to single database so a single query engine can be used to present data in an ODS.</li>\r\n	<li>Mitigate the problem of database isolation level lock contention in transaction processing systems caused by attempts to run large, long-running, analysis queries in transaction processing databases.</li>\r\n	<li>Maintain data history, even if the source transaction systems do not.</li>\r\n	<li>Integrate data from multiple source systems, enabling a central view across the enterprise. This benefit is always valuable, but particularly so when the organization has grown by merger.</li>\r\n	<li>Improve data quality, by providing consistent codes and descriptions, flagging or even fixing bad data.</li>\r\n	<li>Present the organization&rsquo;s information consistently.</li>\r\n	<li>Provide a single common data model for all data of interest regardless of the data&rsquo;s source.</li>\r\n	<li>Restructure the data so that it makes sense to the business users.</li>\r\n	<li>Restructure the data so that it delivers excellent query performance, even for complex analytic queries, without impacting the operational systems.</li>\r\n	<li>Add value to operational business applications, notably customer relationship management (CRM) systems.</li>\r\n	<li>Make decision&ndash;support queries easier to write.</li>\r\n	<li>Organize and disambiguate repetitive data.</li>\r\n</ul>\r\n</body>\r\n</html>\r\n', 'Lecture_Note', '', '', '2021-08-01 09:09:13'),
(15, 'good@gmail.com', 'Assignment on Benefits of data warehouse', 1, 'Physics', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>A data warehouse maintains a copy of information from the source transaction systems. This architectural complexity provides the opportunity to:</p>\r\n\r\n<p>Integrate data from multiple sources into a single database and data model. More congregation of data to single database so a single query engine can be used to present data in an ODS.</p>\r\n</body>\r\n</html>\r\n', 'Assignment', '', '', '2021-08-01 09:21:44');
INSERT INTO `content` (`id`, `teacher_id`, `title`, `module_id`, `dept`, `content`, `content_type`, `file1`, `file2`, `date_posted`) VALUES
(17, 'good@gmail.com', 'Data mining software and application in problem solving', 2, 'Physics', '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">1.<strong style=\"box-sizing:border-box; font-weight:700\">&nbsp;<span style=\"box-sizing:border-box\">Carrot&sup2;</span></strong>&nbsp;is an open source search results clustering engine.&nbsp;It can automatically&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Cluster_analysis\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Cluster analysis\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">cluster</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&nbsp;small collections of documents, e.g. search results or document abstracts, into thematic categories. Apart from two specialized search results clustering algorithms, Carrot&sup2; offers ready-to-use components for fetching search results from various sources.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">2.&nbsp;<strong style=\"box-sizing:border-box; font-weight:700\">Chemicalize</strong>&nbsp;is an online platform for chemical calculations, search, and text processing. It is developed and owned by ChemAxon and offers various cheminformatics tools in freemium model: chemical property predictions, structure-based and text-based search, chemical text processing, and checking compounds with respect to national regulations of different countries.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">3.&nbsp;<strong style=\"box-sizing:border-box; font-weight:700\">General Architecture for Text Engineering</strong></span></span></span></span><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&nbsp;or&nbsp;<strong style=\"box-sizing:border-box; font-weight:700\">GATE</strong>&nbsp;is a&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Java_(programming_language)\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Java (programming language)\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">Java</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&nbsp;suite of tools developed for scientists, companies, teachers and students for many&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Natural_language_processing\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Natural language processing\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">natural language processing</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&nbsp;tasks, including&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Information_extraction\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Information extraction\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">information extraction</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&nbsp;in many languages. GATE includes an&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Information_extraction\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Information extraction\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">information extraction</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&nbsp;system called&nbsp;<strong style=\"box-sizing:border-box; font-weight:700\">ANNIE</strong>&nbsp;(<strong style=\"box-sizing:border-box; font-weight:700\">A Nearly-New Information Extraction System</strong>) which is a set of modules comprising a&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Lexical_analysis\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Lexical analysis\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">tokenizer</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">, a&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Gazetteer\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Gazetteer\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">gazetteer</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">, a&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Sentence_boundary_disambiguation\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Sentence boundary disambiguation\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">sentence splitter</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">, a&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Part-of-speech_tagging\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Part-of-speech tagging\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">part of speech tagger</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">, a&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Named_entity_recognition\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Named entity recognition\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">named entities</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&nbsp;transducer and a&nbsp;co reference&nbsp;tagger. ANNIE can be used as-is to provide basic&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Information_extraction\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Information extraction\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">information extraction</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&nbsp;functionality, or provide a starting point for more specific tasks. Languages currently handled GATE include&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/English_language\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"English language\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">English</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">,&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Standard_Chinese\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Standard Chinese\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">Chinese</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">,&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Arabic\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Arabic\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">Arabic</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">,&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Bulgarian_language\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Bulgarian language\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">Bulgarian</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">,&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/French_language\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"French language\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">French</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">,&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/German_language\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"German language\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">German</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">,&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Hindi\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Hindi\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">Hindi</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">,&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Italian_language\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Italian language\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">Italian</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">,&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Cebuano_language\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Cebuano language\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">Cebuano</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">,&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Romanian_language\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Romanian language\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">Romanian</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">,&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Russian_language\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Russian language\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">Russian</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">,&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Danish_language\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Danish language\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">Danish</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">. GATE generates vast quantities of information including; natural language text, semantic annotations, and ontological information. Sometimes the data itself is the end product of an application but often the information would be more useful if it could be efficiently searched. GATE Mimir provides support for indexing and searching the linguistic and semantic information generated by such applications and allows for querying the information using arbitrary combinations of text, structural information, and SPARQL.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">4.&nbsp;<strong style=\"box-sizing:border-box; font-weight:700\">KNIME</strong>&nbsp;allows users to visually create data flows (or pipelines), selectively execute some or all analysis steps, and later inspect the results, models, and interactive views. KNIME is written in Java and based on&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Eclipse_(software)\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Eclipse (software)\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">Eclipse</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&nbsp;and makes use of its extension mechanism to add plugins providing additional functionality. The core version already includes hundreds of modules for data integration (file I/O, database nodes supporting all common database management systems through JDBC or native connectors: SQLite, SQL Server, MySQL, PostgreSQL, Vertica and H2), data transformation (filter, converter, splitter, combiner, joiner) as well as the commonly used methods of statistics, data mining, analysis and text analytics. Visualization supports with the free Report Designer extension. KNIME workflows can be used as data sets to create report templates that can be exported to document formats like doc, ppt, xls, pdf and others. Other capabilities of KNIME are:</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:10px 0px 1.2pt 19.2pt; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">1. KNIMEs core-architecture allows processing of large data volumes that are only limited by the available hard disk space (not limited to the available RAM). E.g. KNIME allows analysis of 300 million customer addresses, 20 million cell images and 10 million molecular structures.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:10px 0px 1.2pt 19.2pt; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">2. Additional plugins allows the integration of methods for&nbsp;</span></span></span></span><a href=\"https://en.wikipedia.org/wiki/Text_mining\" style=\"box-sizing:border-box; color:#009dd8; text-decoration:none; appearance:none; outline:0px; font-weight:400\" title=\"Text mining\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\"><span style=\"text-decoration:none\">Text mining</span></span></span></span></span></a><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">, Image mining, as well as time series analysis.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">5.&nbsp;<strong style=\"box-sizing:border-box; font-weight:700\">Massive Online Analysis:&nbsp;</strong>MOA allows users to build and run experiments of machine learning or data mining on evolving data streams. It includes a set of learners and stream generators that can be used from the Graphical User Interface (GUI), the command-line, and the Java API. MOA contains several collections of machine learning algorithms.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">6.&nbsp;<strong style=\"box-sizing:border-box; font-weight:700\">MLPACK (C++ library</strong>): Mlpack is a machine learning software library for C++, built on top of the Armadillo library. Mlpack has an emphasis on scalability, speed, and ease-of-use. Its aim is to make machine learning possible for novice users by means of a simple, consistent API, while simultaneously exploiting C++ language features to provide maximum performance and maximum flexibility for expert users. Its intended target users are scientists and engineers.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">7<strong style=\"box-sizing:border-box; font-weight:700\">. The Natural Language Toolkit</strong>, or more commonly NLTK, is a suite of libraries and programs for symbolic and statistical natural language processing (NLP) for English written in the Python programming language. NLTK is intended to support research and teaching in NLP or closely related areas, including empirical linguistics, cognitive science, artificial intelligence, information retrieval, and machine learning.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">8.&nbsp;<strong style=\"box-sizing:border-box; font-weight:700\">OpenNN</strong>&nbsp;(Open Neural Networks Library) is a software library written in the C++ programming language which implements neural networks. The software implements any number of layers of non-linear processing units for supervised learning. This deep architecture allows the design of neural networks with universal approximation properties. Additionally, it allows multiprocessing programming by means of OpenMP, in order to increase computer performance.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">9.&nbsp;<strong style=\"box-sizing:border-box; font-weight:700\">Torch&nbsp;</strong>Torch is an open source machine learning library, a scientific computingframework, and a script language based on the Lua programming language. It provides a wide range of algorithms for deep learning, and uses the scripting language is used by the Facebook AI Research Group, IBM, Yandex and the Idiap Research Institute. Torch has been extended for use on Android and iOS. It has been used to build hardware implementations for data flows like those found in neural networks.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">10.&nbsp;<strong style=\"box-sizing:border-box; font-weight:700\">IBM SPSS Modeler</strong>&nbsp;is a data mining and text analytics software application from IBM. It is used to build predictive models and conduct other analytic tasks. It has a visual interface which allows users to leverage statistical and data mining algorithms without programming. One of its main aims from the outset was to get rid of unnecessary complexity in data transformations, and to make complex predictive models very easy to use. SPSS Modeler has been used in these and other industries:</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Customer analytics and Customer relationship management (CRM)</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Fraud detection and prevention</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Optimizing insurance claims</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Risk management</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Manufacturing quality improvement</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Healthcare quality improvement</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Forecasting demand or sales</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Law enforcement and border security</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Education</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Telecommunications</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Entertainment: e.g., predicting movie box office receipts</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">11.&nbsp;<strong style=\"box-sizing:border-box; font-weight:700\">Clarabridge&nbsp;</strong>offers software as a service product for sentiment analysis and text analytics to automatically collect categorize and report on structured data and unstructured data. The data typically used for analysis comes from social media (such as Facebook, Twitter, or review sites), call center notes, email, chats, and surveys. Using natural language processingand other patented technology; the software is used in voice of the customer, customer experience management and customer feedback programs.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">12<strong style=\"box-sizing:border-box; font-weight:700\">. LIONsolver</strong>&nbsp;can be used to build models, visualize them, and improve business and engineering processes. It is a tool for decision making based on data and quantitative models, it can be connected to most databases and external programs, it is fully integrated with the Grapheur business intelligence software and intended for more advanced users, interested in designing business logic and processes and not only in simple analytics and visualization tasks.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">The software architecture of LIONsolver permits interactive multi-objective optimization, with a user interface for visualizing the results and facilitating the solution analysis and decision making process. The architecture allows for problem-specific extensions, and it is applicable as a post-processing tool for all optimization schemes with a number of different potential solutions. When the architecture is tightly coupled to a specific problem-solving or optimization method, effective interactive schemes where the final decision maker is in the loop can be developed.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">13<strong style=\"box-sizing:border-box; font-weight:700\">. Microsoft SQL Server Analysis Services, SSAS</strong>, is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services, Reporting Services and Analysis Services. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors &ndash; Multidimensional and Tabular.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">14.&nbsp;<strong style=\"box-sizing:border-box; font-weight:700\">pSeven</strong>&nbsp;is a design space exploration software platform developed by DATADVANCE, extending design, simulation and analysis capabilities and assisting in smarter and faster design decisions. It provides a seamless integration with third party CAD and CAE software tools, powerful multi-objectiveand robust optimization algorithms, data analysis and uncertainty quantification tools. pSeven&rsquo;s application areas are different industries such as aerospace, automotive, energy, electronics, biomedical and others. Application examples are:</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Multidisciplinary and multi-objective optimization of an aircraft family</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in 6pt 0.5in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&nbsp;&nbsp;&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Sizing of composite structures in order to reduce their mass subject to various mechanical and manufacturing constraints</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in 6pt 0.5in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Construction of quick and accurate behavioral models (surrogate models) in order to enable efficient and secure exchange of models across Extended Enterprise</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in 6pt 0.5in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Optimization of the gas path of the steam turbine in order to improve overall turbine efficiency</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">&bull;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Optimization of layered composite armor in order to reduce its weight</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n\r\n<p style=\"margin:6pt 0in; -webkit-text-stroke-width:0px; text-align:justify\"><span style=\"font-size:14px\"><span style=\"box-sizing:border-box\"><span style=\"-webkit-font-smoothing:antialiased\"><span style=\"position:relative\"><span style=\"color:#313b3d\"><span style=\"font-family:&quot;Open Sans&quot;, &quot;Helvetica Neue&quot;, sans-serif\"><span style=\"font-style:normal\"><span style=\"font-variant-ligatures:normal\"><span style=\"font-variant-caps:normal\"><span style=\"font-weight:400\"><span style=\"letter-spacing:normal\"><span style=\"orphans:2\"><span style=\"text-transform:none\"><span style=\"white-space:normal\"><span style=\"widows:2\"><span style=\"word-spacing:0px\"><span style=\"background-color:#ffffff\"><span style=\"text-decoration-thickness:initial\"><span style=\"text-decoration-style:initial\"><span style=\"text-decoration-color:initial\"><span style=\"line-height:28px\"><span style=\"font-size:12pt\"><span style=\"box-sizing:border-box\"><span style=\"line-height:32px\"><span style=\"font-family:&quot;Times New Roman&quot;, serif\">15.&nbsp;<strong style=\"box-sizing:border-box; font-weight:700\">RapidMiner</strong>&nbsp;is a data science software platform developed by the company of the same name that provides an integrated environment for data preparation, machine learning, deep learning, text mining, and predictive analytics. It is used for business and commercial applications as well as for research, education, training, rapid prototyping, and application development and supports all steps of the machine learning process including data preparation, results visualization, model validation and optimization.</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></p>\r\n</body>\r\n</html>\r\n', 'Lecture_Note', '', '', '2021-08-01 10:01:49');


-- --------------------------------------------------------

--
-- Table structure for table `interact`
--

CREATE TABLE `interact` (
  `id` int(11) NOT NULL,
  `sender_id` varchar(100) NOT NULL,
  `content_id` varchar(100) NOT NULL,
  `interact_content` varchar(100) NOT NULL,
  `date_posted` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `module`
--

CREATE TABLE `module` (
  `id` int(11) NOT NULL,
  `Title` varchar(500) NOT NULL,
  `pre_id` int(11) NOT NULL,
  `Summary` varchar(1000) NOT NULL,
  `pic` varchar(200) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `module`
--

INSERT INTO `module` (`id`, `Title`, `pre_id`, `Summary`, `pic`, `date`) VALUES
(1, 'Data communication and internet security', 0, '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Internet security is a branch of computer security specifically related to not only the Internet, often involving browser security</p>\r\n</body>\r\n</html>\r\n', 'blog_6d7868490ac716ec1f525e00b972c094.jpg', '2021-07-31 21:59:22'),
(2, 'Data mining and internet security', 1, '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Learning Objectives<br />\r\nBy the end of this lesson, students should be able to do the following:<br />\r\n1. Define data, information, and knowledge.<br />\r\n2. Define data mining<br />\r\n3. List the data mining software and its application in problem solving.<br />\r\n4. Define Data warehouse</p>\r\n</body>\r\n</html>\r\n', 'blog_dc10170adf27e4c401279edde306a672.jpeg', '2021-08-01 09:47:21'),
(3, 'Wireless communication and mobile computing technology', 2, '<html>\r\n<head>\r\n	<title></title>\r\n</head>\r\n<body>\r\n<p>Learning Objectives<br />\r\nBy the end of this lesson, students should be able to do the following:<br />\r\n1. Define warless communication<br />\r\n2. List the examples of wireless communication technologies<br />\r\n3. Mention types of wireless communication devices<br />\r\n4. Mention the Advantages and Disadvantages of Wireless Communications<br />\r\n5. Explain wireless networks<br />\r\n6. List and explain types of wireless networks<br />\r\n7. Define Network Topology<br />\r\n8. Explain Personal Digital Assistant<br />\r\n9. Explain the functionality of IEEE 802.11 Architecture network<br />\r\n10. Explain Bluetooth security<br />\r\n11. List and explain mobile app used in teaching and learning</p>\r\n</body>\r\n</html>\r\n', 'blog_a8db35e2e1ee087af089503fb15cd685.jpeg', '2021-08-01 14:09:06');

-- --------------------------------------------------------

--
-- Table structure for table `quiz_answer`
--

CREATE TABLE `quiz_answer` (
  `id` int(11) NOT NULL,
  `answer_option` varchar(5) NOT NULL,
  `question_no` int(100) NOT NULL,
  `answer_text` varchar(100) NOT NULL,
  `module_id` int(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `quiz_answer`
--

INSERT INTO `quiz_answer` (`id`, `answer_option`, `question_no`, `answer_text`, `module_id`) VALUES
(169, 'A', 1, 'Kelechi', 1),
(170, 'B', 1, 'Henry', 1),
(171, 'C', 1, 'None', 1),
(172, 'D', 1, 'Good', 1),
(173, 'A', 2, 'Kelechi', 1),
(174, 'B', 2, 'Henry', 1),
(175, 'C', 2, 'None', 1),
(176, 'D', 2, 'Good', 1),
(177, 'A', 3, 'Kelechi', 1),
(178, 'B', 3, 'Henry', 1),
(179, 'C', 3, 'None', 1),
(180, 'D', 3, 'Good', 1),
(181, 'A', 4, 'Kelechi', 1),
(182, 'B', 4, 'Henry', 1),
(183, 'C', 4, 'None', 1),
(184, 'D', 4, 'Good', 1),
(185, 'A', 5, 'Kelechi', 1),
(186, 'B', 5, 'Henry', 1),
(187, 'C', 5, 'None', 1),
(188, 'D', 5, 'Good', 1);

-- --------------------------------------------------------

--
-- Table structure for table `quiz_correct_answer`
--

CREATE TABLE `quiz_correct_answer` (
  `id` int(11) NOT NULL,
  `question_no` int(100) NOT NULL,
  `module_id` int(100) NOT NULL,
  `correct_answer_option` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `quiz_correct_answer`
--

INSERT INTO `quiz_correct_answer` (`id`, `question_no`, `module_id`, `correct_answer_option`) VALUES
(69, 1, 1, 'A'),
(70, 2, 1, 'A'),
(71, 3, 1, 'B'),
(72, 4, 1, 'D'),
(73, 5, 1, 'C');

-- --------------------------------------------------------

--
-- Table structure for table `quiz_questions`
--

CREATE TABLE `quiz_questions` (
  `id` int(11) NOT NULL,
  `question_no` int(100) NOT NULL,
  `question` varchar(100) NOT NULL,
  `module_id` int(100) NOT NULL,
  `date` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `quiz_questions`
--

INSERT INTO `quiz_questions` (`id`, `question_no`, `question`, `module_id`, `date`) VALUES
(56, 1, 'What is your Name', 1, '2021-08-06 12:55:33'),
(57, 2, 'What is your surname', 1, '2021-08-06 12:55:33'),
(58, 3, 'What are you good at', 1, '2021-08-06 12:55:33'),
(59, 4, 'Who ownes the work', 1, '2021-08-06 12:55:33'),
(60, 5, 'This is the last one', 1, '2021-08-06 12:55:33');

-- --------------------------------------------------------

--
-- Table structure for table `student_progress`
--

CREATE TABLE `student_progress` (
  `id` int(11) NOT NULL,
  `student_email` varchar(100) NOT NULL,
  `module_id` int(11) NOT NULL,
  `module_score` int(11) NOT NULL,
  `module_status` varchar(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student_progress`
--

INSERT INTO `student_progress` (`id`, `student_email`, `module_id`, `module_score`, `module_status`) VALUES
(7, 'cps@gmail.com', 1, 6, 'passed');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `assignment`
--
ALTER TABLE `assignment`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `comment_tab`
--
ALTER TABLE `comment_tab`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `content`
--
ALTER TABLE `content`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `interact`
--
ALTER TABLE `interact`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `module`
--
ALTER TABLE `module`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `quiz_answer`
--
ALTER TABLE `quiz_answer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `quiz_correct_answer`
--
ALTER TABLE `quiz_correct_answer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `quiz_questions`
--
ALTER TABLE `quiz_questions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `student_progress`
--
ALTER TABLE `student_progress`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `assignment`
--
ALTER TABLE `assignment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `comment_tab`
--
ALTER TABLE `comment_tab`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `content`
--
ALTER TABLE `content`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `interact`
--
ALTER TABLE `interact`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `module`
--
ALTER TABLE `module`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `quiz_answer`
--
ALTER TABLE `quiz_answer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=209;

--
-- AUTO_INCREMENT for table `quiz_correct_answer`
--
ALTER TABLE `quiz_correct_answer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=79;

--
-- AUTO_INCREMENT for table `quiz_questions`
--
ALTER TABLE `quiz_questions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=66;

--
-- AUTO_INCREMENT for table `student_progress`
--
ALTER TABLE `student_progress`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

