google analytics database
does anybody know how data in google analytics is orginized? Difficult selection from large amounts of data they perform very-very fast, what structure of database is it? ...
database
Database Error, Vendor Code 17
I have a problem with creating an report in my Webservice with ASP. Lokally everything works fine, connecting to SqlServers or MySQL Servers is no problem at all. But now !'m trying to connect to a SqlServer 2005 and i get an error, somthing about a database vendor code 17 (it's a german version, so i won't directly post the whole error...
database for web analytics
what database to choose to store information about site visits, key characteristics: big amount of data, many page requests per second, different reports for data presentation, i think to use MySql, any suggestions? ...
Creating a messaging "system" in DB (most especially MySQL)
Hi guys, Sorry, I have a concern: I have a table successully created in MySQL: CREATE TABLE IF NOT EXISTS MESSAGE ( MESSAGE_ID BIGINT NOT NULL AUTO_INCREMENT ,AUTHOR_ID VARCHAR(30) NOT NULL ,TITLE VARCHAR(100) NOT NULL ,MESSAGE VARCHAR(4095) NOT NULL ,UNREAD_FLAG ...
Translucent Databases
Hi, I am building an application with health information inside. This application will be consumer-facing with is new for me. I would like a method to put privacy concerns completely at ease. As I review methods for securing sensitive data in publicly accessible databases I have frequently come across the notion of database translu...
ADO.NET Entity Framework Quirk
Hi, When I run the code below, it works int charId = int.Parse(Request.Params["charId"]); EveFPT ctx = new EveFPT(); var theCharQuery = from a in ctx.tblChars where a.id == charId select new { ...
How do I catch a connection failure to a nonexistant Rose::DB database?
My Perl application uses Rose::DB, Rose::DB::Object (ORM) and Tk on Windows XP. I need to check whether the database connection information (host, port, database name, user, password) leads to a valid connection. If I call $db->connect and use e.g. a nonexistant host for testing, Rose::DB says: DBI connect('dbname=my_db;host=192.168.70.8...
converting progress 4GL procedures to oracle stored procedures
Hi All, I need to convert procedures written in Progress 4GL to Oracle stored procedures. Is there any tool other than SQLWays using which I can achieve this? ...
how to rank gene using information gain??
how gene ranking is done for microarray data using information gain and chi-square statistics ?? Please illustrate with a simple example.. ...
From an image, how do I determine the shade?
Hi All, For a database app I'm trying to determine the average shade of a section of photo, against a colour scale. Being a novice I'm finding this very difficult to explain so I've created a simple diagram showing exactly what I'm trying to achieve. http://www.knockyoursocksoff.com/shade/ If anybody has the time to give me some ...
how to discard changes made to all linq tables?
I would like to discard all changes made to linq tables (this means -- I use linq, and data are changed on client side, the data on server are intact). How to do this? EDIT: problem partially solved http://graemehill.ca/discard-changes-in-linq-to-sql-datacontext/ It works as long as you don't use transaction. When you do and you use m...
SQL Table linking... is it better to have a linking table, or a delimited column?
My database has two tables, one contains a list of users, the other a list of roles. Each user will belong to one or more roles, and of course each role will have multiple users in it. I've come across two ways to link the information. The first is to add a third table which contains the ID's from both tables. A simple join will the...
Retrieving auto-incremented column value in ASP.NET from mySQL table WITHOUT using stored proceedure
I a function that used a mySQL Data Adapter and inserts a new row. I want the function to return the value of the auto-incremented column of the updated row. Please help. Public Function addRow(ByVal colA as String, ByVal colB as String) As Integer Dim dbConnection As New MySqlConnection("server=xxx; user id=xxx; password=xxx; dat...
Is facebook faster or local database?
Hi, In my facebook application, I use peoples friends names in the application. I can either get the names from facebook. Or save them the first time the person logs in. So everytime his/her friends received from the database. Which method is faster? ...
One active IB transaction the whole lifetime of a single user application
Are there any negative impacts when a single user application uses only one IB transaction, which is active as long the program runs? By using only CommitRetaining and RollbackRetaining. Background: I want to use IBQuery(s) and connect them to a DB Grid(s) (DevExpress), which loads all records into memory at once. So I want to avoid re-...
Remove Primary Key in MySQL
I have the following table schema which maps user_customers to permissions on a live MySQL database: mysql> describe user_customer_permission; +------------------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------+------+-----+---------+...
Synchronize 2 databases installed locally with Xampp
Hi there, I've 2 computers connected to Internet. Each one has Xampp installed, with a local mysql database. Is it possible to sychronize these 2 dbs ? I use Navicat. The sync works well with a local database to a server database, using tunneling. But what about the sync between 2 PCs dbs ? Thank you very much for your help, Cheer...
Replace SQL Server Database
A vendor has a data database (read only) that gets sent to us via dvd every week. Their upgrade script detaches the existing copy of the database, overwrites the MDF and LDF, drops all the users and recreates what they think proper security should be. Is there a way that I can just synchornize the data without taking the database offli...
Does column order matter in your MySQL tables?
While learning mysql, I read that you can perform the following statement when adding a column to a mysql table: ALTER TABLE contacts ADD email VARCHAR(60) AFTER name; or ALTER TABLE contacts ADD email VARCHAR(60) FIRST; When would you want to do this? Can column order be utilized for query optimization purposes? Should longblobs b...
Restful Authentication -- Relating User ID to Profile
Hey Guys, I'm new to Ruby on Rails...I've been playing around with developing a social networking type app....I just added Restful Authentication to my app successfully..Now I would like to create a model/controller where each User once logged in can create/edit their own profile. So I created the model and controller...the code in th...