# file: sfSummaryTopicData28-Jan-2005.txt # 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) 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 topic_desc, topic_code, count(*) as count_of_projects # from project_topic # where datasourceID=3 # group by topic_desc # order by 3 desc # Note: not all projects have a topic, and some projects have more # than one. #Here are the results from datasourceID=3 (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 | +-------------------------------------------+------------+-------------------+