data

Master data validation & enumerations

At a high level my question is like the following - I am doing a data sync, using web services, between two different systems. To validate the mater data, I depended on creating enums and tried to validate; which I though will ease my job of comparison. But evetually, I ended up comparing as enum.ToString() (which I feel not a good pra...

how to design a database to save data whose structure is not always known during design, and could change later?

sites like IBM's many eyes, swivel etc store varieties of data and allow their users to visualize them. How do they design their tables? For example, if you were to save the data from data.gov site into a database and allow your users to perform operations on it, how would you go about designing the tables? The structure needs to be gene...

List management problem...

I have a datasource, which I show as a list in a Flex UI. I refresh the list periodically, One of my UI requirements is to gracefully show when the datasource removes an item from the list, So I'm correlating the current list against the incoming datasource. The correlation process is this: Refresh the datasource. Loop through the e...

Flash : How to read data from shape/graphics object.

Hallo, I am wondering if it is possible to get the data that is stored in a shape/graphics object in flash using actionscript 3? In my project I would like to be able to draw a shape and then read all the points in that shape into my script. The reason for that is that I need go generate lines from those points that I later can use to ...

xml data not showing in flash movie

I know this has been asked already. But the solution given is not working. I have a page.php with a flash banner embeded. banner.swf loads, but displays nothing because it is not getting its data from data.xml which is in flash/lighter/data.xml It only works if the banner.swf and data.xml and the banner_images are all in the root dir...

Why java has fixed data type size unlike C

In C as we know the size of data types (ex. int) can vary depending on compiler / hardware. But why the size of data types is constant in java language? why don't we have the flexibility for different data type size in java depending on compiler? ...

PHP mysql echo data

<?php // query db $sql = "SELECT category.id as category_pk, category_id, products.* from category, products WHERE products.id = category.category_id AND category.id = category_id"; // from category get id if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { $row = mysql_fetch_assoc($result); ...

Can anyone recommend a synthetic data generator?

Did anyone come across a free data generator that ca create synthetic data to load into databases for testing purposes? ...

Oracle Data Modeler and synonyms

Hi, I've been searching the web for two days and still cannot find a way to generate DDL code with public synonyms. Would be very grateful for an advice. ...

Google Wave and Robot with dynamic thirdparty data source

Hi! I am new to google wave robot programming and for some time I am looking for an answer to my question. Consider example: (A) - Thirdparty Data Source with Thirdparty API (B) - Google Robot (C) - Google Wave Is there a way to create robot (B), which will periodically interact with (A) updating the (C) even if user is away (doesn...

EDIFACT macro (readable message structure)

Hi, I´m working within the EDI area and would like some help with a EDIFACT macro to make the EDIFACT files more readable. The message looks like this: data'data'data'data' I would like to have the macro converting the structure to: data' data' data' data' Pls let me know how to do this. Thanks in advance! BR Jonas ...

fiiling data base randomly

i need to generate my sql server 2005 database for testing a multithreaded application. it must be morre than 3 gb at least, what should i do ...

Terminating and Starting Data Connection on Windows Mobile 6.5 in C#?

Heys Guys! Just got a rather annoyingly akward question :S I want to create an easy application for windows mobile devices, i have recently got a HTC HD2 and the connection is being eaten by the weather app, email accounts and windows live service :@ I am getting rather annoyed with this and well i have set myself a project to give m...

SQL SSRS very large extract

Hi I support some very large databases (approaching a terabyte). We currently have an in-house reporting solution, but are investigating the use of SSRS (SQL Reporting Services). However our users sometimes need to extract large volumes of data (many millions of records), which may take a few hours to retrieve. What is an advisable app...

XML to Datamodel synchronisation strategies...

I have an XML data source, which I'm loading / refreshing. I'm populating a data model from this source and would like to manage synchronisation issues e.g. being able to notify the GUI/User when items have been removed, had their values increased / decreased, changed... etc. I'm wondering if there is a standard way of doing this? I...

Need help thinking about ways to normalize some messy data!

So I have some data in an Access table. I am well-versed in Access and am using it in this instance for its report-generating qualities and ease of use for the non-tech proficient. This is the only tool at my disposal. The data came to me as an .xls with a lot of junk and stuff basically all over the place. I made a bunch of queries to ...

Tool to determine a dataset's schema

Let's say I want to write a program that can generate a diagram (e.g. an organization chart, timeline, or GANTT chart) out of some input data sitting in a spreadsheet or database. One big challenge is that users store their data in different formats that are frequently unstructured or missing 100% integrity. For example, I can think of...

Multiple users table VS 1 users table? (mysql and php)

I am in dilemma situation. I am not sure if its a good idea to separate the users table. I notice my game highscores table performances, as the numbers growing, the loading is getting slower and slower. My current users table store all users, which currently about 10k users. I am thinking of splitting the users table (for future) into l...

Getting data is fast, but Flash displaying php data is slow, why?

In my database(mysql), I have a table which has 50k data(rows/records). I do a test using firebug, after playing the game, the call to load_score.php and save_score.php is around 380ms (millisecond). The save_score.php just a normal inserting, nothing much. The load_score.php, I use this query: SELECT name, score FROM `highscores` WH...

Flex: Displaying properties from two objects in a datagrid

Previously I post a discussion on this matter on Flex Adobe forum and still don't understand what needs to be done. So, I'll try my luck again on stackoverflow. I'm using drag and drop data binding functionality in flash builder 4 on a data-grid. However, the data I need to show need to be query from another object. <mx:DataGrid id="da...