Search Results

Search found 30339 results on 1214 pages for 'shrinking database'.

Page 88/1214 | < Previous Page | 84 85 86 87 88 89 90 91 92 93 94 95  | Next Page >

• GORM ID generation and belongsTo association ?

  - by fabien-barbier

  I have two domains : class CodeSetDetail { String id String codeSummaryId static hasMany = [codes:CodeSummary] static constraints = { id(unique:true,blank:false) } static mapping = { version false id column:'code_set_detail_id', generator: 'assigned' } } and : class CodeSummary { String id String…

  Read the article

• What are the uses for Cross Join?

  - by vanslly

  A cross join performs a cartesian product on the tuples of the two sets. SELECT * FROM Table1 CROSS JOIN Table2 Which circumstances render such an SQL operation particularly useful?

  Read the article

• Undo table updates in SQL Server 2008

  - by sikas

  I updated a table in my MS SQL Server 2008 by accident, I was updating a table from another by copying cell by cell, but I have overwritten the original table. Is there a way that I can restore my table contents as it was?

  Read the article

• Best way to fetch data from a single database table with multiple threads?

  - by Ravi Bhatt

  Hi, we have a system where we collect data every second on user activity on multiple web sites. we dump that data into a database X (say MS SQL Server). we now need to fetch data from this single table from daatbase X and insert into database Y (say mySql). we want to fetch time based data from database X through multiple threads so that we…

  Read the article

• Program to find canonical cover or minimum number of functional dependencies

  - by Sev

  I would like to know if there is a program or algorithm to find canonical cover or minimum number of functional dependencies? For example: If you have: R = (A,B,C) <-- these are tables: A,B,C And dependencies: A ? BC B ? C A ? B AB ? C The canonical cover (or minimum number of dependencies) is: A ? B B ? C Is there a program…

  Read the article

• Building a many-to-many db schema using only an unpredictable number of foreign keys

  - by user1449855

  Good afternoon (at least around here), I have a many-to-many relationship schema that I'm having trouble building. The main problem is that I'm only working with primary and foreign keys (no varchars or enums to simplify things) and the number of many-to-many relationships is not predictable and can increase at any time. I looked around…

  Read the article

• Any simple approaches for managing customer data change requests for global reference files?

  - by Kelly Duke

  For the first time, I am developing in an environment in which there is a central repository for a number of different industry standard reference data tables and many different customers who need to select records from these industry standard reference data tables to fill in foreign key information for their customer specific records. …

  Read the article

• I want define tables from ER Diagram.

  - by M R Jafari

  I have a unary relationship. (Image Url : http://freezpic.com/pics/666c94955212a2f757fa25f9f7d31a5e.png) But I want define a table for person. The table has personID and personName column. What columns add it?

  Read the article

• add schema to path in postgresql

  - by veilig

  I'm the process of moving applications over from all in the public schema to each having their own schema. for each application, I have a small script that will create the schema and then create the tables,functions,etc... to that schema. Is there anyway to automatically add a newly created schema to the search_path? Currently, the…

  Read the article

• Best solution for a comment table for multiple content types

  - by KRTac

  I'm currently designing a comments table for a site I'm building. Users will be able to upload images, link videos and add audio files to the profile. Each of these types of content must be commentable. Now I'm wondering what's the best approach to this. My current options are: 1. to have one big comments table and a link tables for…

  Read the article

• Examples of "when is good idea implement many-to-many relationships"?

  - by panchicore

  I ask this because need to understand/explain better with examples. clasical examples like: an Article can be published in multiple Publication objects, and a Publication has multiple Article objects. (source) I see is usefull for web2.0 for sharing features.

  Read the article

• Experimenting with data to determine value - migration/methods?

  - by TCK

  Hey guys, I have a LOT of data available to me, and want to experiment with data that isn't currently being used in production. The obvious solution seems to be to make a copy of production data and integrate it with what I want to play around with, but I was wondering if there was a better (less expensive?) way to do this. Both…

  Read the article

• Modify database for the SharePoint 2010 Enterprise Search administration web site

  - by Mark Hall

  Does anyone know how to modify the database settings for the Enterprise Search administration web site? When you configure the service application via Central Administration, SharePoint just decides to use the default database server and gives a name like Enterprise_Search_DB_Identifier. I want to modify this to atleast give a…

  Read the article

• Entity framework (1): implement 1 foreign key to multiple tables

  - by Michel

  Hi, i've modeled this: i have an import table, and an import steps table import 1 .. N importsteps Now i have a table importparams, which hold key/value pairs to register all kind of info about the import or the importsteps. So i have modeled a FK in SqlServer which points to the PK of the import table and to the PK of the…

  Read the article

• When is referential integrity not appropriate?

  - by Curtis Inderwiesche

  I understand the need to have referential integrity for limiting specific values on entry or possibly preventing them from removal upon a request of deletion. However, I am unclear as to a valid use case which would exclude this mechanism from always being used. I guess this would fall into several sub-questions: When is…

  Read the article

• Can I ask Postgresql to ignore errors within a transaction

  - by fmark

  I use Postgresql with the PostGIS extensions for ad-hoc spatial analysis. I generally construct and issue SQL queries by hand from within psql. I always wrap an analysis session within a transaction, so if I issue a destructive query I can roll it back. However, when I issue a query that contains an error, it cancels the…

  Read the article

• Two different tables or just one with bool column?

  - by Aidas

  We have two tables: OriginalDocument and ProcessedDocument. In the first one we put an original, not processed document. After it's validated and processed (converted to our xml format and parsed), it's put into Document table. Processed document can be valid or invalid. Which makes more sense: have two different tables for…

  Read the article

• How to force grails GORM to respect DB scheme ?

  - by fabien-barbier

  I have two domains : class CodeSet { String id String owner String comments String geneRLF String systemAPF static hasMany = [cartridges:Cartridge] static constraints = { id(unique:true,blank:false) } static mapping = { table 'code_set' version false columns { …

  Read the article

• Tables as relations in ER diagrams

  - by Richard Mar.

  Assume I have the following tables (**bold** - primary key, *italics* - foreign key): patient(**patient_id**, name) disease(**disease_id**, name) patient_disease(**p_d_id**, *patient_id*, *disease,_id* ) I want to draw the ER diagram for this. My idea is to make two entities, one for patient and one for disease, then…

  Read the article

• Data Modeling of Entity with Attributes

  - by StackOverflowNewbie

  I'm storing some very basic information "data sources" coming into my application. These data sources can be in the form of a document (e.g. PDF, etc.), audio (e.g. MP3, etc.) or video (e.g. AVI, etc.). Say, for example, I am only interested in the filename of the data source. Thus, I have the following table: …

  Read the article

• How to schedule a backup in Plesk for Database and configuration?

  - by Dilip Rajkumar

  I like to make a scheduled backup in plesk 10.4. My target is to Take the backup of Database and configuration and put in the FTP location. I dont see any option in backup manager in plesk. Any help is greatly appreciated. Then there is a setting "Suspend domain until backup task is completed" If I…

  Read the article

• django models : How to have variable number of foreign keys in a model ?

  - by Rohit

  For instance, Model Resume contains variable number of Model Project 's, What should be my models and relationships between them to achieve this ? Thanks in advance.

  Read the article

• What is an index in MySQL?

  - by Eric

  http://i.imgur.com/JdsUK.jpg I created a table like the picture above. What are the "Indexes"? primary key? unique? It works well without setting indexes.. What do they do? why do I need them? Also, I set all String fields to TEXT because I didn't know how many characters I need. Is this a good idea? I…

  Read the article

• Common one-to-many table for multiple entities

  - by Ben V

  Suppose I have two tables, Customer and Vendor. I want to have a common address table for customer and vendor addresses. Customers and Vendors can both have one to many addresses. Option 1 Add columns for the AddressID to the Customer and Vendor tables. This just doesn't seem like a clean solution to…

  Read the article

• Many to many table design question

  - by user169867

  Originally I had 2 tables in my DB, [Property] and [Employee]. Each employee can have 1 "Home Property" so the employee table has a HomePropertyID FK field to Property. Later I needed to model the situation where despite having only 1 "Home Property" the employee did work at or cover for multiple…

  Read the article

< Previous Page | 84 85 86 87 88 89 90 91 92 93 94 95  | Next Page >