I have a piece of maintenance code that should grant select privileges to a certain user at certain points of time: grant select on A_DB.A_TABLE to READ_ONLY_USER; I want to do this for all tables. I could use select * from tab in Oracle or show tables in MySQL to get the complete list and then move on like that. But since I already ...
For our reporting application, we have a process that aggregates several databases into a single 'reporting' database on a nightly basis. The schema of the reporting database is quite different than that of the separate 'production' databases that we are aggregating so there is a good amount of business logic that goes into how the data ...
My application will need to reference addresses. Street info will be stored with my main objects but the rest needs to be stored seperately to reduce redundancy. How should I store/retrieve ZIPs, cities and states? Here are some of my ideas. single table solution (cant do relationships) [locations] locationID locationParent (FK for loc...
I have designed databases several times in my company. To increase the performance of the database, I look for Normalisation and Indexing only. If you were asked to increase the performance of a database which has approx 250 tables and some tables with millions of records, what different things you would look for? Thanks in advance. ...
Hi, There are very useful documents explaining the server architectures like Linkedin, MySpace, Amazon and etc. After seeing MySpace, I really surprised as they are using 500+ database servers for their application. Would like to know how will they maintain SQL transactions, joins, look ups if data spans across multiple database serve...
I am storing a list of "Users" in a table. The business logic of the application will have a reference to an object with all the data in this table for the currently logged-in user. And be able to allow the user to perform operations if they have the correct access. I'm wondering what is the best way to store "access levels?" One way I...
I want to build an N-Tier web-application , for shopping cart. I want to follow the concepts collections. That is retrieve data from db, fill it in collections and bind collections with asp.web and html controls. Or simply i can say , i want to know how to use collections with ASP.Net controls or Some good tutorials or links to learns ...
I have some links on a page such as: < a id="Digg" runat="server">< img alt="Digg" id="imgDigg" runat="server" src="~/resources/images/icons/social/digg_32.png" border="0" />< /a> I have a database table that can "turn" them on or off, in my code behind I have the following: string[] SocialMedia = new string[] { "Twitter", "Facebook"...
Hello; I want to insert about 50,000 mysql query for 'insert' in mysql db, for this i have 2 options, 1- Directly import the (.sql) file: Following error is occur " You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit. " 2- Use php code to insert these queries in form of differ...
Can a database table contains more than one primary key? Yes, I am talking about RDBMS. ...
I'm an embedded guy, not a database guy. I've been asked to redesign an existing system which has bottlenecks in several places. The embedded device is based around an ARM 9 processor running at 220mHz. There should be a database of 50k entries (may increase to 250k) each with 1k of data (max 8 filed). That's approximate - I can try to...
I just want to know if it's possible. How do I save an html page and all of its contents to a database? like for example, I have a database wherein it consists all HTML pages. Just want to know if its possible. And how to retrieve it too. We're using PHP as our language. Thank you. ...
Hello guys, I was wondering if there are any abstraction layers for the SQLite database thats integrated into Adobe AIR. I don't expect something like Doctrine or Zend_Db (coming from the PHP world) but a bit more abstraction and comfort would be really nice. I'm using the HTML/JavaScript flavor of AIR so any ActionScript stuff is of ...
I am doing a program involving a database. I have a query that will fetch all the data from the table. But I want to traverse through each record and get each column values of each record. For that, we usually use a ResultSet. But since I am a beginner in SQLite, I dont have any idea on how to do this? Do anyone have an idea? ...
hi all, in my database i store the student information in encrypted form. now i want to perform the search to list all student which name is start with "something" or contains "something" anybody have idea that how can perform this type of query? Please suggest ...
Example: I have two tables in my database called classA and classB, and one table called classA_classB. The last one just defined two int fields with foreign keys to link between classA and classB. So one classA can have many classB, and many classA can link with the same classB. Simple stuff, so far. The problem is, in my special case,...
I want to know if it's possible to change this: ENTRY IN DATABASE WHERE CAPSLOCK IS USED. I WANT TO REMOVE THIS CAPS HERE. To: Entry in database where capslock is used. I want to remove this caps here. With a script or anything withing sql. I have copied a database into another database, but alot of records contain fields with ever...
I'm not very familiar with C# so far, at least not enough to feel confident when choosing ways of doing something when it comes for the first time. What could be the best way to organize SQL Server database timer based polling from my WPF application for controls updating? Could you please share some thoughts on this issue or, maybe, ...
Ideally, where would an application like Facebook store its "Friends" data? In a database table? in an xml file? ...
i have what seems like a basic scenario for a db trigger in SQL server and i am running into an issue. i have table Users (id, name, phone, etc) and i have tables UsersHistory (id, user_id action, fields, timestamp) i want a database trigger where anytime inserts, updates or deletes into Users, i want a new record created in UsersHist...