You are here:
- Home
- Computing/Technology
- Oracle
- Data Management & Storage
Data Management & Storage/Questions Answered by Expert Krishna Prasad
| Subject | Date Asked |
| MS Excel | 4/5/2010 |
| Q: I am setting up a database of customer names and email addresses for my small business. I exported ... A: Chad, In Excel, if you select the rows, at the bottom you will see the line that says how many ... | |
| Database size and storage | 3/14/2010 |
| Q: I have a question that I hope you can help me with. We're trying to figure out space requirements ... A: Ryan, A page limitation is imposed by certain software (for instance DB2). In order to find the ... | |
| internet passwords | 5/8/2009 |
| Q: I would like to put a password on the internet options of my computer, im having problems with ... A: Justin, If it is your personal PC or even a shared PC at home, you can create separate accounts ... | |
| Storage Area Network (SAN) | 3/10/2009 |
| Q: Please what certification exams and courses will i need to do to become a SAN Administrator (or SAN ... A: Elliot, There are many certifications offered by many institutions, but the most reputed are ... | |
| design of db | 3/5/2009 |
| Q: we are developing a site for classfieds.the site will have different categories and different ... A: Parth, This ia a very general question and involves a design of a whole subsystem. I would like ... | |
| Database Accuracy | 2/18/2009 |
| Q: We want to insure that the information stored in our database is accurate. Are there any standard ... A: Brian, The short answer is - you have to test! When you build the data warehouse, it shoudl be ... | |
| Data Management | 1/16/2009 |
| Q: i would like to learn data management and build mhy career towards business intelligence. which ... A: Raja, If you want to be a data modeller than a generic Data Management Course is what you need. ... | |
| Data Management | 1/14/2009 |
| Q: i would like to learn data management and build mhy career towards business intelligence. which ... A: Raja, The question is broad, and without further details, my answer may be off the mark. So, ... | |
| Entity / relationship model | 1/12/2009 |
| Q: I would still ask you kindly to send me the answer to my ER question even though you mentioned that ... A: Tennis-Girl, Sorry, I did not get the email in your note. Can you send me the question again in ... | |
| Data Management | 10/22/2008 |
| Q: If the business scans a PDF document of 8 pages (that is a total of over 3 sperate documents) for ... A: TJ, Are you simply storing the documents in your disk drive? Or are you thinking in terms of a ... | |
| MS Access Stability | 10/15/2008 |
| Q: Can you advise please, I have concerns on the amount of data and more importantly the complex ... A: Neil, MS Access is not scalable, you are absolutely right. Scalable databases built for ... | |
| datawarehousing tools | 10/15/2008 |
| Q: I am having a databse with pretty large amounts of data. some of the data entered have mistakes ... A: Typically, you will do two things: 1. I assume that the data is entered into the database through ... | |
| Converting old data in dbase or Lotus 123 format! | 6/27/2008 |
| Q: Krishna Prasad I am hoping you could assist me with some ideas/solutions - I have an old computer ... A: Carl, I have heard that sometimes it does not work perfectly but in most cases it should be OK. ... | |
| Automaticall saving back-up | 6/1/2008 |
| Q: Is there a way to have Microsoft Office software to save two copies of a file when you click save? ... A: Unfortunately, what you ask for is not possible through Word itself. Now, from Word 2003 ... | |
| backup | 5/11/2008 |
| Q: I have two dell servers ,one dell power edge 2950 and one power edge 1950,I want to use the 2950 as ... A: Hussein, Depending on the sophistication you want and the money that you are willing to spend, ... | |
| cloning | 3/31/2008 |
| Q: What I want to accomplish ti to clone my entire hardrive on my desktop to an external USB harddrive ... A: Jim, I simply meant that in the target system, you need to have the drive recognized.... (If a ... | |
| cloning | 3/29/2008 |
| Q: What I want to accomplish ti to clone my entire hardrive on my desktop to an external USB harddrive ... A: Generally, the hardware layer is hidden underneath what you are trying to do. If you can define your ... | |
| mirrored databases and tailored databases | 12/28/2007 |
| Q: I'm studying the difference between distributed databases and localized databases, my question is ... A: Fiorita, In the time and space available I can give only an overview. A mirrored database is ... | |
| migrate to oracle | 11/14/2007 |
| Q: resp. sir, I have a fair knowledge of FoxPro system of database mgmt. and programming related to ... A: DDY, I can answer your questions but please bear this in mind. 1. I only give my perspective in ... | |
| need for a solution | 11/10/2007 |
| Q: respected sir my question is that ,how i create a database,what are the steps are thers for create a ... A: Anirban, 1. You have control over access to the database. (You can set up who can see, update, ... | |
| What database handles the largest files? | 11/7/2007 |
| Q: I know that certain database system (e.g. ACCESS) defaults at 2 gigabytes. I need a database ... A: Unfortunately, with power comes complexity. All these systems are complex and require knowledge to ... | |
| need for a solution | 11/4/2007 |
| Q: respected sir my question is that ,how i create a database,what are the steps are thers for create a ... A: Aniban, If you are looking for the absolute basic material, you can find some here ... | |
| What database handles the largest files? | 11/1/2007 |
| Q: I know that certain database system (e.g. ACCESS) defaults at 2 gigabytes. I need a database ... A: For that large a database, you need an industrial strength database. I have used Oracle, Sybase and ... | |
| knowledge mgt | 9/13/2007 |
| Q: I have a question and I'm not too sure if it's related to database but i'm just wondering what is ... A: Sue, In my view, designing all your systems and processes around knowledge means that you keep ... | |
| knowledge mgt | 9/12/2007 |
| Q: I have a question and I'm not too sure if it's related to database but i'm just wondering what is ... A: Sue, You are right in that Knowledge Management does not have anything directly to do with ... | |
| Help with Sql query | 8/21/2007 |
| Q: i m steve, i actually need a sql query, i am not able to get it can you please help i got two table ... A: Steve, That should be easy. In any SQL, you determine the link field. Here it is PATIENTID. ... | |
| rank (vba) | 5/30/2007 |
| Q: I would like to create a database that will contain a rank field on the form which allows me to rank ... A: Sue, Just for this purpose, many SQLs (DB2, Oracle among those) have given a CREATE SEQUENCE ... | |
| Data Mining Software | 3/22/2007 |
| Q: I have anotherWhat are the top 3 data mining software vendors and what are their software package ... A: A list of Data Mining software vendors can be found at ... | |
| indexing | 3/19/2007 |
| Q: I have a query which sets all the 'lastmod' values from update_products equal to the 'lastmod' ... A: Victor, I thought that the description was being checked to verify that the description was ... | |
| indexing | 3/18/2007 |
| Q: I have a query which sets all the 'lastmod' values from update_products equal to the 'lastmod' ... A: Lack of a proper index may only be one of the possible problems in this query. Depending on what the ... | |
| Sorting question | 3/17/2007 |
| Q: I am running a MySQL query using product ids like this: SELECT * FROM products WHERE product_id=510 ... A: Unfortunately, SQL and most databases do not guarantee the order of results. That is a fundamental ... | |
| upgrading to different windows version | 2/28/2007 |
| Q: I have a computer that i purchased in 2001, it came with windows 98. Recently i have found that many ... A: Greg, You can go to Windows XP or Vistas, but the problem is that if your system is very old, ... | |
| Data storage | 2/15/2007 |
| Q: We have about 200 pages of an old timey computer print out with some very valuable information from ... A: Well, scanning it in directly can give you only a few options. For instance, you can post the ... | |
| formatting | 1/23/2007 |
| Q: i am aashish , i had win 98 on my c drive , than i removed win 98 by formatting c partition and ... A: Aashish, I am afraid I have no easy answers for you in both the questions. Typically, it means ... | |
| privacy for a folder | 12/20/2006 |
| Q: I AM HAVING MY COMPUTER UPGRADED. MY PROBLEM IS THAT I HAVE A FILE THAT IS VERY PRIVATE. WHAT CAN ... A: There are many solutions, all of which involve encryption. (Of course, I assume that you do not ... | |
| Migration | 12/19/2006 |
| Q: Can you tell me how to migrate Oracle database from VMS operating to Windows XP. Regards Subangini A: Typically, you would use the following process. The actual commands required can be looked up in an ... | |
| Entity life History | 12/9/2006 |
| Q: Many many thanks for your suggestion. I would be very pleased if you kindly check my diagram's ... A: Sorry for the late response, Maruf! I really did not understand the 'order of attributes'. What ... | |
| Data Warehousing | 11/8/2006 |
| Q: I am planning to take data warehousing as a career path. I have started my training in Business ... A: In the Data Warehouse Projects I was involved with, you could see the migration path in the members ... | |
| data bank | 11/3/2006 |
| Q: You have good understanding of my question and your second solution seems is my answer but could you ... A: Unfortunately it is a very involved process. That is why I said in my answer 'depending on your ... | |
| data bank | 11/2/2006 |
| Q: I am filling a data sheet form in excel format for my daily works. How I can walk between files ... A: Ali, Let me restate the question first to make sure that I understand it properly. You want to ... | |
| starting a business | 10/6/2006 |
| Q: Namaste Dai, I am assuming that you're older. I am actually a Nepali and thought you were one too. ... A: Yes, I am in Toronto. I would help you with suggestions/ views in any way I can, but with two ... | |
| starting a business | 10/5/2006 |
| Q: I am on the process of starting an online company. I was wondering if you could tell me how to ... A: Ronin, First of all, congratulations on your enterpreneurial venture! I wish you all the best in ... | |
Krishna Prasad
Top Expert on this page
Expertise
Data Warehousing and Data Modelling, Cube Building, Data Migration Strategies and Middleware aspects
Experience
Several large scale data warehousing and data migration projects. Built a data warehouse of 7 Terrabytes for an organization. Was involved in cradle-to-grave (data architecture to implementation and testing) of a large scale data warehouse effort, in a control position.
Education/Credentials
Bachelor of Technology and MBA
©2012 About.com, a part of The New York Times Company. All rights reserved.