CN103093338A - Civil aviation passenger transport combined transport electronic data processing method and electronic bill generated by using the same - Google Patents
Civil aviation passenger transport combined transport electronic data processing method and electronic bill generated by using the same Download PDFInfo
- Publication number
- CN103093338A CN103093338A CN201310030646XA CN201310030646A CN103093338A CN 103093338 A CN103093338 A CN 103093338A CN 201310030646X A CN201310030646X A CN 201310030646XA CN 201310030646 A CN201310030646 A CN 201310030646A CN 103093338 A CN103093338 A CN 103093338A
- Authority
- CN
- China
- Prior art keywords
- file
- transport
- processing method
- bill
- civil aviation
- 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
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a processing method based on various electronic files and business data needed by making out a bill and applicable to the field of civil aviation passenger transport combined transport, and an electronic entitative bill exported and generated by using the processing method. A civil aviation passenger transport combined transport electronic data processing method and the electronic bill generated by using the civil aviation passenger transport combined transport electronic data processing method have the advantages of achieving unified storage, relevance, management, retrieval and display of electronic files which are multiple in format, type and source, reducing repeated storage of the electronic files, achieving relevance and retrospect of whole process of the electronic files and various business data, improving efficiency and accuracy of business of making out the bill in actual operations, enabling the sources of the business of making out the bill to be clear, and being good in operability.
Description
Technical field
The present invention relates in civil aviation passenger transport through transport system about the disposal route of the electronic data of making out a bill and use the e bill that the method generates.
Background technology
Passenger traffic through transport: the business of jointly being completed passenger transport by many airlines.(make out a bill: billing making out a bill of civil aviation passenger transport through transport clearing, airline obtains income to the airline that draws a bill by acknowledgement of consignment) in process, the one complete management of electronic documents method of cover need to be provided, realize multi-format (comprising the .txt/.csv/.htm/.html/.jpg/.jpeg/.GIF/.GIFf/.rtf/.pdf multiple format), polymorphic type (comprising plain text, type of webpage, picture/mb-type, complex format etc.), multi-source (are come from the airline's reception of making out a bill, various through transport rules, bilateral agreements, the ticket image that oneself scans, the unified storage of e-file papery bill etc.), management, retrieval and demonstration, and realize e-file and miscellaneous service data (business datum: be stored in the passenger ticket in database, luggage check, abort shipping bill (Flight Interruption Manifest, be called for short FIM), traveling expenses card (Miscellaneous Charges Order, be called for short MCO, a kind of multi-usage value warrant) the ticket information such as, the bill information that receives, the bill information that sends etc.) full-range association and reviewing, and generation meets industry standard automatically, the content of making out a bill is complete, and the e bill with airline's personalized identification.
At present, in process is made out a bill in the civil aviation passenger transport through transport, to the disposal route of supportive file be usually:
(1) airline personnel of making out a bill need to be searched for the electronics files such as through transport rule, bilateral agreements in computer separately;
(2) airline personnel of making out a bill need to manually scan or print a large amount of ticket images and papery bill etc., forms the electronics file;
(3) the electronics document that (1) and (2) is obtained manually prints, binds;
(4) mailing is to the airline that made out a bill, as the Main Basis of making out a bill.
In the present disposal route of making out a bill, have following shortcoming and defect:
(1) personnel that make out a bill need to search for these e-files in computer separately in the process of making out a bill, and then print, bind, and can not robotization realize, waste time and energy;
(2) these electronics files can not obtain unified storage and recycling;
(3) these electronics files and make out a bill and do not set up automatic incidence relation between business datum, so-called electronics file and the corresponding relation between business datum of making out a bill: in order to allow make out a bill the true of data and effectively of airline's approval of being made out a bill, must provide simultaneously the make out a bill electronics file of data of some supports, between the data of making out a bill and these electronics files, corresponding relation be arranged.
Therefore, for the air passenger traffic field, if a kind of complete management of electronic documents method of cover that has can be provided, in making out a bill with realization, the unified of various e-files gathers and storage, and realize that data file is related with the Auto-matching of the data of making out a bill, and automatically generate the complete e bill of making out a bill for supporting, have extremely significant economic benefit and social value.
Summary of the invention
In existing air passenger traffic through transport, between required various e-files and business datum, most employing manually gathers, stores, classifies, searches, gathers based on making out a bill, not only affairs are numerous and diverse trifling, inefficiency, and be easy to confusion reigned, the present invention is directed to above defective and deficiency, a kind of disposal route with civil aviation passenger transport through transport electronic data of height correlation connection is provided, to improve in civil aviation passenger transport through service field based on the association process of making out a bill between needed various e-file and business datum, improve the treatment effeciency of data and e bill.
It is a kind of based in above civil aviation passenger transport through transport field that another object of the present invention is to provide, based on required various e-files and the disposal route of business datum of making out a bill, and the electronic entity bill of utilizing the method to derive and generating.
Technical scheme of the present invention is as follows:
A kind of civil aviation passenger transport through transport electronic data processing method is characterized in that comprising the following steps:
(a) collection of e-file and business datum storage is distinguished the e-file of establishment and the miscellaneous service data of collection in stored data base;
(b) data correlation creates the incidence relation table, and the e-file in disparate databases and business datum is interrelated.
(c) derivation of e-file and associated services data, utilize the incidence relation table, and the business datum that will be associated with e-file is extracted and derived with the e-file packing.
Further, in step (a), e-file comprises attribute information and solid data file, wherein structural data of attribute information amount is little, be stored in the general data storehouse, solid data file data amount is large, is stored in oracle database in binary mode.
Further, independent table space and data file are used in the storage of described solid data file, to improve access efficiency and easy to maintenance.
Further, the asynchronous extraction of multithreading is adopted in the extraction of described solid data file.
Further, described incidence relation table creates and stores based on the Oracle data layout.
Further, described incidence relation is the multi-to-multi incidence relation, and namely arbitrary e-file can carry out relatedly with the multiple business data, and is recorded in the incidence relation table; Simultaneously any business datum can be carried out relatedly with a plurality of e-files, and is recorded in the incidence relation table.
Further, described interrelational form comprises auto-associating, this document is named and uploaded in batches to the rule that described auto-associating comprises setting to file, and the determinant attribute of this document is recorded in database, automatically search corresponding business datum according to these determinant attributes, and will be recorded in simultaneously in the incidence relation table of database with the incidence relation of this business datum.
Further, described interrelational form comprises manual association, and described manual association comprises the visualized graph interface for inquiry and operation, for the user is manual, e-file and business datum are associated, and background data base records final result.
A kind of e bill of using civil aviation passenger transport through transport electronic data processing method generation as above, it is characterized in that: will be as described above civil aviation passenger transport through transport electronic data processing method e-file and the business datum packing derivation of processing and store, and the electronic entity bill of generation.
Further, described electronic entity bill is PDF, and integrated e-file and the business datum that is associated that show.
Technique effect of the present invention is:
1, the invention provides a cover based on the complete e-file in existing civil aviation passenger transport through transport field and the disposal route of solid data, the various unified store and managements based on make out a bill required e-file and solid data for different-format, dissimilar, separate sources have been realized, and utilize the incidence relation table of establishment to realize that various e-files are related with the Auto-matching of the data of making out a bill, thereby realized fast, accurately automatically generating the purpose for the complete electronic entity bill of supporting to make out a bill.
2, provided by the invention based on the complete e-file in existing civil aviation passenger transport through transport field and the disposal route of solid data, unified storage, management, retrieval and demonstration to the e-file of multi-format, polymorphic type, multi-source have been realized, reduced the repeated storage of e-file, realize that simultaneously e-file and miscellaneous service data are full-range related and review, efficient and the accuracy of the business of making out a bill in the practical operation had both been improved, guaranteed that again all information of making out a bill all have good grounds, make the business of making out a bill originate clear, improved operability.
3, the invention provides safe and reliable storage based on the various e-files of making out a bill and solid data with related, and provide the automatic generation of the electronic entity bill that produces based on this data processing method, and the e bill that utilizes method provided by the invention to produce is convenient to meet industry standard, can articulates e-file and is embodied airline's Extraordinary e bill for the user.
Embodiment
Below be described further to the electronic data processing method based on the civil aviation passenger transport through transport of the present invention with based on the e bill that the method generates.
Electronic data processing method based on the civil aviation passenger transport through transport of the present invention mainly comprises automatic generation and the derivation of efficient association, data or the e bill of the storage of e-file and displaying, e-file and business datum.
The storage of e-file and displaying: the data that e-file need to be stored comprise attribute information and solid data file, according to the difference of characteristic separately, the structurized attribute information that data volume is less is stored in database in a conventional manner, and the non-structured solid data file that data volume is larger is with the storage separately in Oracle (inscriptions on bones or tortoise shells) database of binary mode.In order to improve access efficiency and easy to maintenance, on the design Storage of database, independently table space (table space) and data file (data file) are used in the storage of solid data file.
When client need to be checked the electronic entity file, according to the type of the e-file of storing, binary data is reduced, can realize by the mode of the corresponding control of dynamic call the front end displaying of e-file, system's support comprises the text-only files such as .txt/.csv, the static Web page of the forms such as support .htm/.html, the picture file of the multiple formats such as support .jpg/.jpeg/.GIF/.GIFf, the file of the complex format such as support .rtf/.pdf.
Simultaneously, experience in order to promote the user, system uses multithreading to realize the asynchronous of binary data read.
The efficient association of e-file and business datum: e-file and incidence relation are stored respectively, and created based on the e-file of Oracle and the incidence relation table between business datum.
Interrelational form comprises auto-associating: in the file designation mode of setting, file is named, upload in batches afterwards these files, and the determinant attribute of these e-files is recorded in database, automatically search corresponding business datum according to these determinant attributes afterwards, and the incidence relation of handle and business datum is recorded in simultaneously in the incidence relation table of database.
Also comprise manual association: utilize to be easy to the visualized graph interface inquiring about and operate, for the user is manual, e-file and business datum are associated, background data base records final result.
Realize that e-file is related with the automatic or craft of miscellaneous service data, reduced the repeated storage of e-file, improved the utilization factor of e-file.In the process of user audit, provide and upload in batches e-file, auto-associating business datum, manually set up or the disassociation relation, automatically derive make out a bill relevant e-file and functions such as packing automatically, the efficient that the General Promotion user examines.
This incidence relation is convenient to strengthen the database store and management of e-file, can realize on the one hand the related correspondence of the multi-to-multi of e-file and business datum, so-called multi-to-multi is related, namely an e-file is only stored portion, but can with the multiple business data carry out related, a plurality of incidence relations of storage in database simultaneously; Simultaneously a kind of business datum can with a plurality of e-files carry out related, and in database storage this a plurality of incidence relations, reach the purpose that e-file reuses; On the other hand, in the process of user's audit, the associated electrical file of supporting business data be can see easily, thereby efficient and the continuity of user's audit promoted.
Automatic generation and the derivation of e bill: utilize increase income assembly and secondary development, automatically generation meets PDF e bill industry standard and that have the personalized LOGO of airline (trade mark) sign, simultaneously can be with e-file (comprising the multiple forms such as word, form, picture) the integrated demonstration in e bill that is associated; And provide zip (compressed package) packing of e bill to derive, when the packaging file size surpasses certain numerical value, can adopt automatic bundling packing.
The disposal route of this e-file and solid data and the e bill of using the automatic generation of this method, can realize the automatic generation of required e bill of making out a bill in civil aviation passenger transport through transport field, and provide and meet industry standard, can articulate e-file and embody airline's Extraordinary e bill for the user.
Claims (10)
1. civil aviation passenger transport through transport electronic data processing method is characterized in that comprising the following steps:
(a) collection of e-file and business datum storage is distinguished the e-file of establishment and the miscellaneous service data of collection in stored data base;
(b) data correlation creates the incidence relation table, and the e-file in disparate databases and business datum is interrelated.
(c) derivation of e-file and associated services data, utilize the incidence relation table, and the business datum that will be associated with e-file is extracted and derived with the e-file packing.
2. civil aviation passenger transport through transport electronic data processing method as claimed in claim 1, it is characterized in that comprising the following steps: in step (a), e-file comprises attribute information and solid data file, wherein structural data of attribute information amount is little, be stored in the general data storehouse, solid data file data amount is large, is stored in oracle database in binary mode.
3. civil aviation passenger transport through transport electronic data processing method as claimed in claim 2 is characterized in that: independent table space and data file are used in the storage of described solid data file, to improve access efficiency and easy to maintenance.
4. civil aviation passenger transport through transport electronic data processing method as claimed in claim 3, is characterized in that: the asynchronous extraction of extraction employing multithreading of described solid data file.
5. civil aviation passenger transport through transport electronic data processing method as claimed in claim 1, it is characterized in that: described incidence relation table creates and stores based on the Oracle data layout.
6. civil aviation passenger transport through transport electronic data processing method as claimed in claim 5, it is characterized in that: described incidence relation is the multi-to-multi incidence relation, namely arbitrary e-file can carry out relatedly with the multiple business data, and is recorded in the incidence relation table; Simultaneously any business datum can be carried out relatedly with a plurality of e-files, and is recorded in the incidence relation table.
7. civil aviation passenger transport through transport electronic data processing method as claimed in claim 5, it is characterized in that: described interrelational form comprises auto-associating, this document is named and uploaded in batches to the rule that described auto-associating comprises setting to file, and the determinant attribute of this document is recorded in database, automatically search corresponding business datum according to these determinant attributes, and will be recorded in simultaneously in the incidence relation table of database with the incidence relation of this business datum.
8. civil aviation passenger transport through transport electronic data processing method as claimed in claim 5, it is characterized in that: described interrelational form comprises manual association, described manual association comprises the visualized graph interface for inquiry and operation, for the user is manual, e-file and business datum are associated, and background data base records final result.
9. an application rights requires the e bill that 1 described civil aviation passenger transport through transport electronic data processing method generates, it is characterized in that: will derive according to e-file and business datum packing that civil aviation passenger transport through transport electronic data processing method claimed in claim 1 is processed and stored, and the electronic entity bill that generates.
10. e bill as claimed in claim 9, it is characterized in that: described electronic entity bill is PDF, and integrated e-file and the business datum that is associated that show.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310030646XA CN103093338A (en) | 2013-01-28 | 2013-01-28 | Civil aviation passenger transport combined transport electronic data processing method and electronic bill generated by using the same |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310030646XA CN103093338A (en) | 2013-01-28 | 2013-01-28 | Civil aviation passenger transport combined transport electronic data processing method and electronic bill generated by using the same |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103093338A true CN103093338A (en) | 2013-05-08 |
Family
ID=48205878
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310030646XA Pending CN103093338A (en) | 2013-01-28 | 2013-01-28 | Civil aviation passenger transport combined transport electronic data processing method and electronic bill generated by using the same |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103093338A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107153717A (en) * | 2017-06-14 | 2017-09-12 | 成都三零凯天通信实业有限公司 | Million grades of method and system that recorded form are exported from database by browser |
| CN114519337A (en) * | 2020-11-20 | 2022-05-20 | 永中软件股份有限公司 | Data synchronization method, computing device and computer readable medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5491325A (en) * | 1992-08-25 | 1996-02-13 | Huang; Dorge O. | Method and system for payment and payment verification |
| CN1439142A (en) * | 1998-12-23 | 2003-08-27 | 大通银行 | System and method for integrating trading operations including the generation, processing and tracking of and trade documents |
| CN101539931A (en) * | 2009-04-21 | 2009-09-23 | 中国民航大学 | Flight dynamic information data integrator and processing method |
| CN102637190A (en) * | 2011-01-24 | 2012-08-15 | 微软公司 | Associating captured image data with a spreadsheet |
-
2013
- 2013-01-28 CN CN201310030646XA patent/CN103093338A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5491325A (en) * | 1992-08-25 | 1996-02-13 | Huang; Dorge O. | Method and system for payment and payment verification |
| CN1439142A (en) * | 1998-12-23 | 2003-08-27 | 大通银行 | System and method for integrating trading operations including the generation, processing and tracking of and trade documents |
| CN101539931A (en) * | 2009-04-21 | 2009-09-23 | 中国民航大学 | Flight dynamic information data integrator and processing method |
| CN102637190A (en) * | 2011-01-24 | 2012-08-15 | 微软公司 | Associating captured image data with a spreadsheet |
Non-Patent Citations (1)
| Title |
|---|
| 孙浩川: "模型库系统中工作流与数据存储机制研究", 《万方学术期刊数据库》, 25 December 2012 (2012-12-25), pages 28 - 29 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107153717A (en) * | 2017-06-14 | 2017-09-12 | 成都三零凯天通信实业有限公司 | Million grades of method and system that recorded form are exported from database by browser |
| CN114519337A (en) * | 2020-11-20 | 2022-05-20 | 永中软件股份有限公司 | Data synchronization method, computing device and computer readable medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104361018B (en) | Electronic archives information reorganization method and device | |
| EP1473642A2 (en) | Information processing apparatus, method, storage medium and program | |
| US10528626B2 (en) | Document processing | |
| CN102063478A (en) | Three-dimensional file format conversion method and search engine suitable for Internet search | |
| JP6835713B2 (en) | Accounting support system | |
| US20210240932A1 (en) | Data extraction and ordering based on document layout analysis | |
| CN103473284A (en) | Electronic certificate management system and electronic certificate management method | |
| CN206411669U (en) | SaaS ancient book knowledge service cloud platform | |
| Ha et al. | Recognition of OCR invoice metadata block types | |
| CN108614819B (en) | Geological data management system | |
| CN107315817A (en) | Electronic drawing text matching technique, device, storage medium and computer equipment | |
| CN108170697B (en) | International trade file processing method and system and server | |
| CN103093338A (en) | Civil aviation passenger transport combined transport electronic data processing method and electronic bill generated by using the same | |
| CN108960054A (en) | A kind of clearance data generation system and method based on picture and text identification | |
| US10579653B2 (en) | Apparatus, method, and computer-readable medium for recognition of a digital document | |
| CN111125221A (en) | Excel format-based data extraction system and configuration method | |
| CN104133861A (en) | Method for intelligently resolving excel format international air ticket freight rate lists | |
| CN107862083A (en) | A kind of method that scanning file is quickly filed | |
| CN105955680A (en) | Document printing method supporting dynamic additional extended information | |
| US20220121881A1 (en) | Systems and methods for enabling relevant data to be extracted from a plurality of documents | |
| CN111241955B (en) | Bill information extraction method and system | |
| CN115687566A (en) | Method and device for full-text retrieval and retrieval result display | |
| Zhou et al. | Bus commuters’ jobs-housing balance in Beijing: An exploration using large-scale synthesized smart card data | |
| CN113806368A (en) | System and method for identifying document and automatically establishing database | |
| Szegedi et al. | Context-based Information Classification on Hungarian Invoices. |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20130508 |