# Scripts & raw data available at http://ossmole.sourceforge.net # Scripts written by Megan Conklin and contributed to the ossmole project # # This data is free and available for any use (afterall we just spidered it ;). # We do however request that those using the data in any published form provide # a citation to: OSSmole Project (2004-2005) SourceForge Available at: # http://ossmole.sourceforge.net # # This particular file is a list of what the topic is for each # project. The information in this file was generated by running the following # 2 queries: # # SELECT description, code, count(*) # FROM project_topic # where datasource_ID=4 # group by 1 # order by 3 desc # Note: not all projects have a topic, and some projects have more # than one. # #Here are the results from datasource_id=4 (April 2005) description code count(*) Software Development 45 6128 Dynamic Content 92 5241 Site Management 243 3408 Internet 87 2546 Games/Entertainment 80 2505 Systems Administration 253 2167 Communications 20 2064 Database 66 2044 Front-Ends 68 1971 Role-Playing 84 1885 Other/Nonlisted Topic 234 1852 WWW/HTTP 90 1844 Education 71 1656 Networking 150 1624 Build Tools 46 1605 Office/Business 129 1596 Code Generators 259 1521 Chat 22 1446 Security 43 1416 File Sharing 251 1328 Artificial Intelligence 133 1244 Internet Relay Chat 24 1204 Monitoring 152 1175 Desktop Environment 55 1157 CGI Tools/Libraries 96 1157 Scientific/Engineering 97 1144 Mathematics 98 1113 Simulation 85 1071 Visualization 135 1065 Interpreters 49 1041 Multi-User Dungeons (MUD) 86 1009 Indexing/Search 93 941 Compilers 48 940 Graphics 100 922 3D Rendering 110 895 Sound/Audio 113 894 Turn Based Strategy 83 891 Email 28 791 HTTP Servers 250 787 Board Games 287 783 Message Boards 95 781 Scheduling 130 753 Distributed Computing 308 728 First Person Shooters 82 719 Database Engines/Servers 67 702 Side-Scrolling/Arcade Games 288 673 Installation/Setup 147 656 Real Time Strategy 81 655 System 136 651 Cryptography 44 650 BBS 21 644 Logging 148 631 Text Processing 285 597 Viewers 112 588 Linux 143 582 Software Distribution 257 568 Gnome 58 566 Filesystems 142 553 MP3 123 550 Operating System Kernels 144 540 Hardware 146 532 Conferencing 27 512 Presentation 111 509 Integrated Development Environments (IDE) 65 504 Information Analysis 385 500 Browsers 91 487 Bio-Informatics 252 480 Hardware Drivers 292 475 Computer Aided Instruction (CAI) 72 471 Debuggers 47 468 Text Editors 63 464 Puzzle Games 268 463 Email Clients (MUA) 31 463 Multimedia 99 462 Firewalls 151 453 Emulators 74 448 3D Modeling 109 447 File Transfer Protocol (FTP) 89 443 K Desktop Environment (KDE) 57 438 Video 125 435 Telephony 247 418 Archiving 19 415 Human Machine Interfaces 272 409 Editors 106 403 Filters 29 402 Players 122 402 Symmetric Multi-processing 312 401 Backup 137 396 Conversion 119 396 Accounting 76 396 Log Analysis 245 391 Clustering 141 378 Testing 575 374 Printing 154 361 Financial 75 352 System Shells 294 321 Physics 387 319 Object Brokering 50 310 Medical Science Apps. 266 307 Documentation 69 297 Graphics Conversion 105 285 Capture 101 283 Office Suites 131 277 Point-Of-Sale 79 269 Version Control 52 264 Electronic Design Automation (EDA) 246 256 Frameworks 606 253 Display 128 247 Usenet News 39 245 Mail Transport Agents 32 244 AOL Instant Messenger 26 240 Name Service (DNS) 149 221 Religion and Philosophy 132 217 Sound Synthesis 249 212 POP3 34 208 GIS 383 208 Window Managers 56 208 ICQ 23 204 MIDI 248 203 Word Processors 70 195 Astronomy 134 193 Analysis 114 188 Boot 139 187 Compression 42 187 CVS 53 184 Packaging 41 179 Benchmark 138 175 Sociology 282 173 Capture/Recording 115 167 Authentication/Directory 289 164 Terminals 156 156 LDAP 291 156 Speech 124 154 Vector-Based 107 150 Internet Phone 40 150 Mailing List Servers 30 149 User Interfaces 561 148 Investment 77 145 WAP 270 143 Interface Engine/Protocol Translator 386 139 Ham Radio 38 138 Object Oriented 562 132 CD Ripping 118 132 Digital Camera 103 131 Chemistry 384 129 Link Checking 244 123 Telnet 159 121 Terminal Emulators/X Terminals 158 120 XML 559 109 Emacs 64 108 IMAP 35 108 Gnutella 286 101 Raster-Based 108 98 Page Counters 94 91 Mixers 121 87 CORBA 51 87 CD Audio 116 85 Post-Office 33 84 Genealogy 284 84 Serial 157 73 Napster 241 71 Spreadsheet 78 69 CD Playing 117 65 Non-Linear Editor 256 65 Data Formats 554 61 Simulations 600 59 File Management 601 59 Fax 36 58 Init 140 57 Quality Assurance 565 57 Screen Savers 62 52 FIDO 37 52 BSD 145 50 I18N (Internationalization) 408 49 Scanners 102 47 Project Management 607 47 Modeling 563 44 Algorithms 620 44 Design 582 43 History 283 41 Screen Capture 104 38 HTML/XHTML 556 38 Power (UPS) 153 34 Hardware Watchdog 155 33 Library 581 31 CRM 579 31 L10N (Localization) 409 31 Calendar 585 31 ERP 577 30 Time Tracking 587 30 Unix Talk 25 29 To-Do Lists 588 29 Wireless 566 25 Streaming 590 24 RCS 54 24 Robotics 602 22 Finger 88 22 Enlightenment 59 21 Search 627 21 Intelligent Agents 591 19 Virtual Machines 610 19 Themes 61 18 Card Games 597 18 TeX/LaTeX 558 16 RSS 615 16 Profiling 603 16 Usability 619 14 Cross Compilers 593 14 CASE 570 14 Earth Sciences 567 14 Resource Booking 586 12 MSN Messenger 574 12 Data Warehousing 580 11 Molecular Science 609 11 XML-RPC 616 10 Ecosystem Sciences 568 10 BitTorrent 622 10 SOAP 613 10 GNU Hurd 239 8 NIS 290 8 Mainframes 313 7 Special Effects 595 7 Genetic Algorithms 621 7 Realtime Processing 623 6 SCCS 260 5 OLAP 578 5 New Age 571 4 DocBook 555 4 MARC and Book/Library Metadata 605 3 Log Rotation 592 3 NNTP 614 2 Codec 596 2 OPAC 604 1 #Here are the results from datasourceID=2 (January 2005) +-------------------------------------------+------------+-------------------+ | topic_desc | topic_code | count_of_projects | +-------------------------------------------+------------+-------------------+ | Software Development | 45 | 6034 | | Dynamic Content | 92 | 5061 | | Site Management | 243 | 3266 | | Internet | 87 | 2465 | | Games/Entertainment | 80 | 2435 | | Systems Administration | 253 | 2105 | | Communications | 20 | 1990 | | Database | 66 | 1989 | | Front-Ends | 68 | 1925 | | Role-Playing | 84 | 1832 | | Other/Nonlisted Topic | 234 | 1810 | | WWW/HTTP | 90 | 1776 | | Education | 71 | 1606 | | Build Tools | 46 | 1589 | | Networking | 150 | 1575 | | Office/Business | 129 | 1533 | | Code Generators | 259 | 1485 | | Chat | 22 | 1396 | | Security | 43 | 1350 | | File Sharing | 251 | 1289 | | Artificial Intelligence | 133 | 1214 | | Internet Relay Chat | 24 | 1171 | | CGI Tools/Libraries | 96 | 1135 | | Monitoring | 152 | 1134 | | Scientific/Engineering | 97 | 1131 | | Desktop Environment | 55 | 1119 | | Mathematics | 98 | 1057 | | Simulation | 85 | 1039 | | Visualization | 135 | 1035 | | Interpreters | 49 | 1012 | | Multi-User Dungeons (MUD) | 86 | 977 | | Compilers | 48 | 910 | | Indexing/Search | 93 | 906 | | Graphics | 100 | 899 | | 3D Rendering | 110 | 866 | | Turn Based Strategy | 83 | 864 | | Sound/Audio | 113 | 856 | | Email | 28 | 772 | | HTTP Servers | 250 | 764 | | Message Boards | 95 | 764 | | Board Games | 287 | 752 | | Scheduling | 130 | 734 | | Distributed Computing | 308 | 707 | | First Person Shooters | 82 | 700 | | Database Engines/Servers | 67 | 683 | | Side-Scrolling/Arcade Games | 288 | 651 | | Installation/Setup | 147 | 645 | | Real Time Strategy | 81 | 638 | | System | 136 | 630 | | Cryptography | 44 | 629 | | BBS | 21 | 623 | | Logging | 148 | 613 | | Text Processing | 285 | 574 | | Linux | 143 | 566 | | Viewers | 112 | 563 | | Software Distribution | 257 | 554 | | Gnome | 58 | 548 | | MP3 | 123 | 536 | | Filesystems | 142 | 532 | | Operating System Kernels | 144 | 530 | | Hardware | 146 | 521 | | Conferencing | 27 | 491 | | Presentation | 111 | 488 | | Integrated Development Environments (IDE) | 65 | 484 | | Information Analysis | 385 | 476 | | Browsers | 91 | 464 | | Hardware Drivers | 292 | 458 | | Debuggers | 47 | 454 | | Email Clients (MUA) | 31 | 454 | | Bio-Informatics | 252 | 451 | | Puzzle Games | 268 | 450 | | Multimedia | 99 | 447 | | Text Editors | 63 | 447 | | Computer Aided Instruction (CAI) | 72 | 446 | | 3D Modeling | 109 | 437 | | K Desktop Environment (KDE) | 57 | 436 | | Firewalls | 151 | 436 | | Emulators | 74 | 431 | | File Transfer Protocol (FTP) | 89 | 431 | | Video | 125 | 412 | | Archiving | 19 | 408 | | Symmetric Multi-processing | 312 | 401 | | Telephony | 247 | 396 | | Filters | 29 | 394 | | Human Machine Interfaces | 272 | 392 | | Editors | 106 | 386 | | Players | 122 | 384 | | Accounting | 76 | 383 | | Backup | 137 | 379 | | Conversion | 119 | 375 | | Log Analysis | 245 | 370 | | Clustering | 141 | 367 | | Printing | 154 | 346 | | Financial | 75 | 340 | | Testing | 73 | 322 | | System Shells | 294 | 311 | | Object Brokering | 50 | 305 | | Physics | 387 | 297 | | Medical Science Apps. | 266 | 288 | | Capture | 101 | 272 | | Documentation | 69 | 266 | | Office Suites | 131 | 266 | | Graphics Conversion | 105 | 266 | | Version Control | 52 | 258 | | Point-Of-Sale | 79 | 256 | | Electronic Design Automation (EDA) | 246 | 248 | | Mail Transport Agents | 32 | 241 | | Usenet News | 39 | 239 | | Display | 128 | 238 | | AOL Instant Messenger | 26 | 235 | | Name Service (DNS) | 149 | 216 | | Religion and Philosophy | 132 | 211 | | POP3 | 34 | 206 | | Sound Synthesis | 249 | 204 | | Window Managers | 56 | 204 | | ICQ | 23 | 200 | | GIS | 383 | 194 | | Word Processors | 70 | 192 | | MIDI | 248 | 190 | | Astronomy | 134 | 183 | | Analysis | 114 | 181 | | CVS | 53 | 179 | | Boot | 139 | 179 | | Compression | 42 | 178 | | Packaging | 41 | 175 | | Benchmark | 138 | 171 | | Sociology | 282 | 167 | | Capture/Recording | 115 | 162 | | Authentication/Directory | 289 | 160 | | Terminals | 156 | 153 | | Speech | 124 | 150 | | LDAP | 291 | 150 | | Mailing List Servers | 30 | 147 | | Vector-Based | 107 | 144 | | Investment | 77 | 143 | | Internet Phone | 40 | 143 | | WAP | 270 | 140 | | Ham Radio | 38 | 132 | | Interface Engine/Protocol Translator | 386 | 132 | | CD Ripping | 118 | 128 | | Link Checking | 244 | 123 | | Digital Camera | 103 | 122 | | Chemistry | 384 | 120 | | Telnet | 159 | 119 | | Terminal Emulators/X Terminals | 158 | 115 | | Emacs | 64 | 105 | | IMAP | 35 | 103 | | Gnutella | 286 | 100 | | Raster-Based | 108 | 97 | | Page Counters | 94 | 88 | | CORBA | 51 | 87 | | CD Audio | 116 | 85 | | Mixers | 121 | 85 | | Post-Office | 33 | 84 | | Genealogy | 284 | 81 | | Object Oriented | 562 | 81 | | User Interfaces | 561 | 74 | | Napster | 241 | 71 | | Serial | 157 | 70 | | Frameworks | 606 | 67 | | Spreadsheet | 78 | 66 | | CD Playing | 117 | 66 | | Non-Linear Editor | 256 | 60 | | Fax | 36 | 57 | | Init | 140 | 54 | | Screen Savers | 62 | 50 | | BSD | 145 | 48 | | XML | 559 | 47 | | FIDO | 37 | 47 | | Scanners | 102 | 43 | | Quality Assurance | 565 | 42 | | History | 283 | 38 | | I18N (Internationalization) | 408 | 36 | | Screen Capture | 104 | 33 | | Hardware Watchdog | 155 | 33 | | Power (UPS) | 153 | 31 | | Modeling | 563 | 30 | | Unix Talk | 25 | 28 | | L10N (Localization) | 409 | 24 | | RCS | 54 | 24 | | Finger | 88 | 21 | | Simulations | 600 | 19 | | Themes | 61 | 18 | | Enlightenment | 59 | 17 | | Data Formats | 554 | 16 | | HTML/XHTML | 556 | 16 | | Design | 582 | 14 | | TeX/LaTeX | 558 | 13 | | File Management | 601 | 12 | | Project Management | 607 | 12 | | CRM | 579 | 11 | | Algorithms | 620 | 11 | | ERP | 577 | 9 | | Resource Booking | 586 | 9 | | GNU Hurd | 239 | 8 | | Time Tracking | 587 | 8 | | Library | 581 | 8 | | NIS | 290 | 8 | | To-Do Lists | 588 | 8 | | Robotics | 602 | 8 | | Intelligent Agents | 591 | 7 | | Calendar | 585 | 7 | | Mainframes | 313 | 7 | | Wireless | 566 | 7 | | Card Games | 597 | 6 | | Earth Sciences | 567 | 6 | | Virtual Machines | 610 | 6 | | RSS | 615 | 6 | | Streaming | 590 | 6 | | Profiling | 603 | 5 | | Search | 627 | 5 | | CASE | 570 | 5 | | SCCS | 260 | 5 | | Cross Compilers | 593 | 5 | | Molecular Science | 609 | 4 | | Genetic Algorithms | 621 | 4 | | BitTorrent | 622 | 4 | | SOAP | 613 | 4 | | MSN Messenger | 574 | 3 | | Ecosystem Sciences | 568 | 3 | | Realtime Processing | 623 | 3 | | New Age | 571 | 3 | | DocBook | 555 | 2 | | Usability | 619 | 2 | | Data Warehousing | 580 | 2 | | NNTP | 614 | 1 | | OLAP | 578 | 1 | | MARC and Book/Library Metadata | 605 | 1 | +-------------------------------------------+------------+-------------------+ #Here are the results for datasourceID=1 (October 2004) +-------------------------------------------+------------+-------------------+ | topic_desc | topic_code | count_of_projects | +-------------------------------------------+------------+-------------------+ | Software Development | 45 | 5784 | | Dynamic Content | 92 | 4738 | | Site Management | 243 | 3075 | | Internet | 87 | 2341 | | Games/Entertainment | 80 | 2267 | | Systems Administration | 253 | 1980 | | Communications | 20 | 1875 | | Database | 66 | 1861 | | Front-Ends | 68 | 1815 | | Role-Playing | 84 | 1731 | | Other/Nonlisted Topic | 234 | 1711 | | WWW/HTTP | 90 | 1671 | | Build Tools | 46 | 1517 | | Education | 71 | 1503 | | Networking | 150 | 1491 | | Office/Business | 129 | 1437 | | Code Generators | 259 | 1407 | | Chat | 22 | 1315 | | Security | 43 | 1265 | | File Sharing | 251 | 1206 | | Artificial Intelligence | 133 | 1148 | | Internet Relay Chat | 24 | 1130 | | CGI Tools/Libraries | 96 | 1084 | | Scientific/Engineering | 97 | 1076 | | Desktop Environment | 55 | 1071 | | Monitoring | 152 | 1060 | | Simulation | 85 | 994 | | Mathematics | 98 | 993 | | Visualization | 135 | 974 | | Interpreters | 49 | 972 | | Multi-User Dungeons (MUD) | 86 | 928 | | Compilers | 48 | 864 | | Indexing/Search | 93 | 856 | | Graphics | 100 | 833 | | Turn Based Strategy | 83 | 826 | | 3D Rendering | 110 | 814 | | Sound/Audio | 113 | 790 | | HTTP Servers | 250 | 733 | | Message Boards | 95 | 727 | | Email | 28 | 723 | | Board Games | 287 | 703 | | Scheduling | 130 | 677 | | First Person Shooters | 82 | 661 | | Distributed Computing | 308 | 658 | | Database Engines/Servers | 67 | 655 | | Side-Scrolling/Arcade Games | 288 | 618 | | Installation/Setup | 147 | 611 | | System | 136 | 601 | | Real Time Strategy | 81 | 599 | | BBS | 21 | 596 | | Cryptography | 44 | 593 | | Logging | 148 | 583 | | Text Processing | 285 | 551 | | Linux | 143 | 540 | | Software Distribution | 257 | 524 | | Gnome | 58 | 519 | | Viewers | 112 | 519 | | MP3 | 123 | 513 | | Operating System Kernels | 144 | 509 | | Filesystems | 142 | 506 | | Hardware | 146 | 488 | | Conferencing | 27 | 473 | | Presentation | 111 | 455 | | Integrated Development Environments (IDE) | 65 | 454 | | Information Analysis | 385 | 438 | | Email Clients (MUA) | 31 | 437 | | Hardware Drivers | 292 | 435 | | Browsers | 91 | 431 | | Puzzle Games | 268 | 431 | | Debuggers | 47 | 429 | | Computer Aided Instruction (CAI) | 72 | 425 | | K Desktop Environment (KDE) | 57 | 424 | | 3D Modeling | 109 | 423 | | Text Editors | 63 | 421 | | Bio-Informatics | 252 | 415 | | Firewalls | 151 | 413 | | Multimedia | 99 | 410 | | Symmetric Multi-processing | 312 | 407 | | File Transfer Protocol (FTP) | 89 | 400 | | Emulators | 74 | 397 | | Video | 125 | 389 | | Archiving | 19 | 382 | | Filters | 29 | 375 | | Telephony | 247 | 370 | | Human Machine Interfaces | 272 | 367 | | Editors | 106 | 365 | | Clustering | 141 | 354 | | Players | 122 | 353 | | Accounting | 76 | 352 | | Log Analysis | 245 | 348 | | Backup | 137 | 347 | | Conversion | 119 | 343 | | Printing | 154 | 323 | | Financial | 75 | 322 | | System Shells | 294 | 298 | | Object Brokering | 50 | 291 | | Testing | 73 | 284 | | Medical Science Apps. | 266 | 269 | | Physics | 387 | 267 | | Capture | 101 | 255 | | Office Suites | 131 | 248 | | Version Control | 52 | 246 | | Graphics Conversion | 105 | 245 | | Point-Of-Sale | 79 | 239 | | Mail Transport Agents | 32 | 233 | | Usenet News | 39 | 230 | | AOL Instant Messenger | 26 | 230 | | Electronic Design Automation (EDA) | 246 | 230 | | Documentation | 69 | 227 | | Display | 128 | 221 | | Name Service (DNS) | 149 | 201 | | POP3 | 34 | 199 | | Window Managers | 56 | 198 | | ICQ | 23 | 197 | | Religion | 132 | 196 | | Sound Synthesis | 249 | 188 | | Word Processors | 70 | 186 | | MIDI | 248 | 178 | | CVS | 53 | 175 | | Boot | 139 | 170 | | Compression | 42 | 170 | | Analysis | 114 | 166 | | Astronomy | 134 | 164 | | GIS | 383 | 164 | | Benchmark | 138 | 164 | | Packaging | 41 | 163 | | Capture/Recording | 115 | 155 | | Sociology | 282 | 151 | | Authentication/Directory | 289 | 148 | | Terminals | 156 | 146 | | Mailing List Servers | 30 | 142 | | Vector-Based | 107 | 141 | | Speech | 124 | 139 | | WAP | 270 | 139 | | LDAP | 291 | 139 | | Investment | 77 | 130 | | Internet Phone | 40 | 128 | | CD Ripping | 118 | 125 | | Ham Radio | 38 | 124 | | Interface Engine/Protocol Translator | 386 | 119 | | Link Checking | 244 | 116 | | Digital Camera | 103 | 114 | | Telnet | 159 | 111 | | Terminal Emulators/X Terminals | 158 | 109 | | Chemistry | 384 | 108 | | Emacs | 64 | 103 | | Gnutella | 286 | 101 | | IMAP | 35 | 97 | | Raster-Based | 108 | 89 | | CORBA | 51 | 86 | | Page Counters | 94 | 84 | | Mixers | 121 | 81 | | CD Audio | 116 | 79 | | Genealogy | 284 | 79 | | Post-Office | 33 | 78 | | Napster | 241 | 69 | | Serial | 157 | 65 | | CD Playing | 117 | 64 | | Spreadsheet | 78 | 58 | | Fax | 36 | 54 | | Non-Linear Editor | 256 | 54 | | Init | 140 | 53 | | Screen Savers | 62 | 48 | | FIDO | 37 | 46 | | BSD | 145 | 46 | | Scanners | 102 | 41 | | History | 283 | 37 | | Hardware Watchdog | 155 | 32 | | Power (UPS) | 153 | 31 | | Screen Capture | 104 | 31 | | Unix Talk | 25 | 27 | | RCS | 54 | 24 | | Finger | 88 | 20 | | Themes | 61 | 18 | | Enlightenment | 59 | 17 | | I18N (Internationalization) | 408 | 10 | | GNU Hurd | 239 | 8 | | L10N (Localization) | 409 | 8 | | Mainframes | 313 | 7 | | NIS | 290 | 6 | | SCCS | 260 | 5 | +-------------------------------------------+------------+-------------------+