Hi, all. Are there any enterprise-grade database engines (Oracle, MS SQL...etc) that can handle large RDF datasets (320 million) and SPARQL queries? I guess my question is also: is SPARQL/RDF/OWL ready for serving large real-world data warehouses for an enterprise? If not, are there efficient mechanisms for adapting SPARQL/RDF against ...
Hi, I am writing a function which is called into a page, but I am not sure how to call information form database into the function in order to use them. Basically I am doing some calculation in the function where I need information form database to do them. Is there anyone who can give a clue on how ot do this? Many thanks F From a co...
SQL Server 2008 database design problem. I'm defining the architecture for a service where site users would manage a large volume of data on multiple websites that they own (100MB average, 1GB maximum per site). I am considering whether to split the databases up such that the core site management tables (users, payments, contact detail...
The environment I'm working in is a Crystal Reports Server 2008 talking to a MySQL Server 5.1 database using JDBC. The problem is that I get a database logon screen every time I try to access a report from Crystal Reports Server. I've setup a JDBC connection using the MySQL Connector/J driver. When I create a .rpt file I provide the l...
My delete.php is sending the selected item to the db as dead as it should, but the blog is still staying on the page that its deleted from. What am I doing wrong? this is my query: on the delete.php: $MyBlog = $_GET['id']; $query = "UPDATE `Blogs` SET `status` = 'dead' WHERE `id` = '".$MyBlog."'"; Like I said, this is marking id dea...
We are facing a strange problem with Websphere Application Server Data Source. Environment: Websphere Application Server (6.1) Linux Liferay Portal (5.2) Oracle 9i Hibernate 3.0 We have datasource deployed in Application server referencing ODBC14.jar Hibernate Configuration for Datasource: <property name="connection.datasource">jd...
asp.net and sql server, have sqls for selecting a subset of rows, I need the count* frequently Of course I can have a select count(*) for each of these sqls in each roundtrip but soon it will become too slow. -How do you make it really fast? ...
Normalisation of database is always a world of pain for data administrators.To what level is the normalisation is important for proper maintenance of the database. What could be the performance issues if the normalisation is done on the local and the remote database? ...
As I found this can be done with merge replication in SQL Server. But I have only one main server and many small ones(with Express edition installed on them). Let me explain: There is the main (big) office with SQL Server Standard edition installed on its server. And there are many offices across the country with with their own small ...
How do I set the the default encoding of my local file SQL-Server database? Thanks. EDIT: Removed the UTF-8 ...
We always have some static data which can be stored in a file as an array or stored in a database table in our web based project. So which one should be preferred? In my opinion, arrays have some advantages: More flexible (it can be any structure, which specifies a really complex relation) Better performance (it will be loaded in memo...
Our company has a product which relies on local database to work (it allows more client to connect to same database and share data between them). DBMS: Microsoft SQL Server 2008 Now, we need to create a single database, accessible through internet (i am not interested in the how, for now), which will allow more users to use it as if ...
I have following script. I dont know how to create new database in sql server 2005. I run following scirpt, and it create tables under model instead of seperate databse. it look massy. how can i create seperate databse. I am copy some script here for your adive and course of action. -----------------------------------------------------...
Is there an easier way of cleaning up a database that has a ton of stored procedures that I'm sure there are some that aren't used anymore other than one by one search. I'd like to search my visual studio solution for stored procedures and see which ones from the database aren't used any longer. ...
I need some inspiration for a solution... We are running an online game with around 80.000 active users - we are hoping to expand this and are therefore setting a target of achieving up to 1-500.000 users. The game includes a highscore for all the users, which is based on a large set of data. This data needs to be processed in code to ...
I've been using SQL Server to store historical time series data for a couple hundred thousand objects, observed about 100 times per day. I'm finding that queries (give me all values for object XYZ between time t1 and time t2) are too slow (for my needs, slow is more then a second). I'm indexing by timestamp and object ID. I've entertain...
I am writing a migration generator for a plugin I am writing and I need to to be able to find what unique indexes a table has so I can modify existing unique indexes to become a composite unique index. I have been trying to find a way to access what indexes a table has with ActiveRecord. I have only been able to find ActiveRecord::Conn...
Hi, I'm trying to migrate one of my PHP projects to Doctrine. I've never used it before so there are a few things I don't understand. In my current code, I have a class similar to this: class ScheduleItem { private Date start; //A PEAR Date object. private Date end; public function getStart() { return $this->start; } public...
I'm working on a rails site that I've inherited and am trying to troubleshooting some sub-optimal model behavior. I have users, songs, and songs_download, each of which is its own model. Here's the relevant line from the users model: has_and_belongs_to_many :downloaded_songs, :class_name => 'Song', :join_table => :song_downloads F...
What are the best ways to keep data synchronized between in memory cache and the database when used in a web application? Specifically, I store large amounts of database data in an in-memory cache using EHcache on my web application. For many interactions, I would like to simply modify the value in cache, and only synchronize it with the...