CN101470866A - Method and system for product test management - Google Patents
Method and system for product test management Download PDFInfo
- Publication number
- CN101470866A CN101470866A CNA2007103066301A CN200710306630A CN101470866A CN 101470866 A CN101470866 A CN 101470866A CN A2007103066301 A CNA2007103066301 A CN A2007103066301A CN 200710306630 A CN200710306630 A CN 200710306630A CN 101470866 A CN101470866 A CN 101470866A
- Authority
- CN
- China
- Prior art keywords
- record
- product
- weight
- test
- data bank
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a method for managing product tests, which comprises establishing a complex pen product record and a complex pen component record in a database, selecting a component record belonging to a product record for the product record, and recording the whole or one part of the complex pen component record to be a measured component record, wherein any measured component record represents that a corresponding component is tested, wherein each component record has a weight, the weights of all component records belonging to the product can be further accumulated to get a total weight, the weights of the measured component records belonging to the product are accumulated to get an actual measured weight, and then, a test covering rate of the product is calculated out according to the total weight and the actual measured weight.
Description
Technical field
The present invention is relevant with the technology of product test aspect, relates in particular to the part of how managing on the product and whether tested relevant item is arranged, and the test of particularly managing the part on the various computer motherboards whether.
Background technology
In the manufacturing engineering of a device, according to the requirement on the quality, the test that each part on this device is carried out to a certain degree is necessary.These parts need whole tests sometimes according to different demands, only need partly test sometimes.Get over complicated apparatus, part is just many more, and the quantity of part, also can increase along with the function of this device and increase.This phenomenon is especially obvious at the product such as this class of computer motherboard.
With existing computer motherboard is example, and its part or assembly (being referred to as parts subsequently) commonly used has CPU, VGA, RAM, PS2, COM, LPT, FAN, IDE, SATA, USB... etc.These parts are many and numerous and diverse, and the computer motherboard of different model has some identical parts, also have some different parts.For example, the parts as the fan, according to different system voltage (12V ,+5V ,-5V, 3.3V...), just be divided into severally, though this means that fan is all arranged on two computer motherboards, may be the fan of different model.Picture CPU and other parts also have similar situation more.In any case these parts can be required to need partly or all by testing usually.This means that the computer motherboard of different model is required that the parts that need test are also inequality, may be similar, also may be little of different greatly.
In the past, do not do systematic management at the test of these parts, therefore, plan which parts a certain computer motherboard has, writing down these parts has which has a survey and which has do not survey, and calculates the test coverage rate of this computer motherboard, and making comprises the form of aforementioned information, all need expensive manpower and time, and might cause the content of this form wrong, for example incorrect test coverage rate because of the data input mistake.
Summary of the invention
The technical problem to be solved in the present invention is: plan which parts a certain computer motherboard has, whether write down these parts through test, calculate the test coverage rate of computer motherboard, the form content that causes because of input error is wrong to cause incorrect test coverage rate thereby reduce.
The invention provides a kind of method that is used for product test management, this method comprises sets up complex product record and the complex part is recorded in a data bank, the corresponding product of represent of each product record, and each part record correspondence is represented a part.Then, be that its affiliated part record selected in product record.Then, the whole or some that those parts are write down is recorded as and surveys the part record.On behalf of its corresponding part, arbitrary part record surveyed have to test.
Preferably, this method comprises the weight in the affiliated all parts of this product of the accumulative total record, to obtain a total weight.Be recorded into the weight of having surveyed the part record in the part record under this product of accumulative total, surveyed weight to obtain a reality.Reality has been surveyed weight divided by this total weight, multiply by 100% again, to obtain the test coverage rate of this product.
The present invention further provides a kind of system that is used for product test management, it comprises above-mentioned data bank, and at least one computer, and a supervisory routine are carried out by this computer, uses this this data bank of computer access of control.Wherein, this supervisory routine is configured to realize said method.
The present invention further provides a kind of Storage Media, and it stores above-mentioned supervisory routine.
Technique effect of the present invention is: by the present invention, can manage the data relevant methodically with product test, and can be fast and correctly will be on the product total total which part, wherein have which part to test, wherein have which part to test ... etc. information write down, for inquiry, output, statistics, reach other utilization.
Description of drawings
Fig. 1 is the calcspar of product test one embodiment of system of the present invention.
Fig. 2 is the process flow diagram of product test method one embodiment of the present invention.
Fig. 3 to Fig. 8 is product test management list and form that formula provided of the present invention.
Embodiment
Fig. 1 is the calcspar of a preferred embodiment of product test of the present invention system, points out that wherein this system comprises a data bank 1, one or more computer 2, an and supervisory routine 3.
This data bank 1 can be selected the data bank of Access data bank, Oracle data bank, MS-SQL data bank or other label for use, and can be based upon according to actual demand on this computer 2, or be based upon on another computer, or be based upon on the data bank server.In any case this data bank 1 is used to store a plurality of part records 10 and complex product record 11, but not as limit.Wherein, each part record 10 corresponding part of representing, each product record 11 corresponding product of representing.
With this product of computer motherboard is example, and its kind is quite a lot of, and various computer motherboard respectively has a lot of identical or parts of being not quite similar, makes suitable many of relevant therewith part.In order to distinguish and to manage, preferably, the content of the pairing product record 11 of arbitrary computer motherboard comprises the title of this arbitrary computer motherboard, suitable bios version, suitable PC plate version, responsible official and client ... or the like.The content of the pairing part record 10 of arbitrary part comprises title, classification, weight, the responsible official of this arbitrary part and is used to distinguish the test badge of having surveyed or not surveyed .... or the like.Wherein, based on the convenience in the unitarity of data and the input, can set up several bios version record, PC plate colophon, user logging, classification record in advance, reach the slip-stick artist and be recorded in this data bank 1, as choosing the source.
This supervisory routine 3 is carried out by this computer 2, to control this this data bank 1 of computer 2 accesses.For arbitrary user, as long as its employed computer has this supervisory routine 3 of installation, this arbitrary user just can come this data bank 1 of access by his computer.This supervisory routine 3 can be write with existing program language, for example VB.NET, C#.NET, C, VB or Delphi.In this example, this supervisory routine 3 is program special projects that VB.NET writes, and can install and carry out for multiple computers 2, in order to this data bank 1 of common access.In any case this supervisory routine 3 is configured to realize described subsequently the inventive method, and can be stored in arbitrarily on the Storage Media.
As shown in Figure 2, the inventive method comprises:
A) set up complex product record 11 and complex part record 10 in this data bank 1;
B) be that its affiliated part record 10 selected in product record 11; And
C) the whole or some of those parts record 10 is recorded as surveys the part record, on behalf of its corresponding part, arbitrary part record of having surveyed have to test.
List shown in Fig. 3 to Fig. 8 and form, its corresponding programs all are the somes of this supervisory routine 3.
First list 4 shown in Figure 3 and second list 5 shown in Figure 4 are to be used to realize a step.
As shown in Figure 3, switch the function that is provided in the page or leaf 40, can increase new part record 10 newly, also can revise or delete part record 10 existing in this data bank 1 in this data bank 1 by first in this first list 4.Switch the function that is provided in the page or leaf 41 by second in this first list 4, can increase new classification newly and be recorded in this data bank 1, also can revise or delete classification record existing in this data bank 1.These classification records are to be used for classifying those part records 10.
As shown in Figure 4, by the function that is provided in this second list 5, can increase new product record 11 newly in this data bank 1.
The 3rd list 6 shown in Figure 5 is to be used to realize this b step, inventory box 60 (listbox) wherein shows all the part records 10 in this data bank 1, can only show that also screening conditions are the conditional values in the condition stub 61 that depends in the 3rd list 6 through garbled part record 10.By to the input of the 3rd list 6 or click operations such as (click), can pick out part record 10a under it for the part record 10 of product record 11 from this inventory box 60, these parts that are selected records 10a is displayed in another inventory box 62 in the 3rd list 6.In this example, though only show to have only several part record 10a in this inventory box 62, in the utilization of reality, the quantity of these part records 10a is more than this number.In any case, be to be used for representing that this product writes down the pairing parts of these parts record 10a are arranged on the 11 pairing products at this inventory box 62 shown parts record 10a.
The 4th list 7 shown in Figure 6 is to be used to realize this c step, and inventory box 70 wherein shows the part record 10a in the inventory box 62 that is same as the 3rd list 6.By function to being provided in the 4th list 7, can from this inventory box 70, pick out and survey part record 10b, and the part record 10b that surveys that is selected is presented in another inventory box 71 of the 4th list 7, one as shown in Figure 7.71 shown part record 10b are used for representing that writing down the corresponding parts of 10b with these parts is to test at this inventory box, and the part record pairing part of 10a (or parts) remaining in this inventory box 70 is then tested.
Via above-mentioned operation, this product writes down on the 11 pairing products total total which part, wherein has which part to test, wherein have which part to test ... etc. information, all can be recorded.These information also can print form as shown in Figure 8, but also remittance abroad (derivation) becomes a document, and for example excel document, Access document, XML document, text document or other can be supported the document of data remittance abroad/remittance (derivation/importing) function.
Please join Fig. 5, as described above, each part record 10 all comprises a weight, and its value has just been determined when this part record 10 is established.The weight of each shown part record 10a all is 1 in the inventory box 62 in the 3rd list 6, so, be 6 for the total weight of this product.
See also Fig. 7, the inventory box 71 shown part record 10b in the 4th list 7 have 4, and every weight all is 1, is 4 so reality has been surveyed weight.To have surveyed weight be 4 to 6 to the weight ratio of total weight thereby obtain reality, and weight number percent then is 4/6*100%=66.67, and this i.e. the test coverage rate of this product.
From the 4th list 7 shown in Figure 6, remit document, except the usefulness that is provided as file.When having the new product of similar machine to handle in the future, just can be with it as the data source that imports system of the present invention.That is to say, use the remittance function that it provides in the 3rd list 6 shown in Figure 4, just the data in the document can be imported, the data that is imported can correspondingly respectively be presented in the inventory box 62 of the 3rd list 6, reach in the inventory box 70 and 71 of the 4th list 7.Then adjust content in those inventory boxes 62,70,71 according to the demand of this new product.Then, carry out the function of the change machine title that the 4th list 7 provided, use and give this new product new title.So, total total which part on this new product, wherein have which part to test, wherein have which part to test ... etc. information, all can be recorded.Import mode by this document, can reduce certain operations.
In addition, in order to accelerate the speed of these supervisory routine 3 access data, these supervisory routine 3 required data that use are to be configured to and can to download to this computer 2 from this data bank 1.Normally download into ACCESS document (being the mdb data bank), be provided as the data source of this supervisory routine 3.When wherein this supervisory routine 3 more was configured to be unlocked at every turn, whether the data that all can compare earlier in the mdb data bank in this computer 2 was consistent with this data bank 1, as long as inconsistent, will immediately the data updating in this mdb data bank be become consistent with this data bank 1.
As seen from the above description, system of the present invention can allow the user of authority, with own computer safeguard, manage, and the test coverage rate of the inquiry item, particularly various products relevant and the correctness of relevent information with product test be protected, and can required information of very fast acquisition and form.
Claims (4)
1, a kind of method that is used for product test management is characterized in that, this method comprises:
Set up complex product record and complex part and be recorded in a data bank, the corresponding product of representing of each product record, the corresponding part of representing of each part record;
Be that its affiliated part record selected in product record; And
Whole or the some of those parts record is recorded as surveys the part record, arbitrary part of having surveyed writes down and represents its corresponding part to test.
As claim 1 a described method, it is characterized in that 2, described each part record comprises a weight, and this method comprises:
Weight during all part writes down under this product of accumulative total is to obtain a total weight;
Be recorded into the weight of having surveyed the part record in the part record under this product of accumulative total, surveyed weight to obtain a reality; And
Reality has been surveyed weight divided by this total weight, multiply by 100% again, to obtain the test coverage rate of this product.
3, a kind of system that is used for product test management is characterized in that, this system comprises:
One data bank stores complex product record and a plurality of part record;
One computer; And
One supervisory routine is carried out by this computer, uses this this data bank of computer access of control, and wherein, this supervisory routine is configured to realize claim 1 or 2 described methods.
4, a kind of Storage Media stores a supervisory routine, it is characterized in that, this supervisory routine is configured to realize method as claimed in claim 1 or 2.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007103066301A CN101470866A (en) | 2007-12-28 | 2007-12-28 | Method and system for product test management |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2007103066301A CN101470866A (en) | 2007-12-28 | 2007-12-28 | Method and system for product test management |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101470866A true CN101470866A (en) | 2009-07-01 |
Family
ID=40828322
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2007103066301A Pending CN101470866A (en) | 2007-12-28 | 2007-12-28 | Method and system for product test management |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101470866A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103136395A (en) * | 2011-11-29 | 2013-06-05 | 鸿富锦精密工业（深圳）有限公司 | Computer system used for circuit diagram data verification and circuit diagram data verification method |
-
2007
- 2007-12-28 CN CNA2007103066301A patent/CN101470866A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103136395A (en) * | 2011-11-29 | 2013-06-05 | 鸿富锦精密工业（深圳）有限公司 | Computer system used for circuit diagram data verification and circuit diagram data verification method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8190555B2 (en) | Method and system for collecting and distributing user-created content within a data-warehouse-based computational system | |
| US9704162B2 (en) | Enterprise structure configurator | |
| Powell | Microsoft Power BI cookbook: Creating business intelligence solutions of analytical data models, reports, and dashboards | |
| CN105793874B (en) | Method and system for managing community information | |
| CN101346720A (en) | A method and data processing system for restructuring web content | |
| CN101416143A (en) | User interface morph based on permissions | |
| CN103646049A (en) | Method and system for automatically generating data report | |
| CN106651092A (en) | Configurable data change flow monitoring method | |
| CN103562905A (en) | Improved data visualization configuration system and method | |
| CN101641688A (en) | Definable application assistant | |
| WO2014008304A2 (en) | Extensibility for sales predictor (spe) | |
| CN101470866A (en) | Method and system for product test management | |
| Souza et al. | Using surveys to build-up empirical evidence on test-related technical debt | |
| Güney et al. | Response Times Comparison of MongoDB and PostgreSQL Databases in Specific Test Scenarios | |
| Sullivan | Official Google Cloud Certified Professional Data Engineer Study Guide | |
| US7149739B1 (en) | System and method for performing ratio planning | |
| Shapira et al. | Common pitfalls of benchmarking big data systems | |
| Brathwaite | Systems design in a database environment | |
| US20160042022A1 (en) | Data coordination support apparatus and data coordination support method | |
| Dolak et al. | Process Mining of Events Log from Windows. | |
| Furtado et al. | An Experimental Evaluation of a Teaching Approach for Statistical Process Control for Software Engineers: An Experimental Study | |
| US20210248132A1 (en) | Tracking errors in data set lineage | |
| Hotek | Microsoft SQL server 2008 step by step | |
| DENG | DESIGN AND IMPLEMENTATION OF E-GATEPASS VISITOR MANAGEMENT SYSTEM | |
| Aldisa | SALES REPORT INFORMATION SYSTEM DESIGN WITH WATERFALL METHOD AT THE MOCIKEKE COMPUTER STORE |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20090701 |