In computing, a graph database is a database that uses graph structures for semantic queries with nodes, edges and properties to represent and store data. A key concept of the system is the graph (or edge or relationship), which directly relates data items in the store. This contrasts with conventional relational databases, where links between data are ad hocand based on the data itself, and related items are gathered by searching for this data within the store. Graph databases are designed to allow simple and rapid retrieval of complex hierarchical structures, whereas a relational database would use a complex query to achieve the same end, generally with far less performance (from wikipedia).

http://neo4j.com/

Neo4j is a highly scalable native graph database that leverages data relationships as first-class entities, helping enterprises build intelligent applications to meet today’s evolving data challenges.

1. Download PhpMyAdmin.

2. Upload it to your Server/Domain.

3. Browse to www.your-domain.com/phpMyAdmin/Setup

4. Click on “New Server” button:

5. Under “Server hostname” write your host name.

6. Under “User for config auth” (might be under authentication tab) write MySql username.

7. Under “Password for config auth” write MySql password.

8. Under PhpMyAdmin top level directory create a directory called “config”:

www.your-domain.com/phpMyAdmin/config

8.1 Click on Apply.

8.2 config direcotry suppose to have RW permissions.

9. Under PhpMyAdmin setup page click on “Save” button:

10. Configuration saved to file config/config.inc.php in phpMyAdmin top level directory, copy it to top level one and delete directory config to use it.

11. Login to your PhpMyAdmin at www.your-domain.com/phpMyAdmin

 

Based on the following Video:

Database good practice

  1. Tools to use:
    1. SSMS – sql server management studio
    2. Visual Studio
  2. The following video is the best to describe the process
    1. How To Create a Database Deployment Project in 10 minutes
    2. In short:
      1. Using VisualStudio connect to Database.
      2. Right click on the DB and select create new project.
        1. At this point there are schemes without data.
  3. The following links explains how to generate script of database with data
    1. Auto-generate INSERT statements for a SQL Server table
  4. The following script explains how to create Visual studio first time database project:
    1. Create Your First Visual Studio Database Project

Creating A New Database Project

ALTER PROCEDURE [dbo].[Mulsp] @Size INT
AS
BEGIN
DECLARE @X INT=2
DECLARE @Y INT=1

BEGIN try
DROP TABLE [dbo].[multable]
END try

BEGIN catch
END catch

CREATE TABLE [dbo].[multable]
(
c1 INT
)

–create the rows 
DECLARE @CN NVARCHAR(max)=
DECLARE @TSql NVARCHAR(max)

WHILE @x <= @Size
BEGIN
SELECT @cn = ‘c’ + Cast(@x AS NVARCHAR)

PRINT @cn

SET @TSql=‘alter table MulTable add ‘ + @cn + ‘ int’

PRINT @Tsql

EXEC sys.Sp_sqlexec
@Tsql

SET @x=@x + 1
END

–at this point build each line query 
SET @X=1

DECLARE @EachLineQuery NVARCHAR(max)

WHILE @Y <= @Size
BEGIN
SET @EachLineQuery=‘insert into MulTable values (‘

WHILE @x < @Size
BEGIN
SET @EachLineQuery=@EachLineQuery + Cast(@x*@y AS NVARCHAR)
+ ‘,’
SET @x=@x + 1
END

SET @EachLineQuery=@EachLineQuery + Cast(@x*@y AS NVARCHAR)
+ ‘)’

EXEC sys.Sp_sqlexec
@EachLineQuery

PRINT @EachLineQuery

SET @EachLineQuery=
SET @y=@y + 1
SET @x=1
END

SELECT *
FROM   multable
END

In Visual Studio 2013 you could double click a SDF database file within Solution Explorer and it would automatically open the database file and allow you to view the database tables, add tables, edit data etc.

In Visual Studio 2013 this native support seems to have ‘fallen off’, double clicking an SDF file simply assumes it is yet another binary object:

VS2013 native 'support' for SDF files (none)

go to the MSDN Gallery and get the SQL Server Compact Toolbox, here:

http://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1/

once installed you can drag the new “SQL Server Compact Toolbox” window and dock it where it used to be:

(It suppose to be At Main Menu->Tools->Server Compact)

VS 2013 with the SQL Server Compact Toolbox add in installed