More from this authorA Kentucky man, 59-year-old James L. Osborne, has been arrested and charged with endangering the welfare of a minor, after he left his son waiting alone in his car – parked outside a pub – while he nipped inside for a couple of beers The boy has now been placed in the care of his grandmother Oh, did I mention the son is aged 17yr old ? Source – http://tinyurl.com/cffvkst
More from this author<?php class Database { public $user='my_user'; public $password='my_password'; public $db='my_db'; public $host='localhost'; public $link; public function connect() { $link = mysql_connect($this->host, $this->user, $this->password); mysql_select_db($this->db); } public function query ($string) { return mysql_query($string); } public function fetchAll($string) { $query = "select * from `$string`"; $result = $this -> query($query); return $result; } }
A few weeks ago, I came across something called SQLCMD (or SQLCommand). I’ve never heard of this, so the curious developer in me wanted to know what it was. The official definition according to MSDN is this: The sqlcmd utility lets you enter Transact-SQL statements, system procedures, and script files at the command prompt, in Query Editor in SQLCMD mode, in a Windows script file or in an operating system (Cmd.exe) job step of a SQL Server Agent job. This utility uses ODBC to execute Transact-SQL batches. You can either run a SQLCMD query via command-line or in SQL Server Management Studio (SSMS). If you want to run it via SSMS, open a new query and press the hotkey combination: ALT+Q, ALT+M. You could also use the menu Query -> SQLCMD Mode. Once you’ve done that, you can run queries in SQLCMD mode. This means you can use your query window as a commandline tool. The advantage of this, is that you can query multiple servers and instances in one query. To run queries in SQ
Recently I have been getting my hands dirty with Lucid @ my work. Wow! quite impressive database. To give an quick intro. on it, its a database that follows “Column Store” whereas the other traditional database like Sybase, Oracle are “Row Store”. By now you might have guessed, yes its a data warehouse storage, quite efficient in handling large chunk of data. Its highlights are, * Free download * quicker installation, * easy to maintain, * compatible with IDE’s like DbVisualizer, * efficient in handling large dataset. Import/Export of data is quite cheap with no additional plug-ins or configuration required. Thou’ it has some serious side-effects as well, * Insufficient or unclear error logs. * Restore is buggy between different versions of Luciddb. * User support and documentation has to be improved. Download from Luciddb and get started here in no time. Favourable environment is Linux thou’ Windows and Mac are supported as well. Stored catalo
Σε διάφορες συζητήσεις γύρω από τα θέματα, αυτού που στην Microsoft λέμε, Application Platform, μία έννοια, νέα για μένα έκανε την εμφάνιση της. Τα Big Data. Μεγάλα δεδομένα (;). Δηλαδή πόσο μεγάλα; Και γιατί να γίνεται ειδική μνεία γι αυτά; Επειδή δεν μου αρέσει να έχω άγνωστες λέξεις παρακάλεσα την καλή συνάδελφο Γεωργία Ψυλλίδου, Solutions Specialist στο Application Platform, να μου περιγράψει σε 4-5 γραμμές τι ακριβώς είναι τα Big Data και γιατί τέτοιος θόρυβος τώρα τελευταία γύρω από αυτά. Ιδού τι μου απάντησε: Εάν καταφέρω να γράψω «κάτι για τα Big Data σε 4-5 σειρές» τότε πιστεύω πως ο καθένας μπορεί να γράψει 4-5 jobs να τρέχουν στο Hadoop μέχρι να συμφωνήσουμε περί τίνος πρόκειται και γιατί γίνεται τόσο χαμός τελευταία. Ας ξεκινήσουμε με τη μετάφραση… Πόσο μεγάλα πρέπει να είναι τα δεδομένα για να τα κατηγοριοποιήσουμε σαν Big Data ; Πολύ, της τάξεως των Petabytes και να μη μοιάζουνε μεταξύ τους, να αλλάζουνε γρήγορα και ακανόνιστα. Πότε αρχίζει η ιστορία τους ; Είναι τόσο
Hi all! Last weeks have been a little busy, and from several tasks I had to do, there was an Oracle Database installation. There was a funny discussion about the version to install, where people recommended installing 10g only because was the version they worked with or because the how to they use it’s only for 10g. At the end, we decided to install last version, 11.2, as the main use for this database would be a huge quantity of data in a data warehouse like use, and I had to install it. I thought that it would be easy, as you have the possibility of doing remote X from the server (yes, it was a server so we only had remote access), and you know the most “boring” part of installing Oracle Database it’s the steps previous to installation, you know, kernel parameters, directories, users, permissions.. But when I talked to my colleague and he told me that the server was installed without any X server package, and that they don’t install it as a policy, I had
I’m currently working on some web projects using Django, which is a pretty nice Python framework for web development, and I run all my tests with a SQLite database. During development, the models are very dynamic and its fields are always changing, so I need the database tables to reflect those changes, but the utilities bundled with Django only create tables, but don’t alter them when models change. So, the way to overcome this workaround is quite simple: just drop the tables and run Django’s table creation utility again. However, that’s a bit of a hassle to do through SQL queries when you’ve got plenty of tables to drop. For managing SQLite databases, I’ve always used sqliteman, which is multiplatform and free. There are binaries for Windows and Linux, and I compiled it on OS X and even packaged the binary into an OS X .app, so that I could just run it like any other OS X app. But sqliteman has still got an issue which makes it uncomfortable for dr
So recently I needed to remove a bunch of URLs from my member’s content on my games because of spyware/malware notifications Chrome users were getting. It took me a bit to figure out how to do it so here’s a nice and nifty little script that will hopefully save you the same trouble. <?php /****** * Purpose: Mass search/replace all database fields * Author: design1online.com, LLC * License: GNU ******/ //connect to your database $host = "localhost"; $username = "your_username_goes_here"; $pass = "your_pass_goes_here"; $database = "your_database_name_goes_here"; //the values you want to find/replace $find = "what_you_want_to_find"; $replace = "what_you_want_to_replace_it_with"; //spit out the SQL without running it $test_mode = true; //change this to false and the queries will be run automatically //if you want to limit the replace to specific tables uncomment this line and enter them below //$tables_list = array("table_name_1", "table_name_2", "table_name_3"); //the value
DATA MINING Organizes and employs information and knowledge from databases Statistical, mathematical, artificial intelligence, and machine-learning techniques Automatic and fast Tools look for patterns Simple models Intermediate models Complex Models Data mining application classes of Problems Sequencing Classification Regression Clustering Forecasting Association Others Hypothesis or discovery driven Iterative Scalable Tools and Techniques Data mining Statistical methods Neural computing Decision trees Intelligent agents Case based reasoning Genetic algorithms Text Mining Hidden content Group by themes Determine relationships Knowledge Discovery in Databases Data mining used to find patterns in data – Identification of data – Preprocessing – Transformation to common format – Data mining through algorithms – Evaluation Data Visualization Technologies
NoSQL is an alternative to the standard Relational Database Management System (RDBMS). It apparently performs very fast and efficiently with querying large data sets (also referred to as “big data”); it apparently is not intended as a replacement for SQL databases, but poses a specialized solution for typical database/data store problems in the enterprise-wide scope of an IT organization. This article can be found online at the following location: http://www.databasejournal.com/news/mongodb-nosql.html MongoDB – Why Does NoSQL Matter? November 7, 2011 In recent years, the drumbeat of vendors proclaiming the ascendancy of NoSQL has become increasingly loud. One of the NoSQL vendors that is seeing business results from its NoSQL solution is 10gen, which is the lead commercial sponsor behind the open source MongoDB NoSQL database. “We’re seeing the NoSQL space really taking off now and it’s being used in a significant way by a lot of people, including a
The latest version of SQL Server Management Studio (SSMS) doesn’t have the SQL Server Agent that enables you to schedule jobs. I guess that’s a “paid for” extra! So to back up your databases, you need to create a T-SQL script and run it through Task Scheduler. 1: Create stored procedure in ‘master’ database Create a new query in SSMS, copy & paste the code below, and run it (F5). -- Copyright © Microsoft Corporation. All Rights Reserved. -- This code released under the terms of the -- Microsoft Public License (MS-PL,http://opensource.org/licenses/ms-pl.html.) USE [master] GO /****** Object: StoredProcedure [dbo].[sp_BackupDatabases] ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Microsoft -- Create date: 2010-02-06 -- Description: Backup Databases for SQLExpress -- Parameter1: databaseName -- Parameter2: backupType F=full, D=differential, L=log -- Parameter3: backup file locati
In this post I will some tips for setting RMAN in RAC environment. Note: This post is not finished I’ll add more information later. First question: Is there a difference of setting up RMAN between standalone and RAC environments? The answer is YES, not too much but some points must be observed. As we are configuring backup on cluster the backup must run in any node of cluster and in any time. This is a challenge. RMAN Catalog First of all, In my point of view use RMAN Catalog is mandatory. Because it’s a HA environment and to restore a database without RMAN Catalog can take long time. To protect and keep backup metadata for longer retention times than can be accommodated by the control file, you can create a recovery catalog. You should create the recovery catalog schema in a dedicated standalone database. Do not locate the recovery catalog with other production data. If you use Oracle Enterprise Manager, you can create the recovery catalog schema in the Oracle Enterprise
When I start development on iPhone, my first task was put image into sqlite database and then read image from database. I spend some days in order to find solution, but I can’t find way which was closer to me. And I decide to write article on stackoverflow but no answer come. After long tries I found solution and now I want to show parts of code which will help you to save and load image from sqlite database. // Here I create IMAGE table if it not exist. sql_stmp = "CREATE TABLE IF NOT EXISTS IMAGES (URL TEXT UNIQUE, IMAGE BLOB)"; if( sqlite3_exec(articlesDB, sql_stmp, NULL, NULL, &errMsg) != SQLITE_OK ) NSLog( @"Fail to create \"IMAGES\" table. Error is: %@", errMsg ); // This is function which save image to sqlite database. As an arguments we give // image data and image url. Image url is unique and it can't be two images with same // url in the IMAGES database. - (void) SaveImagesToSql: (NSData*) imgData NSString*) mainUrl { NSLog( @"\n*****Save image to SQLite*****\n"
