Team:SUSTC-Shenzhen-A/Biosearch Tool1

From 2012.igem.org

(Difference between revisions)
(Created page with "{{Template:SUSTC_A2}} <html> <head> <style type="text/css"> .sidebar_box_woframe { margin-bottom: 20px; } .sidebar_box { width: 260px; padding: 0; } .sidebar_box_top { wi...")
Line 163: Line 163:
   <tr>
   <tr>
     <td><div id="talkbubble_c1">
     <td><div id="talkbubble_c1">
-
<p class="title">Tool</p>
+
<p class="title">SQLite</p>
<ul>
<ul>
         <a href="https://2012.igem.org/Team:SUSTC-Shenzhen-A/Biosearch_Tool">MySQL<img src="https://static.igem.org/mediawiki/2012/0/0f/Arrow_down.gif" style="BORDER:#FFFFFF 5px dashed;margin:10px;" ></img>   
         <a href="https://2012.igem.org/Team:SUSTC-Shenzhen-A/Biosearch_Tool">MySQL<img src="https://static.igem.org/mediawiki/2012/0/0f/Arrow_down.gif" style="BORDER:#FFFFFF 5px dashed;margin:10px;" ></img>   
Line 175: Line 175:
             </ul>
             </ul>
<div class="image_wrapper image_fr"><span></span><img src="https://static.igem.org/mediawiki/2012/b/bd/Test.jpg"" alt="image 2" /></div>
<div class="image_wrapper image_fr"><span></span><img src="https://static.igem.org/mediawiki/2012/b/bd/Test.jpg"" alt="image 2" /></div>
-
<p>&nbsp;&nbsp;We have use MySQL as our relational database management system (RDBMS). The MySQL database has become the world's most popular open source database .Many of the world's largest and fastest-growing organizations including Facebook, Google, Adobe, Alcatel Lucent and Zappos rely on MySQL to save time and money powering their high-volume Web sites, business-critical systems and packaged software. Given these considerations, MySQL has many attractive features to offer: </p>
+
<p>&nbsp;&nbsp;The Main work to deal with first is the database . We get nothing but a file with the format of ‘xml’. It may be very easy work for someone who is professional . But for a beginner like me, the only thing I can do is Google , Google and Google... Fortunately, eventually I finished it.</p>
-
<p>&nbsp;&nbsp;</p>
+
<p>&nbsp;&nbsp;Core Data is a very useful part of iOS developing . The built-in Sqlite function is the one with which I can set up a built-in database.</p>
-
<p><strong>Speed.</strong> MySQL is fast. Its developers contend that MySQL is about the fastest database system you can get. You can investigate this claim by visiting http://www.mysql.com/why-mysql/benchmarks/, a performance-comparison page on the MySQL Web site.</p>
+
<p>&nbsp;&nbsp;the next thing we should overcome is transfer xml to Sqlite. Thankfully there is NSXmlParser Method with which we can finish this work.</p>
-
<p>&nbsp;&nbsp;</p>
+
<p>&nbsp;&nbsp;why we choose sqlite?</p>
-
<p><strong>Ease of use. .</strong>MySQL is a high-performance but relatively simple database system and is much less complex to set up and administer than larger systems.</p>
+
<p>&nbsp;&nbsp;because it provide the function we needed . Network independent, very efficient , and it can store what you search in cache therefore you can get the same search result faster next time. </p>
-
<p>&nbsp;&nbsp;</p>
+
-
<p><strong>Query language support.</strong> MySQL understands SQL (Structured Query Language), the standard language of choice for all modern database systems.</p>
+
-
<p>&nbsp;&nbsp;</p>
+
-
<p><strong>Capability.</strong> The MySQL server is multi-threaded, so many clients can connect to it at the same time. Each client can use multiple databases simultaneously. You can access MySQL interactively using several interfaces that let you enter queries and view the results: command-line clients, Web browsers, or GUI clients. In addition, programming interfaces are available for many languages, such as C, Perl, Java, PHP, Python, and Ruby. You can also access MySQL using applications that support ODBC and .NET (protocols developed by Microsoft). This gives you the choice of using prepackaged client software or writing your own for custom applications.</p>
+
-
<p>&nbsp;&nbsp;</p>
+
-
<p><strong>Connectivity and security.</strong> MySQL is fully networked, and databases can be accessed from anywhere on the Internet, so you can share your data with anyone, anywhere. But MySQL has access control so that one person who shouldn’t see another’s data cannot. To provide additional security, MySQL supports encrypted connections using the Secure Sockets Layer (SSL) protocol.</p>
+
-
<p>&nbsp;&nbsp;</p>
+
-
<p><strong>Portability.</strong>MySQL runs on many varieties of Unix and Linux, as well as on other systems such as Windows and NetWare. MySQL runs on hardware from high-end servers down to small personal computers (even palmtop devices).</p>
+
-
<p>&nbsp;&nbsp;</p>
+
-
<p><strong>Small size.</strong>  MySQL has a modest distribution size, especially compared to the huge disk space footprint of certain other database systems.</p>
+
-
<p>&nbsp;&nbsp;</p>
+
-
<p><strong>Availability and cost.</strong>  MySQL is an Open Source project available under multiple licensing terms. First, it is available under the terms of the GNU General Public License (GPL). This means that MySQL is available without cost for most in-house uses. Second, for organizations that prefer or require formal arrangements or that do not want to be bound by the conditions of the GPL, commercial licenses are available.</p>
+
-
<p>&nbsp;&nbsp;</p>
+
-
<p><strong>Open distribution and source code.</strong> MySQL is easy to obtain; just use your Web browser. If you don’t understand how something works, are curious about an algorithm, or want to perform a security audit, you can get the source code and examine it. If you think you’ve found a bug, please report it; the developers want to know.</p>
+
-
<p>&nbsp;&nbsp;</p>
+
-
<p><strong>(select from MySQL 4th edition by Paul Dubois)</strong></p>
+
-
<p>&nbsp;&nbsp;</p>
+
-
<p>Consequently, compared to other products, MySQL is our ideal choice for RDBMS to assist us in accomplishing our iPhone App BioSearch.</p>
+
-
<p>&nbsp;&nbsp;</p>
+
<p>&nbsp;&nbsp;</p>
<p>&nbsp;&nbsp;</p>
 +
<img src="https://static.igem.org/mediawiki/igem.org/1/1c/IMG_1167.JPG"/>
</div>
</div>
</td>
</td>

Revision as of 12:27, 22 September 2012

SQLite

image 2

  The Main work to deal with first is the database . We get nothing but a file with the format of ‘xml’. It may be very easy work for someone who is professional . But for a beginner like me, the only thing I can do is Google , Google and Google... Fortunately, eventually I finished it.

  Core Data is a very useful part of iOS developing . The built-in Sqlite function is the one with which I can set up a built-in database.

  the next thing we should overcome is transfer xml to Sqlite. Thankfully there is NSXmlParser Method with which we can finish this work.

  why we choose sqlite?

  because it provide the function we needed . Network independent, very efficient , and it can store what you search in cache therefore you can get the same search result faster next time.

  

Footbar.jpg