|
1 <?xml version="1.0" encoding="utf-8"?> |
|
2 <!-- Copyright (c) 2007-2010 Nokia Corporation and/or its subsidiary(-ies) All rights reserved. --> |
|
3 <!-- This component and the accompanying materials are made available under the terms of the License |
|
4 "Eclipse Public License v1.0" which accompanies this distribution, |
|
5 and is available at the URL "http://www.eclipse.org/legal/epl-v10.html". --> |
|
6 <!-- Initial Contributors: |
|
7 Nokia Corporation - initial contribution. |
|
8 Contributors: |
|
9 --> |
|
10 <!DOCTYPE concept |
|
11 PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd"> |
|
12 <concept id="GUID-22844C28-AB5B-5A6F-8863-7269464684B4" xml:lang="en"><title>Symbian |
|
13 SQL Overview</title><shortdesc>This document introduces you to the Symbian platform implementation |
|
14 of the Structured Query Language(SQL). </shortdesc><prolog><metadata><keywords/></metadata></prolog><conbody> |
|
15 <section id="GUID-C09F38AF-3ABF-4921-8A7C-269A60BB5201"><title>Purpose</title> <p>SQL is: the syntax for creating, modifying |
|
16 and deleting databases and the data they contain; an engine or server that |
|
17 understands that syntax; the commands and operations that allow the SQL engine |
|
18 to process the syntatical elements. Developers who know one variant of SQL |
|
19 can easily work in another. </p> </section> |
|
20 <section id="GUID-A1F01FE6-EF37-4778-8A2B-E3F7982057DA"><title>Required background</title> <p>Relational databases, the SQL |
|
21 query language, database programming fundamentals. </p> </section> |
|
22 <section id="GUID-553C560E-D439-4AE9-8F46-329E54769CDA"><title>Key concepts/terms</title> <p>The SQL component includes these |
|
23 key concepts: </p> <ul> |
|
24 <li id="GUID-BA38B572-000A-5798-B10E-0E54FB5300DC"><p>Relational database </p> <p>A |
|
25 structured collection of data organised as tables (relations). </p> </li> |
|
26 <li id="GUID-37E36881-7760-5269-B11A-128C81FE5741"><p>SQL </p> <p>A standard |
|
27 language for querying relational databases. </p> </li> |
|
28 <li id="GUID-AFC25A9E-C040-548A-9C62-C8D03C5F1055"><p>Security policy </p> <p>A |
|
29 specification of user permissions on a database. </p> </li> |
|
30 </ul> </section> |
|
31 <section id="GUID-0D11B2C7-F34E-4E57-96A9-F1F94B0C220E"><title>Architectural relationships</title> <p>The SQL component is |
|
32 a free standing component that can be accessed by any application and from |
|
33 anywhere in Symbian platform. </p> <p>It is has a client-server architecture. |
|
34 Applications interface with the client API. The server side is an executable |
|
35 running in its own process and is not directly accessible to client applications. |
|
36 It can only be reached via the client-side interface. </p> <fig id="GUID-79734111-15D9-51E2-A1CE-09A4F72D1B21"> |
|
37 <title> This image depicts the client / server nature of Symbian |
|
38 SQL </title> |
|
39 <image href="GUID-A6EE8A2A-8B17-5D3A-A9B9-C8D25C92EA21_d0e365484_href.png" placement="inline"/> |
|
40 </fig> </section> |
|
41 <section id="GUID-47F435F2-2621-4FA8-91BF-9DD5B17FD629"><title>API summary</title> <p>The SQL component client consists of |
|
42 three APIs which are used to access, query and secure a database. </p> <p><b>SQL APIs </b> </p> <ul> |
|
43 <li id="GUID-74A5E9C2-A9CA-5595-8249-E311054EBFE6"><p>The SQL database API, |
|
44 which you use to access a database. </p> </li> |
|
45 <li id="GUID-4FE61907-6DBA-5B59-B923-F2AB623BE3B2"><p>The SQL statement API, |
|
46 which you use to query a database. </p> </li> |
|
47 <li id="GUID-1530DA5D-3E75-5C71-9AA9-72EA342AF3E6"><p>The SQL security policy |
|
48 API, which you use to create a secure database. </p> </li> |
|
49 </ul> <table id="GUID-89A08BF1-F7CB-594A-9693-42CB5AE4B499"> |
|
50 <tgroup cols="2"><colspec colname="col0"/><colspec colname="col1"/> |
|
51 <thead> |
|
52 <row> |
|
53 <entry>API</entry> |
|
54 <entry>Description</entry> |
|
55 </row> |
|
56 </thead> |
|
57 <tbody> |
|
58 <row> |
|
59 <entry><p> <xref href="GUID-4688F6B7-E1B0-37CF-BAA2-C6BD103D4FDF.dita"><apiname>RSqlDatabase</apiname></xref> </p> </entry> |
|
60 <entry><p>The SQL database API </p> </entry> |
|
61 </row> |
|
62 <row> |
|
63 <entry><p> <xref href="GUID-0176BF07-DF94-3259-8F90-DE030E35CE9A.dita"><apiname>RSqlStatement</apiname></xref> </p> </entry> |
|
64 <entry><p>The SQL statement API </p> </entry> |
|
65 </row> |
|
66 <row> |
|
67 <entry><p> <xref href="GUID-56C52D43-C4A9-3B31-B154-CA1E77693F57.dita"><apiname>RSqlSecurityPolicy</apiname></xref> </p> </entry> |
|
68 <entry><p>The SQL security policy API </p> </entry> |
|
69 </row> |
|
70 </tbody> |
|
71 </tgroup> |
|
72 </table> </section> |
|
73 <section id="GUID-C09E74E9-A9AC-4C7F-9972-C08C78AA0114"><title>Typical uses</title> <p>Relational databases and the SQL query |
|
74 language are fundamentals of application development with numerous uses. </p> <p><b>SQL Users </b> </p> <ul> |
|
75 <li id="GUID-747924C7-5E24-5EA5-9E11-8FB216822A0B"><p>Application developers |
|
76 needing to access databases. </p> </li> |
|
77 </ul> <p><b>SQL |
|
78 tasks</b> </p> <p>The SQL component is used to: </p> <ul> |
|
79 <li id="GUID-79CD646D-0E08-5F17-ADDF-D245D0CEEF74"><p>create, </p> </li> |
|
80 <li id="GUID-98666D77-DA2F-58B5-BEAB-3FFC149425EE"><p>delete, </p> </li> |
|
81 <li id="GUID-D7D164C6-FF45-5A2B-AB3F-B011F04BCF3F"><p>access, </p> </li> |
|
82 <li id="GUID-012D297E-74B7-5B53-98C8-8ECF97C16141"><p>query, and </p> </li> |
|
83 <li id="GUID-8CCECFDE-1D8E-5A66-A1CE-DBEB5777EC76"><p>modify relational databases. </p> </li> |
|
84 </ul> <p><b>Creating |
|
85 and deleting a relational database</b> </p> <p>The SQL component is used to |
|
86 create and delete relational databases. They may be secure or insecure. </p> <p><b>Accessing a relational database</b> </p> <p>Use the SQL component to open |
|
87 and close databases and to attach a secondary database to a primary one. </p> <p><b>Querying and modifying a relational database</b> </p> <p>Use the SQL component |
|
88 to query a database using SQL. Queries can read, write, modify and delete |
|
89 data in a database. </p> </section> |
|
90 </conbody><related-links> |
|
91 <link href="GUID-22844C28-AB5B-5A6F-8863-7269464684B4.dita"><linktext>SQL Overview</linktext> |
|
92 </link> |
|
93 <link href="GUID-1F12E3F5-45B2-55EC-B021-00338277C608.dita"><linktext>SQL DB Overview</linktext> |
|
94 </link> |
|
95 <link href="GUID-78773BCA-ADF6-53E6-AC80-5CB2AE1F8BCC.dita"><linktext>SQL Server |
|
96 Guide</linktext></link> |
|
97 <link href="GUID-F8824165-4B33-50D1-9706-BD2438B5A2EE.dita"><linktext>Persistent |
|
98 Storage</linktext></link> |
|
99 </related-links></concept> |