What is SQL?
"SQL, which is an abbreviation for Structured Query Language, is a language to request data from a database, to add, update, or remove data within a database, or to manipulate the metadata of the database." -Wikibooks' Introduction to SQL (PT)
What is SQL Anywhere?
According to Wikipedia, SQL Anywhere is a Relational DataBase Management System (RDBMS) product from the SAP company - a German software enterprise company. (PT)
"SQL Anywhere is a relational database" means the data stored in the system have some sort of relationships with the other data in the system. (PT) [http://en.wikipedia.org/wiki/SQL_Anywhere]
Based on QGIS.org, the Add SQL Anywhere layer dialog functions similar to PostGIS and SpatiaLite Maybe continue with an explanation of what they have in common?
http://djjr-courses.wikidot.com/soc128:how-to-postgis http://djjr-courses.wikidot.com/soc128:how-to-spatiallite
Rephrase: Maybe say something like: QGIS can import geographic data from an SQL Anywhere database. To do so, the user must have access to such data and then use the command under XXX>YYY in QGIS. In dialog like that below user must specify… to make a connection to an SQL Anywhere server to obtain data stored on it.
(PT)
What Is SQL Anywhere Used For?
SQL Anywhere, in Geographic Information System (GIS), is used to store data points, etc. that one creates in GIS, it allows people to access and/or share these data easily since it is a relational database that allows you to obtain those information anywhere, internationally or globally. (PT)
Where Can You Learn About SQL Anywhere?
- Click here to learn more about SQL Anywhere for Mac OS X (PT)
- SQL Anywhere Version 10.x (PT)
- Tutorials: [http://dcx.sybase.com/index.html#1201/en/saintro/fg-tutoriallist.html](PT)
WHAT I LEARNED by looking at these sites:
I learned that there are several different versions of SQL Anywhere for Mac and for PC. A lot of people use SQL Anywhere because it is manageable, easily accessible, and shareable. There data stored in SQL Anywhere allows people to create, access, and share them with people from the local to the global level. (PT)
More about SQL Anywhere
"SAP Sybase SQL Anywhere is a comprehensive suite of solutions that provides data management, synchronization and data exchange technologies that enable the rapid development and deployment of database-powered applications in remote and mobile environments" –http://Sybase.com
(PT)
Here are some examples:
SQL Anywhere 16 Introduction:
Welcome to the newest SAP Sybase SQL Anywhere, currently the most advanced data management system.
There are three methods to using this system to your benefit:
Sybase Central
Interactive SQL
Command-line Utilities
The types of methods does not affect much of the function of its performance and results, it is more for ones own preference.
Sybase Central:
This is a tool that administers and develops access to properties, utilities, and database settings through a graphical user interface. Besides SQL Anywhere Server, Sybase Central can also be used in managing other programs like UltraLite, MobiLink, Relay Server, and other Sybase products. As shown below:
Sybase Central could as well, perform tasks like statistics, procedure profiling, connection profiles, web services, management of events and schedules, and much more. It performs its tasks, by sending SQL statements to the database server (SQL Anywhere utilities).
Interactive SQL (SQL query editor):
This is another database that has been designed to perform SQL Statements as well as displaying database data. The built in tools included as part of this database such as the “graphical plan display” will help you analyze, and troubleshoot additionally.
OVERVIEW of SQL Anywhere 16:
This is a database package that allows for data management and enterprise data exchange, which facilitates speedy development for database-powered applications for cell phones, desktops or remote office environments.
It offers:
Data management technologies:
SQL Anywhere is designed to handle tasks with many different varieties of environments (high performance database like a software application to a cell-phone database that is used on numerous amounts of handheld devices.
Data exchange technologies:
SQL Anywhere promises secure data exchange technology that would be able to handle intricate data exchanges from application servers, messaging systems as well as unreliable wired, wireless networks and back-end databases.
Design and management tools:
SQL Anywhere contains large varieties of tools for improvement of design and progress with database driven applications
It would be great if you can add your research to mine instead of making two sections. Also, can you put some images and align these texts neatly? Please cite your info. Thanks! (PT)
Simple Step by Step on creating a SQL Anywhere database:
A) Steps to creating a SQL Anywhere database file:
a. Start Sybase Central
(Start > Programs > SQL Anywhere 16 > Administration Tools > Sybase Central)
b. Start with “Create Database Wizard”
(Tools > SQL Anywhere 16 > Create Database)
i. Locate the Welcome page > Next
ii. “Create a database on this computer” > Next
iii. “Save the main database file to the following file”
(save as appropriate desired name)
iv. In the user ID and password page, by default, the ID: DBA, and password: sqi. Though it can be changed to increase the level of security for your database.
v. “Finish” > “Close”
vi. Congratulations! You have just created and connected yourself to first main step to a database
B) Steps to adding tables to the database from the previous step:
a. Start with “Create Table Wizard”. On your left of the panel, right click “Tables” > “New” > “Table”.
i. Under “What do you want to name the new table”, we will type “products” as an example of how this can be used in a company production process.
ii. “Finish”
You have just created a table, under the “columns” tablet on your right, is where you can specify the name of the new column that have just been created. [i.e. ProductID]
iii. You will see that PKey has been selected as ‘Primary Key’.
iv. Under “Data Type” > Integer > “…”
v. Value > Default value > System-defined > autoincrement (This make sures that each of the columns made is unique to the PKey) > OK
vi. File > New > Column
1. Name (i.e. ProductName)
2. Data Type > Char
3. Size (i.e.15)
vii. Repeat steps above for (i.e. Sales Order Items)
viii. File > Save
History:
Created by Watcom
Version 3 made in 1992
Version 16 made on April 18th, 2013 with by far fastest synchronization and also has improved on security
Credits:
Phuong T.